Simple operation for MySQL

Create data Table User

1 CREATE TABLE ' node '. 'user'intnotNULLINT not NULL INT  not NULL )= InnoDB;

Increase

1              database name. Table name            key                               value 2INSERT into ' node '. 'uservalues ' ('1'wulv'123' ); 3 // Note that the parentheses of the value are single quotes and not the next floating key

By deleting

1Delete user table because ID is unique ID= 02 DELETE  from`User`WHERE`User'. ' ID '= 03Or:DELETE  from`User`WHERE`User'. ' Username '= 'John Doe';//When the value is non-numeric, you need to"'Enclosed in single quotation marks.

Change

1 UPDATE  ' node '. 'userSET  =  '  Brooks 'WHERE  'user=3 ;

Check

1 SELECT *  from 'userwhere=3// query all contents of user in this table

Simple operation for MySQL