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

¹ØÓÚMySQLɾ³ý¼Ç¼ºóIDÈçºÎÁªÏµ

id INT NOT NULL PRIMARY KEY AUTO_INCREMENT

È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿

ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST

ºó³ö´í£¬Çó½â£¡
³ö´íÐÅÏ¢ÊÇʲô£¿ÄãµÄÔ­½¨±íÓï¾äÊÇʲô£¿

ûÓÐÄãËù˵µÄÇé¿ö£¡

SQL code:
mysql> create table t_spf19871001(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,col
1 int);
Query OK, 0 rows affected (0.08 sec)

mysql> insert into t_spf19871001(col1) values (10),(20),(30),(40),(50),(60),(70),(80),(90);
Query OK, 9 rows affected (0.05 sec)
Records: 9 Duplicates: 0 Warnings: 0

mysql> select * from t_spf19871001;
+----+------+
| id | col1 |
+----+------+
| 1 | 10 |
| 2 | 20 |
| 3 | 30 |
| 4 | 40 |
| 5 | 50 |
| 6 | 60 |
| 7 | 70 |
| 8 | 80 |
| 9 | 90 |
+----+------+
9 rows in set (0.00 sec)

mysql> delete from t_spf19871001 where id in (1,4,7,8);
Query OK, 4 rows affected (0.05 sec)

mysql> select * from t_spf19871001;
+----+------+
| id | col1 |
+----+------+
| 2 | 20 |
| 3 | 30 |
| 5 | 50 |
| 6 | 60 |
| 9 | 90 |
+----+------+
5 rows in set (0.00 sec)

mysql> ALTER TABLE t_spf19871001 DROP id;
Query OK, 5 rows affected (0.13 sec)
Records: 5 Duplicates: 0 Warnings: 0

mysql> A


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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ЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

±í
CREATE TABLE `ch1` (
  `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `no` int(10) unsigned DEFAULT NULL,
  `dtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id ......

ÇëÎÊʹÓÃado¿Ø¼þÁ¬½ÓmysqlÊý¾Ý¿âµÄ²½ÖèÊÇʲô

ÈçÌâ¡£ÎÒÒѾ­°²×°ÁËmysqlodbcÇý¶¯¡£
adodc¿Ø¼þÊôÐÔÀïÃæ£¬Á¬½Ó×ÊÔ´£¬
ÓÐ
ʹÓÃDataLinkÎļþ
ʹÓÃODBCÊý¾Ý×ÊÔ´Ãû³Æ
ʹÓÃÁ¬½Ó×Ö·û´®
ÊÇÑ¡ÔñÄĸö£¿
È»ºóµÃ²½ÖèÊÇÔõôÑùµÄ£¿
HTML code:
http://www.connectionst ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ