Select a row from a specific column by giving a condition- SELECT name, address FROM customers WHERE id=54 Select all the row accept a specific row from a column- SELECT name, address FROM customers...
For multiple conditions the use of statement AND- SELECT name, state, city FROM customers WHERE state='CA' AND city='Hollywood' For multiple conditions the use of statement OR- SELECT name, state,...
This is some kinds of sorting. If want to find out some portion of your information according to a order then follow the examples- SELECT name, cost FROM items WHERE cost>(250) ORDER BY cost DESC ELECT...
If you want want to create a custom column which will hold the upper case letters and everything then use the character function UPPER - SELECT name, UPPER(name) FROM customers There are different...
Creating a custom column use the keyword CONCAT - SELECT CONCAT(city,',',state) FROM customers Give name to the new custom column - SELECT CONCAT(city,',',state) AS new_info FROM customers ...
If you want to find a specific information from different sources/places from database then you can use the statement IN like this- SELECT name, state FROM customers WHERE state IN('CA','NY','NC') If...
A good blog should have a Contact Us option in it so that readers can contact with the...
Meta tags are very important for any blog or website. Google bots read Meta tags and...
If you want to run multiple queries at a time then command for selecting city and id from customers- SELECT city FROM customers; SELECT id FROM customers; You run the any query by giving line breaks...
If there is duplicate result in data but you are asked to show distinct result then command- SELECT DISTINCT state FROM customers If you are asked to find a list of 10 customers from...
If you have more tables in your database those who are holding columns of same name then you can sort out the specified column and its data form a table by this command- SELECT customers.address FROM...
Retrieve more than one column of a table in the same SELECT statement- SELECT name,zip FROM customers Show all the columns of a table in the same SELECT statement- SELECT * FROM customers ...
To see your databases command- SHOW DATABASES To see your tables in a database command- SHOW TABLES To see all the column names in a table named customer command- SHOW COLUMNS FROM customers If...
I am going to make a few tutorials about MySQL to let you know how to create it and access...
It is always a very good practice to link Facebook page to your blog. If you have...
Steps to add code box in blogger: Go to the Dashboard of your blog and select Template. Click...
