Drop all tables, MySQL.
SELECT concat('DROP TABLE IF EXISTS `', table_name, '`;')
FROM information_schema.tables
WHERE table_schema = 'MyDatabaseName';
Copy and paste the result and run ...
Featured Website - Planescape Online
The Planescape Online website has been a labor of love. Since the beginning of my time at Conestoga College, in the Web Design and Development program, I have been working very hard on this personal project.
Friday, May 13, 2022
Friday, April 22, 2022
Noob Creating a Shell Script
Using the terminal can be a pain in the ass.
So let's make a shell script, so we can avoid typing in the same commands over and over again.
Connect to your terminal and log in, then type this...
cd ~
...or wherever you want, "~" is the users home directory...
mkdir shellScript
cd shellScript
...note: while you're typing in a file or folder name, type a few letters and press the TAB button, the rest of the name should appear automatically, unless there's another name that starts the same.
Create a script file:
Both "vim" and "nano" are file...
