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

¹ØÓÚÔÚDOS(CMD)ÖÐʹÓÃmysqlÃüÁî²éѯµÄһЩÎÊÌ⣬

ÎÒÔÚCMDÀïÃæÐ´ÁËSQLÓï¾äÁË£¬ÎªÊ²Ã´ÎÒÒ»°´ÏÂenter¼üµÄʱºò£¬ÄÇô¼´Ê¹°´ÁËɾ³ý¼ü£¬È´ÎÞ·¨°ÑÉÏÒ»ÐеĸøÉ¾³ý,ÈçºÎ²Å¿ÉÒÔ½«ÉÏÒ»ÐÐɾ³ý¡£
ÎÒÒѾ­Ð´Á˵ÄÒѾ­Ö´ÐÐÁ˵ÄÔõôÐ޸İ¡¡£
ÊDz»ÊÇCMDÖÐ ÓÐÊ²Ã´ÌØ±ðµÄʹÓ÷½·¨£¬mysqlÓõ½µÄCMDµÄС¼¼ÇÉÓÐÄÄЩ°¡¡£
ûÓа취ɾ³ýÉÏÒ»Ðеġ£

mysql> select test from ssad
    -> where < Ö»ÄÜɾ³ýµ±Ç°ÐС£

»òÕßÄãÓà \c È¡ÏûÕû¸ö¸öÃüÁî¡£

mysqlÃüÁîÐй¤¾ßûʲô̫¶àµÄ¼¼ÇÉ¡£ Äã¿ÉÒÔ°´ help

SQL code:
mysql> select test from ssad
-> where \c
mysql> help

For information about MySQL products and services,
http://www.mysql.com/
For developer information, including the MySQL Ref
http://dev.mysql.com/
To buy MySQL Network Support, training, or other p
https://shop.mysql.com/

List of all MySQL commands:
Note that all text commands must be first on line
? (\?) Synonym for `help'.
clear (\c) Clear command.
connect (\r) Reconnect to the server. Optional a
delimiter (\d) Set statement delimiter.
ego (\G) Send command to mysql server, displ
exit (\q) Exit mysql. Same as quit.



Ò»°ãÀ´ËµÃüÁîÐй¤¾ßд½Å±¾±È½Ï·½±ã¡£ÁíÍâ¿´µÃ±È½ÏÇå³þ¡£

ºÇºÇ£¬Ã»ÓУ¬ÔÚMYSQLµÄÃüÁîÐÐϹ¦ÄÜ¡¡Ã»ÓÐÔÚWINXP¡¡DOSϹ¦ÄÜÇ¿´ó£¬¸Õ¿ªÊ¼Ê¹ÓõÄʱºò£¬
Ò²²»Ï°¹ß¡£

¿ÉÒÔÓÃ
\c
ÇåÀíÈ«²¿



Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ÉÊÇÎÒÕÒ ......

ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

MYSQLÊÂÎñ»Ø¹öµÄÎÊÌâ

SQL code:

CREATE PROCEDURE A()
BEGIN
DECLARE 'Constraint Violation'
CONDITION FOR sqlexception;
DECLARE EXIT HANDLER FOR
'Constraint Violation' ROLLBACK;
BEGIN TRAN ......

MYSQL character_set_server Ôõô¸Ä

ÎÒ¿ª·¢ASP.netʱ 
²åÈëÍâÎÄÂÒÂë 
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8 
character_set_connection utf8 
character_set_database utf8 
ch ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ