https://cdn.jsdelivr.net/gh/wefantasy/FileCloud/img/fantasy-r.png

sql常用命令

整理sql常用命令及高级用法 基本命令 insert 1 2 INSERT INTO table_name ( field1, field2,...fieldN ) VALUES ( value1, value2,...valueN ), ( value1, value2,...valueN ); delete 1 DELETE FROM table_name [WHERE Clause] update 1 UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause] select 1 2 3 4 5 6 SELECT column_name,column_name FROM table_name1 LEFT JOIN table_name2 ON table_name1.some_field =