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
>
>
>

[PHP-DB] Correct Syntax?

2015-10-13 Thread 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

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