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; 


Deprecated: html_entity_decode(): Passing null to parameter #1 ($string) of type string is deprecated in D:\webserver\www\vcampusbd_com_https\answers\column_answer_two.php on line 128
+ Report
Total Preview: 1029
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
Copyright © 2024. Powered by Intellect Software Ltd