MySQL Database Forum

Sub: Append a string to all the values in a column SQL Hi all, This might be a very simple query. But I am new to SQL programming. Hope someone can help me. I have a table --- 1634 Fred los angeles 123 Sam

Sub: Append a string to all the values in a column SQL Hi all, This might be a very simple query. But I am new to SQL programming. Hope someone can help me. I have a table --- 1634 Fred los angeles 123 Sam

Hi, trying to update a BLOB column using SQLParamData / SQLPutData and it all works fine until the BLOB is > ~700KB. I'm putting it in 1KB chunks, but I have also tried 2KB without success. The SQLPutdata succeeds, but when the final SQLParamData is called SQL_ERROR is returned and the log file shows: DIAG Lost connection to MySQL...

Sorry if this is a really dumb question. I am trying to connect to our remote MySQL server (which is running just fine). I have a perl script which worked just fine on my other Fedora 4 box (all servers are Fedora 4 with latests updates). The one that worked fine it down and I cannot compare anything against it (it was a client also). ...

I am breeder of birds. I attempt to make one table BIRDS. It looks like this CREATE TABLE `birds` (`id` int(11) not NULL auto_increment, `father_id` int(11) NULL, `mother_id` int(11) NULL, `sexe` varchar(1) NOT NULL default 'M', PRIMARY KEY (`id`), KEY `father_id` (`father_id`), KEY `mother_id` (`mother_id`),

I have two identical databases running on two separate servers. I want to add a column to the following table: classified_cats { acid , name , parent } Running ALTER TABLE `classified_cats` ADD `is_active` TINYINT( 1 ) DEFAULT '0' NOT NULL ; on server A works fine, so I know the SQL is correct. Running the same query on server B results...

After reading that enum column is very efficient, I'm determined to use it where I can. Does anyone have WebApp experiences, that make life easier. I can see applications for US states, phone types, order types, etc. but for example in a contact manager business phone types may differ than personal phone types ie: work

hi everyone, we have a server on which someone blew away the MySQL 4 progs directory before installing MySQL 5. When installing MySQL 5 the installation failed with an error stating that it was unable to create system tables as the MySQL 4 directory did not exist. We are now unable to uninstall MySQL 5: # rpm -i

I'm having some issues with my full text indexes in MySQL 3.23.58. I'm using I have a table with a full text index on the 'content' column. There are some words that are returning results just fine but others that should return results aren't. For example, SELECT * FROM lift_content WHERE match(content) AGAINST('content') returns results...

Is there a forum, somewhere online, for sharing MySQL database schemas and applications? For example, if I want a basic check register or contact manager using MySQL, I am certain that these things have been developed hundreds of times. I could do it, but why re-invent the wheel? Is there anything like this out there in the ether?

Hi All, We use the Navicat GUI tool for end-user report generation, data exports, etc, from MySQL databases. In this capacity, it works admirably. Unfortunately, one downside is the lack of detailed documentation. We would like to be able to prompt the user to enter a value and have that value stored in a SQL user variable. Given the...

Hi I have been trying to do a similar thing for a number of different tables but have given up as i could not find a way to do it but it seems an obvious thing many pople would want to do so i thought i would ask once more to see if it is possible. I have a mysql table like this Id01 Maidstone KENT Id02 Ashford KENT

I'm trying to import a csv file with a PHP procedure. However, some of the lines in the csv file have missing values. When this command is given to mysql: insert tablex values...

Issue: I am trying to convert my old VB / SQL to now use MySQL. Setup: I have installed the MySQL ODBC 3.51 driver Code:

Is there some manual on how to make indexes? for example: table is create mytable ( a varchar, b varchar, c int, d int

Hi I am totally new to MySQL. Just wanted to know what are the major differences between version 3.23 and version 4.0.26? Also would apps written for 4.0.26 break on 3.23? Thanks Regards

I have a php page which contains the code: echo "<tr>"; echo "<th>$JobNumber</th>"; echo "<td>$Description</td>"; echo "<td>$NSN</td>"; echo "<td>$Manufacturer</td>"; echo "<td>$PartNumber</td>"; echo "</tr>";

Hi. I am a newbie to mysql, cron, and shell scripting, so please bear with me. I have a script that is used for updating an image directory based on contents in a database. The script does the following: runs several queries against different tables in a database; returns several lists of pictures being used in the database; removes any...

Hi all, I am not very good at sql, so anything remotely beyond simple, it goes over my head. I have a table which contains various fields, including 3 image fields. (image1_id, image2_id, image3_id). Each of these fields contains the id of an image found in the images table, (id, image). I need to pull all three images out and use...

HI,all I used an odbc-wrapper connectting mysql with unixODBC. But it didnt work well, often some exception occured. So I need one new wrapper for unixODBC, it must run stably. Could U give me an advice? THX

Hi all! I'm wondering if you have any good suggestions on program to create an ER diagram of a database... (sort of like the one shipped with MS SQL (sorry for cursing in this group :))) //Drew

i have 2 mysql servers. one is local on my pc and the second is hosted on a remote server and my web site is using it. during the day on i run some scripts and updates on my local pc and i want every once in a while to update the remote sever with the data i have on my local server. more the this, i have tables with autonumber fields.. and...

how can I do this type of join: table1: id, value1, value2 table2: id, value1, value2 table3: id, value1, value2 the "id" is a product code the values are new & used pricing

Hi. We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine. mysql-administrator v1.0.22 is installed on RH Linux FC3 from the mysql-administrator-1.0.22a-1.rh9.i386.rpm. Everything seems to run fine except User Administration is *extremely* slow. If I click on "User Administration" in the sidebar, it takes about 2 minutes (seems...