|
Server IP : 172.16.15.8 / Your IP : 3.136.25.249 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/tjpepper/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
#!/bin/bash
echo "CREATE TABLE descriptions (id INT NOT NULL AUTO_INCREMENT, description VARCHAR(120), filepath VARCHAR(50), PRIMARY KEY (id));" > "createDescriptions.sql"
echo "INSERT INTO descriptions (description) VALUES" >> "createDescriptions.sql"
sed 's/[0-9][0-9][0-9] \(.*\)/("\1"),/g' $1 >> "createDescriptions.sql"
sed -i '$ s/\(.*\),/\1;/g' "createDescriptions.sql"