I am trying to find a good guide for setting up mysql on a stand alone linux box just to play around with but I can't find any good one do you have...

Glen Davie

11-23-2005 02:32 AM
Giuseppe Maxia

Dears, Is there any simple way to convert characters from national characters to 'flat' ascii characters without using cast or convert functions? I...

11-21-2005 04:30 PM

I have MySQL 4.1 installed in my windows machine, now installed it on another machine and copied databases to that other machine thru our network,...

Frances

11-21-2005 10:42 AM
Frances

Jerry Stuckle wrote: Please consider snipping the 200 lines of code next time. Thanks. -- -bts -Warning: I brake for lawn deer

Beauregard T. Shagnasty

11-19-2005 12:42 PM
Matt Probert

This should be easy, but I've been fudging with this for a while so perhaps someone can help. I have 2 tables: fruit, fruitchoices. The first...

Bosconian

11-18-2005 08:00 PM
Bosconian

ARRRRRRRGGGGGHHHHH!! Please can you help, I'm going round the bend with this. I have a simple and small table called STOCKCATS, which I need to...

Laphan

11-18-2005 06:14 AM
Laphan

Hi, I installed phpbb on my website and all was well. All I did was "wrap" the php on the index.php in my html to match the rest of my site. now I...

Paul Watt

11-17-2005 08:45 AM
Jerry Stuckle

Command LOAD DATA is it transactional ? What's happens if loading 1000 rows, some rows goes in error ? Thank You in advance

Tony

11-16-2005 12:06 PM
Duane Phillips

Hi colleagues Pls help me. I have very important problem. I have 3 tables: tab1 - objects, index field tab2 - propertyes, index field tab3 - linc...

Stanislav V.Pshegoda

11-16-2005 03:31 AM
Stanislav V.Pshegoda

What is wrong with this code? mysql_query("LOAD DATA LOCAL INFILE '/usr/home/wei/dealerinv' INTO TABLE `inv` FIELDS TERMINATED BY '\t' ESCAPED BY...

DBLEXPOSURE

11-15-2005 11:05 PM
DBLEXPOSURE

Hi, do you know how can I declare a key on more tables? For example, if I have the table TABLE1 and the table TABLE2, every one with a field called...

myname@yahoo.it

11-15-2005 04:29 PM
Dikkie Dik

Is it possible to select from a table where the table name is itself data stored in a column? I Can't easily think of an example (and the real...

Rob Kings

11-15-2005 01:55 AM
Rob Kings

Hi all, I've downloaded and installed easygen2 and easyphp, but I can't seem to get it too connect to the mysql database. I've created a new DB with...

Paul Watt

11-13-2005 04:10 PM
Christian Kirsch

I'm new to mysql and was trying to compile the admin tool. The configure script complains about something called "pcre libraries". What is that? I'm...

Wayne Happ

11-12-2005 11:11 PM
Bill Karwin

Hi All One of my VarChar fields in my MySQL DB isn't big enough so I need to expand it. In light of this, could you please answer these...

Laphan

11-12-2005 10:08 PM
Jerry Stuckle

A short time ago, I upgraded to Debian testing/Etch. I found my "p" and "!" keys were dead ("P" and "1" were fine), only in mysql-client. They both...

s. keeling

11-12-2005 09:08 PM
s. keeling

Hi there I'm developing a large web application. Part of this web application will be storing numerical chart data in a MySQL table - these numbers...

Good Man

11-11-2005 11:36 AM
Giuseppe Maxia

ik zoek naar niewe flim

soe

11-10-2005 06:55 PM
Fester

Hi, How do I change the variable 'save_load_tmpdir' in MySql. ( it point to an non existing directory ) When I do set global save_load_tmpdir=<new...

Bruintje Beer

11-09-2005 12:05 PM
Bruintje Beer

Hi All Wondered if you could help me with the below query. I have 1 simple table called STOCKCATS that consists of 2 fields. These fields are...

Astra

11-08-2005 04:45 AM
Astra

Hi All, I just installed MySQL 5.0.15-win32 on a WinXP-Pro/SP2 workstation with plenty of RAM/HD resources. I elected to install all components. ...

Richard Lionheart

11-08-2005 12:10 AM
Richard Lionheart

I'm running MySQL on my production servers here. "--version" says "mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)". OS is RedHat Enterprise...

Dan M

11-07-2005 11:49 AM
Dan M

Hi, if I try to install mediawiki, I get following mysql-error, during running config/index.php: "Specified key was too long; max key length is...

Sebastian Noack

11-07-2005 10:42 AM
Christian Kirsch

Hello, where can I do to find information about Blob attribute with sql? How to estract files with blob attribute from sql database? Thanks

Giak

11-07-2005 02:39 AM
Laurenz Albe

Hi, I need a way to read a numeric field and then increment it by one in such a way that even if two users did this at the exact same time, they...

Lars

11-05-2005 07:32 PM
Lars

Hi! I'm setting up a multi-user system where I want different users to have access to different tuples in the same schema. So that, for instance,...

Matthijs Holter

11-04-2005 01:06 PM
Kees Nuyt

Please excuse this post if you've already read it on mailing.database.mysql - i just discovered these other groups. future posts will be crossposted...

Good Man

11-04-2005 11:38 AM
Good Man

Hi, I have a table with a field that contains a file path(www/docs/.../.../...) Some of the path contain this characters 'é' or 'è'. How can i do an...

VooDoo

11-04-2005 04:03 AM
VooDoo

Dear newsgroup, I'm having a critical problem with the MySQL Connector .NET 1.0.6. I'm developing a .NET (Version 1.1 SP1) application on a Windows...

Sven Jacobs

11-04-2005 02:24 AM
Sven Jacobs

Hello, where can I do to find information about Blob attribute with sql? How to estract files with blob attribute from sql database? Thanks

Giak

11-03-2005 03:51 PM
Giak

I have the following fields in a database: year integer(4) not null default '0' month integer(2) not null default '0' day integer(2) ...

Peter

11-03-2005 08:37 AM
Christian Kirsch

Have been using MySQL on an infrequent basis, mostly on web databases. Now the MySQL site is pushing both products. Both now support stored...

Duane Phillips

11-02-2005 07:48 PM
Duane Phillips

I'm loading tab delimited lines from a txt file using php and running a query for each line to enter the data into a mysql database. However the...

Techie Guy

11-02-2005 04:32 AM
Techie Guy

I have a small SQL Server database with a lot of tables. I'd like to migrate the data to MySQL on the same Windows server. Is there a Windows-based...

Bernard Peek

10-30-2005 12:52 PM
Bernard Peek

Hi All Wonder if you could help, I have a bog standard table called STOCKPRICES that has served me well for a while, but now I need to change the...

Laphan

10-27-2005 09:58 AM
Martijn Tonies

Who can tell me what's a good conversion tool from BDE (Paradox) to MySQL... It may be Shareware, but my budget is limited, so preferable...

Ron Tuijnman

10-26-2005 01:01 AM
Martijn Tonies

I have been asked to compose a query to return the metadata of a function or procedure (MySQL 5.0): argument names and types, IN or OUT, return value...

Laurenz Albe

10-25-2005 01:51 AM
Laurenz Albe

Hi, I am not 100% happy with my understanding of indexes and primary keys. I have a table with ID, Author and Text, (ID is auto increment) Most of...

Simon

10-24-2005 02:47 PM
Bill Karwin

Hi, can someone recommend a freeeware (!) frontend to MySQL? Regarding the usability I really like MySQL-Front and am looking for something...

Anja Länge

10-24-2005 04:57 AM
nico rijsmus

Hi! How much traffic does a master/slave configuration produce beyond the inserted/updated data? As to say: How much "meta"-traffic is to be...

Marco Dieckhoff

10-24-2005 04:54 AM
nico rijsmus

Schraalhans Keukenmeester wrote: Race condition? If user 1 increments the $msgid and user 2 selects count(*) before user 1 has added her message ->...

Christian Kirsch

10-22-2005 08:18 AM
Christian Kirsch

Jimi Hullegård wrote: comp.databases is probably the closest thing to a general SQL newsgroup. Consider this example of a many-to-many...

Bill Karwin

10-22-2005 05:23 AM
Tony Marston

I am using the following query : $query_archief = "SELECT * FROM vacatures where dd_eind_plaatsing < $dd_eind_plaatsing_archief1" note:...

roy

10-16-2005 06:57 AM
Kai Ruhnau

hi, how would I query my table to return only the records where the field 'mobile' has a valid mobile telephone number. Valid being.. begining 07...

10-15-2005 02:04 PM
Giuseppe Maxia

Occasionally, I'm running into the following exception, and it is starting to be a pain... SQLException: Unable to connect to any hosts due to...

Rob McDonald

10-14-2005 06:50 AM
Rob McDonald

Hi All, I'm putting a website together using PHP and a MySQL database. I've been using phpMyAdmin as it makes updating the DB nice and easy. For...

Dave Moore

10-13-2005 03:35 AM
Axel Schwenke

Good day, and thank you in advance for any help. I am a new MySQL user, and have just recently begun to learn something about PHP. I usually work...

Serious_Practitioner

10-12-2005 02:44 PM
Serious_Practitioner

hi to everybody. i'm a newbie in the world of mysql and i've got a problem with the access to a database. i created a user 'default', from host %,...

francesco

10-12-2005 03:25 AM
Fra

Hello, I'm building an application (well, going to... ;) and am looking for a -hopefully- free database with countries and cities (linked) that I...

Job

10-09-2005 03:01 PM
Job

Oracle buys Innobase Oy: http://www.oracle.com/corporate/press/2005_oct/inno.html http://forums.mysql.com/read.php?3,48400,48400#msg-48400 XL

Axel Schwenke

10-08-2005 02:56 AM
Axel Schwenke