Databases
StackOverflow2013
Postsdbo
POMySQL procedures check
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMySQL procedures check
    primarykey
    data
    text
    <p>I am new to procedures and I am trying to implement them within my customer website.</p> <p>I want to create a procedure to add a new customer. I want to check to make sure there phoneNumber is not already in the database. If it is, I want to display an error message. If the phone number is not in the db, I want to insert it into my CUSTOMER table. </p> <p>I have implemented the following but I am getting an error. I am not sure if I am declaring variables right in MySQL, and I am not sure if the "if statement" is valid in the way I have done it. Also, how could I set the if statement query to a variable? If anyone could help, it would mean a lot. Thanks!</p> <pre><code>DELIMITER // CREATE PROCEDURE add_Customer (IN customerNum int, IN last varchar, IN first varchar) BEGIN DECLARE output var DEFAULT ''; IF SELECT CUSTOMER.customerNum FROM CUSTOMER WHERE CUSTOMER.customerNum= customerNum THEN SET output= "Customer already exists!"; select output; ELSE INSERT INTO CUSTOMER VALUES (customerNum, last, first); END IF; END// DELIMITER; </code></pre> <p><strong>EDITED</strong></p> <pre><code>DELIMITER // CREATE PROCEDURE add_Customer (IN customerNum int, IN last varchar, IN first varchar) BEGIN DECLARE output var DEFAULT ''; DECLARE var_num INT; SELECT CUSTOMER.customerNum INTO var_num FROM CUSTOMER WHERE CUSTOMER.customerNum= customerNum if var_num IS NULL THEN INSERT INTO CUSTOMER VALUES (customerNum, last, first); ELSE SET output= "Customer already exists!"; select output; END IF; END// DELIMITER; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAlex G
    1. USAlex G
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhat type of data is CUSTOMER.customerNum ?
      singulars
      1. POMySQL procedures check
      1. USalditis
    2. CO@alditis It is an integer... simply the customer number. Thanks
      singulars
      1. POMySQL procedures check
      1. USAlex G
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload