mysql view table code example
Example 1: mysql show data from table
mysql> SELECT * FROM [table name];
Example 2: mysql show table structure
DESCRIBE table_name;
Example 3: mysql command show tables
SHOW TABLES;
Example 4: show table mysql
USE yourDb;
SHOW TABLES;
Example 5: create view mysql
CREATE VIEW `general_v_movie_rentals` AS SELECT mb.`membership_number`,mb.`full_names`,mo.`title`,mr.`transaction_date`,mr.`return_date` FROM `movierentals` AS mr INNER JOIN `members` AS mb ON mr.`membership_number` = mb.`membership_number` INNER JOIN `movies` AS mo ON mr.`movie_id` = mo.`movie_id`;
Example 6: mysql show tables in database
show tables;