mysql´íÎó
ÔÚ±¾µØ¼ÆËã»úÎÞ·¨Æô¶¯mysql ´íÎó3£ºÏµÍ³ÕÒ²»µ½ÖªµÀ·¾¶ ÎÒËÑÁËÒ»ÏÂû¿´µ½½â¾öµÄ£¬³ýÁË֨װ£¬µ«ÊÇÄÇÑùÌ«Âé·³£¬¶øÇÒ²»ÖªµÀÔõôµÄÎÒ×ܳöÕâ¸öÎÊÌâ ´ó¼Ò˰ïæ½â¾öÏÂ
Õâ¸öÎÊÌ⻹ÊÇÖØÐÂ×°°É£¬¿ÉÄÜÊÇÄãɾ³ýÁËmysqlµÄϵͳÎļþ¡£ Õâ¸öÎÊÌâÎÒÓöµ½¹ý ÊÇÒòΪÄãµÄmySql·þÎñËÀÁË£¬É¾³ý·þÎñ £¬È»ºóÖØÐ°²×°mySql¼´¿É ÎÒ¾ÍÊÇÏëÖªµÀ³ýÁË֨װ»¹ÓбðµÄ°ì·¨Ã» ±ÈÈç Ôö¼Ó»òÐÞ¸ÄÒ»¸ö×¢²á±íʲôµÄ ֨װMySQLÓÖ²»Âé·³£¬ һϾÍ×°ÍêÁË£¬ ÖØ×°Ê²Ã´ÎÊÌâ¶¼½â¾öÁË¡¡ ±ØÐë֨װÁË¡£ ¡£Èç¹û֨װµÄʱºò ÄãµÄmysql·þÎñÆð²»À´ ¾ÍÒªÏñÎÒ¸Õ²Å˵µÄ ÏȰÑÒÔǰµÄ·þÎñɱËÀ È»ºóÔÙÖØÐÂ×°¡£ ÂÌÉ«°æMYSQL¡£¡£¡£¡£¡£¡£¡£É¶¶¼²»×°£¬¾ÍÅäÖà ǰ2Ìì¸ÕÓöµ½Ò»´Î£¬ÖØ×°ÁË¡£¡£¡£ Åöµ½mysqlµÄһЩÎÊÌ⣡£¡ÕæµÄÒ²¾ÍÊǸßÊÖÄܽâ¾ö£¡£¡ ×îºÃµÄ·½·¨»¹ÊÇ֨װ°É ½¨ÒéÄãÖØÐ°²×°£¬²»È»µÄ»°£¬Äã¿´¿´ÊDz»ÊÇ·þÎñÿ´ò¿ª£¬»òÕßÊDz»ÊÇ360 ʲôµÄ°ÑÕâ¸ö·þÎñ¸ø½ûÖ¹ÁË¡£ ÒýÓà ÂÌÉ«°æMYSQL¡£¡£¡£¡£¡£¡£¡£É¶¶¼²»×°£¬¾ÍÅäÖà ¾ÍÊÇÕâÖÖÂÌÉ«°æ£¬Èç¹û°ÑÎļþɾÁË£¬·þÎñÈ·»¹Áô×Å£¬Õâ¸ö·þÎñ¾Í±ä³ÉËÀ·þÎñÁË£¬»áÈÃÈ˺ÜÍ·ÌÛ ÖØ×°Ò»¸ömysqlÓÐÂé·³£¿
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡ Íò·Ö¸Ðл£¡ String SQL=&q ......
ÈçºÎÓÃsql²é¿´±íµÄÁг¤¶È show create table xxx; ¿ÉÒÔ»ñµÃ½¨±íÃüÁÔÙ½øÐзÖÎö£¬Ó¦¸ÃÄܵõ½ÏëÒªµÄÐÅÏ¢ MySQL 5 ÒÔÉÏ£¬Äã¿ÉÒÔ´ÓÊý¾Ý×ÖµäÖв鵽 select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,DATA_TYPE,CHAR ......