create table Plustwomarks(subject varchar(20), marks int)
insert into Plustwomarks('English', 175)
when i execute this i get a statement like this:
Line 1: Incorrect syntax near ')'.
what should i do. I have tried everything
2006-07-24 20:54:00 · 10 answers · asked by Rajesh K 2 in Computers & Internet ➔ Programming & Design
insert into Plustwomarks values ('English', 175)
If you are using SQL server then
insert Plustwomarks values ('English', 175)
2006-07-24 21:03:41 · answer #1 · answered by ash_m_79 6 · 1⤊ 0⤋
you might need to specify the size for the second input parameter, eg. create table Plustwomarks(subject varchar(20), marks int(4))
insert into Plustwomarks('English', 175)
good luck
2006-07-25 04:44:14 · answer #2 · answered by Adeel I 3 · 0⤊ 0⤋
I am not positive, but have you tried putting a semi-colon after the bracket? like create table Plustwomarks (subject varchar(20), marks int);
?
I think it depends on the script runner, but...
2006-07-25 03:57:44 · answer #3 · answered by AlphaOne_ 5 · 0⤊ 0⤋
You probably want:
insert into Plustwomarks values ('English', 175);
Note the addition of the word "values".
2006-07-25 03:57:51 · answer #4 · answered by msabramo 2 · 0⤊ 0⤋
insert into plustwomarks values('English', 175);
add 'values' and semi colons at the end..
and yes there is no datatype as 'int'. write 'number' instead of int....
2006-07-25 04:00:49 · answer #5 · answered by nikki 3 · 0⤊ 0⤋
Could you make your question titles a little more meaningful please? I just wasted 20 seconds of my life reading that, and I needn't have had you specified something to do with the question in the title!
Rawlyn.
2006-07-25 04:13:12 · answer #6 · answered by Anonymous · 0⤊ 0⤋
u get syntax near ..??? but it supposed to be syntax error
2006-07-25 03:59:19 · answer #7 · answered by Anonymous · 0⤊ 0⤋
get someone near you that knows the correct way.
2006-07-25 04:00:38 · answer #8 · answered by James Bond 5 · 0⤊ 0⤋
no thanks i am part of the stupid half of the world
wish i could help
2006-07-25 03:56:52 · answer #9 · answered by DeAd DiScO 4 · 0⤊ 0⤋
no ------i will not try
2006-07-25 03:57:43 · answer #10 · answered by hanifrng 3 · 0⤊ 0⤋