CREATE TABLE new_table_name LIKE old_table_name with old_table_name's AUTO_INCREMENT values

Can I create a new table with an old table's autoincriment status in mysql client?

I think, that ALTER TABLE new_table_name AUTO_INCREMENT=@my_autoincr_iment helps me, but this construction must use with a constant value. I don't wanna use a difficult script.

Drochite na carmu!

Answers


mysql> create table new_table like old_table;

mysql> select @my_auto_increment:=auto_increment from information_schema.tables where table_name='old_table';

mysql> set @query = CONCAT("alter table new_table auto_increment = ", @my_auto_increment);

mysql> prepare stmt from @query;

mysql> execute stmt;

mysql> deallocate prepare stmt;

Thx to my brother!


Your CREATE TABLE can specify the auto_increment to use:

mysql> create table foo (i int primary key auto_increment, s varchar(12)) auto_increment = 10;
Query OK, 0 rows affected (0.19 sec)

mysql> insert into foo (s) values ("s");
Query OK, 1 row affected (0.09 sec)

mysql> select * from foo;
+----+------+
| i  | s    |
+----+------+
| 10 | s    |
+----+------+
1 row in set (0.03 sec)

Need Your Help

How to keep UISearchBar in place while scrolling table in a MasterDetail Project using UISplitViewController?

objective-c uisplitviewcontroller uisearchbar master-detail

I already placed a UISearchBar inside the MasterViewController, but the problem is that whenever the user scrolls the table the searchbar goes away. If use a single view project it is ok to do so, I

Google project hosting svn commit problem

svn project-hosting

When I try to commit my code with svn commit, it returns an error :

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.