Mysql Query Error

Mohamed Rafi N 106 Reputation points
2022-03-26T06:00:18.753+00:00

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>

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
714 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Viorel 112.5K Reputation points
    2022-03-26T08:05:54.057+00:00

    Try typing ';' after each statement.

    1 person found this answer helpful.

  2. Mohamed Rafi N 106 Reputation points
    2022-03-26T08:36:35.003+00:00

    ok sir. Noted

    0 comments No comments

  3. 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/

    0 comments No comments