12345678910111213141516171819202122232425262728 |
- #!/bin/sh
- #
- # Script to create a table 'FPdev' and to fill it with data.
- # The script accepts an optional argument :
- # A database to connect to. (default 'testdb')
- echo -n "Creating and filling table FPdev in database ${1-testdb}..."
- mysql ${1-testdb} << EOF >/dev/null
- create table FPdev (
- id INT NOT NULL,
- UserName CHAR(255),
- InstEmail CHAR(255),
- PRIMARY KEY (id),
- INDEX (id) );
- insert into FPdev values ('1','Michael Van Canneyt','[email protected]');
- insert into FPdev values ('2','Florian Klaempfl','[email protected]');
- insert into FPdev values ('3','Carl-Eric Codere','[email protected]');
- insert into FPdev values ('4','Daniel Mantione','[email protected]');
- insert into FPdev values ('5','Pierre Muller','[email protected]');
- insert into FPdev values ('6','Jonas Maebe','[email protected]');
- insert into FPdev values ('7','Peter Vreman','[email protected]');
- insert into FPdev values ('8','Gerry Dubois','[email protected]');
- EOF
- if [ ! $? = 0 ]; then
- echo "Failed."
- else
- echo "Done."
- fi
- # Ready
|