MySQL Database Forum

I have installed mysql 5 on my mac and now I can't uninstall it or at least I don't know how to. The reason for the uninstall is I want to use MySQL 4 (which is already on my Mac...I forgot about it when I installed MySQL 5). I'm a newbie when it comes to MySQL and Unix so I'm not sure what to do. Is there anyone out there that can...

Hi, MySQL Administrator turns my ' characters into \' which simply doesn't work as general insert statement for InnoDB DB. Have I got stupid setting on Windows? I have already been told from MySQL that \' is standard format. I have to manually change all my \' to ''

Hi, I would like to catch and handle error 1060 - Ducplicate column already found, while adding column in my script.

Okay, when ever (on Invision Power Board's PM option) we try to send a PM to any other member on the forum, we all get this message... mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.members_disable_pm, m.members_display_name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM...

Can some one please help me on this? I got 2 records by individual with some fileds, one associates with the min date and the other one assocaites with max date. So lay out looks as follows: Key_ID | Dates_Min_Max Avg_Weight 1234 1/2/2004 12 1234 1/2/2006 24 I need to get the difference change...

Hi, i have some problem when trying make insert a lot of row in a large db. I have to pharse a 10 file of 1 million of record and insert it into a table ... when arrive at around 1 million of record, every 1000 / 2000 records, the query take 1 or 2 second to make 1 insert, then restart with a normal fast inserting ... in first i think was...

I'm trying to do an install of mysql on a Sun Ultra 10 machine running Solaris 10 (1/06) which is a completely clean, fresh install. I can get the packaged (with Solaris 10) version of mysql (4.0.something) running easily. I do have version 5.0.15-standard installed and running on another machine. It appears that between 5.0.15 and 5.0.22...

I've managed to get the .net connector working in VS Web Developer Express so that I can use the mySQL 5.0.22 database as a Membership provider. So I can now (if I wanted to) use the web admin tool to do all my user admin, and also use the login controls easily. However, I cannot get the 'test' function to work on the Providers tab of the...

I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x, which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a table to a text file, tab-delimited, text qualifyer of "none" (this is how I read to do it from newsgroups). When I use the Query window in phpmyadmin to import the text file, it waits a while,...

Hi, How do I at the best way perform select statements over multiple databases? I have a couple of databases containing the same table definitions with diffrent data. Now I want them to act as a single database giving me one answer on a select statement but the answer fetched from all my defined databases.

Can someone please help me combine these two queries? Basically, there are 3 columns in the ebluecard table that refer to agent. I need to do this first query, but filter by the office which is in the agents table in a different database. Is this possible? This is the main query: SELECT count(MarketingSource) as newvalue,...

I am trying to devise a procedure to delete rows wherein all the fields have been set to their default values (either null, or in the case of a not null default value for a row, that default value). Is there a means in MySQL which allows me to obtain what the defaults are for all fields in a table? Thanks, Ike

I canceled the install of mysql 5 and now I can't access my databases. mysql 4.1.14 is still installed(windows). How can I fix this?

bash-2.05b# ldd mysql libcurses.so.1 => /usr/lib/libcurses.so.1 libmysqlclient.so.12 => /sandbox/mysql-4.0.21/lib/mysql/libmysqlclient.so.12 libz.so.1 => /usr/lib/libz.so.1 librt.so.1 => /usr/lib/librt.so.1 libcrypt_i.so.1 => /usr/lib/libcrypt_i.so.1 libgen.so.1 => /usr/lib/libgen.so.1 libsocket.so.1 => ...

Hi there! I'm using PHP to create a simple, dynamic MySQL SELECT query. The user chooses a selection from a HTML Form SELECT element's many options and submits the form via a POST action. The SELECT query is built as follows: $itemtype = stripslashes(trim($_POST));

hi ! in mysql doc it is stated that : "MySQL supports local transactions (within a given client connection) " ref : http://dev.mysql.com/doc/refman/5.1/en/transactional-commands.html but what happens if for instance 2 different users tries to modify same data in 2 different transactions in 2 different connections ? does the last one which...

I am asked to upgrade mysql 3.23 to 4.0, because the final objective is to upgrade to 5.0. I have several questions. If you have some similar experience, please give me a hand. 1. Can version 3 client access version4/5 server? 2. What needs changing after upgrade to 4.0 or 5.0? 3. We use perl and java. Do I need to do something for these...

Hi, I'm fairly new to MySql and come from a MS SQL background. I have an application that I am converting from MS SQL to MySql. I need to return a value from MySql using a parameter. In MS SQL my select statement is: "select @id = id from database"

I have a MyISAM table where I am saving longblobs. These blobs are jpg files. However, when they are read back, there is a problem in that the jpg files "have two sof markers." I am wondering if it is something in the encodings of the table that could be causing this? Is there some particular encoding I must have this table of longblobs set...

Hello, all: I am pleased to announce that the MySQL Journal is moving forward.*During the past two weeks, I've been discussing the journal with MySQL AB, and the plan that's been devised benefits all involved, including authors, readers, the community, and MySQL AB.* Let me outline how the journal will operate: * The name of the...

Hi, I have MySQL 5.0.22 and I can't seem to do multiple delete 100% on InnoDB table with Foriegn Key. What should the correct syntax be?

Hi, In pure sql script I would like to handle possible error 1060. >ALTER TABLE `MyTable`.`flat-rooms` ADD COLUMN `guestsin` VARCHAR(1) NOT >NULL DEFAULT 'N' AFTER `keysin`;

Hi, I would like to delete rows only if table exist to prevents errors. Also I would like to add column only if it doesn't already exist. Thanks Jared

I have a table, "article" that has a datetime field "article_expires". In my SQL statement I have this: SELECT id, title, body FROM article WHERE (article_expires IS NOT NULL OR article_expires = '' OR article_expires LIKE '0000-00-00%' OR article_expires < now()) ORDER BY ranking DESC, record_entered DESC, upper(title) ASC, upper(body)...

Hello I make an regexp select statement over two tables. The Result set comes Back without errors. But If I look into the resultSets sometimes the ColumnName is Missing. Anyone knows about this problem or how to fix this ? Without the regexp everything is fine: Kontakte.Id INTEGER Kontakte.Anrede ...