mySQL spojování II

Spojování tabulek

Vícenásobné

 $query = "SELECT
      par.nazev as nazev_par,
      moznost.nazev,
      moznost.id_moz,
      poradi
      FROM tabulka1 t1
         JOIN tabulka2
                ON tabulka1.id_par = tabulka2.id_par
         JOIN tabulka3
                 ON tabulka2.id_moz = tabulka3.id_moz
         LEFT JOIN tabulka4
                 ON tabulka3.nazev = tabulka4.nazev
         WHERE tabulka2.id_pro = $idProduktu  AND par.typ = 6
         ORDER BY velikosti_poradi.poradi, moznost.nazev";
                                                

SELECT

práce s Datumem

SELECT *,date_format(datum_vlozeni, '%d.%m.%y') as datum FROM tabulka 

UpperCase a LowerCase

 SELECT * FROM tabulka WHERE LOWER(jmeno)=LOWER('MarkéTkA')

 SELECT * FROM tabulka WHERE UPPER(jmeno)=UPPER('MarkéTkA')

 SELECT * FROM tabulka WHERE jmeno LIKE 'MarkéTkA'

Nastavení práv k databázi

delete from user where user = 'uzivatel' and host='localhost';
insert into user (user, host, password) values ('uzivatel', 'localhost', password('atnarf'));
create database db-martyn;
insert into db (host, db, user, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv,References_priv, Index_priv, Alter_priv, Create_tmp_table_priv,
Lock_tables_priv,Create_view_priv,Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) values ('localhost', 'db-martyn', 'uzivatel', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y','Y', 'Y', 'Y', 'Y', 'Y');
flush privileges;