![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
iteye_13888
这个作者很懒,什么都没留下…
展开
-
排序查询结果
[size=medium][align=center][b]Sorting Query Results[/b][/align][/size][size=small][b]1.Sorting by Variable-Length Substrings[/b][/size]select id,left(substring(id,4),char_length(substring(id,4)-...原创 2011-12-17 14:58:31 · 121 阅读 · 0 评论 -
生成摘要
[size=medium][align=center][b]Generating Summaries[/b][/align][/size][size=small][b]1.Using DISTINCT to Eliminate Duplicates[/b][/size]select count(DISTINCT name) from driver_log;count(DISTINC...原创 2011-12-19 00:16:15 · 97 阅读 · 0 评论 -
使用mysql客户端程序
[size=medium][align=center][b]Using the mysql Client Program[/b][/align][/size][size=small][b]1.Setting Up a MySQL User Account[/b][/size]GRANT ON TO [IDENTIFIED BY ""] [WITH GRANT OPTION];...2011-11-29 14:30:39 · 120 阅读 · 0 评论 -
从表中查询数据
[size=medium][align=center][b]Selecting Data from Tables[/b][/align][/size][size=small][b]1.Combining Columns to Construct Composite Values[/b][/size]select date_format(monthname(t),'',dayofmont...原创 2011-12-01 21:40:31 · 163 阅读 · 0 评论 -
表管理
[size=medium][align=center][b]Table Management[/b][/align][/size][size=small][b]1.Cloning a Table[/b][/size]create table [i]new_table[/i] like [i]original_table[/i];insert into [i]new_table[/i...原创 2011-12-01 21:43:54 · 82 阅读 · 0 评论 -
与字符串共舞
[size=medium][align=center][b]Working with Strings[/b][/align][/size][size=small][b]1.Converting the Lettercases of a String[/b][/size]select thing,upper(thing),lower(thing) from limbs;upper()...原创 2011-12-02 00:49:07 · 96 阅读 · 0 评论 -
使用日期和格式
[size=medium][align=center][b]Working with Dates and Times[/b][/align][/size][size=small][b]1.Changing MySQL's Date Format[/b][/size]select d,date_format(d,'%m %d,%y') from date_val;使用date_for...原创 2011-12-04 00:21:55 · 299 阅读 · 0 评论