...

View Full Version : Stuck on creating tables



ttttt
08-21-2006, 04:27 PM
Hi all!
I'm a newbie with MySQL and I'm quite stuck with creating the tables I need in a db.
Do you think you could help me with the php code to create a table: with an id, username, password and level (integar) field.
Thanks,
EDIT: sorry about the typo in the title! I don't think I can change it though...

mlseim
08-21-2006, 05:16 PM
Google is always your friend ...

http://www.google.com/search?hl=en&q=php+mysql+creating+tables+example&btnG=Google+Search

Spookster
08-21-2006, 05:16 PM
Do you need to create these tables on the fly dynamically or do you just need some tables created? If the latter then you can use something like phpMyAdmin to create them when you need them. With phpMyAdmin you can also generate the necessary SQL in order to do it if you need that for later use in a script.

Len Whistler
08-21-2006, 05:23 PM
I would get a book on MySQL, there is lots of MySQL data types that you will need to know with their descriptions and size. My book has 20 listed, five are listed below.

CHAR
VARCHAR
TINTTEXT
TEXT
MEDIUMTEXT



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum