MYSQL: create table from another clever way

Post date: Jul 24, 2012 1:48:39 PM

If you need create table on basis of another you do not need to search types and so on.

Example:

CREATE TABLE name_birthday_backup (KEY(name))

    SELECT name, birthday

    FROM users

    WHERE name is not null and birthday is null;

Request above creates table with names and birthdays for users who specified their names and not specified their birthday with index on name. Types of columns will be the same.