Moving data by length

I have to move words table's data to another tables.

For example words table is :

------------------------------
| word             | type    |
|------------------|---开发者_StackOverflow社区------|
| car              | NA      |
| home             | NA      |
| question         | PR      |
------------------------------

I have to move this data by length . For example , car's length is 3 , and car will move to 3-char table (with type column). And question will moved to 8-char .

How can i do it with SQL commands .

Sort of an incomplete question, but something like this might help point you in the right direction:

INSERT INTO words_3char SELECT word FROM all_words WHERE LENGTH(word)=3;

DELETE FROM all_words WHERE LENGTH(word)=3;

I'm not going to ask why you need to do all this moving around, but I'm not sure its a good idea. Assuming it is, take a look at the Length() function for mysql and then try something like this.

Insert into table_Char3(Word) Values (
       Select Word from Words where Length(word) = 3)

You can move them to new tables like this

create table word1char as select word from words where length(trim(word)) = 1
..
create table word3chars as select word from words where length(trim(word)) = 3