MySQL database table creation practices

Today, when I create a table in MySQL, I first create it in MySQL Query Browser, but I always report an error. Later I thought it was just a client software that is easy to operate. I guess it won't work. Later, I created a table under the MySQL Administrator on the server, but the same error still occurred. No way to go online for help.

It turns out that tables are created under the doscommand line in MySQL. After entering the command line, first enter: net start MySQL (stop server with: net stop MySQL) after the server is started, then enter: MySQL-uroot-p here the root represents the user name. Press Enter and you will be prompted to Enter the password: Enter password: password is the password set during installation. (This step may prompt that MySQL is not an internal command because the environment variable is not set. You should add the bin directory under the MySQL installation directory to the path, for example, I am D: \ program files \ MySQL \ bin. When MySQL> is displayed, you can create a table. For example, to create a guestbook table in test, follow these steps: MySQL> use test Database changed MySQL> create table guestbook-> (-> serial_no int auto_increment not null primary key, -> name varchar (10) not null,-> guest_time varchar (10) not null->); the table is created successfully, however, during the input process, note that there must be a space before not null, and there must be a comma (,), and no comma (;) after the last line, these are the basic knowledge of the database, but I forgot to create them several times.