mysql ¼òµ¥²éѯÎÊÌâ
±íA
name1
aa
ÎҵIJéѯÓï¾äÊÇ£º
select 'ÎÒµÄÃû×Ö½Ð'+name1 from ±íA
ÎÒÏëÒªµÄ½á¹ûÊÇ
ÎÒµÄÃû×Ö½Ðaa
µ«Êǵõ½µÄ½á¹ûÈ´ÊÇ
aa
Ϊʲô
ÄÄλ֪µÀµÄ
°ïÎÒ½â¾öÏÂ
MySQL ÖÐ×Ö·û´®ÏàÁ¬ÊÇÓà concat ºÍSQL SERVER²»Ò»Ñù¡£
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
±¾ÈËÏëÖªµÀMySqlÔõôÔÚÊý¾Ý°²×°µÄʱºò¾ÍÄÜ×Ô¶¯È¥Éú³ÉһЩĬÈϵÄÓû§ºÍȨÏÞÄØ£¨Óû§£ºClient£¬ÃÜÂ룺12345£©£¿
±ÈÈçÊDz»ÊÇÐèҪд×Ô¶¯°²×°½Å±¾°¢£¿µÈµÈ£¬Ð»Ð»£¡
MySQLµÄ±ê×¼°²×°£¬»òÕ߷ǰ²×°°æ±¾Öв»»á°ïÄã´´½¨ÕâЩ ......