MySQL-Data Manipulation language

Data on the table (add and revise)

View the data in the table
Select * from user;
Finding data in the user table

Inserting data
Insert into User (Key,key,key,key ...) VALUES (Value,value,value,...) ；
Insert a data into the user table, key represents the column name in the user table, value is the data for the corresponding column, and key and value correspond.

Then view the inserted data

Modify the value of a field
Update user set User_name= "NewName" where id=1;
Modify the user_name of the field with ID 1 in the user table to NewName. (This is based on the ID to change the user name)
Attention?? : You can also change fields based on user name or other fields.
If you modify multiple fields by separating them with commas

Delete
Delete from user where id=2;
Delete the data with ID 2. If there are two data, you delete the second, then the newly added data ID will not fill in the ID you deleted, will be deleted from there and then add
Attention?? : If you do not add a where condition, all the data in the table will be deleted. There is only one way to do it, so pack your things and leave.

There is also a delete is to clear the table
Truncate user;
This clears all the data in the table. The newly inserted data is sorted from the beginning.
Application scenario: To go online, you need to delete the previous test data, then use this command.

Modify Database Pipe Permissions
The highest-privileged account is root when you first want to control the root link database only with 127.0.0.1来 links.
Use MySQL;
Select User,host from user;
After executing the above two sentences, you will see the root link permission. Delete the superfluous, and leave only 127.0.0.1 on the line.

The delete and set commands are the same as the commands in the previous notes.

And then refresh the permissions
Flush Privileges

Re-Login
Mysql-uroot-h127.0.0.1-p

Attention?? To add an-H to specify host

----------------------------------------------------------------------

MySQL-Data Manipulation language