SmashingX: If you can’t.

 
Krise: Salle: what is it generated by, InnoDB?

Keiter: SmashingX: why do you think you don’t need a join?

Correl: SmashingX: Joins in SQL are like steering wheel for car driving

Wortham: I don’t know that’s why Im asking here thumbs

Keiter: SmashingX: use a join.

Correl: SmashingX: Would you ask if you need to know what steering wheel is and why would you use it when you want to drive your car around?

Kirschner: My question would be why would I need a join?

Correl: SmashingX: Because you need it

Keiter: SmashingX: because it’s the simplest solution to solve your problem.

Correl: SmashingX: Because join is the natural way to do what you want to do with your three tables

Regulus: The last time I asked something and I just followed directions and I *****ed up they told me “why didn’t you try to understand the solution instead of just doing what they tell you to do” now, it seems like I don’t have a choice

Abilez: But if I ask more is like “you just need to do it”

Keiter: SmashingX: ok. Read about joins. Understands what joins do. Better?

Correl: SmashingX: You have to understand joins in order to use them

Madine: Can i not install mysql on centos7 at all?

Madine: All the docs say to use mariadb

Nietfeldt: No, I know what joins are

Madine: I’m nervous about that

Keiter: Rakm: you can probably find a package somewhere.

Keiter: SmashingX: are you sure?

Correl: Rakm: MariaDB replaces MySQL so it provides mysql too

Keiter: SmashingX: I’m not sure.

Keiter: SmashingX: read about joins.

Madine: Existing databases will continue to work?

Morrell: Keiter: I already did

Keiter: Rakm: yes, it’s compatible with Oracle MySQL

Correl: SmashingX: If you know what joins are you wouldn’t ask such questions :

Edde: Rakm: I recently switched from MySQL to MariaDB with a database with 400 tables and had 0 problems – it “just worked”

Keiter: SmashingX: if you knew what joins were, you wouldn’t ask your questions.

Madine: Aeiou that’s encouraging

Madine: Aeiou what was your switch process

Correl: Rakm: If you are installing new CentOS there are no existing databases :

Buie: Mysqldump, pv file.sql mysql database_name

Osbourne: Here: http://www.codeproject.com/KB/database/Visual_SQL_Joins/Visual_SQL_JOINS_orig.jpg

Sabataso: That’s what joins are

Klaphake: Rakm: literally that simple

Keiter: SmashingX: so now do you understand how joins can help you solve your problems?

Correl: SmashingX: That you can copy some URLs does not mean you understand them

Briguglio: Rakm: i had the same concerns you’re having – but when we ran in production there were 0 issues

Lambeth: Salle: well, it’s pretty basic

Benya: Rakm: it’s a PHP ecommerce platform, which has a pretty crazy database – and had no issues

Correl: Rakm: Depending on what MySQL version you have you might not need to dump and reimport anything

Keiter: And MariaDB has tons of new useful stuff Oracle doesn’t.

Correl: SmashingX: Yes pretty basic and your question is pretty basic too

Keiter: SmashingX: yes, it is.

Madine: Salle i’m setting up ansible scripts for what we already have and doing it against centos7 instead of EL6.6 that we use in prod right now

Correl: SmashingX: If you understand joins you know how to answer your question

Carrano: Rakm: ha ha ha – that is exactly what I did and why i chose mariadb :-

Correl: SmashingX: If you can’t answer your own question that proves you don’t understand the very basics of the joins