Navigation Cat (NaviCat for MYSQL) How to create a table

I know there are three kinds of tables built on the client (I know, I don't know, there are other ways of wood, if you leave a message)

1. Right-click a database to create a table, fill in the fields yourself

2. Import the. sql file (SQL statement is already written), such as:

Right-click Data point to run the SQL file on the above section, after the execution of SQL, refresh the database, the table is set up. (provided that the statements in the SQL file are right).

3. Click Query, new query, and then write the SQL statement, such as:

I know these three kinds of, in fact, the SQL file should be can be generated (if the switch data, should be able to build in the original database), I suggest the third one can contact the SQL statement

Popular Science: The obvious difference between Oracle and MySQL (physically): Oralce is a database with multiple users, and MySQL is a user with multiple databases.

Navigation Cat (NaviCat for MYSQL) How to create a table