{"id":655,"date":"2024-04-09T12:09:31","date_gmt":"2024-04-09T09:09:31","guid":{"rendered":"https:\/\/vsevolodtsarev.wordpress.com\/?page_id=655"},"modified":"2024-10-14T07:29:05","modified_gmt":"2024-10-14T07:29:05","slug":"ra","status":"publish","type":"page","link":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/","title":{"rendered":"Random database"},"content":{"rendered":"\n

<\/p>\n\n\n\n

RANDOM andmed – https:\/\/www.mockaroo.com<\/a><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

XAMPP Localhost<\/p>\n\n\n

\ncreate table kliendiAuto (\n\tid INT PRIMARY KEY,\n\tfirst_name VARCHAR(50),\n\tlast_name VARCHAR(50),\n\temail VARCHAR(50),\n\tcar_make VARCHAR(50),\n\tcar_model VARCHAR(50),\n\tcar_year INT,\n\tcar_price DECIMAL(7,2)\n);\n<\/pre><\/div>\n\n
\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (1, 'Danila', 'Berardt', 'dberardt0@wikispaces.com', 'GMC', 'Jimmy', 1993, 8478.47);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (2, 'Gordan', 'Tomadoni', 'gtomadoni1@nyu.edu', 'Jeep', 'Compass', 2009, 4604.55);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (3, 'Delila', 'Jurkiewicz', 'djurkiewicz2@plala.or.jp', 'GMC', '2500', 1993, 2675.24);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (4, 'Colline', 'Jermin', 'cjermin3@mlb.com', 'Mercedes-Benz', 'CL-Class', 2010, 8349.29);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (5, 'Edd', 'Perdue', 'eperdue4@senate.gov', 'Kia', 'Rio', 2002, 2437.18);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (6, 'Faythe', 'Ghiron', 'fghiron5@ft.com', 'Mazda', 'Tribute', 2011, 4157.19);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (7, 'Tammy', 'Arbon', 'tarbon6@ycombinator.com', 'Infiniti', 'I', 1996, 6575.49);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (8, 'Ginger', 'Rolf', 'grolf7@salon.com', 'Nissan', 'Pathfinder', 2002, 6601.07);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (9, 'Gabriel', 'Mullinger', 'gmullinger8@utexas.edu', 'GMC', 'Savana 1500', 2007, 4543.4);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (10, 'Lamont', 'Dorwood', 'ldorwood9@ftc.gov', 'Pontiac', 'Montana', 2005, 9388.24);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (11, 'Valentine', 'Beeston', 'vbeestona@sakura.ne.jp', 'Mazda', 'B-Series Plus', 2003, 5162.67);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (12, 'Noe', 'Brockman', 'nbrockmanb@over-blog.com', 'BMW', '5 Series', 2007, 1746.2);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (13, 'Ruben', 'Enden', 'rendenc@canalblog.com', 'Subaru', 'Justy', 1993, 7953.14);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (14, 'Shari', 'Prandy', 'sprandyd@boston.com', 'Chevrolet', 'Corvette', 1960, 1471.29);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (15, 'Orin', 'Wittrington', 'owittringtone@bing.com', 'GMC', 'Canyon', 2008, 7280.44);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (16, 'Humbert', 'Bullimore', 'hbullimoref@blogs.com', 'GMC', 'Safari', 2004, 5020.72);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (17, 'Rinaldo', 'Saur', 'rsaurg@elpais.com', 'Chevrolet', 'Corsica', 1995, 355.4);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (18, 'Lorilee', 'Rigney', 'lrigneyh@bloomberg.com', 'Dodge', 'Caravan', 2006, 4012.99);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (19, 'Arther', 'Luard', 'aluardi@joomla.org', 'Lincoln', 'Continental', 2000, 9349.24);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (20, 'Rochella', 'Buxey', 'rbuxeyj@vimeo.com', 'Chevrolet', 'Colorado', 2010, 7762.05);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (21, 'Gaylord', 'Bangle', 'gbanglek@symantec.com', 'Chevrolet', 'SSR', 2004, 6229.89);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (22, 'Ronica', 'Storry', 'rstorryl@deliciousdays.com', 'Suzuki', 'Grand Vitara', 2003, 7115.91);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (23, 'Lia', 'Lacotte', 'llacottem@youku.com', 'Mercury', 'Grand Marquis', 1993, 885.42);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (24, 'Sabra', 'Stuart', 'sstuartn@people.com.cn', 'Geo', 'Tracker', 1996, 912.22);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (25, 'Francine', 'Pateman', 'fpatemano@squarespace.com', 'Buick', 'Skylark', 1985, 168.67);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (26, 'Haily', 'Stidson', 'hstidsonp@examiner.com', 'Dodge', 'D150 Club', 1992, 9191.2);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (27, 'Lethia', 'Moss', 'lmossq@drupal.org', 'Pontiac', 'Grand Am', 1995, 1451.33);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (28, 'Erhart', 'Bakewell', 'ebakewellr@guardian.co.uk', 'Infiniti', 'FX', 2005, 6197.56);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (29, 'Dilan', 'MacVagh', 'dmacvaghs@phoca.cz', 'Oldsmobile', 'Alero', 2003, 9035.51);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (30, 'Shaun', 'Rieger', 'sriegert@printfriendly.com', 'Ford', 'Fusion', 2009, 3517.31);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (31, 'Vernor', 'Unwin', 'vunwinu@usda.gov', 'Dodge', 'Grand Caravan', 1995, 5367.49);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (32, 'Frederick', 'Murra', 'fmurrav@github.io', 'Lincoln', 'LS', 2003, 912.86);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (33, 'Duky', 'Enbury', 'denburyw@woothemes.com', 'GMC', 'Yukon', 1997, 8592.97);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (34, 'Nigel', 'Peak', 'npeakx@google.co.jp', 'Isuzu', 'i-280', 2006, 5819.45);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (35, 'Shanna', 'Toretta', 'storettay@bluehost.com', 'Isuzu', 'Trooper', 1995, 415.14);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (36, 'Trisha', 'Snary', 'tsnaryz@taobao.com', 'Ford', 'Taurus', 2006, 5892.22);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (37, 'Gaston', 'Pietranek', 'gpietranek10@merriam-webster.com', 'Buick', 'Riviera', 1987, 1734.09);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (38, 'Loria', 'Fasham', 'lfasham11@sbwire.com', 'Chevrolet', 'Express 2500', 1999, 1585.22);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (39, 'Emmit', 'Illes', 'eilles12@imageshack.us', 'Toyota', 'RAV4', 2008, 6057.99);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (40, 'Davin', 'Keenleyside', 'dkeenleyside13@miibeian.gov.cn', 'BMW', '6 Series', 2004, 8903.53);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (41, 'Dyana', 'Adnet', 'dadnet14@economist.com', 'Mitsubishi', 'Galant', 2007, 4941.94);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (42, 'Appolonia', 'Celle', 'acelle15@cafepress.com', 'Pontiac', 'Grand Am', 1988, 3285.23);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (43, 'Trish', 'Twentyman', 'ttwentyman16@instagram.com', 'Saturn', 'Astra', 2008, 1573.02);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (44, 'Lance', 'Tomasino', 'ltomasino17@fotki.com', 'Chrysler', 'Town & Country', 1996, 1248.42);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (45, 'Richie', 'Stanbury', 'rstanbury18@java.com', 'Volkswagen', 'Touareg', 2004, 223.82);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (46, 'Mufinella', 'Mortlock', 'mmortlock19@aol.com', 'Buick', 'Rainier', 2006, 6158.6);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (47, 'Guenevere', 'Priel', 'gpriel1a@archive.org', 'Oldsmobile', 'Intrigue', 2001, 2438.09);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (48, 'Stormie', 'Michelmore', 'smichelmore1b@fda.gov', 'Land Rover', 'Range Rover', 2006, 9599.21);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (49, 'Katharyn', 'Guerrier', 'kguerrier1c@360.cn', 'Volvo', 'C70', 2000, 1751.87);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (50, 'Devonna', 'Danigel', 'ddanigel1d@tamu.edu', 'Land Rover', 'Range Rover Sport', 2012, 6996.91);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (51, 'Daryl', 'Ismail', 'dismail1e@vimeo.com', 'Pontiac', 'Bonneville', 2004, 7722.74);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (52, 'Sara-ann', 'Bellenie', 'sbellenie1f@princeton.edu', 'Isuzu', 'Hombre', 2000, 5265.94);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (53, 'Lesli', 'Dark', 'ldark1g@guardian.co.uk', 'Ford', 'Bronco', 1987, 6910.58);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (54, 'Cazzie', 'Blaine', 'cblaine1h@oakley.com', 'Suzuki', 'Equator', 2010, 3414.74);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (55, 'Courtney', 'Gorden', 'cgorden1i@blog.com', 'GMC', 'Savana 3500', 2004, 2980.63);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (56, 'Vilhelmina', 'MacAnelley', 'vmacanelley1j@arstechnica.com', 'Mercury', 'Mystique', 2000, 5035.47);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (57, 'Elonore', 'Keyson', 'ekeyson1k@php.net', 'Buick', 'Skyhawk', 1984, 6825.28);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (58, 'Marian', 'Hatton', 'mhatton1l@samsung.com', 'Ford', 'Econoline E150', 1993, 529.34);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (59, 'Neall', 'Eble', 'neble1m@ox.ac.uk', 'GMC', 'Safari', 2004, 5362.41);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (60, 'Dulciana', 'Chandlar', 'dchandlar1n@sohu.com', 'Cadillac', 'Escalade', 2012, 6473.96);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (61, 'Vinnie', 'Tille', 'vtille1o@msn.com', 'Dodge', 'Aries', 1981, 6410.73);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (62, 'Kile', 'Lever', 'klever1p@fc2.com', 'Pontiac', 'Grand Am', 1989, 4080.57);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (63, 'Dorothy', 'Sandever', 'dsandever1q@weibo.com', 'Kia', 'Soul', 2012, 2058.05);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (64, 'Desirae', 'Glanders', 'dglanders1r@usnews.com', 'Isuzu', 'Hombre', 2000, 3146.76);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (65, 'Ekaterina', 'Faherty', 'efaherty1s@indiatimes.com', 'Chevrolet', 'Corvette', 2008, 1213.15);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (66, 'Jaymie', 'Lewens', 'jlewens1t@google.es', 'Chevrolet', 'Camaro', 1974, 3974.81);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (67, 'Saidee', 'Deery', 'sdeery1u@home.pl', 'Nissan', 'Armada', 2009, 7853.96);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (68, 'Lucretia', 'Vasyagin', 'lvasyagin1v@yale.edu', 'Buick', 'Riviera', 1998, 4199.7);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (69, 'Kristoffer', 'Ovendon', 'kovendon1w@angelfire.com', 'Volkswagen', 'GTI', 2002, 3024.24);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (70, 'Cyndie', 'Nother', 'cnother1x@hhs.gov', 'Pontiac', 'Parisienne', 1985, 2420.91);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (71, 'Kath', 'Dunford', 'kdunford1y@google.co.jp', 'Toyota', 'Solara', 2004, 4659.72);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (72, 'Raymond', 'Woolcocks', 'rwoolcocks1z@youku.com', 'Porsche', 'Boxster', 2013, 3498.84);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (73, 'Phaedra', 'Bark', 'pbark20@mtv.com', 'Honda', 'Accord', 1988, 2837.37);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (74, 'Adella', 'Moorhouse', 'amoorhouse21@vinaora.com', 'Mercedes-Benz', 'SL-Class', 2007, 4448.95);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (75, 'Patric', 'Turmel', 'pturmel22@webnode.com', 'Dodge', 'Viper', 1999, 4898.23);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (76, 'Cami', 'Bartelli', 'cbartelli23@gravatar.com', 'Toyota', 'Prius', 2007, 7796.61);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (77, 'Janean', 'Enga', 'jenga24@forbes.com', 'Mercury', 'Grand Marquis', 2006, 8901.25);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (78, 'Coleman', 'Kidder', 'ckidder25@sitemeter.com', 'Chevrolet', 'Lumina', 1997, 6394.56);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (79, 'Teodoro', 'Whitefoot', 'twhitefoot26@abc.net.au', 'Saab', '9000', 1998, 6763.71);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (80, 'Mohammed', 'Dingivan', 'mdingivan27@webnode.com', 'Toyota', 'Corolla', 2002, 4197.65);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (81, 'Natty', 'Trayling', 'ntrayling28@hubpages.com', 'Mercedes-Benz', 'Sprinter 3500', 2012, 8531.1);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (82, 'Claudelle', 'Knightsbridge', 'cknightsbridge29@shareasale.com', 'Chevrolet', 'Venture', 2003, 7413.63);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (83, 'Lodovico', 'Pettengell', 'lpettengell2a@npr.org', 'Isuzu', 'Ascender', 2004, 1587.29);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (84, 'Giffer', 'Rosendahl', 'grosendahl2b@virginia.edu', 'Buick', 'Century', 1990, 337.89);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (85, 'Baxie', 'Moehler', 'bmoehler2c@booking.com', 'Saturn', 'S-Series', 2001, 4530.76);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (86, 'Janina', 'Clee', 'jclee2d@simplemachines.org', 'Nissan', 'Sentra', 2005, 2993.17);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (87, 'Sarita', 'Perotti', 'sperotti2e@gravatar.com', 'Honda', 'Accord', 2004, 8635.8);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (88, 'Gisele', 'D''Aeth', 'gdaeth2f@gizmodo.com', 'Subaru', 'Outback', 2004, 4880.23);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (89, 'Halli', 'Murcutt', 'hmurcutt2g@weather.com', 'Dodge', 'Ram 2500', 2004, 7208.57);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (90, 'Terra', 'Fraine', 'tfraine2h@delicious.com', 'Dodge', 'Ram Wagon B150', 1992, 3479.75);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (91, 'Stanton', 'Hymans', 'shymans2i@sfgate.com', 'Chevrolet', 'Venture', 2005, 514.19);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (92, 'Carny', 'McGarrahan', 'cmcgarrahan2j@opensource.org', 'Ford', 'Thunderbird', 1987, 9231.24);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (93, 'Gran', 'Thairs', 'gthairs2k@slideshare.net', 'Honda', 'Accord', 2010, 3309.97);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (94, 'Shay', 'Duffield', 'sduffield2l@chron.com', 'Plymouth', 'Voyager', 1996, 4315.15);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (95, 'Klara', 'Karpol', 'kkarpol2m@ebay.com', 'Dodge', 'Ram', 1994, 1086.74);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (96, 'Grissel', 'Farrans', 'gfarrans2n@uiuc.edu', 'Ford', 'Thunderbird', 1958, 4533.51);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (97, 'Fielding', 'Brito', 'fbrito2o@blinklist.com', 'Jeep', 'Grand Cherokee', 2011, 1243.54);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (98, 'Bernadette', 'Whimper', 'bwhimper2p@vimeo.com', 'Pontiac', 'Bonneville', 1964, 1949.6);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (99, 'Benjamen', 'Dunk', 'bdunk2q@gnu.org', 'Dodge', 'Daytona', 1993, 5413.75);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (100, 'Melisent', 'Villa', 'mvilla2r@photobucket.com', 'Mitsubishi', 'Pajero', 1986, 7718.39);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (101, 'Vsevolod', 'Tsarev', 'tsarev@tthk.ee', 'Bugatti', 'Divo', 2018, 1253.26);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (102, 'Bogdan', 'Sergachev', 'sergachev@tthk.ee', 'BMW', 'M4 Competition', 2023, 2521.45);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (103, 'Kirill', 'Sats', 'sats@tthk.ee', 'BMW', 'E60', 2012, 6119.19);\n\n<\/pre><\/div>\n\n\n
SELECT, UPDATE, DELETE lausete kasutamine<\/strong><\/p>\n\n\n\n
Muuda enda lisatud automargiks Zaporo\u017eets<\/p>\n\n\n
\nUPDATE kliendiauto\nSET car_make='Zaporozec'\nWHERE id>100;\n\nSELECT * FROM kliendiauto\nWHERE id>100;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Muuda k\u00f5ik Cadillac margid Citro\u00ebn\u2019iks<\/p>\n\n\n
\nSELECT * FROM kliendiauto\nWHERE car_make LIKE 'Cadillac';\n\nUPDATE kliendiauto\nSET car_make='Citro\u00ebn'\nWHERE car_make LIKE 'Cadillac';\n\n--kontrollimiseks n\u00e4data ei Cadillac puudub tabelis\nSELECT * FROM kliendiauto\nWHERE car_make LIKE 'Cadillac';\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Kustuta \u00e4ra read, mille ID on 5, 10 ja 15<\/p>\n\n\n
\nSELECT * FROM kliendiauto\nwhere id&lt;16; \ndelete from kliendiauto\nWHERE id=5 or id=10 or id=15;\nSELECT * FROM kliendiauto\nwhere id&lt;16; \n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Kuva read, kus on ainult ID, perenimi, automark ja aasta, sorteeri ID j\u00e4rgi kasvavalt<\/p>\n\n\n
\nSELECT id, last_name, car_make, car_year\nFROM kliendiauto\nORDER BY id;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Kuva 10 rida autosid, kus kliendi perenimi hakkab sama algust\u00e4hega, mis sul, sorteeri autod aasta j\u00e4rgi kahanevalt<\/p>\n\n\n
\n--perenimi algab 'T'\nSELECT last_name, car_make, car_year\nFROM kliendiauto\nWHERE LEFT (last_name,1)='T'\nORDER BY car_year DESC\nLIMIT 10;\n--perenimi algab 'T'\nSELECT last_name, car_make, car_year\nFROM kliendiauto\nWHERE last_name LIKE 'T%'\nORDER BY car_year DESC\nLIMIT 10;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Kuva 2 vabalt valitud automarki sisaldavad read ja \u00fcletavad mingit summat<\/p>\n\n\n
\nSELECT last_name, car_make, car_price\nFROM kliendiauto\nWHERE car_make IN ('BMW', 'Mercedes') AND car_price >=6000;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Keskmine autode hind ja summarne autode hind<\/p>\n\n\n
\nSELECT AVG(car_price) AS 'average price', SUM(car_price) AS 'sum price'\nFROM kliendiauto;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n
\nCREATE TABLE muuk(\n    muukID INT PRIMARY KEY,\n\tkuupaev DATE,\n\tmuuja VARCHAR(50),\n\tmuugihind VARCHAR(50),\n\tkliendiAutoid INT,\n    FOREIGN KEY(kliendiAutoid) REFERENCES kliendiAuto(id)\n    );\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n
\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (1, '2023-12-17', 'Carlin Mayoh', '\u20ac3169,15', 1);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (2, '2023-12-08', 'Victor Heball', '\u20ac8515,78', 2);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (3, '2023-10-01', 'Fiorenze Nerne', '\u20ac7519,16', 3);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (4, '2023-08-04', 'Karyl Shirland', '\u20ac9162,34', 4);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (5, '2023-07-03', 'Stormi Garfath', '\u20ac12499,95', 1);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (6, '2023-12-26', 'Imogen Rowlinson', '\u20ac8591,88', 6);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (7, '2023-07-19', 'Jarrad Joseph', '\u20ac2349,00', 7);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (8, '2023-10-05', 'Vi Leathard', '\u20ac12293,57', 8);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (9, '2023-10-30', 'Jerrie Slyvester', '\u20ac11874,87', 9);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (10, '2023-08-02', 'Pablo Pell', '\u20ac4519,89', 1);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (11, '2024-03-01', 'Tallia Gowry', '\u20ac2566,75', 11);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (12, '2024-03-16', 'Cathryn Kinastan', '\u20ac7703,25', 12);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (13, '2023-12-04', 'Tedd Wherrett', '\u20ac2182,77', 13);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (14, '2024-04-06', 'Dode Eliot', '\u20ac10674,00', 14);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (15, '2023-04-10', 'Emmalynne Skelhorn', '\u20ac4583,37', 1);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (16, '2023-06-08', 'Teodorico Bradie', '\u20ac1464,28', 16);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (17, '2023-08-30', 'Jasmin Mulvagh', '\u20ac11822,63', 17);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (18, '2023-10-22', 'Pascale Filpo', '\u20ac6727,20', 18);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (19, '2024-04-01', 'Jenna Constantine', '\u20ac8549,38', 19);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (20, '2024-01-20', 'Renee O''Kennavain', '\u20ac12912,46', 20);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (21, '2024-02-27', 'Adolf Lared', '\u20ac12200,28', 21);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (22, '2023-07-04', 'Tally Ansill', '\u20ac5756,65', 22);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (23, '2023-06-07', 'Duffy Diddams', '\u20ac8382,07', 23);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (24, '2023-07-24', 'Corilla Henze', '\u20ac7675,79', 24);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (25, '2024-03-14', 'Alfredo Jerche', '\u20ac2588,87', 25);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (26, '2023-11-18', 'Hadrian Parry', '\u20ac3986,96', 26);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (27, '2023-11-08', 'Tyrone Kobus', '\u20ac4088,14', 27);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (28, '2023-11-06', 'Garold Gourlay', '\u20ac3673,18', 28);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (29, '2023-12-17', 'Clementius Fearnsides', '\u20ac11597,93', 29);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (30, '2023-08-31', 'Bobette Greeno', '\u20ac5991,41', 30);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (31, '2023-09-05', 'Frasquito Cowlam', '\u20ac10058,85', 31);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (32, '2023-12-17', 'Clarke McMurrugh', '\u20ac3343,64', 32);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (33, '2023-06-02', 'Anjela Alred', '\u20ac14605,24', 33);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (34, '2023-04-11', 'Klaus Jermey', '\u20ac5610,85', 34);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (35, '2024-01-28', 'Barrie Piotr', '\u20ac14477,50', 35);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (36, '2023-10-15', 'Rees Di Domenico', '\u20ac9643,34', 36);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (37, '2023-06-25', 'Cecilia Monaghan', '\u20ac2618,73', 37);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (38, '2023-05-26', 'Danette Fairholme', '\u20ac11380,32', 38);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (39, '2023-12-01', 'Kelbee Letty', '\u20ac4870,44', 39);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (40, '2023-09-15', 'Kristyn Neve', '\u20ac1457,28', 40);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (41, '2023-12-10', 'Wyn Rosendale', '\u20ac6425,37', 41);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (42, '2024-02-13', 'Sander Tackett', '\u20ac13435,96', 42);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (43, '2023-10-22', 'Rosana Routham', '\u20ac8356,05', 43);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (44, '2024-02-24', 'Casie Dumbarton', '\u20ac6057,97', 44);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (45, '2024-04-03', 'Rickert Birchwood', '\u20ac10953,03', 45);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (46, '2023-09-14', 'Jody Cullity', '\u20ac1243,16', 46);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (47, '2023-11-30', 'Hynda Dunsleve', '\u20ac10649,67', 47);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (48, '2024-02-03', 'Teddie Rene', '\u20ac1833,88', 48);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (49, '2023-08-06', 'Archer Early', '\u20ac12503,09', 49);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (50, '2023-12-19', 'Blinnie Bourne', '\u20ac8297,09', 50);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (51, '2023-07-30', 'Carlotta Lapides', '\u20ac10001,81', 51);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (52, '2023-09-07', 'Hammad Foale', '\u20ac5689,76', 52);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (53, '2023-11-28', 'Daryl Attewell', '\u20ac11798,25', 53);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (54, '2023-06-06', 'Spike Scapens', '\u20ac5040,07', 54);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (55, '2023-06-13', 'Amby Higgonet', '\u20ac12536,01', 55);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (56, '2023-06-03', 'Lisetta Dax', '\u20ac5898,42', 56);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (57, '2023-08-05', 'Had Catchpole', '\u20ac13677,33', 57);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (58, '2024-03-09', 'Kippy Sturton', '\u20ac3324,52', 58);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (59, '2024-03-09', 'Isidor Hark', '\u20ac8721,30', 59);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (60, '2024-01-29', 'Bernhard Wenger', '\u20ac7091,92', 60);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (61, '2023-06-29', 'Alika Tremaine', '\u20ac9614,61', 61);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (62, '2023-07-05', 'Talya Rennels', '\u20ac12386,47', 62);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (63, '2023-08-31', 'Krissy Boumphrey', '\u20ac6141,50', 63);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (64, '2023-10-13', 'Maitilde Rassell', '\u20ac6144,51', 64);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (65, '2024-01-20', 'Talyah Ormistone', '\u20ac14110,40', 65);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (66, '2024-04-07', 'Melanie Scarre', '\u20ac4245,91', 66);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (67, '2023-06-27', 'Petronella Luker', '\u20ac5866,48', 67);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (68, '2023-10-12', 'Calida Arnout', '\u20ac10562,52', 68);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (69, '2024-03-11', 'Lesly Pearton', '\u20ac5346,05', 69);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (70, '2023-11-29', 'Donny Gudgion', '\u20ac5643,18', 70);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (71, '2023-06-08', 'Berty Di Roberto', '\u20ac10965,98', 71);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (72, '2023-09-03', 'Broddie Strelitzer', '\u20ac4618,53', 72);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (73, '2023-10-24', 'Aloisia Paradyce', '\u20ac7487,20', 73);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (74, '2023-12-26', 'Diahann Bosson', '\u20ac14910,68', 74);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (75, '2023-10-24', 'Diann Loughlin', '\u20ac12311,46', 75);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (76, '2023-07-21', 'Valerie Blackley', '\u20ac12115,15', 76);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (77, '2023-08-31', 'Morse Hindsberg', '\u20ac6494,86', 77);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (78, '2023-11-20', 'Westleigh Seiler', '\u20ac13544,08', 78);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (79, '2023-12-29', 'Jodie Antcliff', '\u20ac12065,44', 79);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (80, '2024-04-08', 'Arel Adamou', '\u20ac12792,81', 80);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (81, '2024-02-01', 'Wileen Sieve', '\u20ac8179,13', 81);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (82, '2023-08-17', 'Fredelia Mulhall', '\u20ac10110,91', 82);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (83, '2023-11-21', 'Paulette Broadbridge', '\u20ac3973,90', 83);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (84, '2023-08-17', 'Blanca Audus', '\u20ac14808,50', 84);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (85, '2023-12-24', 'Virginie Matelaitis', '\u20ac2456,51', 85);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (86, '2024-02-20', 'Fidela Dickson', '\u20ac1878,03', 86);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (87, '2024-03-13', 'Jesse Gerritzen', '\u20ac8623,44', 87);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (88, '2023-04-24', 'Lari Conklin', '\u20ac4456,96', 88);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (89, '2023-11-23', 'Marissa Rosson', '\u20ac2265,89', 89);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (90, '2023-11-24', 'Selle Hurkett', '\u20ac5972,79', 90);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (91, '2024-03-21', 'Corrinne Simmgen', '\u20ac5502,03', 91);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (92, '2023-11-28', 'Ad Heake', '\u20ac4745,41', 92);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (93, '2023-08-20', 'Meredithe Leak', '\u20ac14680,47', 93);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (94, '2023-11-22', 'Baryram Waddell', '\u20ac9385,19', 94);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (95, '2023-05-18', 'Cullan Birdis', '\u20ac12107,37', 95);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (96, '2023-12-31', 'Val Vermer', '\u20ac7531,04', 96);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (97, '2023-08-01', 'Chrysa Belcham', '\u20ac9590,22', 97);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (98, '2023-04-19', 'Bridgette Warry', '\u20ac10205,57', 98);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (99, '2023-09-06', 'Loren Cockren', '\u20ac13557,16', 99);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (100, '2023-10-04', 'Jaime Gotmann', '\u20ac11896,10', 100);\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
MS ACCESS<\/p>\n\n\n
\ncreate table kliendiAuto (\n\tid INT PRIMARY KEY,\n\tfirst_name VARCHAR(50),\n\tlast_name VARCHAR(50),\n\temail VARCHAR(50),\n\tcar_make VARCHAR(50),\n\tcar_model VARCHAR(50),\n\tcar_year INT,\n\tcar_price int\n);\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n
\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (1, 'Danila', 'Berardt', 'dberardt0@wikispaces.com', 'GMC', 'Jimmy', 1993, 8478.47);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (2, 'Gordan', 'Tomadoni', 'gtomadoni1@nyu.edu', 'Jeep', 'Compass', 2009, 4604.55);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (3, 'Delila', 'Jurkiewicz', 'djurkiewicz2@plala.or.jp', 'GMC', '2500', 1993, 2675.24);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (4, 'Colline', 'Jermin', 'cjermin3@mlb.com', 'Mercedes-Benz', 'CL-Class', 2010, 8349.29);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (5, 'Edd', 'Perdue', 'eperdue4@senate.gov', 'Kia', 'Rio', 2002, 2437.18);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (6, 'Faythe', 'Ghiron', 'fghiron5@ft.com', 'Mazda', 'Tribute', 2011, 4157.19);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (7, 'Tammy', 'Arbon', 'tarbon6@ycombinator.com', 'Infiniti', 'I', 1996, 6575.49);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (8, 'Ginger', 'Rolf', 'grolf7@salon.com', 'Nissan', 'Pathfinder', 2002, 6601.07);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (9, 'Gabriel', 'Mullinger', 'gmullinger8@utexas.edu', 'GMC', 'Savana 1500', 2007, 4543.4);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (10, 'Lamont', 'Dorwood', 'ldorwood9@ftc.gov', 'Pontiac', 'Montana', 2005, 9388.24);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (11, 'Valentine', 'Beeston', 'vbeestona@sakura.ne.jp', 'Mazda', 'B-Series Plus', 2003, 5162.67);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (12, 'Noe', 'Brockman', 'nbrockmanb@over-blog.com', 'BMW', '5 Series', 2007, 1746.2);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (13, 'Ruben', 'Enden', 'rendenc@canalblog.com', 'Subaru', 'Justy', 1993, 7953.14);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (14, 'Shari', 'Prandy', 'sprandyd@boston.com', 'Chevrolet', 'Corvette', 1960, 1471.29);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (15, 'Orin', 'Wittrington', 'owittringtone@bing.com', 'GMC', 'Canyon', 2008, 7280.44);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (16, 'Humbert', 'Bullimore', 'hbullimoref@blogs.com', 'GMC', 'Safari', 2004, 5020.72);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (17, 'Rinaldo', 'Saur', 'rsaurg@elpais.com', 'Chevrolet', 'Corsica', 1995, 355.4);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (18, 'Lorilee', 'Rigney', 'lrigneyh@bloomberg.com', 'Dodge', 'Caravan', 2006, 4012.99);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (19, 'Arther', 'Luard', 'aluardi@joomla.org', 'Lincoln', 'Continental', 2000, 9349.24);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (20, 'Rochella', 'Buxey', 'rbuxeyj@vimeo.com', 'Chevrolet', 'Colorado', 2010, 7762.05);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (21, 'Gaylord', 'Bangle', 'gbanglek@symantec.com', 'Chevrolet', 'SSR', 2004, 6229.89);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (22, 'Ronica', 'Storry', 'rstorryl@deliciousdays.com', 'Suzuki', 'Grand Vitara', 2003, 7115.91);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (23, 'Lia', 'Lacotte', 'llacottem@youku.com', 'Mercury', 'Grand Marquis', 1993, 885.42);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (24, 'Sabra', 'Stuart', 'sstuartn@people.com.cn', 'Geo', 'Tracker', 1996, 912.22);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (25, 'Francine', 'Pateman', 'fpatemano@squarespace.com', 'Buick', 'Skylark', 1985, 168.67);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (26, 'Vsevolod', 'Tsarev', 'tsarev@tthk.ee', 'Bugatti', 'Divo', 2018, 1253.26);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (27, 'Bogdan', 'Sergachev', 'sergachev@tthk.ee', 'BMW', 'M4 Competition', 2023, 2521.45);\ninsert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (28, 'Kirill', 'Sats', 'sats@tthk.ee', 'BMW', 'E60', 2012, 6119.19);\n\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
SELECT, UPDATE, DELETE lausete kasutamine<\/strong><\/p>\n\n\n\n
Muuda enda lisatud automargiks Zaporo\u017eets<\/p>\n\n\n
\nUPDATE kliendiauto\nSET car_make='Zaporozec'\nWHERE id>25;\nSELECT * FROM kliendiauto\nWHERE id>25;\n\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Muuda k\u00f5ik Subaru margid Citro\u00ebn\u2019iks<\/p>\n\n\n
\nSELECT * FROM kliendiauto\nWHERE car_make LIKE 'Subaru';\nUPDATE kliendiauto\nSET car_make='Citro\u00ebn'\nWHERE car_make LIKE 'Subaru';\n--kontrollimiseks n\u00e4data ei Subaru puudub tabelis\nSELECT * FROM kliendiauto\nWHERE car_make LIKE 'Subaru';\n\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Kustuta \u00e4ra read, mille ID on 5, 10 ja 15<\/p>\n\n\n
\nSELECT * FROM kliendiauto\nwhere id<16; \ndelete from kliendiauto\nWHERE id=5 or id=10 or id=15;\nSELECT * FROM kliendiauto\nwhere id<16; \n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Kuva read, kus on ainult ID, perenimi, automark ja aasta, sorteeri ID j\u00e4rgi kasvavalt<\/p>\n\n\n
\nSELECT id, last_name, car_make, car_year\nFROM kliendiauto\nORDER BY id;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Kuva 10 rida autosid, kus kliendi perenimi hakkab sama algust\u00e4hega, mis sul, sorteeri autod aasta j\u00e4rgi kahanevalt<\/p>\n\n\n
\n--perenimi algab 'T'\nSELECT last_name, car_make, car_year\nFROM kliendiauto\nWHERE LEFT (last_name,1)='T'\nORDER BY car_year DESC\nLIMIT 10;\n--perenimi algab 'T'\nSELECT last_name, car_make, car_year\nFROM kliendiauto\nWHERE last_name LIKE 'T%'\nORDER BY car_year DESC\nLIMIT 10;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Kuva 2 vabalt valitud automarki sisaldavad read ja \u00fcletavad mingit summat<\/p>\n\n\n
\nSELECT last_name, car_make, car_price\nFROM kliendiauto\nWHERE car_make IN ('BMW', 'Mazda') AND car_price &gt;=1500;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Keskmine autode hind ja summarne autode hind<\/p>\n\n\n
\nSELECT AVG(car_price) AS 'average price', SUM(car_price) AS 'sum price'\nFROM kliendiauto;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n
\nCREATE TABLE muuk(\n    muukID INT PRIMARY KEY,\n\tkuupaev DATE,\n\tmuuja VARCHAR(50),\n\tmuugihind VARCHAR(50),\n\tkliendiAutoid INT,\n    FOREIGN KEY(kliendiAutoid) REFERENCES kliendiAuto(id)\n    );\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n
\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (1, '2023-12-17', 'Carlin Mayoh', '\u20ac3169,15', 1);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (2, '2023-12-08', 'Victor Heball', '\u20ac8515,78', 2);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (3, '2023-10-01', 'Fiorenze Nerne', '\u20ac7519,16', 3);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (4, '2023-08-04', 'Karyl Shirland', '\u20ac9162,34', 4);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (5, '2023-07-03', 'Stormi Garfath', '\u20ac12499,95', 1);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (6, '2023-12-26', 'Imogen Rowlinson', '\u20ac8591,88', 6);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (7, '2023-07-19', 'Jarrad Joseph', '\u20ac2349,00', 7);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (8, '2023-10-05', 'Vi Leathard', '\u20ac12293,57', 8);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (9, '2023-10-30', 'Jerrie Slyvester', '\u20ac11874,87', 9);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (10, '2023-08-02', 'Pablo Pell', '\u20ac4519,89', 1);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (11, '2024-03-01', 'Tallia Gowry', '\u20ac2566,75', 11);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (12, '2024-03-16', 'Cathryn Kinastan', '\u20ac7703,25', 12);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (13, '2023-12-04', 'Tedd Wherrett', '\u20ac2182,77', 13);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (14, '2024-04-06', 'Dode Eliot', '\u20ac10674,00', 14);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (15, '2023-04-10', 'Emmalynne Skelhorn', '\u20ac4583,37', 1);\ninsert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (16, '2023-06-08', 'Teodorico Bradie', '\u20ac1464,28', 16);\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
RANDOM andmed – https:\/\/www.mockaroo.com XAMPP Localhost SELECT, UPDATE, DELETE lausete kasutamine Muuda enda lisatud automargiks Zaporo\u017eets Muuda k\u00f5ik Cadillac margid Citro\u00ebn\u2019iks Kustuta \u00e4ra read, mille ID on 5, 10 ja 15 Kuva read, kus on ainult ID, perenimi, automark ja aasta, sorteeri ID j\u00e4rgi kasvavalt Kuva 10 rida autosid, kus kliendi perenimi hakkab sama algust\u00e4hega, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-655","page","type-page","status-publish","hentry"],"yoast_head":"\nRandom database - Vsevolod Tsarev portfoolio || Eng<\/title>\n<meta name=\"description\" content=\"Random database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Random database - Vsevolod Tsarev portfoolio || Eng\" \/>\n<meta property=\"og:description\" content=\"Random database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/\" \/>\n<meta property=\"og:site_name\" content=\"Vsevolod Tsarev portfoolio || Eng\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-14T07:29:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vsevolodtsarev.wordpress.com\/wp-content\/uploads\/2024\/04\/image.png?w=1024\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/ra\\\/\",\"url\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/ra\\\/\",\"name\":\"Random database - Vsevolod Tsarev portfoolio || Eng\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/ra\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/ra\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/vsevolodtsarev.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/image.png?w=1024\",\"datePublished\":\"2024-04-09T09:09:31+00:00\",\"dateModified\":\"2024-10-14T07:29:05+00:00\",\"description\":\"Random database\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/ra\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/ra\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/ra\\\/#primaryimage\",\"url\":\"https:\\\/\\\/vsevolodtsarev.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/image.png?w=1024\",\"contentUrl\":\"https:\\\/\\\/vsevolodtsarev.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/image.png?w=1024\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/ra\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Random database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Vsevolod Tsarev portfoolio || Eng\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/vsevolodtsarev23.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Random database - Vsevolod Tsarev portfoolio || Eng","description":"Random database","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/","og_locale":"en_US","og_type":"article","og_title":"Random database - Vsevolod Tsarev portfoolio || Eng","og_description":"Random database","og_url":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/","og_site_name":"Vsevolod Tsarev portfoolio || Eng","article_modified_time":"2024-10-14T07:29:05+00:00","og_image":[{"url":"https:\/\/vsevolodtsarev.wordpress.com\/wp-content\/uploads\/2024\/04\/image.png?w=1024","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/","url":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/","name":"Random database - Vsevolod Tsarev portfoolio || Eng","isPartOf":{"@id":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/#primaryimage"},"image":{"@id":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/#primaryimage"},"thumbnailUrl":"https:\/\/vsevolodtsarev.wordpress.com\/wp-content\/uploads\/2024\/04\/image.png?w=1024","datePublished":"2024-04-09T09:09:31+00:00","dateModified":"2024-10-14T07:29:05+00:00","description":"Random database","breadcrumb":{"@id":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/#primaryimage","url":"https:\/\/vsevolodtsarev.wordpress.com\/wp-content\/uploads\/2024\/04\/image.png?w=1024","contentUrl":"https:\/\/vsevolodtsarev.wordpress.com\/wp-content\/uploads\/2024\/04\/image.png?w=1024"},{"@type":"BreadcrumbList","@id":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/ra\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"Random database"}]},{"@type":"WebSite","@id":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/#website","url":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/","name":"Vsevolod Tsarev portfoolio || Eng","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/655","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=655"}],"version-history":[{"count":1,"href":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/655\/revisions"}],"predecessor-version":[{"id":1054,"href":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/655\/revisions\/1054"}],"wp:attachment":[{"href":"https:\/\/vsevolodtsarev23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}