Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am trying to create a table using MySQL and MariaDB, what is wrong with my syntax in trying to create this table? Welcome to

image text in transcribed

I am trying to create a table using MySQL and MariaDB, what is wrong with my syntax in trying to create this table?

Welcome to the MariaDB monitor. Commands end with or Ig. Your MySQL connection id is 43 Server version: 5.7.18 Honebrew Copyright (c) 2000, 2017, oracle, MariaDB Corporation Ab and others. Type 'help or 'Ih' for help. Type 'Ic' to clear the current input statement. [MySQL (none) CREATE DATABASE TESTING Query OK, 1 row affected (0.00 sec) [MySQL [(none) USE TESTING Database changed [MySQL [TESTING] CREATE TABLE PERSONS > ERROR 1064 (42000) You have an error in your SQL syntax; check the manual that c orresponds to your MySQL server version for the right syntax to use near > at line 1 MySQL [TESTING]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bioinformatics Databases And Systems

Authors: Stanley I. Letovsky

1st Edition

1475784058, 978-1475784053

More Books

Students also viewed these Databases questions

Question

Question How is life insurance used in a DBO plan?

Answered: 1 week ago