•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,555 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,624 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 1736 | 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: 176
Reputation:
Rep Power: 3
Solved Threads: 4
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: 215
Reputation:
Rep Power: 3
Solved Threads: 19
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 3:00 am.
challenge the limits
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Similar Threads
- end statement error happen in vbscript (Visual Basic 4 / 5 / 6)
- SQL Server 2005 version Error Insert command help me (MySQL)
- Its really a problem on INSERT statement (MySQL)
- SQL statement error (ASP.NET)
- Error connecting to database (ASP.NET)
- syntax error: i cant find it..HELP! (ASP)
Other Threads in the MySQL Forum
- Previous Thread: Normalised database
- Next Thread: very newbie (mysql) question
