MySQL Database Forum

Hi,All, I try to install mysql-5.0.15 on RHEL3-U5. But It give me a error. MySQL-client-standard-5.0.15-0.rhel3.i386.rpm MySQL-devel-standard-5.0.15-0.rhel3.i386.rpm MySQL-server-standard-5.0.15-0.rhel3.i386.rpm MySQL-shared-standard-5.0.15-0.rhel3.i386.rpm MySQL-standard-debuginfo-5.0.15-0.rhel3.i386.rpm

Hi there After posting a little bit earlier about many to many tables, I was wondering how I can get the total number of logins for each store, if I'm storing information like so: Stores: +---------+-------------+ | StoreID | StoreName |

Hi everyone, still pretty new to MySQL. I was wondering if there is a way to automatically filter records based on a mysql userlogin name?? I have serveral databases that I want to combine in order to manage the databases more efficiently. - I'm currently using MySQL 4.1.12 and I'm currently testing 5.0.14 - I have a databases for each...

When I designed my db in several tables I used unsigned integer fields to hold an integer that each bit was a 'flag'. Now I realize that the set field type does just what I was trying to accomplish. Is it safe to convert the field(s) from uint to set and keep their current values? Obviously all external programming (queries) will have to...

Hello, If I have a table, of say.... people, with their names, ages, addresses etc., and some lines in the table have the ages BLANK, how do I make sure that the blank fields are not taking up disk space? Does OPTIMIZE TABLE do this, or is another command? Thanks.

I'm stumped and my brains are fried!!!! I have the following data +-------+------------------------------+------------+ | resID | FLEName | VersionNbr | +-------+------------------------------+------------+ | 1 | 35_laserdatandria2104.zip | 1.0 | | 2 | 35_laserdatandria2104.zip | 1.23 | | 3...

Hello. I'd like to know the SQL query for the following operation. Table AUTHOR BOOK Bill A Bill B Charles A Bill C ....

Ok here's the thing... I have a vBulletin forum database... there is a table in there called "post" which has all of my forums posts in it. What I have are many posts with regular titles like "Oh hello how are you" or whatever, and many posts (which are replies) with "Re:" before them and whatever message following that. I have recently...

Question on PhP, MySQL I am thinking of a consumer internet business for which I will have to have a database driven site built. I am thinking of using PhP, MySQL as the main technologies amd Linux hosting( and some Dreamweaver). My question is:

I am following a book on PHP and MySQL and have come across the below SQL statement. CREATE TABLE users ( user_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT, username VARCHAR(20) NOT NULL, first_name VARCHAR(15) NOT NULL, last_name VARCHAR(30) NOT NULL, email VARCHAR(40) NULL, password VARCHAR(16) NOT NULL,

Hi I'm running mysql 4.1 on Intel 4 Linux gcc 2.4. Have found serious problem with memory leak - can't call calloc repeatedly without a seg fault. problem comes after a connect call has been made. help sought.

I have this query to get the 10 most common products from in stock, based upon which parent category they are in: SELECT p.*,i.sql_inventory AS quantity FROM products AS p JOIN inv_cnt AS i ON p.sql_id=i.sql_product_id JOIN catxprod AS x ON p.sql_id=x.sql_product_id -- product/category index JOIN cats AS c ON x.sql_cat_id=c.sql_id --...

Now that MySQL 5.0.15 is production ready, are there any functions to use with mysqlimport, so I can load a string such as, MM/dd/yy, in a text file into a MySQL database as a yyyy-MM-dd date value. Thanks, Yasaswi

Hello, I am creating a Database Architecture and there is a volume problem with MySQL. My tables are quite simple. Problem is they will record million of lines. Within 10 seconds, MySQL could receive 1.000 querries to insert raws in the same table.

Hi everyone, i'm trying to copy data from a table in Pervasive database to a table in MySQL Does anyone know how to do it? :confused: Is it posible to copy data from another database prog to MySQL? :confused: Thanks for the help....

Is there a way to store an indefinite number of keys in one field and self join them? Imagine, for example, you have a table of users with a "friends" column. Say user 1 is friends with users 9, 7, 24 and 6; then would it be possible to store this array/list/whatever-you-want-to-call-it into user 1's friends cell and extract the join in a...

jGu ----qtHwhORV90yyhqJMOc Content-Type: text/html; Content-Transfer-Encoding: quoted-printable <html><head><style type=3Dtext/css>.eyebrow { FONT-WEIGHT: bold; FONT-SIZE= : 10px; TEXT-TRANSFORM: uppercase; COLOR: #ffffff; FONT-FAMILY: verdana,ar= ial,helvetica,sans-serif; TEXT-DECORATION: none } A.eyebrow:link { TEXT-DE= CORATION: none...

I'm implementig a java web application using MySQL as database. The main function of the application is basically to redistribuite documents. Those documents (PDF, DOC with an average size around 2Mb) are stored in BLOB column. The amount of documents for the first year should not exceed 5/6 Giga, but I cannot make prevision for the next...

Hi there, I'm trying to figure out if it's going painless to upgrade our oooold mysql 3.23 to the latest MySQL 4 or 5. Any suggestions? Thanks in advance! David

Hi, We sent you an email a while ago, because you qualified for a much lower rate based on our records from a national database. Why is this? Because currently it is a buyers market with the lowest rates in years. You can now get $325,000 for as little as $709 a month! We realize many homeowners struggle and that makes it difficult to...

NEED CONVERSION FOR "14:10:01.000 GMT Sat Oct 22 2005" AS "2005-10-22 14:10:01" thanks

I have a MySQL 4.1.11 database, table and table columns all configured as utf8 as I need to accept data in a number of languages. The MySQL database is hosted so I use SET NAMES utf8 in the connection string in ASP e.g. sCon = "dsn=mydsn;uid=user;pwd=pass;stmt=set names utf8;option=3;". The ASP pages are all charset utf8. Now the ASP...

Is there anyway to compare a field with multiple string values using LIKE? Here's the statement I have now: SELECT * FROM list WHERE email LIKE CONVERT( _utf8 'hotmail@hotmail.com' USING latin1 ) OR email LIKE CONVERT( _utf8 'john@hotmail.com' USING latin1 )"; I know how to do it using the IN operator, SELECT * FROM list

Hi, I'm trying to ensure all entries in the database are upper case to keep the data looking consistent. I've written the following proc but the UPPER() function doesn't do anything. For example: CREATE PROCEDURE hospitals_AddHospital (IN HospitalName char(150)) BEGIN

In the usual case, this SQL select count(*) from mytable where ... returns an accurate count of the rows you want. But how do I go about counting rows from this SQL (the sum...if statements function as a pseudo pivot query)?