Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MYSQL ±¸Íü¼

MySQL client programs:
mysql
The command-line tool for interactively entering SQL statements or executing them from a file in batch mode. See Section 4.5.1, “mysql — The MySQL Command-Line Tool”.
mysqladmin
A client that performs administrative operations, such as creating or dropping databases, reloading the grant tables, flushing tables to disk, and reopening log files. mysqladmin can also be used to retrieve version, process, and status information from the server. See Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”.
mysqlcheck
A table-maintenance client that checks, repairs, analyzes, and optimizes tables. See Section 4.5.3, “mysqlcheck — A Table Maintenance and Repair Program”.
mysqldump
A client that dumps a MySQL database into a file as SQL, text, or XML. See Section 4.5.4, “mysqldump — A Database Backup Program”.
mysqlimport
A client that imports text files into their respective tables using LOAD DATA INFILE. See Section 4.5.5, “mysqlimport — A Data Import Program”.
mysqlshow
A client that displays information about databases, tables, columns, and indexes. See Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”.
mysqlslap
A client that is designed to emulate client load for a MySQL server and report the timing of each stage. It works as if multiple clients are accessing the server. See Section 4.5.7, “mysqlslap — Load Emulation Client”.


Ïà¹ØÎĵµ£º

Mysql·þÎñ°²×°ºÍжÔØÃüÁî

ÆäʵÈç¹ûÄã·þÎñÆ÷ÖØа²×°ÁË,Ò²²»±ØÖØа²×°mysql ¼¸¸öСÃüÁî¾Í¸ã¶¨ÁË
Ê×ÏÈÊÇ°²×°mysql·þÎñ:
mysql-nt –install
net start  mysql
µ±È»Ó´ÔÚbinĿ¼ÔËÐÐÕâ¸öÃüÁîÁË
жÔصÄÃüÁîÊÇ:
net stop "MySQL"
mysqld-nt.exe –remove "MySQL"
ΪʲôÓеÄÅóÓÑжÔز»ÁËÄØ,ÒòΪËûÒѾ­°ÑÔ´Îļþ¶¼É¾³ýÁË »òÕßÔËÐÐÐ ......

mysql Óï·¨

Transact_SQLСÊÖ²á
*******************Transact_SQL********************
--Óï ¾ä                                ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT & ......

oracleÏòmysqlÒÆÖ²

ÓÐһЩûÓÐʹÓÃÊý¾Ý¿âÖмä¼þµÄÈí¼þ¿ÉÄÜ»áÅöµ½ÔÚ²»Í¬µÄÓ¦Óó¡¾°ÐèÒªÓò»Í¬µÄÊý¾Ý¿â£¬ÕâÑù¿ÉÄܾÍÐèÒª½«Êý¾Ý¿â´úÂë×öÒÆÖ²£¬ÎÒÕâÀïÕûÀíÁËһЩ´Óoracleµ½mysqlµÄÒÆÖ²¹ý³ÌÖеÄ×¢ÒâÊÂÏ
1¡£sequenceÉú³É
¿ÉÒÔÓÃÀàËƵĶ«Î÷À´×ö,ÈçÏ£º  
  create   table   myseq   ( &nb ......

MysqlÖеÄisolation level

MysqlÖеÄÊÂÎñ¿ÉÒÔÔËÐÐÔÚÏÂÃæ4¸öisolation levelÖУ¬Ó°Ïì×Åselect²Ù×÷µÄ½á¹û£º
1. Read Uncommitted
ÊÂÎñ¿ÉÒÔ¶Áµ½ÆäËûÊÂÎñûÓÐÌá½»µÄÄÚÈÝ
2. Read Committed
ÊÂÎñ¿ÉÒÔ¶Áµ½ÆäËûÊÂÎñÒѾ­Ìá½»µÄÄÚÈÝ
3. Repeatable Read
InnoDBµÄĬÈÏlevel£¬¿ÉÒÔÈ·±££¬ÔÚÊÂÎñÖÐÿ´ÎÖ´ÐеĶÁ²Ù×÷·µ»ØµÄ½á¹û¶¼ÓëµÚÒ»´ÎʱµÄÒ»ÖÂ
4. Seriali ......

MySQLµÄÃÜÂëÉèÖÃ

http://www.3d308.cn/article.asp?id=37
shell> mysql -u root mysql
mysql> Update user SET Password=PASSWORD('new_password')
           Where user='root';
mysql> FLUSH PRIVILEGES; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ