subject:"Re\: \[PHP\-DB\] Correct Syntax\?"

Re: [PHP-DB] Correct Syntax?

2015-10-30 Thread chimurenga chimurenga

make vehicle licence the unique key

On 14 Oct 2015 00:28, "Karl DeSaulniers"  wrote:
>
> Quick question. Is this viable in MySQL?
>
> UNIQUE KEY `Vehicle_Name`
(`Vehicle_Make`+`Vehicle_Model`+`Vehicle_Style`+`Vehicle_License`)
>
> TIA
>
> Best,
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>
>

Re: [PHP-DB] Correct Syntax?

2015-10-13 Thread Roberto Spadim

instead of +, use ",'

2015-10-13 20:21 GMT-03:00 Karl DeSaulniers :

> Quick question. Is this viable in MySQL?
>
> UNIQUE KEY `Vehicle_Name`
> (`Vehicle_Make`+`Vehicle_Model`+`Vehicle_Style`+`Vehicle_License`)
>
> TIA
>
> Best,
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>
>
>


-- 
Roberto Spadim
SPAEmpresarial - Software ERP
Eng. Automação e Controle