Q:

Moving data by length

I have to move words table's data to another tables.
For example words table is :
------------------------------
| word             | type    |
|------------------|---------|
| 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 . 

A:

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;

