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 …
Original source
(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 …
Original source
13 responses to “(11) MySQL Sub Query Tutorial”
yo Espanol nop english
Hello quiero ser admins 😀
@jattwhiskey604 heidi sql
What program are you using
If only I had known about this before, this is fantastic. Thanks!
@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 SELECT * FROM users WHERE 1 IN (SELECT * FROM other_table)
@SuperJammed if you have phpMyAdmin installed you should Export the database, then just select the thread area and pop those in!
@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. 😡
@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
@JREAMdesign i know i am noob xD but what i dont know is how to for example.
SELECT * FROM posts"from db1"
WHERE aurthor_id"from db1" = user_id"from db2"
i dont know how to refer posts to db1 or db2 ><
@SuperJammed Heya cool LOL thanks. Yeah you can connect locally or not locally. Its actually seriously easy, you just type in your MySQL info into HeidiSQL to your remote host. If it doesn't work, then you have to make your Remote Connections are allowed (I keep mine to accept only my webserver IP, otherwise id use SOAP or something)
thanks for your work i like it! and i want to ask you. can you connect to 2 local databases? also can you connect to 2 databases not local and work on them?i would like to see tutorial about it if possible. thanks and your tutorials are clear to me 🙂