SQL Tutorials part 4

MySQL alter table statement is used to add a column, modify a column, drop a column, rename a column or rename a table. This video tutorial demonstrates the following: alter table employees -change column salary sal double; alter table sample -rename to smallEmp;

SQL Tutorials part 3

MySQL alter table statement is used to add a column, modify a column, drop a column, rename a column or rename a table. This video tutorial demonstrates the following: use riim; Database changed show tables; +----------------+ | Tables_in_riim | +----------------+ |...

SQL tutorials part 2

Queries: 1. How to create a table? 2. How to show list of tables? 3. How to insert records/rows into the tables 4. How to describe the structure of the table? 5. How to retrieve/display the records of the table? 6. How to retrieve limited rows from a table?

SQL tutorials part 1

1. How to create a database? 2. How to list databases? SQL is structural query language used in many popular databases. The database is organized collection of tables. The popular database software include Oracle, IBM DB2, MySQL, MS SQL Server.