MySQL simple additions and deletions to change the statement

Add Record:

NOTE: The NULL keyword is combined with the auto_increment restriction to automatically assign a value to the field, the field must be full, and one by one corresponds; a single quotation mark for the character type;

1 mysql>insertintovalues('sunshine_habit' ,'[email protected]'2      ,1558888888, NULL );
Output:31 row affected (0.10 sec)

Query record:

1Mysql> Select *  fromTestwhereName='Sunshine_habit';2 Output:3 +----------------+-------------------------+--------------+----+4 |Name|Email|Phone_number|Id|5 +----------------+-------------------------+--------------+----+6 |Sunshine_habit|Hello_world_lyq@163. com|   1558888888 |  1 |7 +----------------+-------------------------+--------------+----+8 1Rowinch Set(0.00Sec

MySQL simple additions and deletions to change the statement