MySQL Database Forum

ON DUPLICATE KEY UPDATE is new as of MySQL 4.1.0, but the web server that I'm using has MySQL 4.0.24 How would I implement ON DUPLICATE KEY UPDATE with an old version of MySQL? Thank you, Alec Colvin

Suppose I have two tables A and B Table A has fields A1, A2, A3, ... A9 Table B has fields B1, B2, B3, ... B9 I want to select all fields in A and only B3 in table B. I dont want to list individual fields for A because they are too many I simply want to use a *. How do I do this?

I'm using mysql 4.0.x, which does not allow the following query (which works fine in 4.1). Is there any way I can issue a single query to achieve the same results? (I want a list of all records from table al, nulled where there is no match in table alm, which has been filtered. Without a subquery, the filtering occurs after the outer join,...

Are there any good PHP scripts or pre written programs that deal with a complex database? Let me explain: I'm in truck dispatch, and we've moved all tables to mysql and access them on a network via ms access. We will open another office in another city, and will want a "web" database. Now here's what I'm after: Currently one form has various...

I have a database consisting of hourly tables ( n2005092100, n2005092101...) Each table contains data for a given hour. So 24 tables per day and I have room for just about 29 days ( = 67GB ). I would like to store the data compressed as volume is more important than speed. Any way to do that? Thanks chuck at blackforest-co dot com

I'm having quite a fuss with my two MySQL DB servers lately. I'm trying to establish replication between a MySQL 4.0.20 server (master) and a MySQL 4.1.11 server (slave). From what I read, replication from a 4.0.x server -> 4.1.x server will work, just not the other way around. However, that's not really my problem. After unsuccessfully...

I am trying to compile mysql for windows with openssl support. I have: - Defined HAVE_OPENSSL and HAVE_VIO in client.c (in libmysql/d projects) and vio.c - linked the libmysql project to libeay32.lib ssleay32.lib - moved lib and dll files into the lib_release directory - included "openssl/ssl.h" in client.c and vio.c - added...

Does anyone know where I can find information on how to setup my shell in unix/linux to allow me to restore a database from an sql dump... Example... I have a database on 83200.mysql.com (example) that I have a file mysql.sql (also just an example). The file was produced using an sqldump command from a web interface...

Hi there, I would like to know if I can pass XML data to a MYSQL stored procedure and then process the XML file to insert its values into a table. Something like the "SELECT ... FROM OPENXML " from TSQL Thank you

When I subtract dates, I can't figure out what I get out. I first I thought it was in seconds, but that's not it. Then I figured maybe HHMMSS, but that does not seem to be it too. How can I subtract two dates and get the resualt in HH:MM:SS format? Thanks for any help. -Eddie

Hi, I can't work out exactly what I need to do with datetime and timestamp, can anyone help? I would like a column created_timestamp to be populated on record creation (and preferably not updatable); and a column updated_timestamp to be populated on record creation, and

Hi, I'm trying to insert some data into a table and wish to confirm the insert is good rather than creating an error. I have tried the following (which works on Sybase) INSERT customers (full_name) VALUES (''Big Tech Enterprises')

Does any one know Embedded Berkeleydb's performance vs. Embeded MySQL's. ? Any idea would help. Thanks a lot.

Hello I can link MS Access (front) with MySQL (back end). However, when I add a new record, the previous added record is signed as Deleted record (view in Access) even I can view this record in MySQL. Please help to go over this... Thank you S.Hoa

Help! I am using SuSE 9.3 with the gcc 3.3.5 and have compiled and installed the newest mysql++ version 2.0.5 from the Internet. I can compile my programs, but getting a lot of link errors like "undefined reference to `mysqlpp::mysql_time::compare(mysqlpp::mysql_time const*) const'" My makefile is looking as follows:

I am not able to connect to the mysql DB if I am not the root user. I have already found identified an issue: * mysql.sock is NOT located in /tmp So, to get around it I created a sym link to the actual location (/var/lib/mysql/mysql.sock). This file, and the sym link, are both owned by root but they have full permission for all user. But...

I just Installed MySQL v4.1.14 and had created a Database (from a script). But I would like to redo the Database portion of it but am not able to drop the Database. If I do a "show database;" I still see the database. But when I look in the data directory, it is not there. Below is my attempt the create / drop the DB: mysql> create database...

Sorry if the cross-posting wasn't appropriate, but I need help with this and am not sure if it's more appropriate to post under MySQL or Perl...I want to be sure that I can get help from the best source. My question is probably a simple answer, but I am not sure what I have to do and the books I have here are either not answering the...

I have an INNODB installation that has caused me some problems recently with the data files growing beyond the UNIX file size limits. I have everything back to normal but, My question: is there a mysql systems table or variable that I can get the: -Current space allocated? -Current space used?

Help! I try to install mysql++ for SuSE 9.3, but I cannot compile any C++ program. Does anybody have any experience on this? Thanks, Matthias

Greetings, I am establishing a database for the purpose of logging access to my secure webserver and am wanting to make the database as efficient as I can because it will be doing a lot of work when the site goes live. What is the most efficient way in a MySQL table to store remote IP addresses? What data type should I use? Should I...

Hello *, i write you with an urgent problem. I would like to create forign keys to datetime field, but it doesn't seem to work. I get Can't create table '.\sampleDB\student_module.frm' (errno: 150) error. the tables look like CREATE TABLE IF NOT EXISTS sampleDB.student ( student.from1 DATETIME not null, student.from2 DATETIME not null,

This is a bit of a newbie question -- I've just installed MySQL 4.1.13 on a Fedora core 3 system. It installed great. It wasn't hard to get it running and create a few databases. But I can't seem to make the client shell run from anywhere but the mysql/bin directory. I've placed the /usr/local/mysql/bin directory in my PATH, but I still...

Hi, Im just working on transfering my access database on MySQL, Is there any GUI tool which allows to add, modify data in tables (I cant use PHP my Admin) ? I also need write some "macros" to transform data, can I shedule executing SQL statement regulary ? regards Peter

Hi, Lets say I have a many to many cross-referenced table b | t ----- A | 1 A | 2 A | 3 A | 4