sql语句

于 2019-05-22 23:17:42 发布
阅读量142 收藏
点赞数
分类专栏： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43688691/article/details/89531828
版权 
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (231, '阿莫西林222', 10, '胶囊', 10, 11101, '2018-11-8', 2, '安徽');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (232, '阿莫西林22', 10, '胶囊', 10, 11101, '2018-11-8', 2, '安徽');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (233, '板蓝根', 50, '颗粒', 1, 11103, '2018-11-14', 1, '浙江');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (234, '小柴胡冲剂', 50, '颗粒', 5, 11104, '2018-11-17', 5, '浙江');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (235, '扑热息痛', 50, '颗粒', 1, 11105, '2018-11-14', 1, '上海');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (236, '去痛片', 2, '片状', 1, 11106, '2018-12-13', 1, '北京');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (237, '圣济感冒灵', 1, '颗粒', 1, 11107, '2018-11-13', 1, '上海');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (238, '硝基安定', 1, '片状', 1, 11108, '2018-11-13', 2, '北京');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (239, '清凉油', 1, '液态', 1, 11109, '2018-11-13', 1, '广州');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (240, '创可贴', 1, '贴条', 1, 11110, '2018-12-29', 1, '安徽');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (241, '烫伤药水', 50, '液态', 1, 11111, '2018-11-29', 1, '安徽');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (555, '阿司匹林', 100, '10ml', 10, 122352, '2020-10-9', 20, 'dao');
INSERT INTO `medical_info` (`medical_id`, `medical_name`, `medical_count`, `medicial_type`, `mdeical_price`, `batch_number`, `expiry_date`, `retail_price`, `man_facturer`) VALUES (556, '阿司匹林', 50, '20ml', 10, 10, '2010-10-19', 1, '1');

二

INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (1, 'PENELOPE', 'GUINESS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (2, 'NICK', 'WAHLBERG', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (3, 'ED', 'CHASE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (4, 'JENNIFER', 'DAVIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (5, 'JOHNNY', 'LOLLOBRIGIDA', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (6, 'BETTE', 'NICHOLSON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (7, 'GRACE', 'MOSTEL', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (8, 'MATTHEW', 'JOHANSSON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (9, 'JOE', 'SWANK', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (10, 'CHRISTIAN', 'GABLE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (11, 'ZERO', 'CAGE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (12, 'KARL', 'BERRY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (13, 'UMA', 'WOOD', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (14, 'VIVIEN', 'BERGEN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (15, 'CUBA', 'OLIVIER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (16, 'FRED', 'COSTNER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (17, 'HELEN', 'VOIGHT', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (18, 'DAN', 'TORN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (19, 'BOB', 'FAWCETT', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (20, 'LUCILLE', 'TRACY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (21, 'KIRSTEN', 'PALTROW', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (22, 'ELVIS', 'MARX', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (23, 'SANDRA', 'KILMER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (24, 'CAMERON', 'STREEP', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (25, 'KEVIN', 'BLOOM', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (26, 'RIP', 'CRAWFORD', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (27, 'JULIA', 'MCQUEEN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (28, 'WOODY', 'HOFFMAN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (29, 'ALEC', 'WAYNE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (30, 'SANDRA', 'PECK', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (31, 'SISSY', 'SOBIESKI', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (32, 'TIM', 'HACKMAN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (33, 'MILLA', 'PECK', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (34, 'AUDREY', 'OLIVIER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (35, 'JUDY', 'DEAN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (36, 'BURT', 'DUKAKIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (37, 'VAL', 'BOLGER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (38, 'TOM', 'MCKELLEN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (39, 'GOLDIE', 'BRODY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (40, 'JOHNNY', 'CAGE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (41, 'JODIE', 'DEGENERES', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (42, 'TOM', 'MIRANDA', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (43, 'KIRK', 'JOVOVICH', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (44, 'NICK', 'STALLONE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (45, 'REESE', 'KILMER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (46, 'PARKER', 'GOLDBERG', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (47, 'JULIA', 'BARRYMORE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (48, 'FRANCES', 'DAY-LEWIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (49, 'ANNE', 'CRONYN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (50, 'NATALIE', 'HOPKINS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (51, 'GARY', 'PHOENIX', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (52, 'CARMEN', 'HUNT', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (53, 'MENA', 'TEMPLE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (54, 'PENELOPE', 'PINKETT', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (55, 'FAY', 'KILMER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (56, 'DAN', 'HARRIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (57, 'JUDE', 'CRUISE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (58, 'CHRISTIAN', 'AKROYD', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (59, 'DUSTIN', 'TAUTOU', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (60, 'HENRY', 'BERRY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (61, 'CHRISTIAN', 'NEESON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (62, 'JAYNE', 'NEESON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (63, 'CAMERON', 'WRAY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (64, 'RAY', 'JOHANSSON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (65, 'ANGELA', 'HUDSON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (66, 'MARY', 'TANDY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (67, 'JESSICA', 'BAILEY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (68, 'RIP', 'WINSLET', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (69, 'KENNETH', 'PALTROW', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (70, 'MICHELLE', 'MCCONAUGHEY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (71, 'ADAM', 'GRANT', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (72, 'SEAN', 'WILLIAMS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (73, 'GARY', 'PENN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (74, 'MILLA', 'KEITEL', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (75, 'BURT', 'POSEY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (76, 'ANGELINA', 'ASTAIRE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (77, 'CARY', 'MCCONAUGHEY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (78, 'GROUCHO', 'SINATRA', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (79, 'MAE', 'HOFFMAN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (80, 'RALPH', 'CRUZ', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (81, 'SCARLETT', 'DAMON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (82, 'WOODY', 'JOLIE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (83, 'BEN', 'WILLIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (84, 'JAMES', 'PITT', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (85, 'MINNIE', 'ZELLWEGER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (86, 'GREG', 'CHAPLIN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (87, 'SPENCER', 'PECK', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (88, 'KENNETH', 'PESCI', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (89, 'CHARLIZE', 'DENCH', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (90, 'SEAN', 'GUINESS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (91, 'CHRISTOPHER', 'BERRY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (92, 'KIRSTEN', 'AKROYD', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (93, 'ELLEN', 'PRESLEY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (94, 'KENNETH', 'TORN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (95, 'DARYL', 'WAHLBERG', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (96, 'GENE', 'WILLIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (97, 'MEG', 'HAWKE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (98, 'CHRIS', 'BRIDGES', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (99, 'JIM', 'MOSTEL', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (100, 'SPENCER', 'DEPP', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (101, 'SUSAN', 'DAVIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (102, 'WALTER', 'TORN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (103, 'MATTHEW', 'LEIGH', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (104, 'PENELOPE', 'CRONYN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (105, 'SIDNEY', 'CROWE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (106, 'GROUCHO', 'DUNST', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (107, 'GINA', 'DEGENERES', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (108, 'WARREN', 'NOLTE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (109, 'SYLVESTER', 'DERN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (110, 'SUSAN', 'DAVIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (111, 'CAMERON', 'ZELLWEGER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (112, 'RUSSELL', 'BACALL', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (113, 'MORGAN', 'HOPKINS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (114, 'MORGAN', 'MCDORMAND', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (115, 'HARRISON', 'BALE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (116, 'DAN', 'STREEP', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (117, 'RENEE', 'TRACY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (118, 'CUBA', 'ALLEN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (119, 'WARREN', 'JACKMAN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (120, 'PENELOPE', 'MONROE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (121, 'LIZA', 'BERGMAN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (122, 'SALMA', 'NOLTE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (123, 'JULIANNE', 'DENCH', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (124, 'SCARLETT', 'BENING', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (125, 'ALBERT', 'NOLTE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (126, 'FRANCES', 'TOMEI', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (127, 'KEVIN', 'GARLAND', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (128, 'CATE', 'MCQUEEN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (129, 'DARYL', 'CRAWFORD', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (130, 'GRETA', 'KEITEL', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (131, 'JANE', 'JACKMAN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (132, 'ADAM', 'HOPPER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (133, 'RICHARD', 'PENN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (134, 'GENE', 'HOPKINS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (135, 'RITA', 'REYNOLDS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (136, 'ED', 'MANSFIELD', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (137, 'MORGAN', 'WILLIAMS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (138, 'LUCILLE', 'DEE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (139, 'EWAN', 'GOODING', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (140, 'WHOOPI', 'HURT', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (141, 'CATE', 'HARRIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (142, 'JADA', 'RYDER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (143, 'RIVER', 'DEAN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (144, 'ANGELA', 'WITHERSPOON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (145, 'KIM', 'ALLEN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (146, 'ALBERT', 'JOHANSSON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (147, 'FAY', 'WINSLET', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (148, 'EMILY', 'DEE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (149, 'RUSSELL', 'TEMPLE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (150, 'JAYNE', 'NOLTE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (151, 'GEOFFREY', 'HESTON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (152, 'BEN', 'HARRIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (153, 'MINNIE', 'KILMER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (154, 'MERYL', 'GIBSON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (155, 'IAN', 'TANDY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (156, 'FAY', 'WOOD', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (157, 'GRETA', 'MALDEN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (158, 'VIVIEN', 'BASINGER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (159, 'LAURA', 'BRODY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (160, 'CHRIS', 'DEPP', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (161, 'HARVEY', 'HOPE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (162, 'OPRAH', 'KILMER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (163, 'CHRISTOPHER', 'WEST', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (164, 'HUMPHREY', 'WILLIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (165, 'AL', 'GARLAND', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (166, 'NICK', 'DEGENERES', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (167, 'LAURENCE', 'BULLOCK', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (168, 'WILL', 'WILSON', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (169, 'KENNETH', 'HOFFMAN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (170, 'MENA', 'HOPPER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (171, 'OLYMPIA', 'PFEIFFER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (172, 'GROUCHO', 'WILLIAMS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (173, 'ALAN', 'DREYFUSS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (174, 'MICHAEL', 'BENING', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (175, 'WILLIAM', 'HACKMAN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (176, 'JON', 'CHASE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (177, 'GENE', 'MCKELLEN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (178, 'LISA', 'MONROE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (179, 'ED', 'GUINESS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (180, 'JEFF', 'SILVERSTONE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (181, 'MATTHEW', 'CARREY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (182, 'DEBBIE', 'AKROYD', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (183, 'RUSSELL', 'CLOSE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (184, 'HUMPHREY', 'GARLAND', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (185, 'MICHAEL', 'BOLGER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (186, 'JULIA', 'ZELLWEGER', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (187, 'RENEE', 'BALL', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (188, 'ROCK', 'DUKAKIS', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (189, 'CUBA', 'BIRCH', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (190, 'AUDREY', 'BAILEY', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (191, 'GREGORY', 'GOODING', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (192, 'JOHN', 'SUVARI', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (193, 'BURT', 'TEMPLE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (194, 'MERYL', 'ALLEN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (195, 'JAYNE', 'SILVERSTONE', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (196, 'BELA', 'WALKEN', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (197, 'REESE', 'WEST', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (198, 'MARY', 'KEITEL', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (199, 'JULIA', 'FAWCETT', '2006-2-15 04:34:33');
INSERT INTO `actor` (`actor_id`, `first_name`, `last_name`, `last_update`) VALUES (200, 'THORA', 'TEMPLE', '2006-2-15 04:34:33');
cgl_dong
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
SQL语句语法
03-21
SQL语句是结构化查询语言（Structured Query Language）的简称，是用于管理和处理关系数据库的标准语言。本篇文章将深入探讨SQL语句的基本语法，包括数据定义、数据操作、实用工具、事务处理和锁定、数据库管理、...
泛微系统SQL语句大全
12-29
**泛微系统SQL语句大全** 在IT行业中，泛微系统是一种广泛应用的企业级协同办公软件，主要用于提升组织的管理效率和工作流程自动化。本资源集合了泛微系统中与SQL Server数据库交互时常用的各种SQL语句，涵盖了组织...
SQL语句API
01-27
sql 语句是对数据库进行操作的一种语言。结构化查询语言(Structured Query Language)简称SQL，结构化查询语言是一种数据库查询和程序设计语言，用于存取数据以及查询、更新和管理关系数据库系统。
通过解析sql语句获取表血缘关系项目
06-07
"通过解析SQL语句获取表血缘关系项目"是一个针对数据库管理的实用技术，主要用于理解和跟踪数据的来源与流向，即血缘关系。血缘关系追踪在数据质量、合规性、审计和数据治理中扮演着关键角色。以下是关于这个主题的...
常用SQL语句大全
03-04
软件介绍 常用SQL语句大全 语 句 功 能　--数据操作　SELECT --从数据库表中检索数据行和列　INSERT --向数据库表添加新数据行　DELETE --从数据库表中删除数据行　...Tags： 常用SQL语句大全 SQL语句大全 SQL
sql语句sql语句sql语句sql语句.txt
06-01
sql语句sql语句sql语句sql语句sql语句
基本SQL语句
12-15
数据库最基层的SQL语句，新手必备，绝对靠谱，不懂可以留言
sql语句范例sql语句范例pdf
最新发布
06-15
篇一:SQL 语句大全实例 SQL 语句实例 表操作 例1对于表的教学管理数据库中的表STUDENTS ， 可以定义如下: CREATE TABLE STUDENTS (SNONUMERIC (6， O) NOT NULL SNAME CHAR (8) NOT NULL AGENUMERIC (3,0) SEXCHAR ...
SQL语句基础教程
01-20
SQL语句基础教程 SQL（Structured Query Language）是一种特殊目的语言，用于管理关系数据库管理系统（RDBMS）。SQL语句基础教程旨在帮助新手和需要复习SQL的资料仓储业界老将，学习SQL基础知识和语法。 SQL指令 -...
sql语句说明sql语句说明sql语句说明.zip
05-11
sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明...
SQL语句生成器
09-20
《SQL语句生成器——数据库操作的得力助手》 SQL语句生成器是一款专为MySQL数据库设计的强大工具，它极大地简化了数据库管理和维护过程中的SQL编写任务。无论是初学者还是经验丰富的数据库管理员，都能从中受益，...
thinkPHP框架中执行原生SQL语句的方法
10-19
在开发过程中，有时候我们需要直接使用原生SQL语句来完成特定的数据操作，特别是在处理复杂的查询或更新时。ThinkPHP框架提供了方便的接口来执行这些原生SQL，这使得开发者能够灵活地利用数据库的强大功能。本篇文章...
oracle导出sql语句的结果集和保存执行的sql语句(深入分析)
09-10
在Oracle数据库管理中，有时我们需要将SQL查询的结果集导出为文本文件，或者保存执行的SQL语句以供后续使用或记录。Oracle提供了一些实用的命令来实现这些功能，主要涉及`spool`和`sav`（或者`savelist`）这两个命令...
Access数据库-SQL语句大全.mdb
03-28
Access数据库-SQL语句资料.mdb
c#实现用SQL池,多线程定时批量执行SQL语句的方法
09-04
在C#中，构建SQL池并利用多线程定时批量执行SQL语句是一种优化数据库操作性能的有效策略。这种设计思路主要是为了将业务逻辑层与数据访问层分离，从而减轻数据库操作对系统整体性能的影响，特别是在高并发场景下，...
SQL语句到底是怎么执行的
01-19
写在前面的话：有时不理解SQL语句各个部分执行顺序，导致理解上出现偏差，或者是书写SQL语句时随心所欲，所以有必要了解一下sql语句的执行顺序。可以有时间自己写一个简单的数据库，理解会更加深入。下面写写我的...
oracle监听执行sql语句
12-23
### Oracle监听执行SQL语句详解 #### 一、Oracle监听执行概述 在Oracle数据库管理与维护过程中，有时候我们需要了解应用程序正在执行哪些SQL语句，这不仅有助于性能优化，还可以帮助我们诊断潜在的问题。通过监听...
mybatis动态SQL语句
04-28
if 、where、set、trim、choose 、foreach等在mybatis中的具体用法，有具体实例可供参考，玩转mybatis
3-SQL.rar_sql语句练习
09-20
SQL语句练习、学生可以查看自学SQL相关语句的练习
全面掌握：SQL语句精华指南
"史上最全数据库SQL语句大全，适用于初学者及查询参考，涵盖数据操作、数据定义、数据控制等多个方面。" 在数据库管理中，SQL（Structured Query Language）是用于管理和操作关系型数据库的标准语言。本资源提供了...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值