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

¼±£¬MySQLÖÐÎÄÄÚÈÝÎÞ·¨±£´æµÄÎÊÌ⣿£¿

±ísongµÄ±àÂëÊÇutf8£¬Ö´ÐÐinsert²Ù×÷ǰִÐÐÁËSET NAMES 'utf8'¼°SET sql_mode=''µÄ²Ù×÷£¬sqlÓï¾ä´òÓ¡³öÀ´×Ö¶Îspecialname¶ÔÓ¦µÄÒ²ÓÐÄÚÈÝ£¬ÊÇÈÕÎÄ(ÓеÄÈÕÎÄÄܱ£´æ£¬ÓеÄÈÕÎIJ»Äܱ£´æ)£¬µ«ÊDZ£´æÔÚÊý¾Ý¿âÖÐÒÔºó×Ö¶ÎspecialnameµÄÖµÊǿյ쬲»ÖªµÀΪʲô£¬Í¬ÑùµÄ£¬×Ö¶Îsongname¶ÔÓ¦µÄÖµÖÐÒ²ÓÐÖÐÎÄ£¬µ«ÊÇ´Ë×ֶεÄÖµ¼´¿ÉÒÔÕý³£±£´æ£¬Í¦Ææ¹ÖµÄ£¬Ï£Íû¸ßÊÖÄܰïÎÒ½â¾öһϣ¬¶àлÁË£¡

Ìáʾ£º×Ö¶ÎspecialnameµÄ³¤¶ÈÊÇ×ã¹»³¤µÄ¡£

2010-04-06 15:42:42 0.90594300 update_data new songid: |337430|
2010-04-06 15:42:42 0.90604500 Sql: INSERT INTO song (sengerid,specialid,songname,lrc,islrc,category_id,specialname,fid,isshow) VALUES ('7474','69363','¥ë¥Ê?¥ì¥¬ー¥í ~Ô¤«¤é¤Î贈¤êÎï~','','0','8','¥Ê?¥ì¥¬ー¥í ~Ô¤«¤é¤Î贈¤êÎï~ (Single)','92294160','1')

±ísongµÄ½á¹¹


create table
CREATE TABLE `song` (
  `songid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '¸èÇúid',
  `songname` varchar(150) NOT NULL,
  `specialname` varchar(100) NOT NULL DEFAULT '',
  `lrc` text NOT NULL,
  `specialid` mediumint(9) NOT NULL DEFAULT '0',
  `sengerid` int(11) NOT NULL DEFAULT '0',
  `isshow` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñ¿ÉÒÔʹÓÃ',
  `islrc` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñÊÇlrc¸è´Ê£¬1±íʾÊÇ£¬0±íʾ²»ÊÇ',


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

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

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

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

mysqlÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......

MysqlȨÏÞ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVI ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ