Click here to Skip to main content
15,867,453 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 3:53
professionalJörgen Andersson30-Jun-14 3:53 
AnswerRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson29-Jun-14 22:39
professionalJörgen Andersson29-Jun-14 22:39 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 22:52
Miller Nguyen29-Jun-14 22:52 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson29-Jun-14 23:03
professionalJörgen Andersson29-Jun-14 23:03 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Bernhard Hiller30-Jun-14 0:38
Bernhard Hiller30-Jun-14 0:38 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 1:15
professionalJörgen Andersson30-Jun-14 1:15 
AnswerRe: SQL convert(datetime, number) wrong? Pin
GuyThiebaut30-Jun-14 0:52
professionalGuyThiebaut30-Jun-14 0:52 
QuestionMySQL Stored Procs - Pin
ericgahn29-Jun-14 9:08
ericgahn29-Jun-14 9:08 
Hi all;

I am learning to write stored procs on MySQL and am going crazy.

SQL
DELIMITER $$

DROP PROCEDURE IF EXISTS CleanCopyEnvData$$

CREATE PROCEDURE CleanCopyEnvData ()
BEGIN

  insert into  EnvData(UserDate, XAction, Balance, UserID)
  select 
    CAST(udate as Date)
    , CAST(amount1 as Decimal(6,3))
    , CAST(amount2 as Decimal(6,3))
    , CAST(UID as UnSigned)
  from 
    DataLoad;
    
END $$

DELIMITER ;


I get an error:

Error starting at line : 17 in command -
END $$
Error at Command Line : 17 Column : 1
Error report -
SQL Error: 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 'END $$' at line 1


I am using Oracle SQL Developer and the INSERT statement works ok when executed on its own. I can do these things blindfolded with my arms tied on MSSQL. Any help appreciated.

EG.
AnswerRe: MySQL Stored Procs - Pin
Wayne Gaylard29-Jun-14 22:37
professionalWayne Gaylard29-Jun-14 22:37 
GeneralRe: MySQL Stored Procs - Pin
ericgahn1-Jul-14 19:03
ericgahn1-Jul-14 19:03 
GeneralRe: MySQL Stored Procs - Pin
Wayne Gaylard1-Jul-14 19:28
professionalWayne Gaylard1-Jul-14 19:28 
QuestionQuestion about File Server / MySQL Database Pin
Jassim Rahma29-Jun-14 2:30
Jassim Rahma29-Jun-14 2:30 
AnswerRe: Question about File Server / MySQL Database Pin
Peter Leow29-Jun-14 3:19
professionalPeter Leow29-Jun-14 3:19 
AnswerRe: Question about File Server / MySQL Database Pin
Bernhard Hiller29-Jun-14 21:12
Bernhard Hiller29-Jun-14 21:12 
Questiondatabase Pin
sheikh muneeb28-Jun-14 7:18
sheikh muneeb28-Jun-14 7:18 
AnswerRe: database Pin
PIEBALDconsult28-Jun-14 7:33
mvePIEBALDconsult28-Jun-14 7:33 
GeneralRe: database Pin
sheikh muneeb28-Jun-14 7:49
sheikh muneeb28-Jun-14 7:49 
GeneralRe: database Pin
PIEBALDconsult28-Jun-14 7:52
mvePIEBALDconsult28-Jun-14 7:52 
GeneralRe: database Pin
sheikh muneeb28-Jun-14 7:56
sheikh muneeb28-Jun-14 7:56 
GeneralRe: database Pin
PIEBALDconsult28-Jun-14 7:58
mvePIEBALDconsult28-Jun-14 7:58 
GeneralRe: database Pin
Shameel2-Jul-14 1:08
professionalShameel2-Jul-14 1:08 
AnswerRe: database Pin
Bernhard Hiller29-Jun-14 21:25
Bernhard Hiller29-Jun-14 21:25 
QuestionWhat is the difference between Data Warehouse and Database? Pin
Bastien Vandamme26-Jun-14 20:28
Bastien Vandamme26-Jun-14 20:28 
AnswerRe: What is the difference between Data Warehouse and Database? Pin
thatraja26-Jun-14 21:04
professionalthatraja26-Jun-14 21:04 
GeneralRe: What is the difference between Data Warehouse and Database? Pin
Bastien Vandamme26-Jun-14 21:28
Bastien Vandamme26-Jun-14 21:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.