write the examples for following mysql commands on table a show, Basic, MySQL

Question:Write the examples for the following mysql commands on the table.

a) SHOW
b) CREATE
c) INSERT
d) UPDATE
e) SELECT
f) ALTER
g) DESC
h) DESCRIBE
i) DROP
j) DELETE

Answer a) example:
 mysql> show tables;

b) example:
mysql>create table book(
    id int(10) not null auto_increment primary key,
    title varchar(50) not null,
    author varchar(50)
);

c) example:
mysql>insert into book(title,author)values('MySQL','Mikel Jone');

d) example:
mysql>update book set title='Advanced MySQL' where id=1;

e) example:
mysql>select id, title, author from book;

f) example:
mysql>alter table book add column isbn varchar(20);

g) example:
mysql>desc book;

h) example:
mysql>describe book

i) example:
mysql>drop table book;

j) example:
mysql>delete from book where id=3;

/11

Deprecated: html_entity_decode(): Passing null to parameter #1 ($string) of type string is deprecated in D:\webserver\www\vcampusbd.com\answers\column_answer_two.php on line 128

+ Report

Quizzes on Basic Ebook

Total Preview: 959

Write the examples for the following mysql commands on the table. a) SHOW b) CREATE c) INSERT d) UPDATE e) SELECT f) ALTER g) DESC h) DESCRIBE i) DROP j) DELETE

Question:Write the examples for the following mysql commands on the table. a) SHOW b) CREATE c) INSERT d) UPDATE e) SELECT f) ALTER g) DESC h) DESCRIBE i) DROP j) DELETE