Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 rootÃÜÂ룿

1¡¢±à¼­MySQLÅäÖÃÎļþ£º
 windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼­¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖÐ ......

mysql Íü¼ÇROOTÃÜÂëµÄ¼òµ¥½â¾ö·½°¸

1.Í£µômysqld
  service mysqld stop
2.ÖØÆômysqld£¬Ö¸¶¨²ÎÊý
  service mysqld start --skip-networking --skip-grant-tables
  »òÕß
  /opt/mysql/bin/mysqld_safe --skip-networking --skip-grant-tables &
  /opt/mysql/ÊÇÎÒµÄMYSQL°²×°Â·¾¶
  skip-grant-tables:Á¬½ÓÊ±Ìø¹ýÊ ......

¡¾×ª¡¿mysqlÏÂÈçºÎÖ´ÐÐsql½Å±¾

Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆÎªmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼ ......

MSSQL ʵÏÖ MySQL µÄ limit ²éѯ·½Ê½

MSSQL ÈçºÎʵÏÖ MySQL µÄ limit ²éѯ·½Ê½
²»ÖªÎªºÎ£¬MSSQL ÖÐûÓÐ limit Õâ¸ö¼«ÎªÖØÒªµÄ²éѯ·½Ê½£¬ÊìϤ MySQL µÄÅóÓѶ¼ÖªµÀ£¬MySQL µÄ limit ¶ÔÓÚʵÏÖ·ÖÒ³ºÍһЩÏÞÖÆ½á¹û¼¯µÄÓ¦ÓÃÖзdz£·½±ã¡£Ã»Óв»Òª½ô£¬ÎÒÃÇ¿ÉÒÔÓÃÆäËû·½·¨´ïµ½Í¬ÑùµÄÄ¿µÄ£¬×Ô¼º¶¯ÊÖ£¬·áÒÂ×ãʳ£¡
Óï·¨£º
Code:
SELECT * from
(
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ