MySQL
soeben
PHP世界上最好的语言(滑稽)
展开
-
MySQL INSERT 插入数据
#语法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...原创 2018-10-18 20:53:51 · 481 阅读 · 0 评论 -
MySQL SELECT 查询数据
语法SELECT field1, field2FROM 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...原创 2018-10-18 21:07:03 · 204 阅读 · 0 评论 -
MySQL WHERE 筛选数据
语法SELECT field1, field2FROM table_nameWHERE field1 = value1 AND field2 = value2运算符支持 =、!=、>、<、>=、<=、<=&a原创 2018-10-18 21:52:16 · 6815 阅读 · 0 评论 -
MySQL DELETE 删除数据
语法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...原创 2018-10-19 13:22:42 · 1193 阅读 · 0 评论 -
MySQL UNION 联合查询
语法SELECT * FROM tableUNION [ALL | DISTINCT]SELECT * FROM tableALL全部数据 DISTINCT去重数据例子//结构CREATE TABLE `user_student` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(10) NOT...原创 2018-10-19 19:13:22 · 397 阅读 · 0 评论 -
MySQL ORDER BY 排序
语法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...原创 2018-10-19 19:14:04 · 341 阅读 · 0 评论