How to create tables in MySQL

view full story

http://www.go2linux.org – Our Tuesday MySQL tip, how to create Tables in a MySQL Database. Tables are somehow like spreadsheets, and one database may have lots of tables into it. So, once you have created your Database you may create the tables inside the Database. We’ll do it, working on the command line: First connect to the MySQL mysql -u [user] -p This will ask the password for the user [user], it should be the user you have given (grant) permissions to work on that database, when you created the MySQL database. The syntax is: CREATE TABLE [table_name] ([field_name1] [field_type1], [field_name2] [field_name (HowTos)