101 reputation
3
bio website dev.thomaskile.me
location Norway
age 26
visits member for 2 years, 2 months
seen Sep 3 at 20:04

Feb
9
comment How can I push data from my local MAMP database to my remote database?
the remote server is where the site is stored online - Bluehost in my case. And there I have a database that is identical to the database locally on my machine - MAMP. When I update the database locally, I would like to somehow update the database online at the end of the day. The site is running against the database on Bluehost - which is what I refer to as "remote server". Did that clear things up a bit?
Feb
9
asked How can I push data from my local MAMP database to my remote database?
Jan
21
comment Would it be better to do a sepparate query instead of a left JOIN?
@ShlomiNoach, sorry about that..
Jan
16
comment Would it be better to do a sepparate query instead of a left JOIN?
Very well then. Knowing nothing was much better than knowing a litte. Everything was easier back then.. Anyway; Thanks for taking your time to reply. Helped a lot..
Jan
16
awarded  Commentator
Jan
16
comment Would it be better to do a sepparate query instead of a left JOIN?
Thanks Jon. But I have to ask, before I waste a whole lot of time with this one thing: No matter how I query - join tables together - I always get one record with type:ALL. Is this correct? Like the one in the image I've put in my question. The same happens when I try to query from the _rel_-tables, and joining the associated tables. The tags/raw_materials get eq_ref while the recipes is set to ALL. the _rel_-tables is set to ref and extra:using index. in both cases..
Jan
16
revised Would it be better to do a sepparate query instead of a left JOIN?
Tried out EXPLAIN
Jan
16
comment Would it be better to do a sepparate query instead of a left JOIN?
How would I expand an index to cover both fk_recipes_id and in_use?
Jan
16
comment Would it be better to do a sepparate query instead of a left JOIN?
How do I analyze a query? Never done something like that before, but would be interresting to know. As I mentioned; I'm primarly working in MySQL Workbench..
Jan
16
awarded  Editor
Jan
16
comment Would it be better to do a sepparate query instead of a left JOIN?
I've added a EER diagram to my question.. Maybe it tells you a bit more...
Jan
16
revised Would it be better to do a sepparate query instead of a left JOIN?
Added an EER diagram
Jan
16
comment Would it be better to do a sepparate query instead of a left JOIN?
what do you mean by "less glib"? What is "glib"? Is there a way to test different queries in mysql workbench to see which execute faster or better?
Jan
16
asked Would it be better to do a sepparate query instead of a left JOIN?
Jan
14
comment Is my JOIN syntax not valid? And have I understood JOIN correctly?
One other thing regarding parent and child tables. In you RIGHT OUTER JOIN article you mentions that your script asks for "all Parent records and only matching Child records". And in your script the parent table is the one that is getting joined. Is it allways like that? or how do I know which one should be treaded as a parent and which should be treaded as the child table?
Jan
14
comment Is my JOIN syntax not valid? And have I understood JOIN correctly?
is JOIN equal to INNER JOIN, and LEFT JOIN equal to LEFT OUTER JOIN?
Jan
14
awarded  Supporter
Jan
14
comment Is my JOIN syntax not valid? And have I understood JOIN correctly?
So I've got it correct then. The joined table will always become the RIGHTtable. And by using LEFT- or RIGHT JOIN would determine which one of them to fetch all records regardless of match in the opposite one...
Jan
14
comment Is my JOIN syntax not valid? And have I understood JOIN correctly?
Yes, I know. I just needed to know if I've understood the relation between tables if I added LEFT or RIGHT to the JOIN. Which table was which...
Jan
14
asked Is my JOIN syntax not valid? And have I understood JOIN correctly?