OWNERNUM LASTNAME FIRSTNAME ADDRESS CITY STATE ZIPCODE AK10...

OWNER_NUM LAST_NAME FIRST_NAME ADDRESS CITY STATE ZIP_CODE AK102 Aksoy Ceyda 411 Griffin Rd. Seattle WA 98131 BI109 Bianchi Nicole 7990 Willow Dr. New York NY 10005 BU106 Burke Ernest 613 Old Pleasant St. Twin Falls ID 83303 CO103 Cole Meerab 9486 Circle Ave. Olympia WA 98506 JO110 Jones Ammarah 730 Military Ave. Seattle WA 98126 KO104 Kowalczyk Jakub 7431 S. Bishop St. Bellingham WA 98226 LO108 Lopez Janine 9856 Pumpkin Hill Ln. Everett WA 98213 MO100 Moore Elle-May 8006 W. Newport Ave. Reno NV 89508 PA101 Patel Makesh 7337 Sheffield St. Seattle WA 98119 RE107 Redman Seth 7681 Fordham St. Seattle WA 98119 S1105 Sims Haydon 527 Primrose Rd. Portland OR 97203

Thanks for your feedback!

MYSQL I am having trouble, I am receiving this error on my query for creating this procedure. ERROR 1064 (42000) at line 2: 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 '.CUSTOMER_NAME VARCHAR(20); SELECT CONCAT (FIRST_NAME, ' ', LAST_NAME) INTO' at line 3. Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer whose ID currently is stored in I_CUST_ID. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. When the procedure is called, it should output the contents of I_CUSTOMER_NAME and I_CREDIT_LIMIT. Here is my query procedure, thank you. I have included the proper table for this question. DELIMITER // CREATE PROCEDURE GET_CREDIT_LIMIT (IN I_CUST_ID CHAR(20)) BEGIN DECLARE I_CUSTOMER_NAME VARCHAR(20); SELECT CONCAT (FIRST_NAME, ' ', LAST_NAME) INTO I_CUSTOMER_NAME FROM CUSTOMER WHERE CUST_ID = I_CUST_ID; SELECT I_CUSTOMER_NAME; END// DELIMITER ; OWNER_NUM LAST_NAME FIRST_NAME ADDRESS CITY STATE ZIP_CODE AK102 Aksoy Ceyda 411 Griffin Rd. Seattle WA 98131 BI109 Bianchi Nicole 7990 Willow Dr. New York NY 10005 BU106 Burke Ernest 613 Old Pleasant St. Twin Falls ID 83303 CO103 Cole Meerab 9486 Circle Ave. Olympia WA 98506 JO110 Jones Ammarah 730 Military Ave. Seattle WA 98126 KO104 Kowalczyk Jakub 7431 S. Bishop St. Bellingham WA 98226 LO108 Lopez Janine 9856 Pumpkin Hill Ln. Everett WA 98213 MO100 Moore Elle-May 8006 W. Newport Ave. Reno NV 89508 PA101 Patel Makesh 7337 Sheffield St. Seattle WA 98119 RE107 Redman Seth 7681 Fordham St. Seattle WA 98119 SI105 Sims Haydon 527 Primrose Rd. Portland OR 97203

Play audio

Feedback

Question

Please give Ace some feedback