List the first name and last name of all authors. Concatenate the first and last names so that the result set has only one column. Hint: CONCAT(). For example:+---------------+| Full Name |+---------------+| Mike Lance || Steve Smith || Anne Penny || Ron MacDonald || Sylvia Parry || Albert Jones |+---------------+ mysql> DESC author;mysql> DESC book;mysql> DESC bookauthor;| Field| Туре| Field| Typ| Field| Туре| author_idint(1varch| isbn| name| var| vartauthor_idisbntint(11| varchaauthor_order | int(11S5nlastname varch.| firstname | varchphoneaddress| type| varroyaltysharedecima.varchvarchvarch.| pub_id| int| dec| price| advance| decytd_sales | intI pubdate| city| state| zipvarch.| varch| datmysql> DESC bookeditor;| FieldI fypemysql> DESC editor;mysql> DESC publisher;| Field| editor_id | int(11)| isbn| varchar(1| editor_idssn| lastname| firstname| phoneeditor positionsalary| Field| ТуреI pub id | int(11)nameaddress | varchar(40)city| statevarchar(40)I varchar(20)I varchar(2)

Concat() function : This function in SQL joins string into one, maximum string which it can take as…

Answered: List the first name and last name of…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

List the first name and last name of all authors. Concatenate the first and last names so that the result set has only one column. Hint: CONCAT(). For example:

+---------------+

| Full Name |

+---------------+

| Mike Lance |

| Steve Smith |

| Anne Penny |

| Ron MacDonald |

| Sylvia Parry |

| Albert Jones |

+---------------+

mysql> DESC author;
mysql> DESC book;
mysql> DESC bookauthor;
| Field
| Туре
| Field
| Typ
| Field
| Туре
| author_id
int(1
varch
| isbn
| name
| var
| var
tauthor_id
isbn
tint(11
| varcha
author_order | int(11
S5n
lastname varch.
| firstname | varch
phone
address
| type
| var
royaltyshare
decima.
varch
varch
varch.
| pub_id
| int
| dec
| price
| advance
| dec
ytd_sales | int
I pubdate
| city
| state
| zip
varch.
| varch
| dat
mysql> DESC bookeditor;
| Field
I fype
mysql> DESC editor;
mysql> DESC publisher;
| Field
| editor_id | int(11)
| isbn
| varchar(1
| editor_id
ssn
| lastname
| firstname
| phone
editor position
salary
| Field
| Туре
I pub id | int(11)
name
address | varchar(40)
city
| state
varchar(40)
I varchar(20)
I varchar(2)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions