- 博客(7)
- 资源 (3)
- 收藏
- 关注
原创 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 339
原创 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 389
原创 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 1186
原创 MySQL WHERE 筛选数据
语法SELECT field1, field2FROM table_nameWHERE field1 = value1 AND field2 = value2运算符支持 =、!=、>、<、>=、<=、<=&a
2018-10-18 21:52:16 6808
原创 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 200
原创 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 478
原创 PHP中echo、print、print_r、var_dump、var_export的区别
void echo ( string $arg1 [, string $... ] )echo 是一个语言结构,可以不用括号包围参数列表,在没有括号情况下可接收多个参数并输出echo 'one';//输出 oneecho('one');//输出 oneecho 'one','two','three';//输出 onetwothreeint print ( string $a...
2018-10-07 17:17:36 184
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人