ÔõÑùѧMYSQL - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ËÓÐMYSQLÊÓÆµ¼°×ÊÁÏ£¬Çë·¢ËÍÖÁtanhualin1985@163.com£¬±¾È˷dz£¸Ðл
ÏȶÁN±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî) È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éMYSQLµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ£¬µÚ¼¸Ò³£©MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.htmlÒýÓà ËÓÐMYSQLÊÓÆµ¼°×ÊÁÏ£¬Çë·¢ËÍÖÁtanhualin1985@163.com£¬±¾È˷dz£¸Ðл ÏÂÒ»±¾<<MySQLȨÍþÖ¼ÄÏ>>£¬ÕÕ×ÅÉϱßʵ×÷£¬È»ºó£¬Online Help¾³£´ò¿ª··¡£²»ÐèҪʲôÊÓÆµµÄ¡£ ÏÈ¿´¿´ÓйØÊý¾Ý¿âµÄ»ù±¾ÖªÊ¶£¬ÔÙ¿´MYSQLµÄHELP£¬¶à¶¯ÊÖÁ·Ï° ¿´¹Ù·½ÊÖ²á°É¡£ ¶¯ÊÖ+¿´Ê飡
Ïà¹ØÎÊ´ð£º
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
ÎÒÏÖÔÚÏëÓÃJSPʵÏÖQQÓÊÏäÀïµÄ¶¨Ê±·¢ËÍ£¬ÎÒÏëͨ¹ýÊý¾Ý¿â½øÐж¨Ê±²åÈëÊý¾Ý¡£ µ«²»ÖªµÀÈçºÎʵÏÖ£¬»òÕß´ó¼ÒÓиüºÃµÄ·½·¨£¬²»Ò»¶¨ËµÊÇÊý¾Ý¿â¡£ Çë´ó¼Ò¸øµãÒâ¼û£¬°ÝлÀ²¡£ quataz¶¨Ê±Æ÷×é¼þÊǸöºÜºÃµÄ½â¾ö·½°¸¡£ È ......
ÎÒÐèҪʹÓÃnhibernateµ÷ÓÃmysqlº¯Êý£¬ÀàËÆµÄsqlÓï¾ä£º select * from concat(',', ServiceCodes, ',') like '%,33,%'; »òselect * from (','||ServiceCodes||',') like '%,33,%'; ËùÒÔÎÒ¾ÍÕâÑùµ÷Ó㺠//..... ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã ´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
¸ãÁËÒ»¸öÏÂÎçÁË£¬ËÑË÷ÁËÍøÂ绹Êǽâ¾ö²»ÁË...Ï£Íû¸ßÊÖ°ïæ½â¾öÏ Դ´úÂ룺 private void SendPhoto(HttpServletRequest request, HttpServletResponse response) { String name=request.getParamet ......