• Wednesday , 18 October 2017

(11) MySQL Sub Query Tutorial

Code Canyon



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

3d Ocean

Related Posts

13 Comments

  1. joaquin purgat
    September 4, 2017 at 21:23

    yo Espanol nop english

  2. joaquin purgat
    September 4, 2017 at 21:23

    Hello quiero ser admins 😀

  3. JREAM
    September 4, 2017 at 21:23

    @jattwhiskey604 heidi sql

  4. jattwhiskey604
    September 4, 2017 at 21:23

    What program are you using

  5. Melvin
    September 4, 2017 at 21:23

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

  6. JREAM
    September 4, 2017 at 21:23

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

  7. JREAM
    September 4, 2017 at 21:23

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

  8. JREAM
    September 4, 2017 at 21:23

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

  9. SuperJammed
    September 4, 2017 at 21:23

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

  10. JREAM
    September 4, 2017 at 21:23

    @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

  11. SuperJammed
    September 4, 2017 at 21:23

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

  12. JREAM
    September 4, 2017 at 21:23

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

  13. SuperJammed
    September 4, 2017 at 21:23

    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 Comment

You must be logged in to post a comment.