A procedure (often called a stored procedure) is a collection of pre-compiled SQL statements stored inside the database. It is a subroutine or a subprogram in the regular computing language. A procedure always contains a name, parameter lists, and SQL statements. We can invoke the procedures by using triggers, other procedures and applications such as Java, Python, PHP, etc. It was first introduced in MySQL version 5. Presently, it can be supported by almost all relational database systems.
https://www.javatpoint.com/mysql-procedure
DELIMITER &&
CREATE PROCEDURE procedure_name [[IN | OUT | INOUT] parameter_name datatype [, parameter datatype]) ]
BEGIN
Declaration_section
Executable_section
END &&
DELIMITER ;
-----------------
use ram;
delimiter &&
create procedure vlrtraining()
begin
select "Please SubCribe";
end&&
DELIMITER ;
call vlrtraining();
delimiter %%
create procedure vlrtraining4()
begin
select "Please subcribe our channel";
end %%
DELIMITER ;
-----------------
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 26
Server version: 8.0.25 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use ram
Database changed
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| classicmodels |
| information_schema |
| mysql |
| performance_schema |
| ram |
| ramesh |
| sakila |
| sys |
| world |
+--------------------+
9 rows in set (0.03 sec)
mysql> show databases
->
-> ;
+--------------------+
| Database |
+--------------------+
| classicmodels |
| information_schema |
| mysql |
| performance_schema |
| ram |
| ramesh |
| sakila |
| sys |
| world |
+--------------------+
9 rows in set (0.00 sec)
mysql> delimeter %%
-> ;
ERROR 1064 (42000): 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 'delimeter %%' at line 1
mysql> delimiter %%;
mysql> show databases;
-> %%
-> %%;
+--------------------+
| Database |
+--------------------+
| classicmodels |
| information_schema |
| mysql |
| performance_schema |
| ram |
| ramesh |
| sakila |
| sys |
| world |
+--------------------+
9 rows in set (0.00 sec)
ERROR 1064 (42000): 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 '%%' at line 1
mysql> delimiter %%
mysql> show databases%%
+--------------------+
| Database |
+--------------------+
| classicmodels |
| information_schema |
| mysql |
| performance_schema |
| ram |
| ramesh |
| sakila |
| sys |
| world |
+--------------------+
9 rows in set (0.00 sec)
mysql> show databases;
-> %%
+--------------------+
| Database |
+--------------------+
| classicmodels |
| information_schema |
| mysql |
| performance_schema |
| ram |
| ramesh |
| sakila |
| sys |
| world |
+--------------------+
9 rows in set (0.00 sec)
mysql> delimiter ;
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| classicmodels |
| information_schema |
| mysql |
| performance_schema |
| ram |
| ramesh |
| sakila |
| sys |
| world |
+--------------------+
9 rows in set (0.00 sec)
mysql> select "ramesh"
-> ;
+--------+
| ramesh |
+--------+
| ramesh |
+--------+
1 row in set (0.00 sec)
mysql> delimeter %%
-> create procedure vlrtraining()
-> begin
-> select "Please subcribe our channel";
ERROR 1064 (42000): 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 'delimeter %%
create procedure vlrtraining()
begin
select "Please subcribe our c' at line 1
mysql> end %%
-> DELIMITER ;
ERROR 1064 (42000): 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 %%
DELIMITER' at line 1
mysql> delimiter %%create procedure vlrtraining3()beginselect "Please subcribe our channel";end %%DELIMITER ;
mysql> delimiter %%
mysql> create procedure vlrtraining4()
-> begin
-> select "Please subcribe our channel";
-> end %%
Query OK, 0 rows affected (0.18 sec)
mysql> DELIMITER ;
mysql> call vlrtraining4();
+-----------------------------+
| Please subcribe our channel |
+-----------------------------+
| Please subcribe our channel |
+-----------------------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> select * from orders;
+-------------+------------+--------------+-------------+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+
| orderNumber | orderDate | requiredDate | shippedDate | status | comments | customerNumber |
+-------------+------------+--------------+-------------+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+
| 10100 | 2003-01-06 | 2003-01-13 | 2003-01-10 | Shipped | NULL | 363 |
| 10101 | 2003-01-09 | 2003-01-18 | 2003-01-11 | Shipped | Check on availability. | 128 |
| 10102 | 2003-01-10 | 2003-01-18 | 2003-01-14 | Shipped | NULL | 181 |
| 10103 | 2003-01-29 | 2003-02-07 | 2003-02-02 | Shipped | NULL | 121 |
| 10104 | 2003-01-31 | 2003-02-09 | 2003-02-01 | Shipped | NULL | 141 |
| 10105 | 2003-02-11 | 2003-02-21 | 2003-02-12 | Shipped | NULL | 145 |
| 10106 | 2003-02-17 | 2003-02-24 | 2003-02-21 | Shipped | NULL | 278 |
| 10107 | 2003-02-24 | 2003-03-03 | 2003-02-26 | Shipped | Difficult to negotiate with customer. We need more marketing materials | 131 |
| 10108 | 2003-03-03 | 2003-03-12 | 2003-03-08 | Shipped | NULL | 385 |
| 10109 | 2003-03-10 | 2003-03-19 | 2003-03-11 | Shipped | Customer requested that FedEx Ground is used for this shipping | 486 |
| 10110 | 2003-03-18 | 2003-03-24 | 2003-03-20 | Shipped | NULL | 187 |
| 10111 | 2003-03-25 | 2003-03-31 | 2003-03-30 | Shipped | NULL | 129 |
| 10112 | 2003-03-24 | 2003-04-03 | 2003-03-29 | Shipped | Customer requested that ad materials (such as posters, pamphlets) be included in the shippment | 144 |
| 10113 | 2003-03-26 | 2003-04-02 | 2003-03-27 | Shipped | NULL | 124 |
| 10114 | 2003-04-01 | 2003-04-07 | 2003-04-02 | Shipped | NULL | 172 |
| 10115 | 2003-04-04 | 2003-04-12 | 2003-04-07 | Shipped | NULL | 424 |
| 10116 | 2003-04-11 | 2003-04-19 | 2003-04-13 | Shipped | NULL | 381 |
| 10117 | 2003-04-16 | 2003-04-24 | 2003-04-17 | Shipped | NULL | 148 |
| 10118 | 2003-04-21 | 2003-04-29 | 2003-04-26 | Shipped | Customer has worked with some of our vendors in the past and is aware of their MSRP | 216 |
| 10119 | 2003-04-28 | 2003-05-05 | 2003-05-02 | Shipped | NULL | 382 |
| 10120 | 2003-04-29 | 2003-05-08 | 2003-05-01 | Shipped | NULL | 114 |
| 10121 | 2003-05-07 | 2003-05-13 | 2003-05-13 | Shipped | NULL | 353 |
| 10122 | 2003-05-08 | 2003-05-16 | 2003-05-13 | Shipped | NULL | 350 |
| 10123 | 2003-05-20 | 2003-05-29 | 2003-05-22 | Shipped | NULL | 103 |
| 10124 | 2003-05-21 | 2003-05-29 | 2003-05-25 | Shipped | Customer very concerned about the exact color of the models. There is high risk that he may dispute the order because there is a slight color mismatch | 112 |
| 10125 | 2003-05-21 | 2003-05-27 | 2003-05-24 | Shipped | NULL | 114 |
| 10126 | 2003-05-28 | 2003-06-07 | 2003-06-02 | Shipped | NULL | 458 |
| 10127 | 2003-06-03 | 2003-06-09 | 2003-06-06 | Shipped | Customer requested special shippment. The instructions were passed along to the warehouse | 151 |
| 10128 | 2003-06-06 | 2003-06-12 | 2003-06-11 | Shipped | NULL | 141 |
| 10129 | 2003-06-12 | 2003-06-18 | 2003-06-14 | Shipped | NULL | 324 |
| 10130 | 2003-06-16 | 2003-06-24 | 2003-06-21 | Shipped | NULL | 198 |
| 10131 | 2003-06-16 | 2003-06-25 | 2003-06-21 | Shipped | NULL | 447 |
| 10132 | 2003-06-25 | 2003-07-01 | 2003-06-28 | Shipped | NULL | 323 |
| 10133 | 2003-06-27 | 2003-07-04 | 2003-07-03 | Shipped | NULL | 141 |
| 10134 | 2003-07-01 | 2003-07-10 | 2003-07-05 | Shipped | NULL | 250 |
| 10135 | 2003-07-02 | 2003-07-12 | 2003-07-03 | Shipped | NULL | 124 |
| 10136 | 2003-07-04 | 2003-07-14 | 2003-07-06 | Shipped | Customer is interested in buying more Ferrari models | 242 |
| 10137 | 2003-07-10 | 2003-07-20 | 2003-07-14 | Shipped | NULL | 353 |
| 10138 | 2003-07-07 | 2003-07-16 | 2003-07-13 | Shipped | NULL | 496 |
| 10139 | 2003-07-16 | 2003-07-23 | 2003-07-21 | Shipped | NULL | 282 |
| 10140 | 2003-07-24 | 2003-08-02 | 2003-07-30 | Shipped | NULL | 161 |
| 10141 | 2003-08-01 | 2003-08-09 | 2003-08-04 | Shipped | NULL | 334 |
| 10142 | 2003-08-08 | 2003-08-16 | 2003-08-13 | Shipped | NULL | 124 |
| 10143 | 2003-08-10 | 2003-08-18 | 2003-08-12 | Shipped | Can we deliver the new Ford Mustang models by end-of-quarter? | 320 |
| 10144 | 2003-08-13 | 2003-08-21 | 2003-08-14 | Shipped | NULL | 381 |
| 10145 | 2003-08-25 | 2003-09-02 | 2003-08-31 | Shipped | NULL | 205 |
| 10146 | 2003-09-03 | 2003-09-13 | 2003-09-06 | Shipped | NULL | 447 |
| 10147 | 2003-09-05 | 2003-09-12 | 2003-09-09 | Shipped | NULL | 379 |
| 10148 | 2003-09-11 | 2003-09-21 | 2003-09-15 | Shipped | They want to reevaluate their terms agreement with Finance. | 276 |
| 10149 | 2003-09-12 | 2003-09-18 | 2003-09-17 | Shipped | NULL | 487 |
| 10150 | 2003-09-19 | 2003-09-27 | 2003-09-21 | Shipped | They want to reevaluate their terms agreement with Finance. | 148 |
| 10151 | 2003-09-21 | 2003-09-30 | 2003-09-24 | Shipped | NULL | 311 |
| 10152 | 2003-09-25 | 2003-10-03 | 2003-10-01 | Shipped | NULL | 333 |
| 10153 | 2003-09-28 | 2003-10-05 | 2003-10-03 | Shipped | NULL | 141 |
| 10154 | 2003-10-02 | 2003-10-12 | 2003-10-08 | Shipped | NULL | 219 |
| 10155 | 2003-10-06 | 2003-10-13 | 2003-10-07 | Shipped | NULL | 186 |
| 10156 | 2003-10-08 | 2003-10-17 | 2003-10-11 | Shipped | NULL | 141 |
| 10157 | 2003-10-09 | 2003-10-15 | 2003-10-14 | Shipped | NULL | 473 |
| 10158 | 2003-10-10 | 2003-10-18 | 2003-10-15 | Shipped | NULL | 121 |
| 10159 | 2003-10-10 | 2003-10-19 | 2003-10-16 | Shipped | NULL | 321 |
| 10160 | 2003-10-11 | 2003-10-17 | 2003-10-17 | Shipped | NULL | 347 |
| 10161 | 2003-10-17 | 2003-10-25 | 2003-10-20 | Shipped | NULL | 227 |
| 10162 | 2003-10-18 | 2003-10-26 | 2003-10-19 | Shipped | NULL | 321 |
| 10163 | 2003-10-20 | 2003-10-27 | 2003-10-24 | Shipped | NULL | 424 |
| 10164 | 2003-10-21 | 2003-10-30 | 2003-10-23 | Resolved | This order was disputed, but resolved on 11/1/2003; Customer doesn't like the colors and precision of the models. | 452 |
| 10165 | 2003-10-22 | 2003-10-31 | 2003-12-26 | Shipped | This order was on hold because customers's credit limit had been exceeded. Order will ship when payment is received | 148 |
| 10166 | 2003-10-21 | 2003-10-30 | 2003-10-27 | Shipped | NULL | 462 |
| 10167 | 2003-10-23 | 2003-10-30 | NULL | Cancelled | Customer called to cancel. The warehouse was notified in time and the order didn't ship. They have a new VP of Sales and are shifting their sales model. Our VP of Sales should contact them. | 448 |
| 10168 | 2003-10-28 | 2003-11-03 | 2003-11-01 | Shipped | NULL | 161 |
| 10169 | 2003-11-04 | 2003-11-14 | 2003-11-09 | Shipped | NULL | 276 |
| 10170 | 2003-11-04 | 2003-11-12 | 2003-11-07 | Shipped | NULL | 452 |
| 10171 | 2003-11-05 | 2003-11-13 | 2003-11-07 | Shipped | NULL | 233 |
| 10172 | 2003-11-05 | 2003-11-14 | 2003-11-11 | Shipped | NULL | 175 |
| 10173 | 2003-11-05 | 2003-11-15 | 2003-11-09 | Shipped | Cautious optimism. We have happy customers here, if we can keep them well stocked. I need all the information I can get on the planned shippments of Porches | 278 |
| 10174 | 2003-11-06 | 2003-11-15 | 2003-11-10 | Shipped | NULL | 333 |
| 10175 | 2003-11-06 | 2003-11-14 | 2003-11-09 | Shipped | NULL | 324 |
| 10176 | 2003-11-06 | 2003-11-15 | 2003-11-12 | Shipped | NULL | 386 |
| 10177 | 2003-11-07 | 2003-11-17 | 2003-11-12 | Shipped | NULL | 344 |
| 10178 | 2003-11-08 | 2003-11-16 | 2003-11-10 | Shipped | Custom shipping instructions sent to warehouse | 242 |
| 10179 | 2003-11-11 | 2003-11-17 | 2003-11-13 | Cancelled | Customer cancelled due to urgent budgeting issues. Must be cautious when dealing with them in the future. Since order shipped already we must discuss who would cover the shipping charges. | 496 |
| 10180 | 2003-11-11 | 2003-11-19 | 2003-11-14 | Shipped | NULL | 171 |
| 10181 | 2003-11-12 | 2003-11-19 | 2003-11-15 | Shipped | NULL | 167 |
| 10182 | 2003-11-12 | 2003-11-21 | 2003-11-18 | Shipped | NULL | 124 |
| 10183 | 2003-11-13 | 2003-11-22 | 2003-11-15 | Shipped | We need to keep in close contact with their Marketing VP. He is the decision maker for all their purchases. | 339 |
| 10184 | 2003-11-14 | 2003-11-22 | 2003-11-20 | Shipped | NULL | 484 |
| 10185 | 2003-11-14 | 2003-11-21 | 2003-11-20 | Shipped | NULL | 320 |
| 10186 | 2003-11-14 | 2003-11-20 | 2003-11-18 | Shipped | They want to reevaluate their terms agreement with the VP of Sales | 489 |
| 10187 | 2003-11-15 | 2003-11-24 | 2003-11-16 | Shipped | NULL | 211 |
| 10188 | 2003-11-18 | 2003-11-26 | 2003-11-24 | Shipped | NULL | 167 |
| 10189 | 2003-11-18 | 2003-11-25 | 2003-11-24 | Shipped | They want to reevaluate their terms agreement with Finance. | 205 |
| 10190 | 2003-11-19 | 2003-11-29 | 2003-11-20 | Shipped | NULL | 141 |
| 10191 | 2003-11-20 | 2003-11-30 | 2003-11-24 | Shipped | We must be cautions with this customer. Their VP of Sales resigned. Company may be heading down. | 259 |
| 10192 | 2003-11-20 | 2003-11-29 | 2003-11-25 | Shipped | NULL | 363 |
| 10193 | 2003-11-21 | 2003-11-28 | 2003-11-27 | Shipped | NULL | 471 |
| 10194 | 2003-11-25 | 2003-12-02 | 2003-11-26 | Shipped | NULL | 146 |
| 10195 | 2003-11-25 | 2003-12-01 | 2003-11-28 | Shipped | NULL | 319 |
| 10196 | 2003-11-26 | 2003-12-03 | 2003-12-01 | Shipped | NULL | 455 |
| 10197 | 2003-11-26 | 2003-12-02 | 2003-12-01 | Shipped | Customer inquired about remote controlled models and gold models. | 216 |
| 10198 | 2003-11-27 | 2003-12-06 | 2003-12-03 | Shipped | NULL | 385 |
| 10199 | 2003-12-01 | 2003-12-10 | 2003-12-06 | Shipped | NULL | 475 |
| 10200 | 2003-12-01 | 2003-12-09 | 2003-12-06 | Shipped | NULL | 211 |
| 10201 | 2003-12-01 | 2003-12-11 | 2003-12-02 | Shipped | NULL | 129 |
| 10202 | 2003-12-02 | 2003-12-09 | 2003-12-06 | Shipped | NULL | 357 |
| 10203 | 2003-12-02 | 2003-12-11 | 2003-12-07 | Shipped | NULL | 141 |
| 10204 | 2003-12-02 | 2003-12-10 | 2003-12-04 | Shipped | NULL | 151 |
| 10205 | 2003-12-03 | 2003-12-09 | 2003-12-07 | Shipped | I need all the information I can get on our competitors. | 141 |
| 10206 | 2003-12-05 | 2003-12-13 | 2003-12-08 | Shipped | Can we renegotiate this one? | 202 |
| 10207 | 2003-12-09 | 2003-12-17 | 2003-12-11 | Shipped | Check on availability. | 495 |
| 10208 | 2004-01-02 | 2004-01-11 | 2004-01-04 | Shipped | NULL | 146 |
| 10209 | 2004-01-09 | 2004-01-15 | 2004-01-12 | Shipped | NULL | 347 |
| 10210 | 2004-01-12 | 2004-01-22 | 2004-01-20 | Shipped | NULL | 177 |
| 10211 | 2004-01-15 | 2004-01-25 | 2004-01-18 | Shipped | NULL | 406 |
| 10212 | 2004-01-16 | 2004-01-24 | 2004-01-18 | Shipped | NULL | 141 |
| 10213 | 2004-01-22 | 2004-01-28 | 2004-01-27 | Shipped | Difficult to negotiate with customer. We need more marketing materials | 489 |
| 10214 | 2004-01-26 | 2004-02-04 | 2004-01-29 | Shipped | NULL | 458 |
| 10215 | 2004-01-29 | 2004-02-08 | 2004-02-01 | Shipped | Customer requested that FedEx Ground is used for this shipping | 475 |
| 10216 | 2004-02-02 | 2004-02-10 | 2004-02-04 | Shipped | NULL | 256 |
| 10217 | 2004-02-04 | 2004-02-14 | 2004-02-06 | Shipped | NULL | 166 |
| 10218 | 2004-02-09 | 2004-02-16 | 2004-02-11 | Shipped | Customer requested that ad materials (such as posters, pamphlets) be included in the shippment | 473 |
| 10219 | 2004-02-10 | 2004-02-17 | 2004-02-12 | Shipped | NULL | 487 |
| 10220 | 2004-02-12 | 2004-02-19 | 2004-02-16 | Shipped | NULL | 189 |
| 10221 | 2004-02-18 | 2004-02-26 | 2004-02-19 | Shipped | NULL | 314 |
| 10222 | 2004-02-19 | 2004-02-27 | 2004-02-20 | Shipped | NULL | 239 |
| 10223 | 2004-02-20 | 2004-02-29 | 2004-02-24 | Shipped | NULL | 114 |
| 10224 | 2004-02-21 | 2004-03-02 | 2004-02-26 | Shipped | Customer has worked with some of our vendors in the past and is aware of their MSRP | 171 |
| 10225 | 2004-02-22 | 2004-03-01 | 2004-02-24 | Shipped | NULL | 298 |
| 10226 | 2004-02-26 | 2004-03-06 | 2004-03-02 | Shipped | NULL | 239 |
| 10227 | 2004-03-02 | 2004-03-12 | 2004-03-08 | Shipped | NULL | 146 |
| 10228 | 2004-03-10 | 2004-03-18 | 2004-03-13 | Shipped | NULL | 173 |
| 10229 | 2004-03-11 | 2004-03-20 | 2004-03-12 | Shipped | NULL | 124 |
| 10230 | 2004-03-15 | 2004-03-24 | 2004-03-20 | Shipped | Customer very concerned about the exact color of the models. There is high risk that he may dispute the order because there is a slight color mismatch | 128 |
| 10231 | 2004-03-19 | 2004-03-26 | 2004-03-25 | Shipped | NULL | 344 |
| 10232 | 2004-03-20 | 2004-03-30 | 2004-03-25 | Shipped | NULL | 240 |
| 10233 | 2004-03-29 | 2004-04-04 | 2004-04-02 | Shipped | Customer requested special shippment. The instructions were passed along to the warehouse | 328 |
| 10234 | 2004-03-30 | 2004-04-05 | 2004-04-02 | Shipped | NULL | 412 |
| 10235 | 2004-04-02 | 2004-04-12 | 2004-04-06 | Shipped | NULL | 260 |
| 10236 | 2004-04-03 | 2004-04-11 | 2004-04-08 | Shipped | NULL | 486 |
| 10237 | 2004-04-05 | 2004-04-12 | 2004-04-10 | Shipped | NULL | 181 |
| 10238 | 2004-04-09 | 2004-04-16 | 2004-04-10 | Shipped | NULL | 145 |
| 10239 | 2004-04-12 | 2004-04-21 | 2004-04-17 | Shipped | NULL | 311 |
| 10240 | 2004-04-13 | 2004-04-20 | 2004-04-20 | Shipped | NULL | 177 |
| 10241 | 2004-04-13 | 2004-04-20 | 2004-04-19 | Shipped | NULL | 209 |
| 10242 | 2004-04-20 | 2004-04-28 | 2004-04-25 | Shipped | Customer is interested in buying more Ferrari models | 456 |
| 10243 | 2004-04-26 | 2004-05-03 | 2004-04-28 | Shipped | NULL | 495 |
| 10244 | 2004-04-29 | 2004-05-09 | 2004-05-04 | Shipped | NULL | 141 |
| 10245 | 2004-05-04 | 2004-05-12 | 2004-05-09 | Shipped | NULL | 455 |
| 10246 | 2004-05-05 | 2004-05-13 | 2004-05-06 | Shipped | NULL | 141 |
| 10247 | 2004-05-05 | 2004-05-11 | 2004-05-08 | Shipped | NULL | 334 |
| 10248 | 2004-05-07 | 2004-05-14 | NULL | Cancelled | Order was mistakenly placed. The warehouse noticed the lack of documentation. | 131 |
| 10249 | 2004-05-08 | 2004-05-17 | 2004-05-11 | Shipped | Can we deliver the new Ford Mustang models by end-of-quarter? | 173 |
| 10250 | 2004-05-11 | 2004-05-19 | 2004-05-15 | Shipped | NULL | 450 |
| 10251 | 2004-05-18 | 2004-05-24 | 2004-05-24 | Shipped | NULL | 328 |
| 10252 | 2004-05-26 | 2004-06-04 | 2004-05-29 | Shipped | NULL | 406 |
| 10253 | 2004-06-01 | 2004-06-09 | 2004-06-02 | Cancelled | Customer disputed the order and we agreed to cancel it. We must be more cautions with this customer going forward, since they are very hard to please. We must cover the shipping fees. | 201 |
| 10254 | 2004-06-03 | 2004-06-13 | 2004-06-04 | Shipped | Customer requested that DHL is used for this shipping | 323 |
| 10255 | 2004-06-04 | 2004-06-12 | 2004-06-09 | Shipped | NULL | 209 |
| 10256 | 2004-06-08 | 2004-06-16 | 2004-06-10 | Shipped | NULL | 145 |
| 10257 | 2004-06-14 | 2004-06-24 | 2004-06-15 | Shipped | NULL | 450 |
| 10258 | 2004-06-15 | 2004-06-25 | 2004-06-23 | Shipped | NULL | 398 |
| 10259 | 2004-06-15 | 2004-06-22 | 2004-06-17 | Shipped | NULL | 166 |
| 10260 | 2004-06-16 | 2004-06-22 | NULL | Cancelled | Customer heard complaints from their customers and called to cancel this order. Will notify the Sales Manager. | 357 |
| 10261 | 2004-06-17 | 2004-06-25 | 2004-06-22 | Shipped | NULL | 233 |
| 10262 | 2004-06-24 | 2004-07-01 | NULL | Cancelled | This customer found a better offer from one of our competitors. Will call back to renegotiate. | 141 |
| 10263 | 2004-06-28 | 2004-07-04 | 2004-07-02 | Shipped | NULL | 175 |
| 10264 | 2004-06-30 | 2004-07-06 | 2004-07-01 | Shipped | Customer will send a truck to our local warehouse on 7/1/2004 | 362 |
| 10265 | 2004-07-02 | 2004-07-09 | 2004-07-07 | Shipped | NULL | 471 |
| 10266 | 2004-07-06 | 2004-07-14 | 2004-07-10 | Shipped | NULL | 386 |
| 10267 | 2004-07-07 | 2004-07-17 | 2004-07-09 | Shipped | NULL | 151 |
| 10268 | 2004-07-12 | 2004-07-18 | 2004-07-14 | Shipped | NULL | 412 |
| 10269 | 2004-07-16 | 2004-07-22 | 2004-07-18 | Shipped | NULL | 382 |
| 10270 | 2004-07-19 | 2004-07-27 | 2004-07-24 | Shipped | Can we renegotiate this one? | 282 |
| 10271 | 2004-07-20 | 2004-07-29 | 2004-07-23 | Shipped | NULL | 124 |
| 10272 | 2004-07-20 | 2004-07-26 | 2004-07-22 | Shipped | NULL | 157 |
| 10273 | 2004-07-21 | 2004-07-28 | 2004-07-22 | Shipped | NULL | 314 |
| 10274 | 2004-07-21 | 2004-07-29 | 2004-07-22 | Shipped | NULL | 379 |
| 10275 | 2004-07-23 | 2004-08-02 | 2004-07-29 | Shipped | NULL | 119 |
| 10276 | 2004-08-02 | 2004-08-11 | 2004-08-08 | Shipped | NULL | 204 |
| 10277 | 2004-08-04 | 2004-08-12 | 2004-08-05 | Shipped | NULL | 148 |
| 10278 | 2004-08-06 | 2004-08-16 | 2004-08-09 | Shipped | NULL | 112 |
| 10279 | 2004-08-09 | 2004-08-19 | 2004-08-15 | Shipped | Cautious optimism. We have happy customers here, if we can keep them well stocked. I need all the information I can get on the planned shippments of Porches | 141 |
| 10280 | 2004-08-17 | 2004-08-27 | 2004-08-19 | Shipped | NULL | 249 |
| 10281 | 2004-08-19 | 2004-08-28 | 2004-08-23 | Shipped | NULL | 157 |
| 10282 | 2004-08-20 | 2004-08-26 | 2004-08-22 | Shipped | NULL | 124 |
| 10283 | 2004-08-20 | 2004-08-30 | 2004-08-23 | Shipped | NULL | 260 |
| 10284 | 2004-08-21 | 2004-08-29 | 2004-08-26 | Shipped | Custom shipping instructions sent to warehouse | 299 |
| 10285 | 2004-08-27 | 2004-09-04 | 2004-08-31 | Shipped | NULL | 286 |
| 10286 | 2004-08-28 | 2004-09-06 | 2004-09-01 | Shipped | NULL | 172 |
| 10287 | 2004-08-30 | 2004-09-06 | 2004-09-01 | Shipped | NULL | 298 |
| 10288 | 2004-09-01 | 2004-09-11 | 2004-09-05 | Shipped | NULL | 166 |
| 10289 | 2004-09-03 | 2004-09-13 | 2004-09-04 | Shipped | We need to keep in close contact with their Marketing VP. He is the decision maker for all their purchases. | 167 |
| 10290 | 2004-09-07 | 2004-09-15 | 2004-09-13 | Shipped | NULL | 198 |
| 10291 | 2004-09-08 | 2004-09-17 | 2004-09-14 | Shipped | NULL | 448 |
| 10292 | 2004-09-08 | 2004-09-18 | 2004-09-11 | Shipped | They want to reevaluate their terms agreement with Finance. | 131 |
| 10293 | 2004-09-09 | 2004-09-18 | 2004-09-14 | Shipped | NULL | 249 |
| 10294 | 2004-09-10 | 2004-09-17 | 2004-09-14 | Shipped | NULL | 204 |
| 10295 | 2004-09-10 | 2004-09-17 | 2004-09-14 | Shipped | They want to reevaluate their terms agreement with Finance. | 362 |
| 10296 | 2004-09-15 | 2004-09-22 | 2004-09-16 | Shipped | NULL | 415 |
| 10297 | 2004-09-16 | 2004-09-22 | 2004-09-21 | Shipped | We must be cautions with this customer. Their VP of Sales resigned. Company may be heading down. | 189 |
| 10298 | 2004-09-27 | 2004-10-05 | 2004-10-01 | Shipped | NULL | 103 |
| 10299 | 2004-09-30 | 2004-10-10 | 2004-10-01 | Shipped | NULL | 186 |
| 10300 | 2003-10-04 | 2003-10-13 | 2003-10-09 | Shipped | NULL | 128 |
| 10301 | 2003-10-05 | 2003-10-15 | 2003-10-08 | Shipped | NULL | 299 |
| 10302 | 2003-10-06 | 2003-10-16 | 2003-10-07 | Shipped | NULL | 201 |
| 10303 | 2004-10-06 | 2004-10-14 | 2004-10-09 | Shipped | Customer inquired about remote controlled models and gold models. | 484 |
| 10304 | 2004-10-11 | 2004-10-20 | 2004-10-17 | Shipped | NULL | 256 |
| 10305 | 2004-10-13 | 2004-10-22 | 2004-10-15 | Shipped | Check on availability. | 286 |
| 10306 | 2004-10-14 | 2004-10-21 | 2004-10-17 | Shipped | NULL | 187 |
| 10307 | 2004-10-14 | 2004-10-23 | 2004-10-20 | Shipped | NULL | 339 |
| 10308 | 2004-10-15 | 2004-10-24 | 2004-10-20 | Shipped | Customer requested that FedEx Ground is used for this shipping | 319 |
| 10309 | 2004-10-15 | 2004-10-24 | 2004-10-18 | Shipped | NULL | 121 |
| 10310 | 2004-10-16 | 2004-10-24 | 2004-10-18 | Shipped | NULL | 259 |
| 10311 | 2004-10-16 | 2004-10-23 | 2004-10-20 | Shipped | Difficult to negotiate with customer. We need more marketing materials | 141 |
| 10312 | 2004-10-21 | 2004-10-27 | 2004-10-23 | Shipped | NULL | 124 |
| 10313 | 2004-10-22 | 2004-10-28 | 2004-10-25 | Shipped | Customer requested that FedEx Ground is used for this shipping | 202 |
| 10314 | 2004-10-22 | 2004-11-01 | 2004-10-23 | Shipped | NULL | 227 |
| 10315 | 2004-10-29 | 2004-11-08 | 2004-10-30 | Shipped | NULL | 119 |
| 10316 | 2004-11-01 | 2004-11-09 | 2004-11-07 | Shipped | Customer requested that ad materials (such as posters, pamphlets) be included in the shippment | 240 |
| 10317 | 2004-11-02 | 2004-11-12 | 2004-11-08 | Shipped | NULL | 161 |
| 10318 | 2004-11-02 | 2004-11-09 | 2004-11-07 | Shipped | NULL | 157 |
| 10319 | 2004-11-03 | 2004-11-11 | 2004-11-06 | Shipped | Customer requested that DHL is used for this shipping | 456 |
| 10320 | 2004-11-03 | 2004-11-13 | 2004-11-07 | Shipped | NULL | 144 |
| 10321 | 2004-11-04 | 2004-11-12 | 2004-11-07 | Shipped | NULL | 462 |
| 10322 | 2004-11-04 | 2004-11-12 | 2004-11-10 | Shipped | Customer has worked with some of our vendors in the past and is aware of their MSRP | 363 |
| 10323 | 2004-11-05 | 2004-11-12 | 2004-11-09 | Shipped | NULL | 128 |
| 10324 | 2004-11-05 | 2004-11-11 | 2004-11-08 | Shipped | NULL | 181 |
| 10325 | 2004-11-05 | 2004-11-13 | 2004-11-08 | Shipped | NULL | 121 |
| 10326 | 2004-11-09 | 2004-11-16 | 2004-11-10 | Shipped | NULL | 144 |
| 10327 | 2004-11-10 | 2004-11-19 | 2004-11-13 | Resolved | Order was disputed and resolved on 12/1/04. The Sales Manager was involved. Customer claims the scales of the models don't match what was discussed. | 145 |
| 10328 | 2004-11-12 | 2004-11-21 | 2004-11-18 | Shipped | Customer very concerned about the exact color of the models. There is high risk that he may dispute the order because there is a slight color mismatch | 278 |
| 10329 | 2004-11-15 | 2004-11-24 | 2004-11-16 | Shipped | NULL | 131 |
| 10330 | 2004-11-16 | 2004-11-25 | 2004-11-21 | Shipped | NULL | 385 |
| 10331 | 2004-11-17 | 2004-11-23 | 2004-11-23 | Shipped | Customer requested special shippment. The instructions were passed along to the warehouse | 486 |
| 10332 | 2004-11-17 | 2004-11-25 | 2004-11-18 | Shipped | NULL | 187 |
| 10333 | 2004-11-18 | 2004-11-27 | 2004-11-20 | Shipped | NULL | 129 |
| 10334 | 2004-11-19 | 2004-11-28 | NULL | On Hold | The outstaniding balance for this customer exceeds their credit limit. Order will be shipped when a payment is received. | 144 |
| 10335 | 2004-11-19 | 2004-11-29 | 2004-11-23 | Shipped | NULL | 124 |
| 10336 | 2004-11-20 | 2004-11-26 | 2004-11-24 | Shipped | Customer requested that DHL is used for this shipping | 172 |
| 10337 | 2004-11-21 | 2004-11-30 | 2004-11-26 | Shipped | NULL | 424 |
| 10338 | 2004-11-22 | 2004-12-02 | 2004-11-27 | Shipped | NULL | 381 |
| 10339 | 2004-11-23 | 2004-11-30 | 2004-11-30 | Shipped | NULL | 398 |
| 10340 | 2004-11-24 | 2004-12-01 | 2004-11-25 | Shipped | Customer is interested in buying more Ferrari models | 216 |
| 10341 | 2004-11-24 | 2004-12-01 | 2004-11-29 | Shipped | NULL | 382 |
| 10342 | 2004-11-24 | 2004-12-01 | 2004-11-29 | Shipped | NULL | 114 |
| 10343 | 2004-11-24 | 2004-12-01 | 2004-11-26 | Shipped | NULL | 353 |
| 10344 | 2004-11-25 | 2004-12-02 | 2004-11-29 | Shipped | NULL | 350 |
| 10345 | 2004-11-25 | 2004-12-01 | 2004-11-26 | Shipped | NULL | 103 |
| 10346 | 2004-11-29 | 2004-12-05 | 2004-11-30 | Shipped | NULL | 112 |
| 10347 | 2004-11-29 | 2004-12-07 | 2004-11-30 | Shipped | Can we deliver the new Ford Mustang models by end-of-quarter? | 114 |
| 10348 | 2004-11-01 | 2004-11-08 | 2004-11-05 | Shipped | NULL | 458 |
| 10349 | 2004-12-01 | 2004-12-07 | 2004-12-03 | Shipped | NULL | 151 |
| 10350 | 2004-12-02 | 2004-12-08 | 2004-12-05 | Shipped | NULL | 141 |
| 10351 | 2004-12-03 | 2004-12-11 | 2004-12-07 | Shipped | NULL | 324 |
| 10352 | 2004-12-03 | 2004-12-12 | 2004-12-09 | Shipped | NULL | 198 |
| 10353 | 2004-12-04 | 2004-12-11 | 2004-12-05 | Shipped | NULL | 447 |
| 10354 | 2004-12-04 | 2004-12-10 | 2004-12-05 | Shipped | NULL | 323 |
| 10355 | 2004-12-07 | 2004-12-14 | 2004-12-13 | Shipped | NULL | 141 |
| 10356 | 2004-12-09 | 2004-12-15 | 2004-12-12 | Shipped | NULL | 250 |
| 10357 | 2004-12-10 | 2004-12-16 | 2004-12-14 | Shipped | NULL | 124 |
| 10358 | 2004-12-10 | 2004-12-16 | 2004-12-16 | Shipped | Customer requested that DHL is used for this shipping | 141 |
| 10359 | 2004-12-15 | 2004-12-23 | 2004-12-18 | Shipped | NULL | 353 |
| 10360 | 2004-12-16 | 2004-12-22 | 2004-12-18 | Shipped | NULL | 496 |
| 10361 | 2004-12-17 | 2004-12-24 | 2004-12-20 | Shipped | NULL | 282 |
| 10362 | 2005-01-05 | 2005-01-16 | 2005-01-10 | Shipped | NULL | 161 |
| 10363 | 2005-01-06 | 2005-01-12 | 2005-01-10 | Shipped | NULL | 334 |
| 10364 | 2005-01-06 | 2005-01-17 | 2005-01-09 | Shipped | NULL | 350 |
| 10365 | 2005-01-07 | 2005-01-18 | 2005-01-11 | Shipped | NULL | 320 |
| 10366 | 2005-01-10 | 2005-01-19 | 2005-01-12 | Shipped | NULL | 381 |
| 10367 | 2005-01-12 | 2005-01-21 | 2005-01-16 | Resolved | This order was disputed and resolved on 2/1/2005. Customer claimed that container with shipment was damaged. FedEx's investigation proved this wrong. | 205 |
| 10368 | 2005-01-19 | 2005-01-27 | 2005-01-24 | Shipped | Can we renegotiate this one? | 124 |
| 10369 | 2005-01-20 | 2005-01-28 | 2005-01-24 | Shipped | NULL | 379 |
| 10370 | 2005-01-20 | 2005-02-01 | 2005-01-25 | Shipped | NULL | 276 |
| 10371 | 2005-01-23 | 2005-02-03 | 2005-01-25 | Shipped | NULL | 124 |
| 10372 | 2005-01-26 | 2005-02-05 | 2005-01-28 | Shipped | NULL | 398 |
| 10373 | 2005-01-31 | 2005-02-08 | 2005-02-06 | Shipped | NULL | 311 |
| 10374 | 2005-02-02 | 2005-02-09 | 2005-02-03 | Shipped | NULL | 333 |
| 10375 | 2005-02-03 | 2005-02-10 | 2005-02-06 | Shipped | NULL | 119 |
| 10376 | 2005-02-08 | 2005-02-18 | 2005-02-13 | Shipped | NULL | 219 |
| 10377 | 2005-02-09 | 2005-02-21 | 2005-02-12 | Shipped | Cautious optimism. We have happy customers here, if we can keep them well stocked. I need all the information I can get on the planned shippments of Porches | 186 |
| 10378 | 2005-02-10 | 2005-02-18 | 2005-02-11 | Shipped | NULL | 141 |
| 10379 | 2005-02-10 | 2005-02-18 | 2005-02-11 | Shipped | NULL | 141 |
| 10380 | 2005-02-16 | 2005-02-24 | 2005-02-18 | Shipped | NULL | 141 |
| 10381 | 2005-02-17 | 2005-02-25 | 2005-02-18 | Shipped | NULL | 321 |
| 10382 | 2005-02-17 | 2005-02-23 | 2005-02-18 | Shipped | Custom shipping instructions sent to warehouse | 124 |
| 10383 | 2005-02-22 | 2005-03-02 | 2005-02-25 | Shipped | NULL | 141 |
| 10384 | 2005-02-23 | 2005-03-06 | 2005-02-27 | Shipped | NULL | 321 |
| 10385 | 2005-02-28 | 2005-03-09 | 2005-03-01 | Shipped | NULL | 124 |
| 10386 | 2005-03-01 | 2005-03-09 | 2005-03-06 | Resolved | Disputed then Resolved on 3/15/2005. Customer doesn't like the craftsmaship of the models. | 141 |
| 10387 | 2005-03-02 | 2005-03-09 | 2005-03-06 | Shipped | We need to keep in close contact with their Marketing VP. He is the decision maker for all their purchases. | 148 |
| 10388 | 2005-03-03 | 2005-03-11 | 2005-03-09 | Shipped | NULL | 462 |
| 10389 | 2005-03-03 | 2005-03-09 | 2005-03-08 | Shipped | NULL | 448 |
| 10390 | 2005-03-04 | 2005-03-11 | 2005-03-07 | Shipped | They want to reevaluate their terms agreement with Finance. | 124 |
| 10391 | 2005-03-09 | 2005-03-20 | 2005-03-15 | Shipped | NULL | 276 |
| 10392 | 2005-03-10 | 2005-03-18 | 2005-03-12 | Shipped | NULL | 452 |
| 10393 | 2005-03-11 | 2005-03-22 | 2005-03-14 | Shipped | They want to reevaluate their terms agreement with Finance. | 323 |
| 10394 | 2005-03-15 | 2005-03-25 | 2005-03-19 | Shipped | NULL | 141 |
| 10395 | 2005-03-17 | 2005-03-24 | 2005-03-23 | Shipped | We must be cautions with this customer. Their VP of Sales resigned. Company may be heading down. | 250 |
| 10396 | 2005-03-23 | 2005-04-02 | 2005-03-28 | Shipped | NULL | 124 |
| 10397 | 2005-03-28 | 2005-04-09 | 2005-04-01 | Shipped | NULL | 242 |
| 10398 | 2005-03-30 | 2005-04-09 | 2005-03-31 | Shipped | NULL | 353 |
| 10399 | 2005-04-01 | 2005-04-12 | 2005-04-03 | Shipped | NULL | 496 |
| 10400 | 2005-04-01 | 2005-04-11 | 2005-04-04 | Shipped | Customer requested that DHL is used for this shipping | 450 |
| 10401 | 2005-04-03 | 2005-04-14 | NULL | On Hold | Customer credit limit exceeded. Will ship when a payment is received. | 328 |
| 10402 | 2005-04-07 | 2005-04-14 | 2005-04-12 | Shipped | NULL | 406 |
| 10403 | 2005-04-08 | 2005-04-18 | 2005-04-11 | Shipped | NULL | 201 |
| 10404 | 2005-04-08 | 2005-04-14 | 2005-04-11 | Shipped | NULL | 323 |
| 10405 | 2005-04-14 | 2005-04-24 | 2005-04-20 | Shipped | NULL | 209 |
| 10406 | 2005-04-15 | 2005-04-25 | 2005-04-21 | Disputed | Customer claims container with shipment was damaged during shipping and some items were missing. I am talking to FedEx about this. | 145 |
| 10407 | 2005-04-22 | 2005-05-04 | NULL | On Hold | Customer credit limit exceeded. Will ship when a payment is received. | 450 |
| 10408 | 2005-04-22 | 2005-04-29 | 2005-04-27 | Shipped | NULL | 398 |
| 10409 | 2005-04-23 | 2005-05-05 | 2005-04-24 | Shipped | NULL | 166 |
| 10410 | 2005-04-29 | 2005-05-10 | 2005-04-30 | Shipped | NULL | 357 |
| 10411 | 2005-05-01 | 2005-05-08 | 2005-05-06 | Shipped | NULL | 233 |
| 10412 | 2005-05-03 | 2005-05-13 | 2005-05-05 | Shipped | NULL | 141 |
| 10413 | 2005-05-05 | 2005-05-14 | 2005-05-09 | Shipped | Customer requested that DHL is used for this shipping | 175 |
| 10414 | 2005-05-06 | 2005-05-13 | NULL | On Hold | Customer credit limit exceeded. Will ship when a payment is received. | 362 |
| 10415 | 2005-05-09 | 2005-05-20 | 2005-05-12 | Disputed | Customer claims the scales of the models don't match what was discussed. I keep all the paperwork though to prove otherwise | 471 |
| 10416 | 2005-05-10 | 2005-05-16 | 2005-05-14 | Shipped | NULL | 386 |
| 10417 | 2005-05-13 | 2005-05-19 | 2005-05-19 | Disputed | Customer doesn't like the colors and precision of the models. | 141 |
| 10418 | 2005-05-16 | 2005-05-24 | 2005-05-20 | Shipped | NULL | 412 |
| 10419 | 2005-05-17 | 2005-05-28 | 2005-05-19 | Shipped | NULL | 382 |
| 10420 | 2005-05-29 | 2005-06-07 | NULL | In Process | NULL | 282 |
| 10421 | 2005-05-29 | 2005-06-06 | NULL | In Process | Custom shipping instructions were sent to warehouse | 124 |
| 10422 | 2005-05-30 | 2005-06-11 | NULL | In Process | NULL | 157 |
| 10423 | 2005-05-30 | 2005-06-05 | NULL | In Process | NULL | 314 |
| 10424 | 2005-05-31 | 2005-06-08 | NULL | In Process | NULL | 141 |
| 10425 | 2005-05-31 | 2005-06-07 | NULL | In Process | NULL | 119 |
+-------------+------------+--------------+-------------+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+
326 rows in set (0.00 sec)
mysql> call vlrtraining3();
ERROR 1305 (42000): PROCEDURE ram.vlrtraining3 does not exist
mysql> call vlrtraining2();
ERROR 1305 (42000): PROCEDURE ram.vlrtraining2 does not exist
mysql> call vlrtraining4();
+-----------------------------+
| Please subcribe our channel |
+-----------------------------+
| Please subcribe our channel |
+-----------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.05 sec)
mysql> 80 what is stored procedure and how to create stored procedure sql videos in telugu
No comments:
Post a Comment
Note: only a member of this blog may post a comment.