9.Here is 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 'show databaseCREATE DATABASE [Da]USE PETSTORE' at line 3mysql> use petstoreERROR 1049 (42000): Unknown database 'petstore'mysql> create database [da] -> use petstore -> -> CREATE TABLE USERS (user_id VARCHAR(30), password -> VARCHAR(30), first_name VARCHAR(50), last_name VARCHAR(50));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 '[da]==========whats the wrong with this work ,what code is correct when i ma trying to make a new table and a new databse in this mysql commend line ?. MySQL 8.0 Command Line Client - UnicodeEnter password: ********Welcome to the MySQL monitor. Commands end with or \g.Your MySQL connection id is 21Server version: 8.0. 29 MySQL Community Server GPLCopyright (c) 2000, 2022, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.tysql> show databases-> show database->-> CREATE DATABASE [Da]-> USE PETSTORE;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 'show databaseCREATE DATABASE [Da]USE PETSTORE' at line 3mysql>

The error in the question lies in the show database command.

Answered: .Here is ERROR 1064 (42000): You have…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

9.Here is 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 'show database

CREATE DATABASE [Da]
USE PETSTORE' at line 3
mysql> use petstore
ERROR 1049 (42000): Unknown database 'petstore'
mysql> create database [da]
-> use petstore
->
-> CREATE TABLE USERS (user_id VARCHAR(30), password
-> VARCHAR(30), first_name VARCHAR(50), last_name VARCHAR(50));
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 '[da]

==========

whats the wrong with this work ,

what code is correct when i ma trying to make a new table and a new databse in this mysql commend line ?.

MySQL 8.0 Command Line Client - Unicode
Enter password: ********
Welcome to the MySQL monitor. Commands end with or \g.
Your MySQL connection id is 21
Server version: 8.0. 29 MySQL Community Server GPL
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
tysql> show databases
-> show database
->
-> CREATE DATABASE [Da]
-> USE PETSTORE;
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 'show database
CREATE DATABASE [Da]
USE PETSTORE' at line 3
mysql>

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions