Please support our MySQL advertiser: Programming Forums
Views: 2009 | Replies: 2
 |
•
•
Join Date: Nov 2004
Posts: 229
Reputation: 
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
hi,
I have a table called shoutbox, i created it this way:
but when i want to insert into it some values using following command :
I get the following error:
ps. i am using mysql 5.0
thanks
I have a table called shoutbox, i created it this way:
CREATE TABLE `shoutbox` ( `id` INT NOT NULL AUTO_INCREMENT , `ip` varchar(20) NOT NULL , `name` varchar(30) NOT NULL , `url` varchar(30) NOT NULL , `message` varchar(50) NOT NULL , `date` date NOT NULL , PRIMARY KEY ( `id` ) );
but when i want to insert into it some values using following command :
insert into shoutbox values(1, 6546556, sam, something.com,skdsd,23-02-07);
I get the following error:
error 1054(42s22): unkown colum 'sam' in 'field list'
ps. i am using mysql 5.0
thanks
•
•
Join Date: Jul 2006
Posts: 191
Reputation:
Rep Power: 3
Solved Threads: 5
Junior Poster
6 fields in your table but u inert only 5 values
char must be single quote
char must be single quote
Thanks
VSSP
VSSP
•
•
Join Date: Jan 2006
Posts: 221
Reputation:
Rep Power: 3
Solved Threads: 20
Posting Whiz in Training
•
•
•
•
Originally Posted by sam1 
hi,
I have a table called shoutbox, i created it this way:
CREATE TABLE `shoutbox` ( `id` INT NOT NULL AUTO_INCREMENT , `ip` varchar(20) NOT NULL , `name` varchar(30) NOT NULL , `url` varchar(30) NOT NULL , `message` varchar(50) NOT NULL , `date` date NOT NULL , PRIMARY KEY ( `id` ) );
but when i want to insert into it some values using following command :
insert into shoutbox values(1, 6546556, sam, something.com,skdsd,23-02-07);
I get the following error:
error 1054(42s22): unkown colum 'sam' in 'field list'
ps. i am using mysql 5.0
thanks
Hi, are you aware of syntax for INSERT statement? anyways,
1. the first thing you need learn is syntax for INSERT statement.
Syntax 1 =>
INSERT INTO TABLE table_name values(value1, value2...)
for eg: if a table is like,
create table TEST ( column1 int, column2 varchar(10) )
then the insert statement for this looks like
insert into TEST values(1, 'apple') insert into TEST values(2, 'strawbery')
INSERT INTO TABLE table_name (column1, column3, column8) values(value1, value3, value8)
can observe the flexibility in the second syntax? i.e you can insert values into only those columns for which know values. Make sure, you provide the values in order as that of the column name you specify.
NOTE:
Whenever you are using the syntax 2, make sure you will insert values for PRIMARY KEY and/or fields which are NOT NULL.
2. fields which expects string or of char type, provide values in quotes.
so your insert statement will now become,
insert into shoutbox(id, ip, name, url, message, date) values(1, '6546556', 'sam', 'something.com', 'skdsd', '23-02-07');
insert into shoutbox values (1, '6546556', 'sam', 'something.com', 'skdsd', '23-02-07');
kath.
Last edited by katharnakh : Mar 16th, 2007 at 4:00 am.
challenge the limits
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
