mysql> desc tbl_board;
+---------+--------------+------+-----+-------------------+----------------+
| Field   | Type         | Null | Key | Default           | Extra          |
+---------+--------------+------+-----+-------------------+----------------+
| bno     | int(11)      | NO   | PRI | NULL              | auto_increment |
| title   | varchar(200) | NO   |     | NULL              |                |
| content | text         | YES  |     | NULL              |                |
| writer  | varchar(200) | NO   |     | NULL              |                |
| regdate | timestamp    | NO   |     | CURRENT_TIMESTAMP |                |
| viewcnt | int(11)      | YES  |     | NULL              |                |
+---------+--------------+------+-----+-------------------+----------------+
6 rows in set (0.03 sec)

S> insert into  tbl_board (title,content,writer)
(select title,content,writer from tbl_board);