mysql/ how do i create a table

NoOneuk · #1 (**permalink**) 07-02-06, 04:59

hi
i have a compelately blank canverse.

i have no idea where to start
i no what i want but i canno work it out..

i am looking for a table that has

topic / views / replise / last poasted /

its the same as most forums i have been on

divined · #2 (**permalink**) 07-02-06, 06:06

I would suggest you pick up a good book on the SQL language for a start. What you need is the create command. Take a look at the following site :

Code:

http://sqlcourse.com/create.html

I suppose you have already connected to the mysql command interface using the mysql command.

NoOneuk · #3 (**permalink**) 07-02-06, 07:22

thank you for the quick responce

i have a book on php and mysql.. i need to read it again
thanks again i will be back

NoOneuk · #4 (**permalink**) 07-02-06, 07:23

Quote:

Originally Posted by divined

I would suggest you pick up a good book on the SQL language for a start. What you need is the create command. Take a look at the following site :

Code:

http://sqlcourse.com/create.html

I suppose you have already connected to the mysql command interface using the mysql command.

where would i do this?

divined · #5 (**permalink**) 07-02-06, 14:26

When you install MySQL there should be a utility called mysql. This can be called from the command line.

Enter the commands :

mysql -u root -p

and give the password of your root user. That password should have been set by you during the installation. In the environment you can enter SQL commands.

Internet Services

Web Development

Digital Marketing

Consumer Tech