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 moreAuthor: Hajira Tabasum J
More 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 moreSelect Statement
The SELECT statement allows we to get the data from table of views. A table consists of rows and columns like a spreadsheet. The SELECT
Read moreCreate a table with auto increment and default option
In MySql, we can create a column that contains a sequence of numbers(1,2,3 and so on) by using the AUTO_INCREMENT attribute. The AUTO_INCREMENT attribute is
Read moreHow To Update The Details In A Table
We may have a requirement where the existing data in MYSQL table needs to be modified. We can do so by using the SQL UPDATE
Read moreDeletion of Rows of the Table
The DELETE command is used to delete rows that are no longer required from the database tables. It deletes the whole row from the table.
Read more