[Help]How To Fix This Error

06/21/2013 03:05 PlayingLess#1
Hello ,

I am Facing Problem In this Sql Code.. i am Following This TuT

: [Only registered and activated users can see links. Click Here To Register...]

I am Trying To Make Server using KingTut A9 Client and a Clean DB also Using My Sql 2000

The Error Is i type this Code :
Use account;
Go
Insert Into [TBL_USER] Values ('09101410275532', 'ID', 'Password', 'E-Mail', 'Secret Answer', 'Secret Question')
Insert Into [USER_PROFILE] Values ('09101410275532','ID','Password','801011000000',' 1','0','Y','01/01/2006 00:00:00',null,null,null,'000')

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

IMG :[Only registered and activated users can see links. Click Here To Register...]

Thanks ^^
06/21/2013 07:45 .Genome.#2
Probably because your SQL syntax is wrong...

I could easily paste correct SQL commands here but use google to search "how to insert data in sql table" and look at the syntax.
06/21/2013 19:17 PlayingLess#3
I Used Google How To Insert Data In Sql Table but i still dont get where is the error they appear to be the same . So What Part Has To Be Changed ?
06/22/2013 07:57 .Genome.#4
I'll rephrase, your syntax is wrong.

Read this (the first search result from "how to insert data in sql table"): [Only registered and activated users can see links. Click Here To Register...]
06/23/2013 03:19 PlayingLess#5
w/e i descovered that the Db is Backwards .. Syntax is Right ... but the order does not fit the DB so i have to do :

1- Over Do Data Base
Or
2- do it manually [non-codes]