Mysqlshow databases;create database name;use databasename;drop database nameshow tables;describe tablename;select distinctmysqladmin drop databasenamemysqlselect version(),current_date;mysql rootshell>mysql -h localhost -u root -p //mysql> update user set password=password("xueok654123") where user='root';mysql> flush privileges //mysql>use dbname;mysql>show databases;mysql>show tables; mysql use mysql;mysql>describe user; mysql user);grantfirstdb(firstdb)firstdbmysql> create database firstdb;mysql> grant all on firstdb.* to firstdb identified by 'firstdb'firstdbmysql localhost,IP127.0.0.1IPIP grantmysql>grant all on *.* to root@202.116.39.2 identified by "123456";:grant on :insert,select,updateon ,**root@IP identified bydrop database firstdb;something mysql> grant all privileges on *.* to user@localhost identified by 'something' withgrant select on .* to @identified by ""GRANT ALL PRIVILEGES ON *.* TO monty@"%" IDENTIFIED BY 'something' WITH GRANT OPTION;mysql> revoke all privileges on *.* from root@"%";mysql> delete from user where user="root" and host="%";mysql> flush privileges;custom fangchandbmysql >grant select, insert, update, delete, create,drop on fangchandb.* to custom@ identified by ' passwd':mysqldumpshell> mysqldump -h host -u root -p dbname >dbname_backup.sqlshell> mysqladmin -h myhost -u root -p create dbnameshell> mysqldump -h host -u root -p dbname < dbname_backup.sqlshell> mysqladmin -u root -p -d databasename > a.sqlsqlshell> mysqladmin -u root -p -t databasename > a.sqlsql?mysqldump -T./ phptest driver-T./mysqldump driver.sql. txt sqlmysqlmy_file.sqlsql.txtmysql > mysql -h myhost -u root -pMysql5.0MySQL¬(ORACLE)sysuserCreate TABLE `firstdb`.`users` (`id` int(11) NOT NULL auto_increment,`username` varchar(40) default NULL,`birthday` date default NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312;MySQL latin1;MySQL ä(my.ini) ;mysqld ;character_set_server ;ûcharacter_set_server;character_set_database ;ûcharacter_set_database;;mysqldump ;Query Browser1.1notebook copyupdate ers set username='' where id=3;MYSQL1.mysqldump -u §-p --default-character-set=latin1 Q>(latin1)mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql2.mysqldump -u §-p ¿>mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql3.mysqldump -u wcnc -p -d -add-drop-table smgp_apps_wcnc >d:wcnc_db.sql-d -add-drop-table create drop table4.A:sourcemysqlmysql -u root -pmysql>usesource(.sql)mysql>source wcnc_db.sqlB:mysqldumpmysqldump -u username -p dbname < filename.sqlC:mysqlmysql -u username -p -D dbname < filename.sql1MySQL MySQL Command Line Client(MySQL DOS)mysql>2MySQL quit exit1create database <>xhkdbmysql> create database xhkdb;2show databases (s)mysql> show databases;3drop database <>xhkdbmysql> drop database xhkdb;4ºuse <>xhkdbmysql> use xhkdb;Database changed5mysql> select database();6mysql> show tables; (s)1create table <> ( <1> <1> [,..<n> <n>]);> id int(4) not null primary key auto_increment,> name char(20) not null,> sex int(4) not null default '0',> degree double(16,2));2ºdesc show columns frommysql>DESCRIBE MyClassmysql> desc MyClass;mysql> show columns from MyClass;3drop table <>íMyClassmysql> drop table MyClass;4insert into <> [( <1>[,..<n > ])] values ( 1 )[, ( n )]MyClass, 1Tom96.45, 2 Joan 82.99 3 Wangmysql> insert into MyClass values(1,'Tom',96.45),(2,'Joan',82.99),(2,'Wang', 96.59);51)ºselect <12...> from < > where < ï>´MyClassmysql> select * from MyClass;2)´MyClass 2mysql> select * from MyClass order by id limit 0,2;mysql> select * from MyClass limit 0,2;6delete from whereýMyClass 1mysql> delete from MyClass where id=1;7update set =,- wheremysql> update MyClass set name='Mary' where id=1;7alter table add¶À;MyClass passtest int(4)0 mysql> alter table MyClass add passtest int(4) default '0'8rename table íto ;MyClass YouClassmysql> rename table MyClass to YouClass;update set Î=update set Î= replace(,'','');4update article set content=concat('',content);1.INT[(M)] º2.DOUBLE[(M,D)] [ZEROFILL] º()3.DATE 1000-01-019999-12-31MySQL YYYY-MM-DDDATE DATE4.CHAR(M)5.BLOB TEXT65535(2^16-1)6.VARCHAR5.(1).sql(2)auction.c:mysqlbin>mysqladmin -u root -p creatauction(2)auction.sqlc:mysqlbin>mysql -u root -p auction < auction.sqlauction auction6.(1)mysqlalter table dbname add column userid int(11) not null primary keyauto_increment;dbname userid int(11)7.mysqlmysql>grant select,insert,delete,create,dropon *.* (test.*/user.*/..)to @localhostidentified by '';-> ON test.*-> TO testuser@localhost;Query OK, 0 rows affected (0.15 sec)testuser localhosttest testusermysql> GRANT select, insert, delete,update-> ON test.*-> TO testuser@localhost;Query OK, 0 rows affected (0.00 sec)testuser test Select InsertDelete Update MySQLBye9!1:SHOWmysql> SHOW DATABASES;2:2MYSQLDATAmysql> Create DATABASE MYSQLDATA;3:mysql> USE MYSQLDATA; (Database changed !)4:mysql> SHOW TABLES;5:mysql> Create TABLE MYTABLE (name VARCHAR(20), sex CHAR(1));6:mysql> DESCRIBE MYTABLE;7:mysql> insert into MYTABLE values ("hyq","M");8:(D:/mysql.txt)mysql> LOAD DATA LOCAL INFILE "D:/mysql.txt" INTO TABLE MYTABLE;9:.sql(D:/mysql.sql)mysql>use database;mysql>source d:/mysql.sql;10:mysql>drop TABLE MYTABLE;11:mysql>delete from MYTABLE;12:mysql>update MYTABLE set sex="f" where name='hyq';MySql,:/article/htmldata/2004_12/3/57/article_1060_1. htmlwindows MySqlnet start mysql Linux"/etc/rc.d/init.d/mysqld start"MySql root¡rootuse mysql;delete from User where User="";update User set Password=PASSWORD('newpassword') where User='root';User Hostmysql -uroot -pnewpassword;mysql mydb -uroot -p;mysql mydb -uroot -pnewpassword;mydbrootrootMySql UserUser;GRANT GRANTgrant all on mydb.* to NewUserName@HostName identified by "password" ; grant usage on *.* to NewUserName@HostName identified by "password"; grant select,insert,update on mydb.* to NewUserName@HostName identified by "password";grant update,delete on mydb.TestTable to NewUserName@HostName identified by "password";GRANT WITH GRANT OPTION User Password PASSWORDUserREVOKE()FILE: MySQLPROCESS:RELOAD:SHUTDOWN: MySQL//Alter: (/)Create:Delete:Drop:INDEX:Insert:Select: /Update:ALL: (root)USAGE: -----------------------MYSQLmysqlMYSQL MYSQLmysqlMYSQL MYSQLMYSQLºmysql -h O-u§-p11MYSQLDOS mysqlbin mysql -uroot -pMYSQL rootMYSQL MYSQL mysql>22MYSQLIP110.110.110.110root,abcd123 mysql -h110.110.110.110 -uroot -pabcd123(:u root)3MYSQLºexit ()mysqladmin -u§-pÜpassword11root ab12DOS mysqlbinmysqladmin -uroot -password ab12root-p22root djg345mysqladmin -uroot -pab12 password djg345MYSQL()1OK2MYSQLmysql-3.23.27-beta-win1show databases;mysql test mysql MYSQL2use mysql; //FOXBASEshow tables;3describe ;4create database ;5use ;create table ();6:drop database ;drop table ;7delete from ;8select * from ;drop database if exists school; //SCHOOLcreate database school; //SCHOOLuse school; //SCHOOLcreate table teacher //TEACHER(id int(3) auto_increment not null primary key,name char(10) not null,address varchar(50) default '',year date); ////insert into teacher values('','glchengang','','1976-10-10'); insert into teacher values('','jack','','1975-12-23');(1)ID3:int(3):auto_increment:not null primary key(2)NAME10(3)ADDRESS50varchar char(4)YEARmysqlschool.sql c:\DOS \mysql\binmysql -uroot -p< c:\school.sql;(//)1tab null\n.3 rose 1976-10-104 mike 1975-12-232load data local infile "" into table ;\mysql\bin use(DOS\mysql\bin)mysqldump --opt school>school.bbb:school school.bbb school.bbb.Select{*|talbe.*|[table.]field1[AS alias1][,[table.]field2[AS alias2][,]]} FROM tableexpression[,][IN externaldatabase][Where][GROUP BY][HAVING][ORDER BY][WITH OWNERACCESS OPTION]([])({})1 FROMFROM Select FROM()INNER JOIN LEFT JOIN òRIGHT JOININSQLSelect orderID,Customer.customerIDFROM orders CustomersWhere orders.CustomerID=Customers.CustomeersID2 ALL DISTINCT DISTINCTROW TOP(1) ALL SQL ALL FROM Employees(2) DISTINCT(3) DISTINCTROW(4) TOP TOP N PERCENT(N )5%Select TOP 5 PERCENT*FROM [ order Details]orDER BY UnitPrice*Quantity*(1-Discount) DESC3 ÃASASFirstName NickNameFROM EmployeesSelect ProductName ,UnitPrice ,UnitsInStock ,UnitPrice*UnitsInStock AS valueInStockFROM Productsþ.Where1Ë=><>=<=<>!>!<961Select orderID, CustomerID, orderDateFROM ordersWhere orderDate>#1/1/96# AND orderDate<#1/30/96#Mcirosoft JET SQL '#'Datevalue()''Where orderDate>#96-1-1#Where orderDate>Datevalue('1/1/96')NOT9611Where Not orderDate<=#1/1/96#2 (BETWEEN ÍNOT BETWEEN)BETWEEN -AN961962Where orderDate Between #1/1/96# And #2/1/96#3 (IN NOT IN)IN IN ORöLondon Paris BerlinFROM CustomersWhere City In('London',' Paris',' Berlin')4 (LIKE)LIKELIKEä?*# 0~9[][!]-(171)555-0000(171)555-9999FROM CustomersWhere Phone Like '(171)555-####'LIKEʺLIKE 'A*' A¤Bc,c255LIKE'5[*]' 5*5 555LIKE'5?5' 55â55,5wer5LIKE'5##5' 52355005 5kd5,5346LIKE'[a-z]' a-z5,%LIKE'[!0-9]' 0-90,1LIKE'[[]' 1,*ý.ORDER BYorDER(16)(ASC) (DESC)ORDER SQLorDERSelect ProductName,UnitPrice, UnitInStockFROM ProductsorDER BY UnitInStock DESC , UnitPrice DESC, ProductNameorDER BYSelect ProductName,UnitPrice, UnitInStockFROM ProductsorDER BY 1 DESC , 2 DESC,3Ä.Select panyName, FROM Customers, SuppliersWhere Customers.City=Suppliers.CitySelect ProductName,OrderID, UnitInStock, QuantityFROM Products, [Order Deails]Where Product.productID=[Order Details].ProductIDAND UnitsInStock>Quantity½Microsof JET SQL ÐJNNER JOINFROM table1 INNER JOIN table2ON table1.field1 comparision table2.field2comparision WhereFROM EmployeesINNER JOIN orders ON Employees.EmployeeID=Orders.EmployeeIDINNER JOIN Memo OLE Object Single DoubleJOIN ONSelect fieldsFROM table1 INNER JOIN table2ON table1.field1 compopr table2.field1 ANDON table1.field2 compopr table2.field2 orON table1.field3 compopr table2.field3Select fieldsFROM table1 INNER JOIN(table2 INNER JOIN [( ]table3[INNER JOER] [( ]tablex[INNER JOIN]ON table1.field1 compopr table2.field1ON table1.field2 compopr table2.field2ON table1.field3 compopr table2.field3ON table1.field1comparision table.field2FROM ProductsLEFT JOIN orders ON Products.PrductsID=Orders.ProductIDFROM talbe1LEFT JOIN table2 ON table1.a=table2.c1 Iif0IifºIif(IsNull(Amount,0,Amout)50Iif([Amount]>50,?Big order?,?Small order?).SQL GROUP BY HAVING GROUP BYHAVINGGROUP BYSelect fidldlistFROM tableWhere criteria[GROUP BY groupfieldlist [HAVING groupcriteria]]Microsoft JetÝJet OLEGROUP BY NullSQL NullGROUP BY'WA'1 Select Title ,Count(Title) as TotalFROM EmployeesWhere Region = 'WA'GROUP BY TitleHAVING Count(Title)>1JET SQLºSUM ( )AVG ( )COUNT ( )COUNT (* )MAXMINVARSTDEVFIRSTLAST. ParametersParameters:PARAMETERS name datatype[,name datatype[, ]]name ,.Datatype.PARAMETERS .:Select orderID ,OrderAmountFROM ordersWhere orderAMount>[low price]AND orderDate>=[Beginning date].,,.,,.,,,.1Update..:UpdateSETWhere:5%,3%SET orderAmount = orderAmount *1.1Freight = Freight*1.03Where ShipCountry = 'UK'2Delete.:.Delete:Delete [.*]FROMWhere: 94FROM ordersWhere orderData<#94-1-1#3Insert.INTOvalueS .Insert :INSETR INTO (1,2,)valueS(1,2,):Insert INTO Employees(FirstName,LastName,title)valueS('Harry','Washington','Trainee')4..Select INTO:Select 1,2,INTO [IN ]FROMWhere:INTO ordersArchiveFROM orders.UNION.UNION:[] 1 UNION [ALL] 2 UNION:Select CompanyName,CityFROM SuppliersWhere Country = 'Brazil'UNIONSelect CompanyName,CityFROM CustomersWhere Country = 'Brazil':,UNION.,ALL UNION.,.GROUP BY ¾ HAVING .,OREER BY..,,,:,.Microsoft Jet SQL TRANSFROM:TRANSFORM aggfunctionSelectGROUP BYPIVOT pivotfield[IN(value1 [,value2[,]]) ]Aggfounction SQL,Select,GROUP BYPivotfield ,IN .value.:1996:TRANSFORM Count(OrderID)Select FirstName&''&LastName AS FullNameFROM Employees INNER JOIN ordersON Employees.EmployeeID = orders.EmployeeIDWhere DatePart("yyyy",OrderDate)= '1996'GROUP BY FirstName&''&LastNameorDER BY FirstName&''&LastNamePOVOT DatePart("q",OrderDate)&''®.Ò.Select.1:ïcomparision [ANY|ALL|SOME]()ANY SOME,(=,<,>,<>,<=,>=).TrueòFalse.ANY,,True,ANYÄTrue(Where),.ALLÄTrue,True.:25%Select * FROM ProductsWhere UnitPrice>ANY(Select UnitPrice FROM[Order Details] Where Discount>0.25)2:[NOT]IN():1000.Where ProductID IN(Select PrdoctID FROM [Order DEtails]Where UnitPrice*Quantity>= 1000)3:[NOT]EXISTS ():EXISTSFROM ordersWhere EXISTS(Select *FROM CustomersWhere Country = 'UK' ANDCustomers.CustomerID= orders.CustomerID)1:SHOWmysql> SHOW DATABASES;2:2MYSQLDATA3:mysql> USE MYSQLDATA; (Database changed !)4:mysql> SHOW TABLES;5:mysql> Create TABLE MYTABLE (name VARCHAR(20), sex CHAR(1));6:mysql> DESCRIBE MYTABLE;7:mysql> insert into MYTABLE values ("hyq","M");8:(D:/mysql.txt)mysql> LOAD DATA LOCAL INFILE "D:/mysql.txt" INTO TABLE MYTABLE;9:.sql(D:/mysql.sql)mysql>use database;mysql>source d:/mysql.sql;10:mysql>drop TABLE MYTABLE;11:mysql>delete from MYTABLE;12:mysql>update MYTABLE set sex="f" where name='hyq';MySql,:/article/htmldata/2004_12/3/57/article_1060_1.htmlwindows MySql net start mysqlLinux/etc/rc.d/init.d/mysqld start"MySql root¢rootuse mysql;delete from User where User="";update User set Password=PASSWORD('newpassword') where User='root';User Hostmysql -uroot -pnewpassword;mysql mydb -uroot -p;mysql mydb -uroot -pnewpassword;mydbroot rootMySql UserUser;GRANT GRANTgrant usage on *.* to NewUserName@HostName identified by "password";grant select,insert,update on mydb.* to NewUserName@HostName identified by "password";grant update,delete on mydb.TestTable to NewUserName@HostName identified by "password";GRANT WITH GRANT OPTIONUser Password PASSWORDUser REVOKE()FILE: MySQLPROCESS:RELOAD:SHUTDOWN: MySQL//Alter: (/)Create:Delete:Drop:INDEX:Insert:Select: /Update:ALL: (root)USAGE: --1MySQLcreate database name;use databasename;drop database nameshow tables;describe tablename;select distinctmysqladmin drop databasenamemysqlselect version(),current_date;2mysql rootshell>mysql -u root -pmysql> update user set password=password(±xueo654123) where user=¯roo;mysql> flush privileges //mysql>use dbname;mysql>show databases;mysql>show tables; mysql use mysql;mysql>describe user; mysql user);3grantsomething mysql> grant all privileges on *.* to user@localhost identified by ¯somethingrant select on .* to @identified byGRANT ALL PRIVILEGES ON *.* TO monty@localhost IDENTIFIED BY ¯somethin¡¯ WITH GRANT OPTI;GRANT ALL PRIVILEGES ON *.* TO monty@%± IDENTIFIED BY¡¯somethi g¡¯ WITH GRANT OPT;mysql> revoke all privileges on *.* from root@%;mysql> delete from user where user=±roo¡± and ho=%;mysql> flush privileges;custom fangchandbidentified by ® passw:mysql > alter table t1 rename t2;4mysqldumpshell> mysqldump -h host -u root -p dbname >dbname_backup.sqlshell> mysqldump -h host -u root -p dbname < dbname_backup.sqlshell> mysqladmin -u root -p -d databasename > a.sqlsqlshell> mysqladmin -u root -p -t databasename > a.sqlsql?mysqldump -T./ phptest driver-T./mysqldump driver .sql.txt sql5mysqlmy_file.sqlsql.txt:mysql > mysql -h myhost -u root -p database < sql.txt//mysqld --console//mysqladmin -u root shutdown// Kmysqlmysql -u root -p mysqlmysql -u root -p -h 11.11.11.11 database//create database db_name [default character set=gbk]//alter databse db_name default character set gbk// ýuse database test after log onuse test// ¼create a table mypic to store picturecreate table mypic (picid int, picname varchar(20), content blob);// Vdescribe table mypicdesc mypic//show create table table_name//alter table table_name engine innodb|myisam|memory// insert a recordinsert into mypic values (1, '', 0x2134545);// show current userselect user();// Vshow current passwordselect password('root');// show current date// change user passwordupdate user set password=password('xxx') where user='root';// Ugrantgrant all privileges on *.* toroot@localhostgrant select,insert,delete,update,alter,create,drop on lybbs.* tolybbs@"%" identified by "lybbs"; grant select,insert,delete,update,alter,create,drop on lybbs.* tolybbs@localhostidentified by "lybbs"; // flush privilegesflush privileges// Óadd primary keyalter table mypic add primary key (picid)// Óadd a new column userid after picidalter table mypic add column userid int after picid// ,blob100kalter table userpic change image image longblob;alter table userpic modify image longblob;// gb2312mysqld --default-character-set=gb2312//show full columns from userpic;//Alter TABLE userpic CHARACTER SET gb2312;// mysql jdbc urljdbc:mysql://localhost/test?useUnicode=true&characterEncoding=gb2312//sourceMySQL SQL MySQL AB MySQL AB MySQL****MySQL MySQL ABMySQL SQL MySQL(mass-deployed)This document was created with Win2PDF available at . The unregistered version of Win2PDF is for evaluation or non-commercial use only.。