MySQL select query, we will perform below actions. List all customers who is active List all customers who is active and ‘Y’ in their firstname List all customers who is active and ‘Y’ in their lastname List all customers who having ‘Y’ in their lastname or lastname (either one) List all customers who having ‘Y’ … Read more
MySQL alter command is used to modify an existing database, table, view or other database objects that might need to change during the life cycle of a database. Or you can used when you want to change the name of your table or any table field. It is also used to add or delete an … Read more
In this article we will discuss about MySQL Query e.g. Create/show/drop database as well create/alert and delete table and table records. Table of Contents Login to MySQL Create a Database Use Database Show Database Drop Database Create a Table Show structure of table Insert Data into table Select record from Table Update record from Table … Read more