mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries

It is query very similar to Normal queries in databases like
It may return one column
it may return more column
It may return single rows
It may return multiple rows

OR
any of above combination.

SubQuries are those queries which are used within Normal Queries.

For Example

select * from users where user_id =(select user_id from profile where type='user');

Here queries used within bracket is known as sub queris

There are four types of sub-queries.
a. Scalar Subqueries: return single columan of single row

select * from users where user_id =(select user_id from profile where type='user' limit 1);

b. Row Subqueries: Return single row

select u1.* from users As u1 left join (select user_id,country from profile limit 1) as u2 on u2.user_id=u1.user_id and u2.country=u1.country

c. Column Subqueries: Return one column of one or more rows

select * from users where user_id in(select user_id from profile where type='user');

d. Table Subqueries: return one more col of one/more rows

select u1.* from users As u1 left join (select user_id,country from profile) as u2 on u2.user_id=u1.user_id and u2.country=u1.country

Best Related Posts are Following:

1. DBMS Interview Questions and Answers for Freshers.
2. MySQL Interview Questions and Answers for Experienced.
3. Difference between inner join and outer join in MySQL.
4. How to get a list of MySQL user accounts?.
5. How to delete MySQL Binary logs Files in Wamp Server?.
6. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY.
7. Multiple column ordering in Zend Framework.
8. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL.
9. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
10. Difference Between MyISAM and innoDB - MySQL.
11. MySQL Functions - MySQL tutorial for beginners.
12. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries.
13. Mysql FullText Search Examples.
14. MySQL Constraint Example.
15. MySQL Cascade Example.
16. Mysql-Group-Concat.
17. MySQL Expressions.
18. MySQL Delete Table Example.
19. Replace Table - Update Field, Move Records to another table MySQL.
20. mysql insert syntax - Add records from another table - Copy Table from one table to another.
21. Mysql Update Syntax - Update Multiple Records.
22. What is Mysql.
23. Mysql Console Commands - Export and Import database from command line.
24. MySQL interview Questions and Answers For Experienced.

Domain Name Server

DNS is simple it just changes IP Address to human readable. 

How to get the Ip address from the website Name
http://whois.net/domain-name-ip-address/

array dns_get_record ( string $hostname [, int $type = DNS_ANY [, array &$authns [, array &$addtl ]]] )

Fetch DNS Resource Records associated with a hostname

Fetch DNS Resource Records associated with the given hostname.


<?php
$result = dns_get_record("php.net");print_r($result);?>

host The record in the DNS namespace to which the rest of the associated data refers. class dns_get_record() only returns Internet class records and as such this parameter will always return IN. type String containing the record type. Additional attributes will also be contained in the resulting array dependant on the value of type. See table below. ttl "Time To Live" remaining for this record. This will not equal the record's original ttl, but will rather equal the original ttl minus whatever length of time has passed since the authoritative name server was queried.

Best Related Posts are Following:

1. What is Composer in php? - Manage the Dependencies.
2. Hadoop Basic Interview Questions and Answer.
3. Hadoop - Understanding Hadoop Architecture.
4. MongoDB Interview Questions and Answers.
5. Manage SPF Record - How to add SPF Record?.
6. How do you parse and process HTML in PHP.
7. Edit an commit message in Github Repository - Commands.
8. How do you disable browser Autocomplete on web form field / input tag?.
9. Web Development Project Manager interview questions and answers.
10. How to create Dynamic XML Sitemap online.
11. What is UPnP in Skype?.
12. How to delete Content of File in windows.
13. Difference between SSL and HTTPS.
14. SPDY Protocol - Improve the Speed of web page.
15. Difference Between Hadoop and Big-Data.
16. Golden Rules for successful project.
17. Winners - Daily Habits of Successful People.
18. Export MS Access to MySQL with SnapShots.
19. What is Streaming Servers, Streaming Protocol and Port Protocol.
20. Project Management Tips- Way to Successful project.
21. Google Dynamic Charts - Bar Pie and Line Chart - code snippets.
22. Web Technology Important Links - Create SiteMap - Monitor Website - SEO Health - All Google API - Blogspot Assistance links.
23. Domain Name Server.
24. Systems Development Life Cycle (SDLC).
25. Normalization Denormalization different form of normalization.
26. Binary Search Tree.
27. Defination of SOLID DRY KISS UX.
28. Design Patterns.
29. Waterfall model.
30. Agile Software Development - Principle of Agile Software Development - Agile means quick in movement..
31. Virtual Host Setup In Window System.
32. Convert worksheets into csv files.
33. MX Record Explanation.
34. Hadoop Interview Questions And Answers For Freshers.
35. PHP MAILER setting to send email through Gmail.
36. Validate Icalendar File or URL.