xampp Óë mysql - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒÊDzËÄñ£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
ÎÒµÄmysql rootÃÜÂëÊÇ root
×Ô´Ó°²×°ÁËxamppÖ®ºó£¬Ö±½ÓÔËÐÐMySQL Command Line Client ÊäÈëroot¾Í²»ÄܽøÈëmysql£¬¶ø¿ªÆôxamppÖ®ºó¾Í¿ÉÒÔ¡£²¢ÇҹرÕÁËxamppÖ®ºóÒ²¿ÉÒÔ½øÈëmysqlÁË¡£
Ò²¾ÍÊÇ˵£¬Ã¿´Î¿ª»úÎÒÔÚÔËÐÐmysql֮ǰ±ØÐëÏÈÔËÐÐÒ»´Îxampp¡£ÕâÊÇʲôµÀÀíÄØ£¿
ÄãµÄmysqlÓ¦¸ÃÊÇÓÉxamppÁ¬´øÆô¶¯µÄ.
¿ÉÄÜÊÇ£¬µ«ÊÇÎÒµÄmysql°²×°ÔÚxampp֮ǰ¡£
ÄÇôxampp¸Ä±äÁËmysqlµÄÉèÖá£Æñ²»ÊÇmysql¾Í²»°²È«¡£ÈκÎÈ˶¼¿ÉÒÔͨ¹ý°²×°xampp½øÈëÊý¾Ý¿â¡£
ÕâÑù×Ó£¿ÄÇ¿ÉÄÜÊÇxampp¸Ä¶¯ÁËmysqlµÄÆô¶¯²ÎÊý¡£
Äã´Ó·þÎñÁбíÀï¿´¿´mysql·þÎñµÄÆô¶¯²ÎÊý¡£¿´Ëü¶ÔÓ¦µÄÊÇÄĸöÅäÖÃÎļþ£¿
ÁíÍ⣬ÄãÍêÈ«¿ÉÒÔÊÖ¶¯Æô¶¯mysqlµÄ¡£Ö»ÒªÖªµÀmysqlµÄÅäÖÃÎļþµÄλÖ㨲»ÒªÅª´íÁË)
¶÷£¬Ð»Ð»¡£
{{
Ïà¹ØÎÊ´ð£º
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
½ñÌìÏëµ½¸öÎÊÌ⣬mysql¿ÉÒÔµ¼³ö±í£¬Êý¾Ý¿â£¬Ôõôµ¼³öij¸ö×ֶεÄÊý¾ÝÄØ£¿²»ÖªµÀ´ó¼ÒÓÐûÓÐÕâôÊÔ¹ýµÄ£¿ÊDz»Êǵ¼³öÊý¾ÝµÄ×îСµ¥Î»¾ÍÊÇ±í£¿
Óù¤¾ß¿ÉÒÔÑ¡ÔñÁе쬱ÈÈçsqlyog
лл£¬ÒѾ½â¾ö£¬ÎÒÓõÄÊÇÃüÁºÇºÇ
......
ÓÃmysql½¨±íʱ³öÏÖ´íÎó1067 £ºinvalid default value for 'id'
idÊÇintÐ͵ģ¬ÎªÊ²Ã´²»ÄÜÉèÖÃĬÈÏÖµ¡£Óï¾äΪid int£¨4£©default '-1' null;³öÏÖ´íÎó¡£
Ìù³öÄãµÄ create table Óï¾ä£¬¼°ÄãµÄmysql °æ±¾¡£
µ±ÄúµÄÎÊ ......
ÔÚmysql´æ´¢¹ý³ÌÖж¨Òå±äÁ¿ºÍ²ÎÊýʱ¿ÉÓпÉÎÞ·ûºÅ@£¬ÇëÎÊÓÐ@ºÍûÓÐ@ÓÐÊ²Ã´Çø±ð£¿Ð»Ð»£¡
create procedure mypro()
begin
declare @temp int;
set @temp=3;
end //
´´½¨Õâ¸ö´æ´¢¹ý³ÌµÄʱºòΪʲô»á±¨´íÄØ£¿
......