[RESOLVED] MYSQL newbie questions

[edkuan]

ok i am very new to mysql so hope u guy could help me

to create a db in mysql what i always do is open up the phpmyadmin page and add new db from there , thats fine. But I got a code here :

CREATE TABLE subject_registerd (
no int primary key,
user_id int,
subject_code varchar(50),

UNIQUE (user_id, subject_code)
);

but how do i even open up the code to put this new code in ? been reading up the mysql manual but just getting confused 😕

using mysql 2.2.3 (i know its not the latest but at the moment thats what i have)

hope u could help

[m_tt]

I really don't understand what the question is here.

If you are using phpMyAdmin, and want to input code manually, click the "SQL" tab.

[sneakyimp]

Yes your post is pretty confusing. Does your DB exist yet? Are you saying that you don't have phpMyAdmin installed?

If you don't have phpMyAdmin, there are two ways to use mysql:

1) write a php script that executes your query. You'll need to read about how to use it:
http://php.net/mysql_query

2) access mysql from a unix (or windows) command line. When you do this, you type all the commands from a unix command prompt

[edkuan]

where do i find this sql tab , what i have is this

[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

 if i want o do some thing to the database say db rgister i just click on it and it will display this   Field | Type  | Attributes | Null | Default |  Extra|            Action  

with all the attributes of register

i mean im looking but havent found the sql tab , is it because Iam using an old version of mysql?

[sneakyimp]

use 'select' perhaps? insert?

sounds like your phpMyAdmin is old.

[edkuan]

ok thanks yeah its pretty old, iwill try installing the lastest ones 2.9.02 . But will it currupt any existing dbase

[sneakyimp]

as far as i know, phpMyAdmin will have no impact at all on the database unless you run queries that impact the database.

MySQL, however, is different.