Subquery in MySQL
Subquery in MySQL means Query inside another query on SELECT, INSERT, UPDATE or DELETE. A subquery must be enclosed with parentheses and can be used anywhere in an expression. The main advantages of subqueries is […]
MySQL in Namaste UI focused on mysql dbms, mysql tools, mysql database, mysql software, mysrl app, mysql server, learn mysql online, sql tutorial and mysql tutorial.
Subquery in MySQL means Query inside another query on SELECT, INSERT, UPDATE or DELETE. A subquery must be enclosed with parentheses and can be used anywhere in an expression. The main advantages of subqueries is […]
To group rows into subgroup by one or more values of columns we use MySQL GROUP BY. Suppose in user table same country name exists for many times for different user. So if we use […]
MySQL LEFT JOIN allows you to get result set from two or more tables for certain matches. Suppose you have two tables i.e. A and B. So if you join A to B using left […]
Using MySQL INNER JOIN you can match rows in one table with another table and get result set that contain columns from both tables. Suppose we have two tables user and order. So Using this […]
Using MySQL UNION Operator you can combine two or more result set from a multiple table into a single result set. UNION operator eliminates duplicate rows from the result set even you forgot to use […]
Using MySQL LIKE operator you can search based on patterns. It is used in the WHERE clause in SELECT statement. This basically use two characters for using the MySQL LIKE operator: ‘%’ – allows you […]
To specify a range of test you can use BETWEEN operator. Example of BETWEEN: SELECT * FROM users WHERE age BETWEEN 18 AND 55; Here below 18 and above 55 aged user will be eliminated. […]
Using IN operator in MySQL you can match the value from a set of values or a subquery. Example of MySQL IN: SELECT * FROM user WHERE country IN (‘IN’,’AUS’); Here both the user from […]
In a table there may be data available i.e. duplicate. Each time you querying and get all the duplicate data. Use DISTINCT to avoid it. Suppose in a coountry table there are two same country […]
To sort a table columns in ascending or descending order you use ORDER BY clause. Using ASC and DESC you can get the result in ascending or descending order. You can also apply both order […]