테이블을 만들려고하는데 제대로 입력한것 같은데 자꾸 오류가 뜨네요..
왜 이러는지 알려주세요 ㅠㅠ
0001행과 0005행은 cust_email이 NULL값 입니다.
[오류내용]
mysql> INSERT INTO customers (
-> cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact, cust_email)
-> VALUES (
-> 0001, 'Village Toys', '200 Maple Lane', 'Detroit', 'MI', 44444, 'USA', 'John Smith', 'sales@villagetoys.com'
-> 0002, 'Kids Place', '333 South Lake Drive', 'Columbus', 'OH', 43333, 'USA', 'Michelle Green',
-> 0003, 'Fun4All', '1 Sunny Place', 'Muncie', 'IN', 42222, 'USA', 'Jim Jones', 'jjones@fun4all.com'
-> 0004, 'Fun4All', '829 Riverside Drive', 'Pheonix', 'AZ', 88888, 'USA', 'Denise L. Stephens', 'dstephens@fun4all.com'
-> 0005, 'The Toy Store', '4545 53rd Street', 'Chicago', 'IL', 54545, 'USA', 'Kim Howard', );
ERROR 1064(42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0002, 'Kids Place', '333 South Lake Drive', 'Columbus', 'OH', 43333, 'USA', 'Mic' at line 5
|