Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HOW CAN I CHANGE THE TABLE NAMES TNANKS O X @ DOO SQLAdditions 1 > | Jump to 46 MySQL Workbench f u nconnected x

image text in transcribed HOW CAN I CHANGE THE TABLE NAMES

TNANKS

O X @ DOO SQLAdditions 1 > | Jump to 46 MySQL Workbench f u nconnected x Local instance MySQL57 (col. x Local instance MySQL57 (colonial.x File Edit View Query Database Server Tools Scripting Help 5 5 6 8 1 E 50 g Navigator Query 1 x SCHEMAS G D 17 F A 0 | 0 53 | Limit to 1000 rows 61 Q 1 2 & Filter objects 45 1 FROM TRIP L WHERE STATE = 'ME'); > Triggers A views #8. Find the guide last name and guide first name of all guides who can lead a Stored Procedures 49 . SELECT LAST_NAME, FIRST_NAME 1 Functions 50 FROM TRIP, TRIP_GUIDES, GUIDE colonialadventuretoursjan2018 WHERE TYPE = 'Paddling'; 1 Tables > customer #9.Repeat Exercise 8 but use aliases for the table names. E guide 54 SELECT LAST_NAME, FIRST_NAME inventory FROM TRIP, TRIP GUIDES, GUIDE E paddling 56 3 alter table LAST_NAME RENAME to 'ALIASES: ve Columns ALTER TABLE FIRST_NAME RENAME TO 'ALIASES' Management Schemas 58 WHERE TYPE = 'Paddling' 47 48 Automatic context help is disable Use the toolbar to manually get help for the current caret positioi or to toggle automatic help. 59 Information: 000000000 Table: trip Export: 8 | Wrap Cell Content: FA | Fetch rows: H Columns: TRIP ID TRIP_NAME START_LOCATION STATE DISTANCE MAX_GRP_SIZE TYPE SEASON | Result Grid D LAST_NAME Abrams Abrams ahrame Result 35 x decimal(3,0) PK char(75) char (50) char (2) decimal(4,0) decimal(4,0) char (20) char (20) Result Grid N Filter Rows: FIRST_NAME Miles Miles Mlec O Read Only Context Help Snippets Output 0x000000000000 O 0 0 Action Output # Time Action Message Duration / Fetch 67 00:45:22 SELECT LAST_NAME, FIRST_NAME FROM TRIP, TRIP_GUL... Emor Code: 1064. You have an error in your SQL syntax; check t... 0.000 sec 68 00:45:57 SELECT LAST_NAME, FIRST_NAME FROM TRIP, TRIP_GUI... 1000 row(3) retumed 0.000 sec /0.000 sec Object Info Session Query Completed Search the web and Windows 0 h 9 0 @ 4 N a " G | E| 1:17 AM O 1:1) = 3/30/2018

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_2

Step: 3

blur-text-image_3

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

Database Internals A Deep Dive Into How Distributed Data Systems Work

Authors: Alex Petrov

1st Edition

1492040347, 978-1492040347

More Books

Students also viewed these Databases questions

Question

2. Do you agree that unions stifle creativity? Why or why not?

Answered: 1 week ago