Q:
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
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
ASKED:
Nov 4 2009 9:59 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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 your other question.
