Return to Question

added 4 characters in body; edited title

Source Link

edited Jul 28, 2015 at 22:35

How can I get the AUTO_INCREMENT value in sequel ruby librarySequel?

In mysqlMySQL, I can get the auto-increment value by:

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DatabaseName'
AND   TABLE_NAME   = 'TableName';

How do I query this information in sequelSequel? When I tried DB.runDB.run and DB.getDB.get, it didn't seem to work.

In mysql, I can get the auto-increment value by:

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DatabaseName'
AND   TABLE_NAME   = 'TableName';

How do I query this information in sequel? When I tried DB.run and DB.get, it didn't seem to work.

In MySQL, I can get the auto-increment value by:

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DatabaseName'
AND   TABLE_NAME   = 'TableName';

How do I query this information in Sequel? When I tried DB.run and DB.get, it didn't seem to work.

Source Link

asked Jul 28, 2015 at 22:32

In mysql, I can get the auto-increment value by:

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DatabaseName'
AND   TABLE_NAME   = 'TableName';

How do I query this information in sequel? When I tried DB.run and DB.get, it didn't seem to work.

mysql ruby sequel