mysqlÊý¾Ýµ¼³öµ½sqlserver·½·¨
ÕâÀïÊÇʹÓÃODBCÀ´×ª»»Êý¾Ý¿âµÄ¡£
1.°²×°mysqlÊý¾Ý¿âµÄODBCÇý¶¯£¬mysql¹ÙÍøÓÐÏÂÔØhttp://dev.mysql.com/downloads/connector/odbc/
2.´ò¿ª¿ØÖÆÃæ°å\¹ÜÀí¹¤¾ß\Êý¾ÝÔ´ODBC£¬ÔÚÓû§DSNÖÐÌí¼ÓÒ»¸öMySQL ODBC Êý¾ÝÔ´¡£
3.½Ó×ÅÔÚÏÂÃæµÄ´°ÌåÖÐÊäÈëÊý¾ÝÔ´Ãû³Æ£¬Èçmysqlodbc£»È»ºóÊäÈë·þÎñÆ÷ServerµØÖ·£¨localhost»òÆäËû£©£¬Óû§User£¬ÃÜÂëPassword£¬ÊäÈëÕýÈ·ºóÑ¡ÔñÒªµ¼ÈëµÄÊý¾Ý¿â¡£ÔÚÁ¬½ÓÑ¡Ïîconnect optionsÖиù¾ÝÐèÒªÉèÖÃMySqlʹÓõĶ˿ÚportºÍ×Ö·û¼¯Character Set¡£ ×Ö·û¼¯Ò»¶¨ÒªºÍMysql·þÎñÆ÷Ïà¶ÔÓ¦£¬Èç¹ûMysqlʹÓÃÁËgbk×Ö·û¼¯£¬ÔòÒ»¶¨ÒªÉèÖÃ×Ö·û¼¯Îªgbk£¬·ñÔòµ¼Èëµ½Sql Server¿ÉÄÜ»á³öÏÖÎʺÅÂÒÂë¡£
4.´ò¿ªsql serverÆóÒµ¹ÜÀíÆ÷£¬Ð½¨Ò»Êý¾Ý¿âMySql¡£Ñ¡Ôñ¸ÃÊý¾Ý¿â£¬µ¥»÷ÓÒ¼üÑ¡ÔñËùÓÐÈÎÎñ\µ¼ÈëÊý¾Ý¡£
5.Ñ¡ÔñÊý¾ÝԴΪÆäËü(ODBCÊý¾ÝÔ´)£¬Óû§/ϵͳDSNΪmysqlodbc¡£ÆäÓà¸ù¾ÝÏòµ¼½øÐУ¬¼´¿É½«Êý¾Ý´ÓMySqlÊý¾Ý¿âµ¼Èëµ½MSSQLÊý¾Ý¿âÖС£
µ¼Èëµ½sqlserverµÄÊý¾Ý¿â¿ÉÄÜÓÐЩ±íÓдíÎ󣬱ÈÈç±íÖÐÊý¾Ýδµ¼È룬±íÖ÷¼üδÉèÖã¬×ֶθñʽ²»ÕýÈ·µÈµÈ£¬ÒªÖØÐÂÉèÖûò²åÈë¡£
Ïà¹ØÎĵµ£º
DATETIME¡¢DATE ºÍ TIMESTAMP ÀàÐÍÊÇÏàËÆµÄ¡£±¾ÆªÃèÊöÁËËüÃǵÄÌØÐÔÒÔ¼°ËüÃǵÄÏàËÆµãÓ벻ͬµã¡£
DATETIME ÀàÐÍ¿ÉÓÃÓÚÐèҪͬʱ°üº¬ÈÕÆÚºÍʱ¼äÐÅÏ¢µÄÖµ¡£MySQL ÒÔ 'YYYY-MM-DD HH:MM:SS' ¸ñʽ¼ìË÷ÓëÏÔʾ DATETIME ÀàÐÍ¡£Ö§³ÖµÄ·¶Î§ÊÇ '1000-01-01 00:00:00' µ½ '9999-12-31 23:59:59'¡£(“Ö§³Ö”µÄº¬ÒåÊÇ£¬¾¡¹Ü¸üÔ ......
phpºÍjavaͨÓÃsqlÓï¾ä·¨
SELECT max(id) from table
¸Ã·½·¨ÔÚ¶àÏ̵߳ÈÇé¿öÏ¿ÉÄÜ»áÔì³É²»ÕýÈ·¡£
javaÈýÖÖ·½·¨
1¡¢¸ù¾ÝpsµÄgetGeneratedKeys
PreparedStatement ps = conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS); //ºìÉ«Êǹؼü
ps.executeUpdate(); //Ö´Ðкó
ResultSet rs = ps.getGeneratedKeys ......
1 ÄÚ´æ±íµÄ±í»ú¹¹»¹ÊÇÔÚÊý¾Ý¿âÖеģ¬Ö»ÊÇÊý¾Ýʱ·ÅÔÚÄÚ´æÖеġ£
2 ÄÚ´æ±íÖв»¿ÉÒÔʹÓÃTEXTºÍBLOBÀàÐ͵Ä×ֶΡ£
3 ÄÚ´æ±í¿ÉÒÔͨ¹ýmax_heap_table_size = 2048MÀ´¼Ó´óʹÓõÄÄÚ´æ¡£
1 ÁÙʱ±íµÄ±í»ú¹¹ºÍÊý¾Ý¶¼ÊÇ·ÅÔÚÄÚ´æÖеÄ
¾ßÌå¼ûÏ£º
ÄÚ´æ±íʹÓùþϣɢÁÐË÷Òý°ÑÊý¾Ý±£´æÔÚÄÚ´æÖУ¬Òò´Ë¾ßÓм«¿ìµÄËÙ¶È£¬Êʺϻº´æÖÐСÐÍÊý¾Ý¿ ......
¸÷λ¸ßÊֺá£Ð¡µÜѧϰJAVA²»¾Ã£¬È»ºóÔÙÓÃMYSQLÊý¾Ý¿â¡£
ÓÉÓÚÊÇÓñðÈ˵ĵķ¶Àýѧϰ£¬ËùÒÔ³öÏÖºÜ¶àÆæ¹ÖµÄÎÊÌâ
ÎÒÓÃ×Ô¼ºµÄMYSQL ·þÎñÆ÷£¬È»ºó°Ñ±ðÈ˵ÄÊý¾Ý¿âµ¼½øÀ´¡£È»ºó³öÏÖ°æ±¾ÎÊÌâ¡£
ÎÊÌâÈçÏÂ
Table './db_librarysys/tb_manager' was created with a different version of MySQL and cannot be read
2010-4-28 22:44 ......