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µÄÅäÖÃÎļþµÄλÖ㨲»ÒªÅª´íÁË)
¶÷£¬Ð»Ð»¡£
{{
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÓÃmysql½¨±íʱ³öÏÖ´íÎó1067 £ºinvalid default value for 'id'
idÊÇintÐ͵ģ¬ÎªÊ²Ã´²»ÄÜÉèÖÃĬÈÏÖµ¡£Óï¾äΪid int£¨4£©default '-1' null;³öÏÖ´íÎó¡£
Ìù³öÄãµÄ create table Óï¾ä£¬¼°ÄãµÄmysql °æ±¾¡£
µ±ÄúµÄÎÊ ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......