MySql stuck

stephencassidy · 03-29-2007, 07:09 AM

Hi all, hope someone can help.

I am trying to write some kind of script that will delete rows from a MySQL table using a parameter that I pass to it

My table has 3 colums and I want to delete the rows where the value in one of the colums matches a value passed programatically by a script.

I have create a file called remove_records.sql

delete from filenames where path="qp-ms"

then I do mysql -u username -p password < remove_records.sql

this works but I need to change the value of path frequently.

Hope all this makes some kind of sense?

Thanks

Stephen

mjones490 · 03-29-2007, 11:52 AM

Perhaps a shell script like:

Code:

#!/bin/bash
echo delete from filenames where path=\"$1\" | mysql -u username -p password

would work.

derzok · 03-29-2007, 12:54 PM

In perl:

Code:

use DBI;
sub dbconnect {
        my $platform = "mysql";
        my $database = "dbname";
        my $host = "localhost";
        my $port = "3306";
        my $tablename = "tablename";
        my $user = "dbuser";
        my $password = "dbpass";
        my $dsn = "DBI:mysql:database=$database;host=$host;port=$port";
        $dbh = DBI->connect($dsn,$user,$password,);
}

&dbconnect;
$sth = $dbh->prepare("DELETE FROM `tablename` WHERE `field`=`'value'");
$sth->execute();

stephencassidy · 03-30-2007, 04:58 AM

Thanks for that, Mark I opted for your version and it worked a treat.

Thanks both for taking the time to help me out.

Stephen