MySQL копирование данных в новую таблицу базы

[Barkas]

Здравствуйте, помогите с небольшой проблемой.

Пытаюсь выполнить следующий оператор:

create table dvds2

-> (

-> dvdname varchar(60) not null,

-> mtypedescrip varchar(30) not null,

-> formdescrib varchar(15) not null,

-> ratingid varchar(4) not null

-> )

-> select dvdname, mtypedescrip, formdescrib, d.ratingid

-> from dvds as d, movietypes as m, formats as f

-> where d.mtypeid=m.mtypeid and d.formid=f.formid

-> and statid='s2'

-> order by dvdname;

 

Получаю: ERROR 1364 (HY000): Field 'dvdname' doesn't have a default value

 

вот все о моей таблице:

+-------+-------------------------------+----------+----------+---------+--------+----------+--------+--------+

| DVDID | DVDName | NumDisks | YearRlsd | MTypeID | StudID | RatingID | FormID | StatID |

+-------+-------------------------------+----------+----------+---------+--------+----------+--------+--------+

| 1 | White Christmas | 1 | 2000 | mt16 | s105 | NR | f1 | s1 |

| 2 | What's Up, Doc? | 1 | 2001 | mt12 | s103 | G | f1 | s2 |

| 3 | Out of Africa | 1 | 2000 | mt11 | s101 | PG | f1 | s1 |

| 4 | The Maltese Falcon | 1 | 2000 | mt11 | s103 | NR | f1 | s2 |

| 5 | Amadeus | 1 | 1997 | mt11 | s103 | PG | f1 | s2 |

| 6 | The Rocky Horror Picture Show | 2 | 2000 | mt12 | s106 | NR | f1 | s1 |

| 7 | Mash | 2 | 2001 | mt12 | s106 | R | f1 | s2 |

+-------+-------------------------------+----------+----------+---------+--------+----------+--------+--------+

 

 

 

+----------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+----------+-------------+------+-----+---------+----------------+

| DVDID | smallint(6) | NO | PRI | NULL | auto_increment |

| DVDName | varchar(60) | NO | | | |

| NumDisks | tinyint(4) | NO | | 1 | |

| YearRlsd | year(4) | NO | | | |

| MTypeID | varchar(4) | NO | MUL | | |

| StudID | varchar(4) | NO | MUL | | |

| RatingID | varchar(4) | NO | MUL | | |

| FormID | char(2) | NO | MUL | | |

| StatID | char(3) | NO | MUL | | |

+----------+-------------+------+-----+---------+----------------+

 

Заранее спасибо.

[Arhar]

Learn english please!!!

[Song]

not null => null