Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- echo "Enter database name: "
- read dbname
- echo "Enter table name: "
- read tablename
- echo "Enter column count: "
- read columns
- echo "Enter database username: "
- read dbuser
- echo "Enter database user password: "
- read dbpw
- for i in ${columns[@]} do
- echo "Column "$i" Name: "
- read array_cname[$i]
- echo "Column "$i" Data Type: "
- read array_ctype[$i]
- done
- table="USE $dbname CREATE TABLE $tablename(array_cname[] array_ctype[] etc etc etc)"
- mysql -u$dbuser -p$dbpw -e "$table"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement