[SQL Codes] Usefull Codes for Ep2!

[xNiceEinz]

Edited again!

 

Added:

 

 

INSERT INTO `t_lcball` (`a_item_order`, `a_tocken_index`, `a_course_code`, `a_order`, `a_item_index`, `a_item_count`, `a_item_max`, `a_item_remain`) VALUES

(1, 5124, 0, 0, 1416, 10, 1, 1),

(1, 5124, 0, 1, 2357, 5, 100, 97),

(1, 5124, 0, 2, 2356, 5, 200, 198),

(1, 5124, 0, 3, 2394, 1, 300, 293),

(1, 5124, 0, 4, 972, 1, 700, 683),

(1, 5124, 1, 0, 2844, 10, 1, 1),

(1, 5124, 1, 1, 2395, 5, 10, 10),

(1, 5124, 1, 2, 2845, 2, 20, 19),

(1, 5124, 1, 3, 2853, 1, 50, 50),

(1, 5124, 1, 4, 1284, 3, 500, 493),

(1, 5124, 2, 0, 6421, 1, 5, 5),

(1, 5124, 2, 1, 6227, 3, 100, 98),

(1, 5124, 2, 2, 2453, 2, 300, 298),

(1, 5124, 2, 3, 852, 10, 500, 500),

(1, 5124, 2, 4, 2858, 1, 700, 696),

(2, 6653, 0, 0, 5293, 1, 1, 1),

(2, 6653, 0, 1, 5292, 1, 5, 5),

(2, 6653, 0, 2, 5291, 1, 10, 10),

(2, 6653, 0, 3, 5290, 1, 300, 300),

(2, 6653, 0, 4, 5289, 1, 3000, 3000),

(2, 6653, 1, 0, 5268, 1, 1, 1),

(2, 6653, 1, 1, 5267, 1, 5, 5),

(2, 6653, 1, 2, 5266, 1, 10, 10),

(2, 6653, 1, 3, 5265, 1, 300, 300),

(2, 6653, 1, 4, 5264, 1, 3000, 3000),

(2, 6653, 2, 0, 5298, 1, 1, 1),

(2, 6653, 2, 1, 5297, 1, 5, 5),

(2, 6653, 2, 2, 5296, 1, 10, 10),

(2, 6653, 2, 3, 5295, 1, 300, 300),

(2, 6653, 2, 4, 5294, 1, 3000, 3000),

(0, 5123, 0, 0, 5124, 15, 3, 3),

(0, 5123, 0, 1, 6921, 3, 10, 10),

(0, 5123, 0, 2, 882, 15, 30, 30),

(0, 5123, 0, 3, 85, 5, 50, 48),

(0, 5123, 0, 4, 19, 50000, 500, 497),

(0, 5123, 1, 0, 1416, 3, 1, 1),

(0, 5123, 1, 1, 2889, 3, 100, 94),

(0, 5123, 1, 2, 883, 5, 350, 347),

(0, 5123, 1, 3, 85, 5, 500, 492),

(0, 5123, 1, 4, 723, 5, 1000, 978),

(0, 5123, 2, 0, 974, 5, 1, 1),

(0, 5123, 2, 1, 2888, 3, 100, 99),

(0, 5123, 2, 2, 882, 5, 300, 297),

(0, 5123, 2, 3, 85, 5, 500, 496),

(0, 5123, 2, 4, 724, 10, 1000, 990),

(3, 6939, 0, 0, 5124, 15, 1, 1),

(3, 6939, 0, 1, 2848, 10, 50, 50),

(3, 6939, 0, 2, 1419, 6, 100, 100),

(3, 6939, 0, 3, 1299, 1, 400, 399),

(3, 6939, 0, 4, 19, 500000, 1000, 996),

(3, 6939, 1, 0, 2968, 3, 1, 1),

(3, 6939, 1, 1, 4923, 1, 50, 49),

(3, 6939, 1, 2, 4924, 1, 50, 49),

(3, 6939, 1, 3, 5124, 1, 500, 488),

(3, 6939, 1, 4, 5123, 2, 1000, 971),

(3, 6939, 2, 0, 19, 5000000, 1, 1),

(3, 6939, 2, 1, 19, 500000, 1000, 1000),

(3, 6939, 2, 2, 19, 250000, 2000, 2000),

(3, 6939, 2, 3, 19, 100000, 3000, 3000),

(3, 6939, 2, 4, 19, 50000, 5000, 4999);