-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathadd_to_carreg.sql
11 lines (10 loc) · 1.57 KB
/
add_to_carreg.sql
1
2
3
4
5
6
7
8
9
10
use localtest;
INSERT CAR_REGISTER_TEST values
('2018-09-22 00:15:00', 'CAR00002', '2018-09-22 00:00:00', 'chundiandong', 'lidianchi', 'zhiliudianji', 200, 2000, 300, 1, 'qianzhimoshi', 'yeleng', 200, 120, 1, '{test:test}', '', '', '', ''),
('2018-09-22 00:15:00', 'CAR00003', '2018-09-22 00:00:00', 'chundiandong', 'lidianchi', 'zhiliudianji', 200, 2000, 545, 1, 'qianzhimoshi', 'yeleng', 200, 120, 1, '{test:test}', '', '', '', ''),
('2018-09-22 00:15:00', 'CAR00005', '2018-09-22 00:00:00', 'chundiandong', 'lidianchi', 'zhiliudianji', 200, 2000, 300, 1, 'qianzhimoshi', 'yeleng', 200, 120, 1, '{test:test}', '', '', '', ''),
('2018-09-22 00:15:00', 'CAR00033', '2018-09-22 00:00:00', 'chundiandong', 'lidianchi', 'zhiliudianji', 200, 2000, 300, 1, 'qianzhimoshi', 'yeleng', 200, 120, 1, '{test:test}', '', '', '', ''),
('2018-09-22 00:15:00', 'CAR00042', '2018-09-22 00:00:00', 'chundiandong', 'lidianchi', 'zhiliudianji', 200, 3242, 300, 1, 'qianzhimoshi', 'yeleng', 200, 120, 1, '{test:test}', '', '', '', ''),
('2018-09-22 00:15:00', 'CAR00023', '2018-09-22 00:00:00', 'chundiandong', 'lidianchi', 'zhiliudianji', 134, 2000, 300, 1, 'qianzhimoshi', 'yeleng', 200, 120, 1, '{test:test}', '', '', '', ''),
('2018-09-22 00:15:00', 'CAR00015', '2018-09-22 00:00:00', 'chundiandong', 'lidianchi', 'zhiliudianji', 200, 2000, 300, 1, 'qianzhimoshi', 'yeleng', 200, 120, 1, '{test:test}', '', '', '', ''),
('2018-09-22 00:15:00', 'CAR00011', '2018-09-22 00:00:00', 'chundiandong', 'lidianchi', 'zhiliudianji', 200, 2000, 300, 1, 'qianzhimoshi', 'yeleng', 200, 120, 1, '{test:test}', '', '', '', '');