• 0

[MySql SQL] What is the DELIMITER about?!


Question

Im confident with SQL and normally use SQL Server. But im messing about with MySql and having a nightmare with some simple stored procedures.

One minute my code is fine, the next it has syntax errors - AND I HAVENT CHANGED THE CODE!

The error points at the first line reading 'DELIMITER $$' - what is this DELIMITER for? I tried taking it out before and it didnt work. Can anyone shine a light here?

3 answers to this question

Recommended Posts

  • 0

MySQL uses a special character (the "delimiter") to mark the end of a command. When loading the stored procedure into memory, MySQL parses that file and treats the input characters literally. Therefore, when it encounters the delimiter while loading the file, it begins executing the stored procedure as if you had just typed it into the console. And since the file hasn't finished loading yet, you get errors. In order to prevent this, it is necessary to change the delimiter to something else temporarily in order to suppress immediate execution. Then, after the stored procedure has been loaded into memory, change the delimiter back into what it was before.

  • 0
  $phinX said:

So, i load the script into Query Browser app. Change the $$ delimiter to //, run it, change it back to $$ and it works, yeah?

Depends on what delimiter you used inside your script file. If it is //, then yes. If it is $$, then:

Change the $$ delimiter to //,

load the script into Query Browser app,

change it back to $$,

run it

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Microsoft is removing legacy drivers from Windows Update by Usama Jawad Last month, we learned that Microsoft is making major changes to the development of hardware drivers in Windows. This included the retirement of Windows Metadata and Internet Services (WMIS), along with the process for pre-production driver signing. Now, the Redmond tech firm has informed partners that it will be getting rid of old drivers in Windows Update. In what is being described as a "strategic" move to improve the security posture and compatibility of Windows, Microsoft has announced that it will be performing a cleanup of legacy drivers that are still being delivered through Windows Update. Right now, the first phase only targets drivers that already have modern replacements present in Windows Update. As a part of its cleanup process, Microsoft will expire legacy drivers so that it is not offered to any system. This expiration involves removing audience segments in the Hardware Development Center. Partners can still republish a driver that was deemed as legacy by Microsoft, but the firm may require a justification. Once the Redmond tech giant completes its first phase of this cleanup, it will give partners a six-month grace period to share any concerns. However, if no concerns are brought forward, the drivers will be permanently eradicated from Windows Update. Microsoft has emphasized that this will be a regular activity moving forward and while the current phase only targets legacy drivers with newer replacements, the next phases may expand the scope of this cleanup and remove other drivers too. That said, each time the company takes a step in this direction, it will inform partners so that there is transparency between both parties. Microsoft believes that this move will help improve the security posture of Windows and ensure that an optimized set of drivers is offered to end-users. The firm has asked partners to review their drivers in Hardware Program so that there are no unexpected surprises during this cleanup process.
    • No idea, but I had a client the other week that lost the entire drive to it. I suggested relying on the Samsung T7's instead. The Sandisk Extreme's had reliability issues too.
    • I use it every day so personally yes I need it, or rather I want it. I use OpenShell though, not the garbage modern Start Menu. I just counted and at the moment I have a total of 92 program shortcuts organized into six folders almost exactly the way I did back in Windows 95. I can get to any program I want to run very quickly. I never use Search to find or run programs.
    • I do miss the Apps view from Windows 8.1 Update.
    • I use the search function and little else since Windows 11 (but there are times where Saved Searches take precedence since the search feature on the Start menu is worse than before). I use other features in previous releases.
  • Recent Achievements

    • Collaborator
      lethalman went up a rank
      Collaborator
    • Week One Done
      Wayne Robinson earned a badge
      Week One Done
    • One Month Later
      Karan Khanna earned a badge
      One Month Later
    • Week One Done
      Karan Khanna earned a badge
      Week One Done
    • First Post
      MikeK13 earned a badge
      First Post
  • Popular Contributors

    1. 1
      +primortal
      664
    2. 2
      ATLien_0
      262
    3. 3
      Michael Scrip
      212
    4. 4
      +FloatingFatMan
      168
    5. 5
      Steven P.
      156
  • Tell a friend

    Love Neowin? Tell a friend!