Course Solutions Uncategorized (Solved) : Mysql Question Help Need Help Inserting Data Tables Already Created Create Table Schema Ne Q33389396 . . . .

(Solved) : Mysql Question Help Need Help Inserting Data Tables Already Created Create Table Schema Ne Q33389396 . . . .

 

MYSQL QUESTION HELP

I need help with inserting data into tables I have alreadycreated “create table schema” but I need it inserted. Here are thetables.

Example of how it needs to be inserted.

INSERT INTO vendor(company_name, contact_lname, contact_fname,address, city, state, zip, phone, fax, email)
VALUES(‘All Merchandises’, ‘Huntington’, ‘Anne’, ‘1515 NW MarketStreet’,   ‘Seattle’, ‘WA’, ‘98107’, ‘206-325-6755′,’206-329-9675’, ‘LAT@business.com’);

The University Database

————————————————————————————————————————————————

The student table

Student ID

Last Name

First Name

Street

City

State

Zip

Birth Date

Major ID

Phone

Student

Type

24746

Diaz

Jose

1 Ford Avenue #7

Hill

NJ   

08863

1993-02-12

100   

9735551111

ugrad

79352

Tyler   

Kee

12 Morris Avenue   

Bronx

NY

10468

1994-03-18

500

7185552222

grad

76672

Miliko

Rajesh

25 River Road #3

Edison

NJ

08837   

1995-12-12

400

7325553333

ugrad

14182

Rickles

Alex

100 Main Street

Iselin

NJ

08838

1990-10-20

500

7325554444

grad

44985

Lee

Ho

2845 First Lane

Hope

NY

11373

1995-10-28

600

2125555555

grad

96052

Holn

Amir

213 Broadway

Clifton

NJ

07222

1994-07-07

200

2015556666

ugrad

The student table

————————————————————————————————————————————————

The registration table

Student ID

Section ID

Midterm Grade

Final Grade

24746

1102

B

B

24746

1103

C

F

24746

1104

B

A

24746

1207

79352

1205

76672

1102

F

D

76672

1103

A

A

76672

1206

B

C

76672

1207

76672

1210

14182

1101

F

W

14182

1104

D

D

14182

1206

A

B

14182

1311

A

A

44985

1206

44985

1207

44985

1210

96052

1208

96052

1209

96052

1311

B

B

The registration table

————————————————————————————————————————————————

The location table

Room ID

Building

Room No.

Capacity

Room Type

Room Description

11

Gandhi

101

2

O

Office

12

Gandhi   

103

2

O

Office

13

Kennedy

202

35

L

Lab

14

Kennedy

204

50

L

Lab

15

Nehru

301

50

C

Classroom

16

Nehru

309

45

C

Classroom

17

Gandhi

105

2

O

Office

18

Kennedy

206

40

L

Lab

19

Kennedy

210

30

C

Classroom

20

Gandhi

107

2

O

Office

21

Gandhi

109

2

O

Office

The location table

————————————————————————————————————————————————

Expert

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post