How to create table in mysql command line?

It is very simple. Tables are created using standard sql commands. And there is no difference whether you work with the base via the command line or through some kind of environment (developer / toad / etc). Creating a table will still look the same. Just through the console is more convenient.

You can use something like this: CREATE TABLE [IF NOT EXISTS] table_name( column_list ) ENGINE=storage_engine Engine - you can use MyISAM or INNODB. [IF NOT EXIST] just for more safe mode if table already exist just skip it just for prevent error in case table exist