mysql°ÑËùÓбíµÄIDÉèÖÃÖ÷¼ü
ÔÚ½¨±íµÄʱºòÍü¼ÇÉèÖ÷¼üÁË¡£ ÏÖÔÚÏë°ÑËùÓеıíµÄID×Ö¶ÎÉèΪÖ÷¼ü¡£ ÓÐûÓÐÓï¾ä¡£²»ÓÃÒ»¸ö¸ö±í´ò¿ªÈ¥Éèѽ¡£
Èç¹ûIDµÄÀàÐͲ»Í³Ò»£¬ÓÐchar ÓÐ int µÄ»°£¬Ôò½¨ÒéÄã´Ó information_schema.`COLUMNS` µÃµ½ÕâЩIDµÄÁкÍÀàÐÍ¡£ SQL code: SELECT C.`TABLE_NAME`, C.`COLUMN_NAME`, C.`DATA_TYPE` from information_schema.`COLUMNS` C where TABLE_SCHEMA='test' and COLUMN_NAME='id'; È»ºóÔÙµ½EXCELÖнøÐвÙ×÷¡£ Èç¹û²»ÏëÓÃEXCELµÄ»°£¬ÄÇô¾Í×Ô¼ºÐ´³ö¸ö´æ´¢¹ý³ÌÁË¡£ ºÇºÇ£¬ºÃ°ì·¨¡£ »¹ÓÐûÓиü¼òµ¥µÄѽ¡£µÈ¼¸·ÖÖÓ¡£ ID¶¼ÊÇINT ²»»áд ´æ´¢¹ý³Ì ÄØ¡£ÓÐûÓеãÌáʾѽ¡£ÒýÓà ²»»áд ´æ´¢¹ý³Ì ÄØ¡£ÓÐûÓеãÌáʾѽ¡£ ÄǾÍÓÃEXCEL°É¡£1·ÖÖӾͿÉÒÔ½áÊøµÄÊÂÇé¡£ show tables; ¸´ÖƵ½excel excel д¹«Ê½£¬ÏÂÀ£¬¸´ÖÆ ¸´ÖÆ»ØmysqlÃüÁî´°¿Ú¡£ Èç¹ûÄãÏëѧϰMYSQLµÄ´æ´¢¹ý³Ì£¬Äã¿ÉÒÔÏȲο¼Ò»Ï¹ٷ½ÊÖ²áÖеÄÀý×Ó¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html лл¡£Ð»Ð»¡£
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ ......
ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£© ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......
½¨±í£º²å¼Ç¼ SQL code: create table tablename (id int,RQ1 datetime,RQ2 datetime) -- select * from tablename insert into tablename select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÈçÌ⣬MySQL²»»áÕâÑù°É Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£ http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx MySQL ÖÐÎÄÏÔʾÂÒÂë Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖà ֧³Ö£¬¼ì² ......