MySQL Database Forum

Complements=2C Dear Sir=2C I am Mrs=2E Patrika Kovac a Yugoslavian and company secretary to YUKOS OIL South Africa owned by Mikhail Khodorkovsky =28M=2EK=29 one of the richest men in Russia and owner of the following companies=3A Chairman CEO=3A YUKOS OIL =28Russian Most Largest Oil Company=29 Chairman CEO=3A Menatep SBP Bank =28A well...

Hi, I'm currently using the following mysql statement to perform a search. Right now it is only returning the results which are found in the description field. How do I modify this statement so that it is searching the following fields: company_name, product_name, description. SELECT product_id, company_name, product_name, url, description...

Hello all, I've been using sql and mysql in particular for several years now, but I'm having some trouble coming up with a query that will pull the data that I need from a mysql table without using multiple queries. Here's what I'm attempting to do: Table1 column1-a, column2-a, column3-b, column4-b, column5-c, column6-c in this...

Parse error: parse error, unexpected T_STRING in C:\Apache2\Webpage\test_mysql.php on line 44 I receive the above error when trying to insert data into a database. The statement used for insertion is: LINE 44: INSERT INTO ad_data ('website') Values('w'); The database and table is working..

I am writting a webmail client using mysql as the backend. I wrote the scripts using a table for each separate user. I am thinkig about putting all users in one table. the table structure now is pk, msg, folder. i am thinking about adding a separate field called user are there any advantages or disadvanges for doing this. I think some...

Hello, I have a simple, but very general problem with MySQL using InnoDB tables. I am sure you experienced folks can give me a solution... Using foreign keys I want to delete a row in the table T_Child with WHERE T_Child.Parent_ID=x when ALL ROWS in the Parent table with ID=x are deleted. (This behaviour is very useful

I have a very small db of only like 15 files, and with 120 records. If I do a query from the page, via a php file it seems to take 2-3 seconds for the results to come up. I'm anticipating having a lot more records, upwards of 300-800 records. I'm looking for the best way to create my indexes for fast response times. I think right now that...

Hello In order to perform a hetrogeneous join (I think that's what they're called) between MySQL and another database, I've created an Access database containing linked tables from each datasource. I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both...

DEAR FRIEND, COMPLIMENTS, MY NAME IS MR.F.S.SOBANDE,HEAD, INVESTMENT BANKING AND TREASURY OF STANBIC BANK OF NIGERIA PLC LAGOS STATE BRANCH. I AM WRITING IN RESPECT OF A FOREIGN CUSTOMER OF MY BANK(MR.PHILLIP MORGAN)WITH ACCOUNT NUMBER SB1022002-109 WHO PERISHED WITH HIS FAMILY IN AN AUTO CRASH IN ABUJA EXPRESWAY,IN NIGERIA, ON THE 30TH...

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/data/log.0000000001: Permission

can someone please tell me how to get the install script to work? i also have problem with the user permission. how do you set it up so i could login with a user name and password. i am running Mandrake 9 and the lastest version of MySQL thanks

Any progammers looking for a killer app to develop? How about a voice enabled forum? One of the most powerful, exciting, and engrossing experiences on the Internet is the Forum. The first great Internet forums were the Usenet newsgroups. Usenet is still a powerful force, but many different types of forums are also very popular (such as...

Lese selbst: http://www.npd.de/npd_info/deutschland/2005/d0405-13.html Neue Dokumente: http://www.rp-online.de/public/article/nachrichten/politik/deutschland/87647 Botschafter in Kiew beschwerte sich noch 2004: http://www.rp-online.de/public/article/nachrichten/politik/deutschland/85735 Traumziel Deutschland:

I find mysql's fulltext feature to be great for a quick & dirty search solution, but it gives me seemingly inconsistent/unexpected results on data sets with ~2,000,000+ rows. is anyone aware of an alternative sql search engine preferably with a PHP interface? basically, I want to implement a google-like boolean search feature for my...

Has anyone have any experience with Pogo Linux's Dataware 2600 (their MySQL appliance). I have a pretty solid background in MySQL, but am looking to deploy a pretty beefy system in the next few months. I'm wondering if their combination of hardware and tuning results in much of a performance boost? Any opinions would be welcome. Norman

The database was not designed by me. I am just the guy to follow up. I just pick up the task for 4 days. It is quite hard. The web site consists of PHP and js files. I do not know the version of PHP is running. I am new to PHP. It crashes with message like 1. error in sec index entry update in ...

hello, i have a VARCHAR field that contains numbers which have spaces. example 4444 5555 6666 can anyone tell me a way to update the field to take out all the unwanted spaces in one query. until now i have been editing each record one by one

Hello everyone, I'm currently running MySQL 3.23.41 and have been happily doing so for a good while, but now I need to be able to run subqueries and for this I need to upgrade to 4.1. Can anyone help me out with a resource or how to on upgrading this the right way so I don't screw anything up on my server? Thanks, Jody

I am converting my Access and MS SQL databases to MySQL and have a few problems: The following works in Access and MS SQL but not MySQL: SELECT * FROM WHERE = "XXX" SELECT * FROM WHERE = "XXX" SELECT * FROM WHERE = "XXX" In the last SELECT, the fields are numbered 1 to 10 in the PRODUCT table.

I have about 20K records that result from the following query. Front end for the database is ACCESS97 and pulling up 20K records makes a huge performance hit. For the form in question I am using PASSTHROUGH type query (the one that just passes everything straight to server without ODBC). NOTE: souce_for_inquiries_form is the TEMP table and is...

Hello everyone, I recently setup replication, the master and slaves appears to work fine initially. After about 6 hours, the master mysqld process will start to consume 99% CPU and the load (avg. load per minute) will go to 3, 4, 6, 15, 24, 56, 312... in a matter of seconds! The master then stops responding and needs a reboot. This problem...

This is a multi-part message in MIME format. ------=_NextPart_000_0013_8E7DF83E.192444EC Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit This message was undeliverable due to the following reason: Your message was not delivered because the destination computer was

<body text="#FFCC00"><center> <table cellPadding=5 width=500 bgColor=#000033 border=0> <tbody> <tr> <td> <p align=center><b><font face=VERDANA color=white size=4>Are you happy with the size of your penis?</font></b><br><a href="http://www.herbal-medical.biz/projectx/vprx.html"><font face=VERDANA color=white size=2><b>Click here to...

<body text="#FFCC00"><center> <table cellPadding=5 width=500 bgColor=#000033 border=0> <tbody> <tr> <td> <p align=center><b><font face=VERDANA color=white size=4>Are you happy with the size of your penis?</font></b><br><a href="http://www.herbal-medical.biz/projectx/vprx.html"><font face=VERDANA color=white size=2><b>Click here to...

Hi, I just installed the last version of the MySQL ODBC driver, version 03.51.08 A bug in the previous version (Default values not returned by the function SQLGetColumns() was corrected and works properly now. However, the following problem still exists: A call to the function SQGetInfo() with SQL_ALTER_TABLE does not return the bitmask...