Insert is not working in mysql 8.0

Question

1.00/5 (2 votes)

See more:

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

What I have tried:

syntax is correct but still showing syntax incorrect

Posted 4-May-23 17:43pm

Member 15418280

Updated 8-May-23 13:13pm

Add a Solution

Comments

Richard MacCutchan 5-May-23 4:18am

I have just run those exact commands on my test db and it works correctly. Please update your question with the complete script that you use and the actual output from when you run it.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2023-05-04T18:47:00

We can't access your database, and we don't know how you are issuing those commands: you could be using a DB Management tool or code in PHP, Python, C#, ... and that could be impacting on the problem you are seeing. Or it could just be that you typed it into your question here and it's different in your actual query.

So start by breaking it up: Execute just the USE and INSERT lines, and see if the error persists. If it doesn't, it's in the SELECT, so execute just the USE and SELECT and see what happens.
If it does, then look at the actual database table and see what it currently holds.

Basically, narrow down your problem: find which part is causing the problem first and it may be more obvious what is going on.

Sorry, but we can't do any of that for you!

Member 10601191 · Answer 2 · 2023-05-08T13:13:00

Suggest you log out/in start a fresh session then start again, copy/paste the entire session if error(s) still persist.

I've re-created a session attempting to mimic yours .... the log of that follows ....

OS - linux mint 20.x
mysql - version 8.0.33 ....

mysql -u $USER
mysql> use junkdb;
Database changed

mysql> describe cust;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| stuff | varchar(255) | NO   |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql> select * from cust;
Empty set (0.00 sec)

mysql> INSERT INTO cust VALUES ('hi');
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM cust;
+-------+
| stuff |
+-------+
| hi    |
+-------+
1 row in set (0.00 sec)

mysql> exit;
Bye

Insert is not working in mysql 8.0

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0