-
数据类型：int , float , varchar 数据操作：CREATE TABLE ta_name(); INSERT INTO tb_name () VALUES (); NOT NULL; AUTO_INCREMENT; UNSIGNED; PRIMARY KEY;UNIQUE KEY; DEFUALT ''; SHOW COLUMNS FROM tb_name;查看全部
-
Windows下的所有的服务启动或停止 net start 服务名 net stop 服务名查看全部
-
CHAR 定长 VARCHAR 变长 ENUM('value1','value2') 单选 SET('value1','value2'...)多选查看全部
-
字符类型查看全部
-
FLOAT [(M,D)]; M >= D M小数点前面的数字，D 小数点后的位置; 小数点后面的7倍; DOUBLE[(MD,D)]查看全部
-
整形！int查看全部
-
笔记很垃圾看看具体他连衣裙努力加油来咯举行查看全部
-
MySQL安装方式 MSI安装（Windwos Installer） ZIP安装 修改编码方式（my.ini） [mysql] --配置客户端字符集 default-character-set=utf8 [mysqld] --配置服务器端字符集 character-set-server=utf8查看全部
-
create function test() returns varchar(30) return date_format(now(),'%Y年%m月%d日 %H:%i:%s'); select test();查看全部
-
select md5('admin'); select md5('admin888'); select password('admin'); select password('admin888'); set password=password('admin');查看全部
-
select avg(goods_price) as avgprice from tdb_goods; select round(avg(goods_price),2) as avgprice from tdb_goods; select count(goods_id) as countid from tdb_goods; select max(goods_price) as pricemax from tdb_goods; select min(goods_price) as pricemin from tdb_goods;查看全部
-
select now(); select curdate(); select curtime(); select date_add('2014-3-12',interval 365 day); select date_add('2014-3-12',interval -365 day); select date_add('2014-3-12',interval 365 week); select datediff('2013-3-12','2014-3-12'); select date_format('2014-10-13','%m/%d/%Y');查看全部
-
select 33 between 1 and 32; select 10 in(3,4,10,44); select null is null; select '' is null; select 0 is null; select * from tdb_goods where goods_id is null; select * from tdb_goods where goods_id is not null;查看全部
-
select ceil(3.01); select floor(3.99); select 3 div 4; select 5.3 mod 3; select power(2,4); select round(3.1415926,3); select truncate(125.668,3); select truncate(125.668,2); select truncate(125.668,1); select truncate(125.668,0);查看全部
-
select substring('myhelloword',3); select substring('myhelloword',1,3); select substring('myhelloword',-3); select substring('myhelloword',-3,2); select 'myhelloword' like 'o%'; select 'myhelloword' like '%o%'; select * from tdb_goods where goods_name like '%笔记本%';查看全部
举报
0/150
提交
取消