{"height":"190","type":"rich","published":"2015-09-04 20:31:19","version":"1.0","categories":["MySQL","in English"],"provider_name":"Hatena Blog","provider_url":"https://hatena.blog","image_url":"http://www-jp.mysql.com/common/logos/logo-mysql-170x115.png","url":"https://oinume.hatenablog.com/entry/duplicateing-a-mysql-table-schema-and-data","blog_title":"oinume journal","author_name":"oinume","blog_url":"https://oinume.hatenablog.com/","description":"Duplicate foo table into foo_20150904 /* Create a new table from foo's schema */ > CREATE TABLE foo_20150904 LIKE foo; /* Insert whole data into a new table */ > INSERT INTO foo_20150904 SELECT * FROM foo;","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Foinume.hatenablog.com%2Fentry%2Fduplicateing-a-mysql-table-schema-and-data\" title=\"Duplicating a MySQL table schema and data - 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>","width":"100%","title":"Duplicating a MySQL table schema and data","author_url":"https://blog.hatena.ne.jp/oinume/"}