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

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

лл¡£Ð»Ð»¡£


Ïà¹ØÎÊ´ð£º

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Á©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......

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

½¨±í£º²å¼Ç¼
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 ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......

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

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

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

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

Ö§³Ö£¬¼ì² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ