Tag Info

New answers tagged

0

Go to folder C:\wamp\bin\mysql\MYSQL_VERSION\bin Hit shift + right-click in that folder and select "Open command window here" from the menu that pops up. This will open a command window in the path you are already in, so C:\wamp\bin\mysql\MYSQL_VERSION\bin Enter any of the MySQL commands you like with any of the executables you find in that folder. For ...


1

wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-server-community-5.1.73-1.rhel5.x86_64.rpm wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-client-community-5.1.73-1.rhel5.x86_64.rpm sudo rpm -Uvh MySQL-client-community-5.1.73-1.rhel5.x86_64.rpm sudo rpm -Uvh MySQL-server-community-5.1.73-1.rhel5.x86_64.rpm sudo service mysql start ...


0

If the file is what you have in hand and you are manipulating it from a shell / console, I would use sed to do string replacements on lines starting with CREATE DABATASE, USE and optionnally -- (mysqldump comments) Replacing the db name on lines that matches Create Database, Use and mysqldump comments dbfile="yoursqldumpfile.sql"; dbname="current_db_name"; ...


1

It appears the OP is conflating how the data should be stored in the database with how the data will be displayed and/or entered when taking classroom attendance. These are not necessarily the same thing. Display should not drive storage. The UI could display the data the way the OP shows above in a classroom attendance form and have a middle layer that ...



Top 50 recent answers are included