[gl-como] Help MySql

Pietro Bertera pietro@bertera.it
Lun 7 Ago 2006 10:51:05 CEST


Il giorno lun, 07/08/2006 alle 10.19 +0300, Carlo Filippetto ha scritto:
> Ciao,
> non riesco a creare una VIEW
> 
> --- 
> CREATE VIEW customer_list AS SELECT SA_fax FROM TB_sale
> 
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'VIEW customer_list AS select SA_fax from TB_sale' at line 1
> ---
> 
> uso 
> mysql  Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)
> 
> Non so come superare il problema.
> 

Nella doc di mysql:
Views (including updatable views) are implemented in MySQL Server 5.0.
Views are available in binary releases from 5.0.1 and up.

ciao



Maggiori informazioni sulla lista gl-como