This is a BEFORE UPDATE trigger:
The simple syntax is below. The trick here is that on my application, I can pick multiple rows to update. When they are changed to 'Ship' status, I would ...
Hello. I have a form that submits information to a backend SQL database using AJAX/PHP. The form consists of two dropdown boxes. The value of each dropdown box and the username of the lo...
i'm in a huge bind.
windows server 2003 / mysql
i have to recover a mysql database from an old server to a new installation. the server it was running on will no longer boot. so i can...
Hi
I need a stored procedure that I can pass an output filename and a blob parameter of VarBinary(max).
The stored procedure must then write the blob to a file as specified in filename.
...
Hi All,
I am looking for MySQL query to find out sub-string inside string. My main string is ~1~2~3~4~ and sub-string is ~2~8~ . I want MySQL query to find out whether either of these 2 or ...
I'm trying to change the password of the root user for MySql (right now the root uses no password). So, to change that, I go to the admin page (http://localhost/phpmyadmin) and in the "Chang...
Hello. I am currently printing information in two separate tables, that I would like to combine into one table, but am unsure of the syntax. Basically, I have a mySQL database table with fie...
While installing Mysql Connector/ODBC 3.51 installer , it show a error message
Error 1918. Error installing ODBC Driver MySql ODBC 3.51 Driver , ODBC error 13 ; Could not load the setup or ...
Hi i'm trying to use the grant all privileges command and i'm getting the following error. I don't know what i am doing wrong. I thought it's because i'm typing my apostophy wrong, but i eve...
What would a trigger syntax look like if I want to validate that a record(s) exist in one table before the status can be changed in another.
psuedo code:
before update on POStatus to new...
Hi!
Im trying to integrate MySql with VS 2010 and be able to get the connector in my datasource-list soi i can work with Linq To Enitites with MySql, but even if i reistall everything it stil...
i have a mysql statement within my social networking site that shows a members friendslist. the problem is that when a member gathers anywhere near 1000 friends the entire site slows down try...
Getting the following error in an email from the scheduled task cron system on a dedicated server:
sh: /mysqldump: No such file or directory
The cron runs a php file with code that execute...
how to configure crontab to take backup of all mysql database automatically on remote host or localhost
I've got a MySQL 'countries' table (see the dump file attached) that has some non-standard characters represented as HTML character entities. How can I write a query that will run through the ...
i'm attempting to do an update statement using parameters but i'm not succeeding. below is a code snippet of what i have so far. i did some research on it and found what I thought was a simple...
I changed the name of an XP box with sql server 2008 Express running on it. I am able to commect to the server with Sql Managemant Studio just fine but whenever I try to do anything like attac...
Hey,
As my question describes, I'm trying to find a way to check if a value existed in one table, and then insert into another. I'm kinda stuck on what to call user input... nothing...
I am looking for some advice on tweaking the my.cnf config file for MySQL. The server is a Centos 5 mail server (Postfix) that uses perl to parse the mail and then insert it into MySQL. Seve...
Hi,
The wildcard in the code below does not work. Is there some way to make it work?
MySQL 5.0.67-community on CentOS.
Cheers
Just to let you know, I have been researching all topics regarding this here at EE and Google. I have tried various techniques to solve this problem:
If I am adding for example:
"ALEXANDE...
This query uses both temporary and filesort, which makes it rather slow when dealing with a lot of rows.
Both the added and color columns have indexes, and the query is using the "added" i...
I have these values in my table
ID price
==========
6 <= 5.0
5 <= 11.99
4 <= 0.8
3 <= 0.7
2 <= 0.6
1 <= 0.5
you see price column has string and integer value in it. ...
My table ,
id states quantity price
10 Chennai, Pondicherry 1-2 30
State is selected from the drop down , For both...
Hi all, trying to optimize a site and i ran into a situation where i need to join
tables in a statement but i dont know what the table will be except from a field from what's in the table al...
