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...
What are the pro's and con's of each?
And where would I use either?
I am trying to access a MySQL 5 database I have created on my machine with a C# program. I am running MySQL 5.0 (the freeware version) on my computer. I am doing this using C# in Visual Studio...
i want to compute the total $ for records (rows) in a table where
each row has a quantity and a (different) unit price.
thus if the table contains:
(qty) (unit price)
1 10
2 100
3 ...
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...
Hi all,
I have a MySQL server running on a linux that is working properly, and i have errors trying to connect to the server on a windows 98 client using ODBC. The error i am getting is Ca...
I am am MS SQL developer and I am busy trying to migrate over to MySQL. I need to populate a table for testing and I would like to do this using a while loop. I noticed that MySQL does support...
I'm using HQL, which is Hibernate's SQL. I'm hoping it works
I have the following HQL
select distinct r from Release as r, ReleaseComponent as c
where r.deploymentDate between :fromDat...
I'm getting the following error message when I run the query below.
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
First, I'm...
I have a TimeClock table that includes these two fields.
TrxDate 2007-11-02 00:00:00
ClockOut 1899-12-30 14:45:00
I want to take the DatePart of the the TrxDate field and replace ...
Hello,
I want to copy a large amount of data from a specific table, and only certain colums within it to another database and table on the same server.
What is the sql syntax to do this?
...
I know this question was asked many times before but I couldn't find a solution that works for me.
I've installed an apache server (2.2.6), PHP (5.2) and MySQL (5.0.45) in my windows XP SP2....
I am getting this error on my Domain Controllers. The SQL service is running on a Cluster of 2003 Server. Originally I found that on one node of the cluster the service was running as the do...
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 want to get the distinct set of rows based on the uniqueness of multiple columns
ex: I have a table last,first whose data is:
smith, john
smith, john
smith, fred
i want to run SQ ...
Currently, the mysql database version 4.3 that my company using is getting error as below
Host 'service.XXXXXXX.com' is blocked because of many connection errors.
Unblock with 'mysql...
I have a table with fields
Datefield date
Timefield time
Notify int
I need to select all rows that have the date and time exactly Notify hours (ignoring minutes and seconds, ...
Hi! I want a simple "copy this row"-function. How do I do this? Mysql and ASP scripting.
An INSERT query would be fine because I can use that both in my dev environment and at the customers...
I'm getting the following error in my app deplayed on Tomcat:
Exception getting connection : java.sql.SQLException: getConnection() timed-out
When it pops up, the Tomcat server needs to ...
Hello experts,
windows 2003 with PHP 4.4.7 and MySQL 4.1.22.
i am trying to install a PHP application which uses MySQL database and I receive an error.
The error is: Client does not supp...
If i change the code be low mysql_query("SET CHARACTER_SET_RESULTS=utf8") to
mysql_query("SET CHARACTER_SET_RESULTS=tis620") what will happen when i update form php code
if (EW_USE_M...
Hi,
I installed a MySQL 5.0 on a server, and I want to connect to the database from another computer.
What setting should I perform on the MySQL server? Edit the my.cnf file?
thanks,
...
I am on a Linux Redhat ver 7.3 box and have install mySql version 4.0.16. I started the daemon under the userid mysql and the daemons apperar to be runnung with a ps. I went to validate the da...
I have a form that inserts information into a database: dbvendor
The form inserts info into two separate tables: vendor and scope
I would like for a sql query to count the number of rows i...
I have been looking at mysql documentation concerning access denied, but I fill like I am getting nowhere.
I have tried the following
C:\>mysql -uroot mysql
ERROR 1045: Access denied f...
