l want to insert statement inside the table student on My SQL program the latest
ID: 3879325 • Letter: L
Question
l want to insert statement inside the table student on My SQL program the latest version but there is an error l am not able determine how to applied or insert a row as:
Steps
In each of these queries you’re shown the columns to display in your result. Make your column headers look exactly like the example shown. All these queries use the Starter database.
0. Even if you downloaded it for the previous assignment, to make sure you have the very latest version, download StarterCreate.SQL from Blackboard now. Before you run the StarterCreate.SQL, modify it to put your name in as the first student. Scroll down in the StarterCreate.SQL file until you see the first INSERT statement for the Student table. Put your name in the First and Last fields, in the Email Address and possibly, change the sex. Be sure not to accidently delete the single quotes. Then run the SQL.
this is the pictures to insert
l am not really shore why l have an error when l try to insert statement
l want to insert as
but how to insert statements probably l am wrong based on the above instuction
s Frank', 'Shoemaker', 'Fr rankshoemaker@college.edu, '1998-06-21', 'M', Do not change any other fieldsExplanation / Answer
Hi,
As you have not shared the column data types and column lengths of your table, it is difficult to predict the exact cause of the failure. But,I can give you some general reasons for insert statements failure-
1. The column data type does not mat with the actual data that you are trying to insert.
2. The date format which you are using to insert in your insert statement may not be correct. To me it looks fine in your code.
3. The length of data for each field which you are trying to insert must be lesser than the column length defined in the table structure. Please check on this point.
4. All varchar fields should be kept inside the single quotes.
Please observe above statements and see if your insert statement meets those guidelines.
If you still face issue, please share the complete table structure and the insert statement being used.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.