Question: 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

I am trying to create a table using MySQL and MariaDB,

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Hands-on Exercise Ex3: Database Transactions 1 Connect to your MySQL Container Make sure your device is connected to the campus network by being on campus connected to the wired/wifi or if remote by...

I can't seem to get this right. I'm not familiar with how to properly use the syntax in bash. B e - Problem set 3-shells OQ SAUS 1 OO 22032042051019235 DilA + puig BB 1. Create a new victual machine...

I just need assistance with 8.b -d I understand the logic but I just can't get the syntax right. file:///C:/Users/corde/Download susudom ( 1 move p (opt. -r) 0 of 3 1 - + Sh18:205 DA 2a o 4. Start...

ELE VATE t h e three disciplines o f advanced strate g i c th i nk ing R I C H H O R WAT H NEW YORK Times Be s ts ellin g A u thor O n s trateg y Contents Introduction 1 Elevate\t1 Importance of...

IFSM 300 Final Assessment Exam NOTE: As for all work in this class, the final exam must be original work developed by the student solely for use in this class and must conform to UMUC's academic...

Confirming Pages C H A P T E R 19 Analyzing Information and Writing Reports Chapter Outline Using Your Time Efficiently Analyzing Data and Information for Reports Identifying the Source of the Data...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Linux You are tell me the difference from the outcome of Lecture 3 Step 2 (Compare man tar to pinfo tar) click on Submit Assignment and type in your response. You can perform this assignment in...

Conduct an internet search to find an organization that lists its mission and vision statement on its website. What do the mission and vision statements communicate? How might the organization use...

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

Suppose that the aggregate demand and aggregate supply schedules for a hypothetical economy are as shown below: a. Use these sets of data to graph the aggregate demand and aggregate supply curves....

A newly formed corporation received the following assets in exchange for stock: What is the corporation's adjusted basis of each asset to the corporation? You must show your calculations....

Question 1 3 pts You have the opportunity to purchase an investment that will pay $ 1 , 8 5 6 , 8 4 3 at the end of 3 8 years . If your required rate of return on this investment is 1 3 . 4 % , what...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Question How is life insurance used in a DBO plan?

Question Do the Section 79 nondiscrimination rules require, in effect, that the plan must cover practically all employees of an employer and provide all of them with insurance equal to the same...

Question Should dependent coverage be included in a group-term plan?