Try typing ';' after each statement.
Mysql Query Error
Error:
What is Error here?
mysql> create table fruitsdb(fruitsid int(20),fruitsname varchar(255),fruitsyear int(10),quality varchar(255),taste varchar(255),sales varchar(255))
-> select * from fruitsdb;
ERROR 1146 (42S02): Table 'testdb.fruitsdb' doesn't exist
mysql> create table fruits(fruitsid int(20),fruitsname varchar(255),fruitsyear int(10),quality varchar(255),taste varchar(255),sales varchar(255))
-> insert into fruits(fruitsid,fruitsname,fruitsyear,quality,taste,sales) values ('1','Apple','2022','Good','Tasty','250000');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into fruits(fruitsid,fruitsname,fruitsyear,quality,taste,sales) values ('' at line 2
mysql>
3 answers
Sort by: Most helpful
-
-
-
Olaf Helper 40,901 Reputation points
2022-03-28T06:46:11.423+00:00 mysql
This is a forum for Microsoft products, for MySQL better post your issue at https://forums.mysql.com/