Hardware Upgrade Forum - View Single Post

breiko · 04-11-2005, 15:27

Codice:

query SQL:     
SELECT FIRST (  img  ) AS I  FROM blog  LIMIT 0 , 30     

Messaggio di MySQL:    #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 '( img ) AS I from blog  LIMIT 0, 30' at line 1

Dalla guida:
FIRST(column) Returns the value of the first record in a specified field (not supported in SQLServer2K)
LAST(column) Returns the value of the last record in a specified field (not supported in SQLServer2K)

Qualcuno mi aiuta a capire cosa non va?

04-11-2005, 15:27	#1
breiko Member Iscritto dal: Apr 2004 Città: Vicenza Messaggi: 123	[SQL] First e Last Codice: query SQL: SELECT FIRST ( img ) AS I FROM blog LIMIT 0 , 30 Messaggio di MySQL: #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 '( img ) AS I from blog LIMIT 0, 30' at line 1 Dalla guida: FIRST(column) Returns the value of the first record in a specified field (not supported in SQLServer2K) LAST(column) Returns the value of the last record in a specified field (not supported in SQLServer2K) Qualcuno mi aiuta a capire cosa non va? __________________ Love, let me sleep tonight on your couch And remember the smell of the fabric of your simple city dress [Jeff Buckley - So real]