Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE people (`id` INT NOT NULL auto_increment primary key, `name` varchar(200) not null,
- `picture` blob, `height` float (2), `weight` float (2), `gender` enum('m', 'f'),
- `birthdate` datetime, `biography` text (65635) );
- insert into people (`id`, `name`, `picture`, `height`, `weight`, `gender`, `birthdate`, `biography`)
- values ('1', 'Maria', '/home/Pictures', '1.70', '65.50', 'f', '1983-05-09', 'She is new to this position and needs some training.' );
- insert into people (`id`, `name`, `picture`, `height`, `weight`, `gender`, `birthdate`, `biography`)
- values ('2', 'Ivan', '/home/Pictures', '1.90', '90.50', 'm', '1988-09-12', 'In this section of the tutorial, you have learned how to add data to your database, and also how to execute SQL statements using MySQL Workbench.' );
- insert into people (`id`, `name`, `picture`, `height`, `weight`, `gender`, `birthdate`, `biography`)
- values ('3', 'Eva', '/home/Pictures', '1.77', '77.30', 'f', '1955-10-30',
- 'In 1994, Schreiber made his first film, Mixed Nuts, playing a transvestite opposite Steve Martin.
- For the next several years, Schreiber established himself in independent films, including Denise Calls Up and Party Girl (1995),
- co-starring Parker Posey; Walking and Talking (1996), featuring Catherine Keener and Anne Heche;');
- insert into people (`id`, `name`, `picture`, `height`, `weight`, `gender`, `birthdate`, `biography`)
- values ('4', 'Gavin', '/home/Pictures', '1.79', '98.50', 'm', '1943-02-28', 'Gavin MacLeod was born as Allan George See on February 28, 1931 in Mount Kisco, New York.
- His father was part Chippewa Indian and owned a gas station, and his mother was a middle school dropout who would later work for Readers Digest' );
- insert into people (`id`, `name`, `picture`, `height`, `weight`, `gender`, `birthdate`, `biography`)
- values ('5', 'Hillary', '/home/Pictures', '1.60', '66.00', 'f', '1967-06-23', 'When Hillary Clinton was elected to the U.S. Senate in 2001,
- she became the first American first lady to ever win a public office seat. She later became the 67th U.S. secretary of state in 2009, serving until 2013. ' );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement