"Incorrect syntax near the keyword 'ON'. (on update cascade, on delete cascade,)












2















total noob sorry any help greatly appreciated.
I keep getting this "Incorrect syntax near the keyword 'ON'."
heres my codes



code one



CREATE TABLE supplier (
supplierID INT PRIMARY KEY,
ISBN INT FOREIGN KEY REFERENCES book(ISBN),
price DECIMAL (5,2),
ON UPDATE CASCADE,
ON DELETE CASCADE,
);


code two



CREATE TABLE orders (
orderID INT PRIMARY KEY,
customerID INT FOREIGN KEY REFERENCES customer(customerID),
ISBN INT FOREIGN KEY REFERENCES book(ISBN),
orderDate date,
ON UPDATE CASCADE,
ON DELETE CASCADE,
);


Ive run out of stuff to try other than dumbing it down to uselessness.










share|improve this question





























    2















    total noob sorry any help greatly appreciated.
    I keep getting this "Incorrect syntax near the keyword 'ON'."
    heres my codes



    code one



    CREATE TABLE supplier (
    supplierID INT PRIMARY KEY,
    ISBN INT FOREIGN KEY REFERENCES book(ISBN),
    price DECIMAL (5,2),
    ON UPDATE CASCADE,
    ON DELETE CASCADE,
    );


    code two



    CREATE TABLE orders (
    orderID INT PRIMARY KEY,
    customerID INT FOREIGN KEY REFERENCES customer(customerID),
    ISBN INT FOREIGN KEY REFERENCES book(ISBN),
    orderDate date,
    ON UPDATE CASCADE,
    ON DELETE CASCADE,
    );


    Ive run out of stuff to try other than dumbing it down to uselessness.










    share|improve this question



























      2












      2








      2








      total noob sorry any help greatly appreciated.
      I keep getting this "Incorrect syntax near the keyword 'ON'."
      heres my codes



      code one



      CREATE TABLE supplier (
      supplierID INT PRIMARY KEY,
      ISBN INT FOREIGN KEY REFERENCES book(ISBN),
      price DECIMAL (5,2),
      ON UPDATE CASCADE,
      ON DELETE CASCADE,
      );


      code two



      CREATE TABLE orders (
      orderID INT PRIMARY KEY,
      customerID INT FOREIGN KEY REFERENCES customer(customerID),
      ISBN INT FOREIGN KEY REFERENCES book(ISBN),
      orderDate date,
      ON UPDATE CASCADE,
      ON DELETE CASCADE,
      );


      Ive run out of stuff to try other than dumbing it down to uselessness.










      share|improve this question
















      total noob sorry any help greatly appreciated.
      I keep getting this "Incorrect syntax near the keyword 'ON'."
      heres my codes



      code one



      CREATE TABLE supplier (
      supplierID INT PRIMARY KEY,
      ISBN INT FOREIGN KEY REFERENCES book(ISBN),
      price DECIMAL (5,2),
      ON UPDATE CASCADE,
      ON DELETE CASCADE,
      );


      code two



      CREATE TABLE orders (
      orderID INT PRIMARY KEY,
      customerID INT FOREIGN KEY REFERENCES customer(customerID),
      ISBN INT FOREIGN KEY REFERENCES book(ISBN),
      orderDate date,
      ON UPDATE CASCADE,
      ON DELETE CASCADE,
      );


      Ive run out of stuff to try other than dumbing it down to uselessness.







      mysql






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 23 '18 at 14:17









      Madhur Bhaiya

      19.6k62236




      19.6k62236










      asked Nov 23 '18 at 14:16









      secretssecrets

      132




      132
























          1 Answer
          1






          active

          oldest

          votes


















          0














          ON UPDATE and ON DELETE should be besides the Foreign Key definition, not away from it. Also, each Foreign Key definition will be having its own ON UPDATE and ON DELETE definitions.



          CREATE TABLE supplier (
          supplierID INT PRIMARY KEY,
          ISBN INT FOREIGN KEY REFERENCES book(ISBN)
          ON UPDATE CASCADE
          ON DELETE CASCADE,
          price DECIMAL (5,2)
          );


          CREATE TABLE orders (
          orderID INT PRIMARY KEY,
          customerID INT FOREIGN KEY REFERENCES customer(customerID)
          ON UPDATE CASCADE
          ON DELETE CASCADE,
          ISBN INT FOREIGN KEY REFERENCES book(ISBN)
          ON UPDATE CASCADE
          ON DELETE CASCADE,
          orderDate date
          );





          share|improve this answer























            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53448323%2fincorrect-syntax-near-the-keyword-on-on-update-cascade-on-delete-cascade%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            ON UPDATE and ON DELETE should be besides the Foreign Key definition, not away from it. Also, each Foreign Key definition will be having its own ON UPDATE and ON DELETE definitions.



            CREATE TABLE supplier (
            supplierID INT PRIMARY KEY,
            ISBN INT FOREIGN KEY REFERENCES book(ISBN)
            ON UPDATE CASCADE
            ON DELETE CASCADE,
            price DECIMAL (5,2)
            );


            CREATE TABLE orders (
            orderID INT PRIMARY KEY,
            customerID INT FOREIGN KEY REFERENCES customer(customerID)
            ON UPDATE CASCADE
            ON DELETE CASCADE,
            ISBN INT FOREIGN KEY REFERENCES book(ISBN)
            ON UPDATE CASCADE
            ON DELETE CASCADE,
            orderDate date
            );





            share|improve this answer




























              0














              ON UPDATE and ON DELETE should be besides the Foreign Key definition, not away from it. Also, each Foreign Key definition will be having its own ON UPDATE and ON DELETE definitions.



              CREATE TABLE supplier (
              supplierID INT PRIMARY KEY,
              ISBN INT FOREIGN KEY REFERENCES book(ISBN)
              ON UPDATE CASCADE
              ON DELETE CASCADE,
              price DECIMAL (5,2)
              );


              CREATE TABLE orders (
              orderID INT PRIMARY KEY,
              customerID INT FOREIGN KEY REFERENCES customer(customerID)
              ON UPDATE CASCADE
              ON DELETE CASCADE,
              ISBN INT FOREIGN KEY REFERENCES book(ISBN)
              ON UPDATE CASCADE
              ON DELETE CASCADE,
              orderDate date
              );





              share|improve this answer


























                0












                0








                0







                ON UPDATE and ON DELETE should be besides the Foreign Key definition, not away from it. Also, each Foreign Key definition will be having its own ON UPDATE and ON DELETE definitions.



                CREATE TABLE supplier (
                supplierID INT PRIMARY KEY,
                ISBN INT FOREIGN KEY REFERENCES book(ISBN)
                ON UPDATE CASCADE
                ON DELETE CASCADE,
                price DECIMAL (5,2)
                );


                CREATE TABLE orders (
                orderID INT PRIMARY KEY,
                customerID INT FOREIGN KEY REFERENCES customer(customerID)
                ON UPDATE CASCADE
                ON DELETE CASCADE,
                ISBN INT FOREIGN KEY REFERENCES book(ISBN)
                ON UPDATE CASCADE
                ON DELETE CASCADE,
                orderDate date
                );





                share|improve this answer













                ON UPDATE and ON DELETE should be besides the Foreign Key definition, not away from it. Also, each Foreign Key definition will be having its own ON UPDATE and ON DELETE definitions.



                CREATE TABLE supplier (
                supplierID INT PRIMARY KEY,
                ISBN INT FOREIGN KEY REFERENCES book(ISBN)
                ON UPDATE CASCADE
                ON DELETE CASCADE,
                price DECIMAL (5,2)
                );


                CREATE TABLE orders (
                orderID INT PRIMARY KEY,
                customerID INT FOREIGN KEY REFERENCES customer(customerID)
                ON UPDATE CASCADE
                ON DELETE CASCADE,
                ISBN INT FOREIGN KEY REFERENCES book(ISBN)
                ON UPDATE CASCADE
                ON DELETE CASCADE,
                orderDate date
                );






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 23 '18 at 14:19









                Madhur BhaiyaMadhur Bhaiya

                19.6k62236




                19.6k62236






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53448323%2fincorrect-syntax-near-the-keyword-on-on-update-cascade-on-delete-cascade%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    404 Error Contact Form 7 ajax form submitting

                    How to know if a Active Directory user can login interactively

                    TypeError: fit_transform() missing 1 required positional argument: 'X'