An Azure relational database service.
Try typing ';' after each statement.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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>
An Azure relational database service.
An Azure managed MySQL database service for app development and deployment.
Try typing ';' after each statement.
mysql
This is a forum for Microsoft products, for MySQL better post your issue at https://forums.mysql.com/