error in SQL workbench
ERROR 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 ‘)’ at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

Answer Question   |  July 21, 2010  1:29 AM
MySQL, SQL, SQL error messages, SQL Server, SQL Server 2005, SQL Syntax

Find the SQL value behind the decimal
I need to know if the numbers after a decimal point are greater than 0. What is the easiest SQL syntax to do this?

Answer Question   |  June 24, 2010  8:42 PM
SQL, SQL Query, SQL Syntax

help me create trigger update column
CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ‘ TABLE is null’ RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP < 300000)  PRINT ‘ finish update ‘ END /* trigger not check ‘ BL3.TIENNOP < 300000′ [...]

Answer Question   |  May 19, 2010  7:03 AM
MySQL, SQL Syntax, SQLite