Message-ID: <1845612868.377860.1711645875006.JavaMail.root@confluence-doc2-production> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_377859_1454524922.1711645875001" ------=_Part_377859_1454524922.1711645875001 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Table names must begin with the PrestaShop "_DB_PREFIX_
=
" prefix.
... FROM= `'. _DB_PREFIX_.'customer` ...=20
=
ps_cart
".ps_order
"._lang
" suffix: "ps_product_lang=
".Keywords must be written in uppercase.
SELECT `= firstname` FROM `'._DB_PREFIX_.'customer`=20
Back quotes ("`
") must be used around SQL field names a=
nd table names.
SELECT p= .`foo`, c.`bar` FROM `'._DB_PREFIX_.'product` p, `'._DB_PREFIX_.'customer` c=20
Table aliases have to be named by taking the first letter of each wo= rd, and must be lowercase.
SELECT p= .`id_product`, pl.`name` FROM `'._DB_PREFIX_.'product` p NATURAL JOIN `'._DB_PREFIX_.'product_lang` pl=20
When conflicts between table aliases occur, the second character has= to be also used in the name.
SELECT c= a.`id_product`, cu.`firstname` FROM `'._DB_PREFIX_.'cart` ca, `'._DB_PREFIX_.'customer` cu=20
A new line has to be created for each clause.
$query = =3D 'SELECT pl.`name` FROM `'._DB_PREFIX_.'product_lang` pl WHERE pl.`id_product` =3D 17';=20
JOIN
in a WHERE
cla=
use.