I have a stored procedure like the one attached, which populates a table called Customers. I would like to change it so that if the field name is set to "NONAME" the entry does not get inserte...
What's the easiest way to change column order in a mysql table?
Thanks
I have XML files ranging from 10Kb to 1.5Gb. They contain product information. (see sample XML file below.) I need to write the product information into a mySQL table using PHP without reading...
This is a query statement I'm using to find and print out an email address in a MySQL table. The query finds the email, and prints out -
'exist in the database', but doesn't print out the $em...
I have a Plesk Server with Plesk 8.1 installed on it. Since Plesk 8.1 supports remote database like MYSQL and PostgreSQL i decided to hosts some databases on another server.
So i bought a new...
Hi,
I am runing SBS 2003 and I have installed MySQL 5.0, PhpMyAdmin 2.8.0, Apache 2.0.58, PHP 5.1.4.
After installing PhpMyAdmin 2.8.0 and opening up in browser i got the error:
#2003 - T...
I'm having trouble connecting to my local MySQL server, and I'm not sure what I'm doing wrong here. I have a very simple script. When I try to connect with the hostname 'localhost', I get an e...
I am using a shared hosting service. My application is ASP.NET and I am using MySQL DB V5.0.23-c-nt
I get the error "SELECT command denied to user 'user'@'ip' for table "municipio" when I t...
Hello all,
I need to create a table with password as a field. What is the data type for that field.
Thanks in advance,
Murugesan
i am running xp 64 corp with a virtual machine
virtual machine is running xp 32 sp3
xammp is installed on the virtual machine
i keep getting Something is wrong with the XAMPP installation :...
Mysql : How do I force drop/delete a database.
One of my developer wrote insertion scripts that are taking for ever to upload into our test datbase.I tried to drop the individual table (af...
In MySQL5, how can I construct a single query (not a union query) that will show the Lastname of the primary *and* secondary account rep assigned to each supplier, with these tables?
SUPPLI...
hi Experts!
I did drop database by mistake, I try to get folder if database from deleted and copy to data folder under mysql root but some table can read data (.MYD or .MYI) and some can no...
I am using MySql 5 and Coldfusion 8 to insert some dates into a table. I want to be able to insert a null value into a date field if that is possible. Basically, if the field is blank, do not...
What would a stored procedure in MySQL look like that returns the inserted ID from an Insert statement?
I need to create a stored procedure that takes arguments, inserts a new record with t...
hello dear
I can call a stored procedure that returns a result set in the MySQL Query Browser, but if I try to call it from a vb.net program then I got this error "PROCEDURE xxx can't return...
Hi. Simple question, can someone tell me how I can delete two rows from two different tables using one query? Thanks.
I have set up two systems with mysql to support Snort with no problem , and in setting up a third I keep getting the "ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number"...
At first the Dummy-Table PHONE with following records:
FIRSTNAME | SURNAME | NUMBER
--------------------------------------------------
Angela | Merkel | +49-3046/411
I...
Hi all,
I have wrote an application in VB and used the database MySQL.
My question is who can I get the database (data and structure) from my PC to a PC of a customer?
Is there something ...
I'm able to backup the database by clicking "Execute Backup Now", but when I set a scheduled time for it to execute, it never does. No errors, the schedule time just passes with nothing happe...
Hello,
I have a MySQL table with a column containing text (multiple words). I'm trying to SELECT rows from the table based on the number of words in the text column.
The cases are: exactly...
Hi,
I need help to resolve the following error. I am running mysql 5.0 (on windows xp). I have been able to connect mysql 5.0 before but I executed "webroot spy sweeper" a program meant to ge...
i have read the differences isam faster vs innodb transaction locking etc.
i have table that is currently 180,000 records and performance is starting to suffer. and yes i have all the need...
When I run a backup within plesk I get this error:
mysqldump: Got error: 29: File './wpmu265/wp_site.MYD' not found (Errcode: 24) when using LOCK TABLES
mysqldump: Got error: 29: File './w...
