MYSQL常用命令列表

時間：2014-04-29 17:57:48 阅读：667 評論：0 收藏：0 [點我收藏+]

標簽：des blog style div size tar ext width log art color

MYSQL常用命令列表

　　1、系統管理

　　mysql -h主机地址 -u用户名 -p

　　連接MYSQL(在mysql/bin)

　　exit

　　退出MYSQL命令

　　mysqladmin -u用户名 -p旧密码 password新密码

　　修改密碼(在mysql/bin)

　　grantselect[insert][,update][,delete]on數據庫.*to用户名@localhost("%"，表示任何主机)identifiedby "密码"

　　增加用戶

　　mysqldump –u root –p opt數據庫名>备份文件名

　　备份數據庫(在mysql/bin)

　　mysql –u root –p < batchfile (例如备份文件名)

　　使用批處理

　　mysql.server start

　　啓動服務器

　　mysql.server stop

　　停止服務器

　　msql.serverlog

　　2、查詢命令

　　select version()

　　查詢版本號

　　select current_date

　　查詢當前日期

　　3、顯示命令

　　show databases

　　显示數據庫列表

　　show tables 显示库中的数据表

　　describe 表名显示数据表的结构

　　select * from 表名显示表中的记录

　　select what_to_select from which table [whereconditions_to_satisfy and (or) where conditions_to_satisfy] 从一个表中检索数据『满足条件』

　　select 字段1,字段2,… from 表名显示特定列的值

　　select * from 表名 order by 字段名排序行

　　select 字段1,包含字段2的运算式as 新字段 from 表名字段值运算操作

　　select 字段1 is null(is not null) 空值操作

　　Select*from表名where字段名like(not like) “ 字符”

　　注：允许使用“_”匹配任何单个字符，而“%” 匹配任意数目字符模式匹配

　　Select * from表名where字段名regexp(not regexp)或者rlike(not rlike) “.”匹配任何单个的字符一个字符类[…]匹配方框内任何字符。例如[a]，[asd]，[az] 匹配任何小写字母，[09] 匹配任何数

　　字。 “*”匹配零个或者多个在它前面的东西。正则表达式区分大小写[aA] 。如果它出现在被测试值的任何地方，模式都匹配。定位，在模式开始处用“^”，结尾处用“$”，例如“^b”

　　擴展正則表達式

　　Select count(*) from 表名

　　Select 字段名，count(*) from 表名 group by 字段名行计数

　　4、編輯命令

　　use database 库名

　　使用的數據庫

　　create database 库名

　　创建數據庫

　　create table 表名

　　在數據庫中创建表

　　insert into表名values (“data”,”data”)

　　向表中添加記錄

　　Load data infile “/path/filename” intotable 表名

　　从文件中向表添加数据，文件每行包括一条记录，用定位符(tab) 把值分开。

　　drop database 库名

　　删除數據庫

　　drop table 表名

　　删除數據庫中的表

　　delete from表名where

　　删除數據庫表中的记录

　　Update表名set字段=”值” wherewhereconditions_to_satisfy

　　更新數據庫表中记录的值

MYSQL常用命令列表,布布扣,bubuko.com

MYSQL常用命令列表

標簽：des blog style div size tar ext width log art color

原文地址：http://www.cnblogs.com/wenxiangchen/p/3698145.html

踩

(0)

贊

(0)

舉報

評論一句话評論（0）

分享檔案

更多>

2021年07月29日 (22)
2021年07月28日 (40)
2021年07月27日 (32)
2021年07月26日 (79)
2021年07月23日 (29)
2021年07月22日 (30)
2021年07月21日 (42)
2021年07月20日 (16)
2021年07月19日 (90)
2021年07月16日 (35)

周排行

友情鏈接

蘭亭集智國之畫百度統計站長統計阿裏雲 chrome插件新版天聽網

關于我們 - 聯系我們 - 留言反饋

迷上了代碼！

"I acquaint the inhabitants of Liège of this, that they may understand what fate threatens them if they should assume a similar attitude. A raiding party of hostiles had passed near the fort, and had killed, with particular atrocity, a family of settlers. The man and his wife had been tortured to death, the baby had had its brains beaten out against the trunk of a tree, a very young child had been hung by the wrist tendons to two meat hooks on the walls of the ranch-house, and left there to die. One big boy had had his eyelids and lips and nose cut off, and had been staked down to the ground with his remains of a face lying over a red-ant hole. Only two had [Pg 196]managed to escape,—a child of ten, who had carried his tiny sister in his arms, twenty miles of ca?ons and hills, to the post. Every engine of the English Court was put in motion to prevent the Electoral Prince from coming. Oxford had an interview with Schutz, in which he repeated that it was his applying for the writ to the Lord Chancellor instead of to the queen that had done all the mischief; that her Majesty, had it not been for this untoward incident, would have invited the Prince to come over and spend the summer in England—forgetting, as Schutz observed, that the minute before he had assured him that the queen was too much afraid of seeing any of that family here. He advised Schutz—who could not be convinced that he had done anything irregular in his application, quoting numerous proofs to show that it was the accustomed mode of applying for writs—to avoid appearing again at Court; but Schutz, not seeming disposed to follow that advice, immediately received a positive order to the same effect from the queen through another channel. Schutz, therefore, lost no time in returning to Hanover to justify himself. At the same time, Lord Strafford was instructed to write from the Hague, blaming the conduct of Schutz in applying for the writ in the manner he did, as disrespectful to the queen; for, though strictly legal for an absent peer to make such application, the etiquette was that he should defer it till he could do it personally. Strafford ridiculed the idea of any movement being afoot in favour of the Pretender, and observed that, as to sending him out of the Duke of Lorraine's territory, it was not practicable, because the French king maintained that he had fulfilled the treaty, Lorraine not being any part of France. On the other hand, there were striking signs that the cause[17] of Hanover was in the ascendant. Men who watched the course of events decided accordingly. Marlborough, who so lately had been making court to the Pretender, now wrote from Antwerp, urging the House of Hanover to send over the prince without delay to England; that the state of the queen's health made prompt action necessary; and that the presence of the prince in London would secure the succession without risk, without expense, and without war, and was the likeliest measure of inducing France to abandon its design of assisting the Pretender. Shorty had been frantically trying to catch the Deacon's eye, and was making all manner of winks and warning gestures without avail, for the Deacon answered frankly: "Sure you do," Dodd said, and his voice began to rise. He went to the bed, walked along its length to the window, as he talked, never facing Albin. "You know how to make me feel just fine, no worries at all, no complications, just a nice, simple life. With nothing at all in it, Albin. Nothing at all." J. O., I mean it. "Good-bye, my Bluebell, farewell to you, "Cudn't spare one hand to fetch over fifteen—that's a valiant idea. Now d?an't go loitering; fetch out your cattle afore they're roast beef, git out the horses and all the stock—and souse them ricks wot ?un't burning yit." "Do you know my voice?" asked one of Wells's companions. HoME 亚洲春色欧美激情 ENTER NUMBET 0010cciokc.org.cn
www.haotaikeji.com.cn
icanfly.org.cn
kokvip.org.cn
maeson.com.cn
maskid.com.cn
tengdasuliao.com.cn
thevfl.org.cn
www.vitfoss.com.cn
xhscl.com.cn