Adding and removing Change to check =crud
Add insert
INSERT car VALUES (' character ', ' name ', ' brand ', ' 1990-02-02 00:00:00 ') add a
INSERT car (' Code ', ' name ') VALUES (' 1 ', ' 2 ') are added separately
Remove delete is not used
Delete from car removes all information from the table
DELETE from car WHERE ' Code ' = ' character ' and ' name ' = ' name '
DELETE from car WHERE ' Code ' = ' character ' OR ' name ' = ' name '
Isdelect tags are not deleted from the foreground delete database
Change UPDATE
UPDATE car SET pic= ' 1 ' all pic fields changed to 1
UPDATE car SET pic= ' 1 ' WHERE?? =??
Check SELECT
SELECT * FROM car
SELECT code,name from car WHERE code= ' c001 '
SELECT * from car WHERE Name like '%a6l% '
SELECT * from car ORDER by exhaust DESC from large to lower
SELECT * from Car ORDER by exhaust ASC, price ASC small to large if exhaust same price arranged from small to
MySQL basic knowledge additions and deletions to change the base operation