Mysql tutorial for beginners in tamil | Create and copy a table from one db to another db table

Mysql tutorial for beginners in tamil | How to create table basic in sql query in tamil | How to create and copy a table from one db to another db in tamil,

This video describes how to open the mysql workbench and how to create the database and how to create table using sql query.
USE keyword which is used to select the particular database from all the databases.
"USE database_name";

CREATE DB and TABLE:
Create is a keyword which is used to create database or create table.
"CREATE DATABASE database_name" this is the query for create database.
CREATE TABLE table_name(
filed1_name data_type,
filed2_name data_type,
etc.,
);
the above query is used to create a new table.

Create a table like already existing one.
"create new_table_name like existing_table_name" this query is used to create only the table structure from the existing table.

"create new_table_name as select * from existing_table_name " which is used to copy and create newly from existing table.

[jayasri-ft]

Excellent service to society by you and your channel. It's purely fulfilling my dream. Thank you so much sir. Good presentation by faculty. Voice and expression also good. Screen visibility is not good little bit has to improve. Thank