{"type":"rich","published":"2015-10-21 09:00:00","url":"https://oinume.hatenablog.com/entry/get-auto-increment-values-from-mysql-information-schema","title":"Get auto increment values from MySQL information schema","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Foinume.hatenablog.com%2Fentry%2Fget-auto-increment-values-from-mysql-information-schema\" title=\"Get auto increment values from MySQL information schema - oinume journal\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://oinume.hatenablog.com/","blog_title":"oinume journal","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/oinume/","width":"100%","version":"1.0","author_name":"oinume","categories":["MySQL","in English"],"image_url":"https://upload.wikimedia.org/wikipedia/en/thumb/6/62/MySQL.svg/1280px-MySQL.svg.png","height":"190","description":"Information schema is metadata about MySQL. We can obtain useful information from it. For example, I get current auto increment values by following SQL. SELECT t.table_name, t.auto_increment FROM information_schema.tables AS t WHERE t.table_schema = 'your_db' ORDER BY t.table_name; +----------------\u2026","provider_url":"https://hatena.blog"}