I've got MySQL Server 5.0 installed on a Windows machine. I remember when I installed it I was given the option to turn on remote connections and I didn't turn it on...thinking when I needed ...
Looks like mysql 3.x version does not support union or intersection.
How would I achive this in mysql without using intersection keyword?
select * from a
intersection
select * from...
Im trying to merge data from 4 different tables (2 really). I want to try to do this using MySQL so that I get a list of unique costcodes, with the various values in the next two columns. Here...
my application does:
delete table1; insert data from tmp_table1 to table1;
delete table2; insert data from tmp_table2 to table2;
delete table3; insert data from tmp_table3 to table3;
del...
I have and Excel/CSV file and I need to import this into MYSQL.
I use asp.net (VB) version 2.0, I also have MySQL Administrator version 1.2.12
I DO NOT have access to the MySql database...
I would like to know how to properly alter a table column name in MySQL; to rename it without using 3rd party editors.
ERROR I receive when I try any of the Snippet Samples.
I receive a sy...
I have a mysql database that has date fields as varchar fields stuctured as YYYYMMDD. I want to count the number of days between two dates: date_start and date_end. I currently do this by:
...
Hi, I just setup wamp and everything ran fine. I went into phpmyadmin and it gave me a warning that I should put a password up for mysql, otherwise people could just log right in, so I change...
I have an application which uses MySql.Data provider and C#. I am connecting to MySQL 4.0.24. My Connection string is using the switch "allow zero datetime = yes". What is happening is this...
Hi,
I've got this datetime column called days_stats in my MySql table called stats_tb
What I'm trying to do is: if the maximum date is not todays date then insert a row with todays date ...
Hello Everyone,
I have a question regarding default character set used in mysql. Since now, I have been using latin1 as default character set for mysql. However, I wish not to change it to...
I've been playing with this for a while now and can't seem to figure it out... Basically, I'm trying to return results for the first week of the month, but only for the 1st day through whatev...
I'm trying to create a procedure using the same syntax successfully used on a different server with the same version of MySQL. This is a new LAMP server (CentOS 5.2) so mysql may not be confi...
I have 5 columns, A,B,C,D, and E.
THere are possible duplicates only in column A and B. I want to create a new table that has only unique values based on A & B, but has all the columns of d...
I have just upgraded to SQL Server 2005 from SQL Server 2000.In Microsoft SQL Server Management Studio, when I click on the SQL Server Agent log, I receive the following error. Configuration o...
Does anyone know if it's possible to do a batch insert on MySQL 5 (as on SQL Server)? If so, how does one go about it? Thanks.
I am using a stored procedure on MySQL 5.0, accessing it via PhpMyAdmin 3.2.1
The code below works beautifully using the mySQL command-line tool. But via phpMyAdmin, I get the error below....
Hi,
I'm planning to have MySQL instead of Access 2k3 as back-end.
I'll keep the Access-DB as front-end.
I have mainly 3 types of queries in Access. Would like to see how they look like a...
Is there a way that I can tell MySQL to select all records of which have a value in a column (BLOB) similar to 90% or some arbritary value? Example:
SELECT * from table where name LIKE "%ha...
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...
Hi all,
i've a problem with sleep processes in my mysql database. Some longe queries cause sleeping processes if the user break up before result is on the screen. There isnt yet a posibilit...
I have an existing ibdata file and log files in my d:\data directory and have recently reinstalled WAMP server in c:\wamp. MySQL won't start. I've included my my.ini file here. It seems as t...
I am trying to set up MySQL ODBC 5.1 in Windows XP. I have previously installed 3.51 but it had severe limitation problems. My MySQL server is version 4.0.18 running on Linux RedHat 9. When...
Hi,
Thanks for your help.
I am currently on an XP box with the following software specs:
Apache/2.2.9 (Win32) PHP/5.2.6 and mySQL 5.0.51a/phpMyAdmin 2.11.7.1
I've uninstalled Apache/PH...
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...
