LIKE Operator The LIKE Operator is commonly used to select data based on patterns. MySQL provides two wildcard characters for using with the LIKE operator
Read moreCategory: MySQL
ALTER TABLE
In MySQL ALTER command command is very useful when you want to change any table field or if you want to add or delete an
Read moreLIMIT Clause
The LIMIT clause is used with the SELECT statement to restrict the number of rows in the result set. The Limit Clause accepts one or
Read moreDISTINCT CLAUSE
The MySQL select Distinct statement is used to retrieve unique rows (by removing the duplicate rows ) from the specified column in the select statement.
Read moreCreating a table as an existing table
we can create a table from an exiting table with all / specific columns by following query, Example 1: will create a table dummy as
Read moreMore On MySQL WHERE Clause
MySQL provides you with some other operators for using in the WHERE clause to form complex search conditions such as: BETWEEN – Selects values within
Read moreEXERCISE
Create a table named customer for the below structure, 80101 DINESH RAJ 9840212400 THIRUNINRAVUR 80102 RAKESH RAJ 9840312413 AMBATTUR 80103 SUMATHI 9489096200 PERUNGUDI 80104 SHANKARAN
Read moreWHERE clause with Multiple Conditions
The MySQL And, Or, Not, operators can be combined in a SELECT, INSERT, UPDATE, or DELETE statement. When combining these operators, it is important to
Read moreMySQL ORDER BY Clause
When we use the SELECT statement to query the data from a table, the result set is not sorted. To sort the result set, we
Read moreExercise No.1
Insert the following data into the student table Enroll_no Student_Name Gender Course Total_fees 12014 RAM KUMAR MALE DCA 8400 12015 DAISY FEMALE HDCA 14800 12016
Read more