MySQL Database Forum

I'm running a series of queries from a Python program using the MySQLdb module. The program opens a connection and then procedes to make two queries and then close the connection. It does this for each file provided as an argument to the program so there can be quite a few such cycles. I'm getting an 1040 error of 'Too many connections'. I...

Hai I want to change the date format at the time of inserting the record. i done it but one error in the insertion. The query is insert into mytable(update) values(date_format( '2006-10-09','%d%m%y'); Query OK but in the out put it will be in the form of '2009-10-06' ie in the date field 20 is added

If multiple tables have the same fields, what is a good way to do synchronous updates? For example, the user name field of the order data table, the user mobile number field, needs to be updated as the field of the user table is updated

Hai All, i want to retrive records from a table between perticular datetime range. the query is select * from geo_trip_history where t.tr_start_date between '2008-02-02' and '2008-02-29' and t.tr_end_date between '2008-02-02' and '2008-02-29' and t.tr_start_time >='010000' and t.tr_end_time <='230000';

Hi, I have a MySQL database linked to an MS Access front-end. I have an app which works fine with the local copy of the Access DB, but when run with the linked tables for MySQL, it fails. I'm trying to copy over related data for products, which is held in seperate tables. The main copying of the producy works fine, just not any related

Hey everyone. I have this query select * from `TableName` where `SomeIDField` 0 I can open a mysql command prompt and execute this command with no issues. However, Im trying to issue the same command inside of mysql_real_query and I keep on getting this error back. "You have an error in your SQL syntax; check the manual that...

I have just moved over to mysql as the back end and keeping access as front end. My database is for a ordering system. I use autonumber as the Order Number. as mysql does not display the order number (autonumber) until the form has been saved. Is there a way on the order form that i can have a button that will save the data then reopen the...

Hi, I have 10GB of harddisk space and now the harddisk space remaining 2GB because of the IBData1 size too big. As I'm check in the administrator tool. There is no any option to reduce or delete some data in IBData1 file. Any option I can move it out from this harddisk and put in another harddisk. e.g. remote machine but the scenario to reduce...

Hi, I changed the data directory of mysql through my.cnf file. my.cnf has the details. "#" indicates the i have changed accordingly to the main directory. I want to move my tables from /var/lib/mysql to /home/db.

Please Guys help me out , as I need the solution of this problem very fast.Please help me. My table contains a varchar field which contains time like : 04:09PM Now the problem is that I have to convert this into time.Please help me to suggest how to convert this data into time as I have to create various reports. I have also tried to...

Hi Gang, Regarding the MysqlDataTruncation issue, I am having trouble over-riding it with: url=jdbc:mysql://localhost/mysql?jdbcCompliantTruncation=false I am still getting the exception thrown in some cases: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'some_field' at row 1

Dear all, I'm new under mysql and have installed mysql5.0.24a community edition for win32. I have tried to implement a foreign key for this following sample scenario: CREATE TABLE student ( student_id INTEGER NOT NULL AUTO_INCREMENT, student_name VARCHAR(100) NOT NULL,

I'm running mysql 4.0.20 on windows 2000. What is the purpose of winmysqladmin? If I type it, a window opens, then closes, and puts an stoplight icon on the taskbar. If I click on "show me" it opens the window again. Then if I click on the databases tab it shows a database called "test", but none of the others that I can see from the mysql...

How would I write the query for mySQL to get all the records in a table that were written in tha last 10 minutes? I have a timestamp field (fldTime) that automatically inserts the curent time when the record is inserted, but I'm unsure how to write a query that would only get records from the last 10 miniutes. Any help would be...

Hello, I would like to know whether MySQL supports parallel query processing on server with two CPUs? If so, where can I find information on how to write such queries. Thanks

I want to create a pass through query in Access to get data from a MYSQL table. I need to do this using code so that sertain aspects of the query can be changed. When I look at the SQL version of a Select and a Passthrough query in access they appear to be the same. eg. "SELECT * FROM MYTABLE WHERE MYFILED = TRUE" What do I need to do to...

Hi! can i call the procedure inside the trigger?.... thank you, kaleeswaran

Hello I want to sum these records on month(datum) and device and get then get the min and max values and the associated low high date/times this does not work select month(datum) as t,device,time_hoog ,max(hoog),time_laag, min(laag) from weerdavis group by month(datum), device With this select i get the high value time but not the...

hi, how do i compare two varchar fields? my table has two fields, name and description. i need to find those records where the name does not match with or exist in the description field anywhere. should i use a "not exists"? thanks, s

I have a public IP system. In that I have installed WAMP. And I have written a java code to establish jdbc connection with the mysql installed in the public ip system. My Database connection fails miserably, Connection con = DriverManager .getConnection("jdbc:mysql://localhost/Test123","usr","123"); If my public ip is...

How can I create a primary key after the table has been created? Fred

I have a database with submissions inserted from a web server. If a submission is made again (i.e. with same user_id and problem_id), I want it to overwrite the row in the database. Currently, when I try to make the insert statement again, it obviously just fails and gives me a duplicate row error. As I don't know if a row is going to exist or...

What is the difference between time and timestamp data type in MySQL?

Hi I have a table that contains all the informations about the user . i want to when to click edit to edit the information of a user . I wrote this page : edit_user.php <?php require_once("../../include/database.php"); require_once("../../Functions/user_functions.php"); $id=$_POST; user::GetInfoUser($userid);

Hi, does anybody know how to copy a record within one table? I am looking for some simple method similair to INSERT INTO orders SELECT * FROM orders WHERE Order_ID=256; Actually, this method does not work and I can not believe that MySQL does not offer some simple method how to do it. Keep in mind that I have a 60-field table. So, naming...