mysql - The multi-part identifier not working during insertion -

create table wel ( pipe_type varchar(30),date date )   insert wel values(h.t.no.2,....,....) 

getting error multi-part identifier h.t.no.2 not bound , 2 incorrect syntax

is there problem varchar or other way insert h.t.no.2 table

for character type data types must give single quotes

for inserting single record have 2 options

first one

insert wel values('h.t.no.2','2013-07-07');

second one

insert wel(pipe_type,date) values('h.t.no.2','2013-07-07');

this helpful when default value given.for example

if give default value date '2000-02-02'.then write query this

insert wel(pipe_type) values('h.t.no.2');

then system takes default value give(like 2000-02-02 ) one.

importance of delimiter(;):

i observe didn't give ";" .if so, database checks query.so 1 query not important,but multiple important.