use test
-- insert
INSERT INTO cust VALUES ('hi');
-- fetch
SELECT * FROM cust
test is my database name cust is my table name have only 1 column varchar
getting error code 1064 you have an error in syntax
use test
-- insert
INSERT INTO cust VALUES ('hi');
-- fetch
SELECT * FROM cust
test is my database name cust is my table name have only 1 column varchar
getting error code 1064 you have an error in syntax
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
raj rajPosted May 5, 2023, 4:21 AM
Amit now record inserted but i am unable to see the records when i am executing select query.
do we have any edit option in table designer where we can modify direct record similar in ms sql server.
Amit MohantyPosted May 5, 2023, 4:15 AM
You can execute multiple SQL statements together in MySQL by separating them with a semicolon (;). So you can run the
USE,INSERT INTO, andSELECTstatements together in one block.raj rajPosted May 5, 2023, 3:57 AM
INSERT INTO cust (pointss) VALUES ('hi');
my column name is pointss
already tried but still showing same error
Amit MohantyPosted May 5, 2023, 3:47 AM
Try this