Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Find the first name, last name and age of people who's last name is not 'Adama': CREATE TABLE `bsg_people` ( `id` int(11) NOT NULL AUTO_INCREMENT,

Find thefirst name, last name and ageof people who's last name is not 'Adama':

CREATE TABLE `bsg_people` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`fname` varchar(255) NOT NULL,

`lname` varchar(255) DEFAULT NULL,

`homeworld` int(11) DEFAULT NULL,

`age` int(11) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `homeworld` (`homeworld`),

CONSTRAINT `bsg_people_ibfk_1` FOREIGN KEY (`homeworld`) REFERENCES `bsg_planets` (`id`) ON DELETE SET NULL ON UPDATE CASCADE

) ENGINE=InnoDB

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

Step: 3

blur-text-image

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

Mobile Usability

Authors: Jakob Nielsen, Raluca Budiu

1st Edition

0133122131, 9780133122138

More Books

Students also viewed these Programming questions