(11) MySQL Sub Query Tutorial

This ones tricky guys! We are going to create a Query within a Query. Please take your time to see the code and think about what is happening so you understand. The SELECT statement in the SUB QUERY compares it to the MAIN QUERY's WHERE statement. Confused? Study the code a few times!

http://jream.com/learning

Category:

Howto & Style

Tags:

• mysql
• query
• sub
• subquery
• select
• subselect
• multi
• multiquery
• multiple
• tutorial

[jattwhiskey604]

What program are you using



[JREAMdesign]

@jattwhiskey604 heidi sql

[AlphonsoWisseh]

@JREAMdesign

Two Questions.

Do you need to know this in order to create a membership website?

&

Where can I get those sounds that you have on your computer installed on my computer?

[JREAMdesign]

@AlphonsoWisseh Hi, you need to know a database language to store and reuse your data, like user logins and passwords. The sounds come with windows 7, they might be the default.

[programmingismylife]

i really love your mysql tutorials, the best i have seen so far.

i am only having the problem with this sub query , is there any chance you would come up with a more practice example to use this?

[JREAMdesign]

@programmingismylife SELECT * FROM users WHERE 1 IN (SELECT * FROM other_table)

[MelvinSF]

If only I had known about this before, this is fantastic. Thanks!

[JREAMdesign]

@SuperJammed if you have phpMyAdmin installed you should Export the database, then just select the thread area and pop those in!

[SuperJammed]

@JREAMdesign ya but i need it. to transfer my threads blog to another cms. there are some extenitons but it is just not that good . i am trying to transfer it myself. :x

[JREAMdesign]

@SuperJammed Hey, you would need two database connections at once (Like if you were working in PHP), but that is a really bad idea, you should have 1 database, a bunch of tables inside it with posts, authors, threads, etc. I do not understand why you want to do that with separate databases