Mysql syntax
Hi
Have a table: budget
When I try this:
MySql:
insert into budget values (’Department A’,1,2,200)
Department A represents:A Department called A
1 represents: a courseno from table course
2 also represents: a courseno from table course
It doesnt work :|…
Any suggestions.... ?
Software/Hardware used:
Mysql
Software/Hardware used:
Mysql
ASKED:
November 4, 2009 9:59 PM
UPDATED:
November 4, 2009 10:22 PM
Answer Wiki:
Hi Ak1bo78.
You cannot insert 4 values in a table of 3 columns. This is very basic, and that is why I suggested a couple of tutorials in <a href="http://itknowledgeexchange.techtarget.com/itanswers/constraints-mysqltablesnullpkfk-etc/#comments">your other question</a>.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
