(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”

  1. @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.

  2. @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

  3. @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 ><

  4. @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)

  5. 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 ๐Ÿ™‚

Leave a Reply