<hr>
(mysqli): select * from ARTICLE where ID_ARTICLE=5349 &nbsp; 
<hr>
<hr>
(mysqli): select * from ARTICLE_SURCHARGE where ID_ARTICLE_SURCHARGE=5349 &nbsp; 
<hr>
FKID_REF_TYPE_ARTICLE ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_A_TITRE ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_A_SOUSTITRE ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_A_REFERENCE ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>BE_A_NEW ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>TEXT_A_DESCRIPTIF ARTICLE_SURCHARGE surchargé ----> abandon unicitaire<br>TEXT_A_METATITLE ARTICLE_SURCHARGE surchargé ----> abandon unicitaire<br>TEXT_A_METATITLEVENTE ARTICLE_SURCHARGE surchargé ----> abandon unicitaire<br>TEXT_A_METADESC ARTICLE_SURCHARGE identique ----> ecrasement unicitaire : update ARTICLE_SURCHARGE set TEXT_A_METADESC=""  where ID_ARTICLE_SURCHARGE=5349<br>TEXT_A_METADESCVENTE ARTICLE_SURCHARGE surchargé ----> abandon unicitaire<br>BE_A_TV ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_A_LINKTV ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_A_PINTEREST ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_A_FACEBOOK ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_A_YOUTUBE ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>BE_A_UNE ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>TEXT_A_UNE ARTICLE_SURCHARGE surchargé ----> abandon unicitaire<br>VAL_A_HAUTEUR ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>VAL_A_LARGEUR ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>VAL_A_PROFONDEUR ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>BE_A_COMPOSE ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>BE_A_ACTIVE ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>BE_A_DELETE ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>DATET_A_CREATE ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>DATET_A_LASTMODIF ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>OLD_ID ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_A_COMPLEMENTAIRE1 ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_A_COMPLEMENTAIRE2 ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_A_COMPLEMENTAIRE3 ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_A_COMPLEMENTAIRE4 ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_A_COMPLEMENTAIRE5 ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_A_COMPLEMENTAIRE6 ARTICLE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_A_COMPLEMENTAIRE7 ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_A_COMPLEMENTAIRE8 ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_A_COMPLEMENTAIRE9 ARTICLE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_A_COMPLEMENTAIRE10 ARTICLE_SURCHARGE identique ----> ecrasement + concat<br><hr>
(mysqli): select * from PLANTE where ID_PLANTE=5349 &nbsp; 
<hr>
<hr>
(mysqli): select * from PLANTE_SURCHARGE where ID_PLANTE_SURCHARGE=5349 &nbsp; 
<hr>
PKFKID_ARTICLE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>FKID_REF_OBTENTEUR PLANTE_SURCHARGE identique ----> ecrasement + concat<br>FKID_FAMILLE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>FKID_REF_FORME PLANTE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_P_FAMILLE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_P_GENRE PLANTE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_P_ESPECE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_P_SESPECE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_P_GROUPE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_P_VARIETE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_VARIETETM PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_VARIETEC PLANTE_SURCHARGE surchargé ----> abandon + concat<br>BE_P_VARIETER PLANTE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_P_MARQUE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_MARQUETM PLANTE_SURCHARGE surchargé ----> abandon + concat<br>BE_P_MARQUEC PLANTE_SURCHARGE surchargé ----> abandon + concat<br>BE_P_MARQUER PLANTE_SURCHARGE surchargé ----> abandon + concat<br>CHAR_P_CULTIVAR PLANTE_SURCHARGE surchargé ----> abandon + concat<br>BE_P_CULTIVARTM PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_CULTIVARC PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_CULTIVARR PLANTE_SURCHARGE identique ----> ecrasement + concat<br>CHAR_P_COMPLEMENT PLANTE_SURCHARGE surchargé ----> abandon + concat<br>BE_P_COMPLEMENTTM PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_COMPLEMENTR PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_COMPLEMENTC PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_LEPAGE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>TEXT_P_GENRE PLANTE_SURCHARGE surchargé ----> abandon unicitaire<br>TEXT_P_ESPECE PLANTE_SURCHARGE surchargé ----> abandon unicitaire<br>TEXT_P_CULTIVAR PLANTE_SURCHARGE surchargé ----> abandon unicitaire<br>TEXT_P_ENTRETIEN PLANTE_SURCHARGE surchargé ----> abandon unicitaire<br>VAL_P_DENSITE PLANTE_SURCHARGE surchargé ----> abandon + concat<br>VAL_P_HAUTEUR PLANTE_SURCHARGE identique ----> ecrasement + concat<br>VAL_P_HAUTEUR_MIN PLANTE_SURCHARGE identique ----> ecrasement + concat<br>VAL_P_HAUTEUR_MAX PLANTE_SURCHARGE identique ----> ecrasement + concat<br>VAL_P_LARGEUR PLANTE_SURCHARGE identique ----> ecrasement + concat<br>VAL_P_LARGEUR_MIN PLANTE_SURCHARGE identique ----> ecrasement + concat<br>VAL_P_LARGEUR_MAX PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_SOLEIL PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_OMBRE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_MIOMBRE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_CALCAIRE PLANTE_SURCHARGE surchargé ----> abandon + concat<br>BE_P_ACIDE PLANTE_SURCHARGE surchargé ----> abandon + concat<br>BE_P_DRAINE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_SEC PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_FRAIS PLANTE_SURCHARGE surchargé ----> abandon + concat<br>BE_P_HUMIDE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_FLEURCOUPE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_MARITIME PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_VENT PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_PASVENT PLANTE_SURCHARGE surchargé ----> abandon + concat<br>BE_P_MELLIFERE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_PERSISTANT PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_ODORANTE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_LONGUEF PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_FLORIFERE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_ISOLE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_COUVRESOL PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_GRIMPANTE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_PRIOFLEUR PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_HYBRIDE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_F1 PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_SEMIS PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_FERTILE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_POTFLEURI PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_COMMESTIBLE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_TOXIQUE PLANTE_SURCHARGE surchargé ----> abandon + concat<br>BE_P_FRUIT PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_CONDIMENT PLANTE_SURCHARGE identique ----> ecrasement + concat<br>TEXT_P_COMMESTIBLE PLANTE_SURCHARGE identique ----> ecrasement unicitaire : update PLANTE_SURCHARGE set TEXT_P_COMMESTIBLE=""  where ID_PLANTE_SURCHARGE=5349<br>BE_P_GEL PLANTE_SURCHARGE identique ----> ecrasement + concat<br>VAL_P_TEMPGEL PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_SECHERESSE PLANTE_SURCHARGE surchargé ----> abandon + concat<br>VAL_P_ARROSAGE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_ACTIVE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>BE_P_DELETE PLANTE_SURCHARGE identique ----> ecrasement + concat<br>DATET_P_CREA PLANTE_SURCHARGE identique ----> ecrasement + concat<br>DATET_P_LASTMODIF PLANTE_SURCHARGE surchargé ----> abandon + concat<br>update PLANTE_SURCHARGE set PKFKID_ARTICLE="5349",FKID_REF_OBTENTEUR="0",FKID_FAMILLE="0",CHAR_P_FAMILLE="Caprifoliaceae",CHAR_P_ESPECE="",CHAR_P_SESPECE="",CHAR_P_GROUPE="",CHAR_P_VARIETE="",BE_P_VARIETETM="0",BE_P_VARIETER="0",CHAR_P_MARQUE="",BE_P_CULTIVARTM="0",BE_P_CULTIVARC="0",BE_P_CULTIVARR="0",BE_P_COMPLEMENTTM="0",BE_P_COMPLEMENTR="0",BE_P_COMPLEMENTC="0",BE_P_LEPAGE="0",VAL_P_HAUTEUR="0",VAL_P_HAUTEUR_MIN="2.00",VAL_P_HAUTEUR_MAX="2.50",VAL_P_LARGEUR="0",VAL_P_LARGEUR_MIN="1.00",VAL_P_LARGEUR_MAX="2.50",BE_P_SOLEIL="1",BE_P_OMBRE="0",BE_P_MIOMBRE="1",BE_P_DRAINE="0",BE_P_SEC="0",BE_P_HUMIDE="0",BE_P_FLEURCOUPE="0",BE_P_MARITIME="1",BE_P_VENT="1",BE_P_MELLIFERE="1",BE_P_PERSISTANT="1",BE_P_ODORANTE="1",BE_P_LONGUEF="0",BE_P_FLORIFERE="0",BE_P_ISOLE="0",BE_P_COUVRESOL="0",BE_P_GRIMPANTE="0",BE_P_PRIOFLEUR="0",BE_P_HYBRIDE="0",BE_P_F1="0",BE_P_SEMIS="0",BE_P_FERTILE="0",BE_P_POTFLEURI="0",BE_P_COMMESTIBLE="0",BE_P_FRUIT="0",BE_P_CONDIMENT="0",BE_P_GEL="0",VAL_P_TEMPGEL="0",VAL_P_ARROSAGE="0",BE_P_ACTIVE="0",BE_P_DELETE="0",DATET_P_CREA="12/12/2016 15:31:33" where ID_PLANTE_SURCHARGE=5349<br><br>-----------------<br>