Simple database building and table-building

First enter MySQL at the command line, enter the username and password--:mysql-u user name-p password

And then we can build the database.

First see if you have MySQL database table--:show databases;

Create a database that we need (such as database db)

Now we continue to create the table in the database

At this point our database, the tables have been created successfully

"The above is the database and the establishment of tables, and other SQL statements to operate the MySQL method will continue to increase, to be continued ..."

===============++++++++++++++++++++++++++====================

Delete a table

Increase the fields in a table

In fact, modifying the SQL statements in the base table is--Adding the modified delete field, respectively

"ALTER TABLE < table name >

[Add < new column name > < data type > [integrity constraint]]

[Dpop < integrity constraints;]

[ALTER COLUMN < column name > < data type >]; '

===============++++++++++++++++++++++++++====================

Add the appropriate value to your field: INSERT into table name (Field 1, Field 2, field ...) value (value 1, value 2,...);

Simple database building and table-building