You can do this : mysqldump -u root -p -h <db-host> –opt <db-name> -d –single-transaction | sed ‘s/ AUTO_INCREMENT=[0-9]*\b//’ > <filename>.sql As mentioned by others, If you want sed to works properly, add the g (for global replacement) parameter like this : mysqldump -u root -p -h <db-host> –opt <db-name> -d –single-transaction | sed ‘s/ … Read more
If you really need this you can achieve your goal with help of separate table for sequencing (if you don’t mind) and a trigger. Tables CREATE TABLE table1_seq ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ); CREATE TABLE table1 ( id VARCHAR(7) NOT NULL PRIMARY KEY DEFAULT ‘0’, name VARCHAR(30) ); Now the trigger … Read more
If it is MySql you can try SELECT @n := @n + 1 n, first_name, last_name FROM table1, (SELECT @n := 0) m ORDER BY first_name, last_name SQLFiddle And for SQLServer SELECT row_number() OVER (ORDER BY first_name, last_name) n, first_name, last_name FROM table1 SQLFiddle
@Id @GeneratedValue(strategy=GenerationType.AUTO) private int id; and you leave it null (0) when persisting. (null if you use the Integer / Long wrappers) In some cases the AUTO strategy is resolved to SEQUENCE rathen than to IDENTITY or TABLE, so you might want to manually set it to IDENTITY or TABLE (depending on the underlying database). … Read more
I think you want to MODIFY the column as described for the ALTER TABLE command. It might be something like this: ALTER TABLE users MODIFY id INTEGER NOT NULL AUTO_INCREMENT; Before running above ensure that id column has a Primary index.
One other option is to look at the system table sqlite_sequence. Your sqlite database will have that table automatically if you created any table with autoincrement primary key. This table is for sqlite to keep track of the autoincrement field so that it won’t repeat the primary key even after you delete some rows or … Read more
Set the auto increment field to NULL or 0 if you want it to be auto magically assigned…
Try this ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT; for an existing primary key
Straight after the $wpdb->insert() that does the insert, do this: $lastid = $wpdb->insert_id; More information about how to do things the WordPress way can be found in the WordPress codex. The details above were found here on the wpdb class page
You get one for free, called ROWID. This is in every SQLite table whether you ask for it or not. If you include a column of type INTEGER PRIMARY KEY, that column points at (is an alias for) the automatic ROWID column. ROWID (by whatever name you call it) is assigned a value whenever you … Read more