Please Help

[mak1084]

hi i'm new to db and i made this table

CREATE TABLE CLIENT(
CLIENT_ID VARCHAR (7) PRIMARY KEY,
FIRST_NAME VARCHAR (10) NOT NULL,
SECOND_NAME VARCHAR (10) NOT NULL,
PHONE_NO CHAR (10) NOT NULL,
ADDRESS VARCHAR (20) NOT NULL,
GENDER CHAR (1) NOT NULL,
ZIP_CODE CHAR (10) NOT NULL)

but when i try to insert these values as

INSERT INTO CLIENT
VALUES
( 0001,'AHMED','SHAH',9812365478,'MOHAMD ALI RD', 'VAKOLA','SANTACRUZ MUMBAI','M',400089)

i get these errors

Server: Msg 213, Level 16, State 5, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

please help me and tell me what wrong i'm doing here..

[ck9663]

hi i'm new to db and i made this table

but when i try to insert these values as


i get these errors



please help me and tell me what wrong i'm doing here..

check your syntax....here's an example:

INSERT INTO MyTable (PriKey, Description)
VALUES (123, 'A description of part 123.')

[azimmer]

hi i'm new to db and i made this table

but when i try to insert these values as


i get these errors



please help me and tell me what wrong i'm doing here..

You insert too many columns (i.e. more than there are in the table) and also should convert number figures to char (add apostrophs) if they are defined as such in the table. (This latter is done automatically by MSSQL, still it's good practice...)

[mak1084]

thnx for replying but now when i try to insert its giving me this error

Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.

[ak1dnar]

If You Getting that error it means that you are trying to add more characters in your Insert Query than you specified in your table declaration.

Example:

FIRST_NAME VARCHAR (10) NOT NULL
 

here maximum char length is 10 for first name, if you try to enter more than that error is getting.

[mak1084]

If You Getting that error it means that you are trying to add more characters in your Insert Query than you specified in your table declaration.

Example:

FIRST_NAME VARCHAR (10) NOT NULL
 

here maximum char length is 10 for first name, if you try to enter more than that error is getting.

thanx lot man this really helped me.......if i get another problem...then i'll be back.

[ak1dnar]

thanx lot man this really helped me.......if i get another problem...then i'll be back.

No Problem..Good luck!