CC Converting Access Schema to MySQL

User Generated

qnavry_enzverm

Programming

Cazenovia College

Description

  1. Download the following Access file (DO NOT USE ANY OTHER FILE): AnnandaleCupcakes_v03.accdb
  2. Using the Access design view for the tables, go through every table and write the equivalent SQL DDL code to create that table in MySQL.
    1. You will need to choose the correct data types and constraints, since Access (Jet) data types are different from MySQL data types (e.g. there is no "Short Text" in MySQL, but varchar(50) would be an example equivalent). Below is a chart of equivalent data types. Also remember to use auto_increment and primary key constraints on the PK

Unformatted Attachment Preview

Access Data Type MySQL Equivalent Type Auto-Number - Long Integer INT with auto-increment enabled CHAR(36) VARCHAR or TINYTEXT Text Tinylnt SMALLINT Limits (value ranges) -2,147,483,648 to 2,147,483,647 normal. O to 4,294,967,295 UNSIGNED 128 bits --> 3.40282366920938438 values 255 characters 65,535 characters - 128 to 127 normal. O to 255 UNSIGNED. -32,768 to 32,767 normal. O to 65,535 UNSIGNED. -2,147,483,648 to 2,147,483,647 normal. O to 4,294,967,295 UNSIGNED 7 digits 15 digits 128 bits --> 3.40282366920938438 values Varies n/a Auto-Number - ReplicationID Short Text Long Text Number - Byte Number - Integer Number - Long Integer Number - Single Number - Double Number - Replication ID Number - Decimal Date/Time Currency Yes/No OLE Object or Attachment Hynerlink INT FLOAT DOUBLE CHAR(36) DECIMAL DATETIME no equivalent BOOL or BIT(1) BLOB no equivalent n/a O or 1 n/a n/a Appl X Inlinx SOLL X S max X max X Mak X Cop X Erro X Erro X The X Erro X 2 Erro X 2 Erro X C Proje x + Table Tools AnnandaleCupcakes_v03 (1): Database - C:\Users\Surface Book\Downloads\AnnandaleC... ? | X Х ☆ TP m : EL = Menu Save All- File Home Create External Data Database Tools Fields Table Tell me what you want to do... 8 Cut 41 Ascending Y Selection New Σ Totals abac Replace Calibri (Detail) 11 ABC Eg Copy ĀJ Descending Advanced Spelling → Go To View Paste Filter Refresh Find Format Painter BI U A - ab Remove Sort Toggle Filter Select Delete - - More Views Clipboard Sort & Filter Records Find Text Formatting customer customer_note event E payment Es product sale All Acc... sale_item customer id first name last name phone_num - email street city Search... Bob (444) 554/5454 joe.bob@gmail.com 1233 Little River Tpk Annandale Tables 2 Barb Smith (555) 234/5233 bsmith@aol.com 507 Main St, #401 Fairfax customer 3 Ryan Ammons (555) 555/5555 rammons@nvcc.edu 123 Main St Alexandria (New) customer_note ES X A Y notes + 1 Joe state zip VA 22002/ Virginia 22003/ VA 22310- + + He's okay. event payment product sale sale_item Queries qrySales Forms -H customer 国国园 sale sale_item Subf... Reports Record: 1 of 3 No Filter Sear Datasheet View B I U = Go GIF 1) O Type here to search in O EE mm АВ H 60°F Σ (8) EU la 11:08 PM 9/30/2021 m Appl X Inlinx SOLL X S max X max X Mak X Cop X Erro X Erro X The X Erro X 7 Erro X 2 Erro X C Proje x + Table Tools AnnandaleCupcakes_v03 (1): Database - C:\Users\Surface Book\Downloads\AnnandaleC... ? | X Х ☆ TP m : File Home Create External Data Database Tools Fields Table of Cut Tell me what you want to do... New Σ Totals Spelling Find Delete - More Calibri (Detail) 11 EL = Menu Eg Copy Save ABC ac Replace → Go To 1 Select View 41 Ascending Y Selection AJ Descending Advanced Remove Sort Toggle Filter Sort & Filter Paste Filter Refresh Format Painter BIU A All- Views Clipboard Records Find Text Formatting FEE customer customer_note BE All Acc... E sale X sale_item A customer id- created at updated_at Click to Add Search... event El payment product note This is a test note :) Yay! 1## note id , subject Test 2 Hi, I like cupcakes (New) Tables 2## customer 0 #### customer_note event payment product sale sale_item Queries qrySales Forms -H customer sale 园园 sale_item Subf... Reports Record: 1 of 2 No Filter Search Datasheet View Β Ι Ο CO GIF 1) O Type here to search in O EE mm АВ H 60°F Σ (8) EU la 11:08 PM 9/30/2021 m Appl X Inlinx SOLL X S max X max X Mak X Cop X Erro X Erro X The X Erro X Erro X 2 Erro X C Proje x + Table Tools AnnandaleCupcakes_v03 (1): Database- C:\Users\Surface Book\Downloads\AnnandaleC... ? | X Х ☆ TP m : File Home Create External Data Database Tools Fields Table Tell me what you want to do... of Cut New Σ Totals Spelling Calibri (Detail) 11 EL = Menu Eg Copy ABC Save sac Replace → Go To hos Select View Paste 41 Ascending Y Selection ĀL Descending Advanced Remove Sort Toggle Filter Sort & Filter Filter Find BE Format Painter Refresh All- BI U A - ab Delete - More Views Clipboard Records Find Text Formatting < x BER All Acc... sale_item A customer customer_note event id → customer id , (New) 0 event E payment E product sale order id - event_dateti - bake_order, 0 description delivery_inst- notes Click to Add Search... Tables customer customer_note event payment product sale sale_item Queries qrySales Forms -H customer 国国园 sale sale_item Subf... Reports Record: + 1 of 1 No Filter Search Datasheet View B I U = CO GIF 1) O Type here to search in O EE mm АВ H 60°F Σ (8) EU la 11:08 PM 9/30/2021 m Appl X Inlinx SOLL X S max X max X Mak X Cop X Erro X Erro X The X Erro X 2 Erro X 2 Erro X C Proje x + Table Tools AnnandaleCupcakes_v03 (1): Database - C:\Users\Surface Book\Downloads\AnnandaleC... ? | X Х ☆ TP m : File Home Create External Data Database Tools Fields Table Tell me what you want to do... of Cut New Σ Totals Calibri (Detail) 11 EL = Menu Eg Copy ABC 41 Ascending Y Selection ĀJ Descending Advanced Remove Sort Toggle Filter Save abac Replace → Go To n Select View Paste Filter Spelling Delete - More Refresh Find Format Painter BI U A - ab All Views Clipboard Sort & Filter Records Find Text Formatting N FE BE sale ES All Acc... sale_item A sale id created at updated_at Click to Add Search... FEE customer customer_note event payment_id, payment_method , 1 Visa 2 Cash (New) payment E product amount notes $100.00 Oh the fees.... $10.00 Cash is king! $0.00 1## Tables 2##### customer 0###### customer_note event payment product sale sale_item Queries qrySales Forms -H customer 国国园 sale sale_item Subf... Reports Record: 1 of 2 No Filter Search Datasheet View Β Ι Ο = CO GIF 1) O Type here to search in O EE mm АВ H 60°F Σ (8) EU la 11:08 PM 9/30/2021 m Appl X Inlinx SOLL X S max X max X Mak X Cop X Erro X Erro X The X Erro X 7 Erro X 2 Erro X C Proje x + Table Tools AnnandaleCupcakes_v03 (1): Database - C:\Users\Surface Book\Downloads\AnnandaleC... ? | X Х ☆ TP m : File Home Create External Data Database Tools Fields Table Tell me what you want to do... of Cut Calibri (Detail) 11 EL = Menu Eg Copy ABC 41 Ascending Y Selection ĀJ Descending Advanced Remove Sort Toggle Filter New Σ Totals Save Spelling Delete - - More abac Replace → Go To hos Select View Paste Filter Find Format Painter Refresh All BI U A Views Clipboard Sort & Filter Records Find Text Formatting BER All Acc... sale event A E sale_item Y Y notes unit_capacity created at Search... O + Tables + customer + customer customer_note product_id cupcake_type 1 Chocalate 2 Vanilla 3 Strawberry 4 Mixed 5 Sprinkles 6 Sprinkles 7 Sprinkles (New) E payment s product cupcake_name Plain Old Chocolate Plain Old Vanilla Plain Old Strawberry The Napolean Party Time (vanilla) Party Time (chocalate) Party Time (strawberry) + price $6.00 $5.50 $6.50 $7.00 $6.00 $6.50 $7.00 $0.00 cost_per_unit $1.50 $1.40 $1.75 $2.25 $1.50 $1.60 $1.85 $0.00 #### customer_note + ####### + event + ##### O## payment product sale sale_item Queries qrySales Forms >> -H customer PPP sale sale_item Subf... Reports Record: K+ 1 of 7 No Filter Sear Datasheet View Β Ι Ο Go GIF O Type here to search in O EE mm АВ 60°F Σ H (8) EU 11:09 PM 9/30/2021 la m Appl X Inlinx SOLL X S max X max X Mak X Cop X Erro X Erro X The X Erro X Erro X 2 Erro X C Proje x + Table Tools AnnandaleCupcakes_v03 (1): Database - C:\Users\Surface Book\Downloads\AnnandaleC... ? | X Х ☆ TP m : ►T EL = Menu Eg Copy Save < x File Home Create External Data Database Tools Fields Table Tell me what you want to do... of Cut 41 Ascending Y Selection New Σ Totals abac Replace Calibri (Detail) 11 ABC ĀJ Descending Advanced Spelling → Go To View Paste Filter Refresh Find Format Painter Remove Sort BI U A - ab Toggle Filter hos Select All Delete - - More Views Clipboard Sort & Filter Records Find Text Formatting EES customer customer_note event All Acc... 3 payment sale E product sale_item sale id sale date notes created at updated_at Click to Add , Search... O 11/11/2019 Just found us, likes our products Tables 2 11/11/2019 customer 3 11/19/2019 He's kind of annoying.... #### 4 11/18/2019 ###### ############################# customer_note (New) ##### ############################# A + + + + * event payment product sale sale_item Queries qrySales Forms -H customer 国国园 sale sale_item Subf... Reports Record: 1 of 4 No Filter Search Datasheet View Β Ι Ο = CO GIF O Type here to search in O EE mm АВ 60°F Σ H (8) EU 11:09 PM 9/30/2021 la m Appl X Inlinx SOLL X S max X max X Mak X Cop X Erro X Erro X The X Erro X 7 Erro X 2 Erro X C Proje x + Table Tools AnnandaleCupcakes_v03 (1): Database - C:\Users\Surface Book\Downloads\AnnandaleC... ? | X Х ☆ TP m : ►T EL = Menu Eg Copy < x FEE BE A Y File Home Create External Data Database Tools Fields Table Tell me what you want to do... of Cut 41 Ascending Y Selection New Σ Totals abac Replace Calibri (Detail) 11 ĀL Descending ABC Save Advanced Spelling → Go To View Paste Filter Refresh Find Format Painter BI U A Remove Sort Toggle Filter Select All- Delete - More Views Clipboard Sort & Filter Records Find Text Formatting customer event customer_note All Acc... E payment sale E product sale_item sale_item_id sale_id product_id quantity created_at updated_at Click to Add , Search... 1 6 1 11/11/2019 3:42:43 PM 11/11/2019 3:48:30 PM Tables 2 1 4 1 11/11/2019 3:48:30 PM 11/11/2019 3:48:30 PM customer 3 2 1 1 11/12/2019 5:39:47 PM 11/12/2019 5:39:47 PM 4 2 6 2 11/12/2019 5:40:06 PM 11/12/2019 5:40:06 PM customer_note 5 2 3 1 11/12/2019 5:40:10 PM 11/12/2019 5:40:10 PM 6 2 2 4 11/12/2019 5:41:09 PM 11/12/2019 5:41:09 PM 7 2 4 2 11/12/2019 5:41:13 PM 11/12/2019 5:41:13 PM 8 3 1 10 11/19/2019 4:13:49 PM 11/19/2019 4:13:49 PM payment 9 1 7 2 11/19/2019 4:42:29 PM 11/19/2019 4:42:29 PM 10 2 1 20 11/19/2019 4:50:46 PM 11/19/2019 4:50:46 PM product 11 3 3 11 11/19/2019 5:12:53 PM 11/19/2019 5:12:53 PM 12 sale 4 7 32 11/19/2019 5:23:44 PM 11/19/2019 5:23:44 PM 13 4 4 12 11/19/2019 5:23:48 PM 11/19/2019 5:23:48 PM sale_item 14 1 5 1 11/20/2019 2:22:55 PM 11/20/2019 2:22:55 PM (New) 0 0 0 9/30/2021 11:08:31 PM 9/30/2021 11:08:31 PM Queries event qrySales Forms >> -H customer 国国园 sale sale_item Subf... Reports Record: 1 of 14 No Filter Search Datasheet View B I U = CO GIF O Type here to search in O EE mm АВ 60°F Σ H (8) EU 11:09 PM 9/30/2021 la m 7 2 C Proje x + | ☆ TP m : EL = Menu Eg Copy ABC Save FEE customer event FE Y Y Y Appl X Inline X SOLL X S max x S max Х Mak X Cop X Erro x Erro X The X Erro X Erro X Erro X AnnandaleCupcakes_v03 (1): Database- C:\Users\Surface Book\Downloads\AnnandaleCupcakes_v03 (1).accdb (Access 2007 - 2016 file forma... ? X Х File Home Create External Data Database Tools Tell me what you want to do... * Cut 4) Ascending Y Selection New Σ Totals abac Replace Calibri 11 ĀJ Descending Advanced Spelling → Go To View Paste Filter Refresh Find Format Painter Remove Sort BIU A Toggle Filter hos Select All Delete - More Views Clipboard Sort & Filter Records Find Text Formatting customer_note All Acc... E payment E product sale E sale_item qrySales first name last name email sale_id sale date notes quantity cupcake_name Search... Joe Bob joe.bob@gmail.com 1 11/11/2019 Just found us, likes our products 1 Party Time (chocalate) customer Joe Bob joe.bob@gmail.com 1 11/11/2019 Just found us, likes our products 1 The Napolean Barb Smith bsmith@aol.com 2 11/11/2019 1 Plain Old Chocolate customer_note Barb Smith bsmith@aol.com 2 11/11/2019 2 Party Time (chocalate) Barb Smith bsmith@aol.com 2 11/11/2019 1 Plain Old Strawberry event Barb Smith bsmith@aol.com 2 11/11/2019 4 Plain Old Vanilla Barb Smith bsmith@aol.com 2 11/11/2019 2 The Napolean payment Ryan Ammons rammons@nvcc.edu 3 11/19/2019 He's kind of annoying... 10 Plain Old Chocolate product Joe Bob joe.bob@gmail.com 1 11/11/2019 Just found us, likes our products 2 Party Time (strawberry) Barb Smith bsmith@aol.com 2 11/11/2019 20 Plain Old Chocolate sale Ammons rammons@nvcc.edu 3 11/19/2019 He's kind of annoying.... 11 Plain Old Strawberry Ryan Ammons rammons@nvcc.edu 4 11/18/2019 32 Party Time (strawberry) sale_item Ryan Ammons rammons@nvcc.edu 4 11/18/2019 12 The Napolean Bob Joe joe.bob@gmail.com 1 Queries 2 1 Party Time (vanilla) 11/11/2019 Just found us, likes our products (New) qrySales Ryan Forms - customer PPPPPP - sale - sale_item Subf... Reports Sales Report Record: 1 of 14 No Filter Sear Datasheet View = SQL B I U CO GIF O Type here to search O וחו EE mm АВ 60°F Σ H (8) EU 11:09 PM 9/30/2021 la m 2 Erro X 2 Erro X C Proje x + ? | ☆ TP m : ►T EL = Menu Appl X Inline X SOLL X S max x S max Х Mak X Cop X Erro X Erro X The X Erro X AnnandaleCupcakes_v03 (1): Database- C:\Users\Surface Book\Downloads\AnnandaleCupcakes_v03 (1).accdb (Access 2007 - 2016 file forma... File Home Create External Data Database Tools Tell me what you want to do... * Cut A1 Ascending Y Selection New Σ Totals abac Replace AJ Descending Advanced Spelling → Go To View Paste Filter Refresh Find Format Painter Remove Sort BIU A , ab Toggle Filter A Select All- Delete - More Views Clipboard Sort & Filter Records Find Text Formatting customer customer_note event All Acc... E payment E product E sale sale_item customer E qrySales Search... Customer Find customer: Eg Copy ABC Save EER BE A customer customer_note Customer ID 1 Street 1233 Little River Tpk Name (first,last) Joe event Bob City Annandale payment Phone (444) 554/5454 Email joe.bob@gmail.com State VA product ZIP 22002/ sale subject note created note_id - 1 Test * (New) This is a test note :) ++ HH HHHHHHH sale_item ######### Queries 2 qrySales Forms customer 阿阿阿 sale Record: K+ 1 of 1 No Filter Sear - sale_item Subf... Reports Sales Report Record: 1 of 3 No Filter Search Form View - 다. B I U = CO GIF O Type here to search O וחו EE mm АВ H 60°F < (8) EU 11:09 PM 9/30/2021 la m 2 Erro X 2 Erro X C Proje x + ? | ☆ TP m : ►T EL = Menu Appl X Inline X SOLL X S max x S max Х Mak X Cop X Erro X Erro X The X Erro X AnnandaleCupcakes_v03 (1): Database- C:\Users\Surface Book\Downloads\AnnandaleCupcakes_v03 (1).accdb (Access 2007 - 2016 file forma... File Home Create External Data Database Tools Tell me what you want to do... * Cut 41 Ascending Y Selection New Σ Totals abac Replace AJ Descending Advanced Spelling → Go To View Paste Filter Refresh Find Format Painter Remove Sort BIU A - ab Toggle Filter A Select All- Delete - More Views Clipboard Sort & Filter Records Find Text Formatting customer_note event All Acc... E payment Es product EES sale sale_item E qrySales customer sale Search... Sale Eg Copy ABC Save FEE customer BE X customer sale id quantity Y customer_note Customer Bob, Joe Items Product Sprinkles - Party Time (chocalate)(6.5) Mixed - The Napolean(7) Sprinkles - Party Time (strawberry)(7) Sprinkles - Party Time (vanilla)(6) event sale_date 11/11/2019 6 O NA notes Just found us, likes our products 1 payment product created at 11/11/2019 3:01:19 PM 国国国 sale updated_at 11/11/2019 3:01:19 PM sale_item Total Queries 2 qrySales Forms customer 园园园 - sale - sale_item Subf... Reports Sales Report Record: 1 No Filter Search Form View - 다. Β Ι Ο = CO GIF O Type here to search O וחו EE mm АВ H 60°F < (8) EU 11:09 PM 9/30/2021 la m MySQL Workbench - Х itd 256 x File Edit View Query Database Server Tools Scripting Help SQL - 10 SQL Additions I? i? | Jump to 구 Navigator MANAGEMENT Server Status Client Connections Users and Privileges Status and System Variables Data Export Data Import/Restore Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help. INSTANCE Startup / Shutdown A Server Logs Options File SQL File 4* x 7 Ta Limit to 1000 rows 1. create database annandale_cupcakes; 2. use annandale_cupcakes; 3 4. CREATE TABLE Customer 5 customer_id int primary key auto_increment, 6 first_name varchar (50), 7 last_name varchar(50), 8 phone_number int(20), 9 email varchar (30), 10 street varchar (100), 11 city varchar(50), 12. state varchar(25), 13 Zip varchar(10), 14 notesvarchar(255) 15 created_at datetime, 16 updated_at datetime 17 ); PERFORMANCE Dashboard Performance Reports Performance Schema Setup 18 19 • CREATE TABLE Customer_note 20 note_id int Primary KEY AUTO_INCREMENT, 21 subject varchar (255), 22 note varchar (255), 23 customer_id int, 24 created_at datetime, 25 updated_at datetime 26 ); 27 Administration Schemas Information No object selected 28 CREATE TARIF Fventi Context Help Snippets Output 0 Action Output Time Action 1 00:42:42 create database annandale_cupcakes Duration / Fetch 0.032 sec 0.015 sec > > ® ® 2 00:42:42 use annandale_cupcakes 3 00:43:22 create database annandale_cupcakes 4 00:43:45 create database annandale_cupcakes 5 00:44:18 create database annandale_cupcakes Message 1 row(s) affected Orow(s) affected Error Code: 1007. Cant create database 'annandale_cupcakes'; database exists Error Code: 1007. Cant create database 'annandale_cupcakes'; database exists Error Code: 1007. Cant create database 'annandale_cupcakes'; database exists 0.031 sec 0.015 sec 0.016 sec Object Info Session O Type here to search АВ 60°F (8) か) 12:47 AM 10/1/2021 m MySQL Workbench - Х itd 256 x File Edit View Query Database Server Tools Scripting Help SQL - 10 SQL File 4* x SQL Additions I? i? | Jump to Limit to 1000 rows 구 Navigator MANAGEMENT Server Status Client Connections Users and Privileges Status and System Variables Data Export Data Import/Restore 20 Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help. 22 19. CREATE TABLE Customer_note note_id int Primary KEY AUTO_INCREMENT, 21 subject varchar (255), note varchar (255), 23 customer_id int, 24 created_at datetime, 25 updated_at datetime 26 ); INSTANCE Startup / Shutdown A Server Logs Options File 27 28 . 29 30 PERFORMANCE Dashboard Performance Reports Performance Schema Setup 31 32 CREATE TABLE Event Event_id int PRIMARY KEY AUTO_INCREMENT, customer_id int, order_id int, event_datetime datetime, bake_order int (11), description varchar(255), delivery_instruction varchar(255), notes varchar(255) ); 33 34 35 36 37 38 39. 40 41 Administration Schemas 42 CREATE TABLE payment payment_id int PRIMARY KEY AUTO_INCREMENT, payment_mathod varchar (100), amout int (11), notes varchar (255), sale_id int (11), created_at datetime, undated at datetime Information 43 44 No object selected 45 46 Context Help Snippets Output 0 Action Output Duration / Fetch 0.032 sec 0.015 sec > > ® ® ® Time Action 1 00:42:42 create database annandale_cupcakes 2 00:42:42 use annandale_cupcakes 3 00:43:22 create database annandale_cupcakes 4 00:43:45 create database annandale_cupcakes 5 00:44:18 create database annandale_cupcakes Message 1 row(s) affected Orow(s) affected Error Code: 1007. Cant create database 'annandale_cupcakes'; database exists Error Code: 1007. Cant create database 'annandale_cupcakes'; database exists Error Code: 1007. Cant create database 'annandale_cupcakes'; database exists 0.031 sec 0.015 sec 0.016 sec Object Info Session O Type here to search АВ 60°F (8) か) 12:47 AM 10/1/2021 m MySQL Workbench - Х itd 256 x File Edit View Query Database Server Tools Scripting Help SQL - 10 SQL File 4* x SQL Additions I? i? | Jump to 구 49. Navigator MANAGEMENT Server Status Client Connections Users and Privileges Status and System Variables Data Export Data Import/Restore 50 Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help. 51 52 53 1 Limit to 1000 rows CREATE TABLE product product_id int PRIMARY KEY AUTO_INCREMENT, cupcake_type varchar (255), cupcake_name varchar(255), price int(11), cost_per_unit int(11), notes varchar(255), unit_capacity int(11), created_at datetime, updated_at datetime 54 55 56 INSTANCE Startup / Shutdown A Server Logs Options File 57 ); PERFORMANCE Dashboard Performance Reports Performance Schema Setup 61. CREATE TABLE Sales sale_id int PRIMARY KEY AUTO_INCREMENT, sale_date datetime, notes varchar (255), created_at datetime, updated_at datetime 64 66 8 8 g a 8 8 s à e 8P RAR ); 71 Administration Schemas 72 CREATE TABLE Sale_Item( sale_item_id int PRIMARY KEY AUTO_INCREMENT, sale_id int (11), product_id int (11), quantity int (11), created_at datetime, updated_at datetime, Information No object selected Context Help Snippets Output Duration / Fetch 0.032 sec 0 Action Output Time Action 1 00:42:42 create database annandale_cupcakes 2 00:42:42 use annandale_cupcakes 3 00:43:22 create database annandale_cupcakes 4 00:43:45 create database annandale_cupcakes 5 00:44:18 create database annandale_cupcakes 0.015 sec > > ® ® Message 1 row(s) affected Orow(s) affected Error Code: 1007. Cant create database 'annandale_cupcakes'; database exists Error Code: 1007. Cant create database 'annandale_cupcakes'; database exists Error Code: 1007. Cant create database 'annandale_cupcakes'; database exists 0.031 sec 0.015 sec 0.016 sec Object Info Session O Type here to search АВ 60°F (8) か) 12:47 AM 10/1/2021 m MySQL Workbench - Х itd 256 x File Edit View Query Database Server Tools Scripting Help SQL - 10 SQL File 4* x SQL Additions I? i? | Jump to Limit to 1000 rows 7 1 Navigator MANAGEMENT Server Status Client Connections Users and Privileges Status and System Variables Data Export Data Import/Restore Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help. INSTANCE Startup / Shutdown A Server Logs Options File 2. CREATE TABLE Customer 3 customer_id int primary key auto_increment, 4 first_name varchar (50), 5 last_name varchar(50), 6 phone_number int(20), 7 email varchar (30), 8 street varchar (100), 9 city varchar(50), 10 state varchar(25), Zip varchar(10), 12 notesvarchar(255) created_at datetime, updated_at datetime 15 ); 11 PERFORMANCE Dashboard Performance Reports Performance Schema Setup 13 14 16 17 • CREATE TABLE Customer_note 18 note_id int Primary KEY AUTO_INCREMENT, 19 subject varchar (255), 20 note varchar (255), 21 customer_id int, 22 created_at datetime, 23 updated_at datetime 24 ); Administration Schemas Information 25 26 • No object selected 27 CREATE TABLE Event Event_id int PRIMARY KEY AUTO_INCREMENT, Customer id int. 28 Context Help Snippets Output + Action A ® ® ® ® ® ® 0 Action Output Time 5 00:44:18 create database annandale_cupcakes 6 00:50:23 CREATE TABLE Customerſ customer_id int primary key auto_increment, first_name varchar(50), last_name ... 7 00:50:24 CREATE TABLE Customer( customer_id int primary key auto_increment, first_name varchar(50), last_name ... 8 00:50:25 CREATE TABLE Customer customer_id int primary key auto_increment, first_name varchar(50), last_name ... 9 00:50:26 CREATE TABLE Customer customer_id int primary key auto_increment, first_name varchar(50), last_name ... 10 00:50:33 CREATE TABLE Customer customer_id int primary key auto_increment, first_name varchar(50), last_name ... Message Duration / Fetch Error Code: 1007. Cant create database 'annandale_cupcakes database exists 0.016 sec Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL ... 0.000 sec Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL ... 0.016 sec Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL ... 0.000 sec Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL ... 0.016 sec Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL ... 0.000 sec Object Info Session O Type here to search АВ 60°F く < (8) e 12:52 AM 10/1/2021 m ca MySQL Workbench - Х itd 256 x File Edit View Query Database Server Tools Scripting Help SQL - 10 SQL File 4* x SQL Additions I? i? | Jump to 구 47. Navigator MANAGEMENT Server Status Client Connections Users and Privileges Status and System Variables Data Export Data Import/Restore 48 Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help. 49 50 51 1 Limit to 1000 rows CREATE TABLE product product_id int PRIMARY KEY AUTO_INCREMENT, cupcake_type varchar (255), cupcake_name varchar(255), price int(11), cost_per_unit int(11), notes varchar(255), unit_capacity int(11), created_at datetime, updated_at datetime 52 53 54 INSTANCE Startup / Shutdown A Server Logs Options File 55 56 57 ); 58 PERFORMANCE Dashboard Performance Reports Performance Schema Setup 59. 60 61 CREATE TABLE Sales sale_id int PRIMARY KEY AUTO_INCREMENT, sale_date datetime, notes varchar (255), created_at datetime, updated_at datetime 62 63 64 65 ); 66 67. 68 69 Administration Schemas 70 CREATE TABLE Sale_Item( sale_item_id int PRIMARY KEY AUTO_INCREMENT, sale_id int (11), product_id int (11), quantity int (11), created_at datetime, updated_at datetime, Information 71 72 No object selected 73 X Context Help Snippets Output + Action A ® ® ® ® ® ® 0 Action Output Time 5 00:44:18 create database annandale_cupcakes 6 00:50:23 CREATE TABLE Customerſ customer_id int primary key auto_increment, first_name varchar(50), last_name ... 7 00:50:24 CREATE TABLE Customer( customer_id int primary key auto_increment, first_name varchar(50), last_name ... 8 00:50:25 CREATE TABLE Customer customer_id int primary key auto_increment, first_name varchar(50), last_name ... 9 00:50:26 CREATE TABLE Customer customer_id int primary key auto_increment, first_name varchar(50), last_name ... 10 00:50:33 CREATE TABLE Customer customer_id int primary key auto_increment, first_name varchar(50), last_name ... Message Duration / Fetch Error Code: 1007. Cant create database 'annandale_cupcakes database exists 0.016 sec Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL ... 0.000 sec Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL ... 0.016 sec Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL ... 0.000 sec Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL ... 0.016 sec Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL ... 0.000 sec Object Info Session O Type here to search АВ 60°F く < (8) e 12:52 AM 10/1/2021 m ca
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

CREATE TABLE Customer(
customer_id int primary key auto_increment,
first_name varchar (50),
last_name varchar(50),
phone_number int(20),
email varchar (30),
street varchar (100),
city varchar(50),
state varchar(25),
Zip varchar(10),
notesvarchar(255)
created_at datetime,
update...


Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Related Tags