soeben的博客

#语法 INSERT INTO table_name ( field1, field2,...fieldN )VALUES ( value1, value2,...valueN ); #例子 //结构 CREATE TABLE `user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(10) NOT N...

语法 SELECT field1, field2 FROM table_name; 例子 //结构 CREATE TABLE `user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(10) NOT NULL, `sex` tinyint(4) NOT NULL, `tel` char(1...

语法 SELECT field1, field2 FROM table_name WHERE field1 = value1 AND field2 = value2 运算符支持 =、!=、>、<、>=、<=、<=&a

语法 DELETE FROM table_name [WHERE Clause] 例子 //结构 CREATE TABLE `user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(10) NOT NULL, `sex` tinyint(4) NOT NULL, `tel` char(11) N...

语法 SELECT * FROM table UNION [ALL | DISTINCT] SELECT * FROM table ALL全部数据 DISTINCT去重数据 例子 //结构 CREATE TABLE `user_student` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(10) NOT...

语法 SELECT * FROM table ORDER BY field1 [ASC|DESC], field2 [ASC|DESC]; ASC升序 DESC降序 例子 //结构 CREATE TABLE `user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(10) NOT NULL, `se...