@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.
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 :)
@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)
@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 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
What program are you using
jattwhiskey604 5 months ago
@jattwhiskey604 heidi sql
JREAMdesign 5 months ago
If only I had known about this before, this is fantastic. Thanks!
MelvinSF 7 months ago
@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?
AlphonsoWisseh 8 months ago
@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.
JREAMdesign 8 months ago
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?
programmingismylife 9 months ago
@programmingismylife SELECT * FROM users WHERE 1 IN (SELECT * FROM other_table)
JREAMdesign 9 months ago
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 :)
SuperJammed 1 year ago
@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)
JREAMdesign 1 year ago
@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 1 year ago
@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 1 year ago
@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
SuperJammed 1 year ago
@SuperJammed if you have phpMyAdmin installed you should Export the database, then just select the thread area and pop those in!
JREAMdesign 1 year ago