Yellowfin is launching the latest release of its Business Intelligence (BI) platform – Yellowfin 5.1 – and you’re invited! Join us in an exclusive...

JTP PR

11-24-2010 06:02 AM
JTP PR

Hello I have a column varchar(255) and a few rows with text. In all rows I want to delete the strings that have strings e.g. ...

pod

11-23-2010 10:54 AM
Luuk

Can the configuration file specified via "--default-extra-file=" contain a "password" entry (that has any effect)? I know I can (but don't) set a...

Phill W.

11-23-2010 09:39 AM
Phill W.

"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 22 Nov...

me

11-22-2010 04:26 AM
me

I want to return the primary key (keyID) and a text field(name) where the text field is Distinct. This would look like: SELECT keyID, DISTINCT name...

bruce

11-21-2010 03:31 PM
bruce

Hi, the following sql is not returning result I had hoped for (obviously my problem and not the sql). I would like to return an array as follows...

Chris Percol

11-21-2010 10:31 AM
Captain Paralytic

Gartner says social computing to change the face of IT and business Gartner has identified the impact of social media as one of four broad trends...

JTP PR

11-21-2010 07:15 AM
JTP PR

I have tow tables, that are slightly different because they cover tow slightly different ways of accessing data - one is URLS and the other is BLOB...

The Natural Philosopher

11-20-2010 05:40 AM
The Natural Philosopher

I just made a link between a MySQL database and a Filemaker database. I can reed information within Filemaker(FM) from the MySQL table. I even can ...

Harry

11-19-2010 09:50 AM
Harry

I just made a link between a MySQL database and a Filemaker database. I can reed information within Filemaker(FM) from the MySQL table. I even can ...

Harry

11-18-2010 06:55 PM
Harry

Hi all, I want to retrieve all posts which are not blocked for a particular country. e.g. the 3 tables involved are given below Table post id int...

mysqlNewbee

11-18-2010 02:25 PM
Luuk

This is more an inner workings of mysql question. I have an innodb table with 1+ billion rows. I took a small subset of that data and put it into an...

Jim

11-18-2010 01:27 PM
Captain Paralytic

I'm trying to select data from an existing database (not designed by me), but the data that I need to extract is stored within several tables. I'm...

David

11-18-2010 05:32 AM
strawberry

Hi, I have a table to store the login history of clients. One of the captured fields is the timestamp. I am trying to write a query to get all but...

Mark Smith

11-18-2010 04:49 AM
strawberry

my ci2 table: id,businessunit, zonenumber,zoneid, ndc There are 874 records that have 1 or more duplicates across zones with the 4 columns in the...

jr

11-18-2010 03:19 AM
Luuk

Hello, Sometimes I need to update datas just after a select, for example : SELECT * FROM users WHERE login = 'the_login' and password =...

Julien Arlandis

11-17-2010 07:42 PM
Doug Miller

Hello, I use mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2. I created database: CREATE DATABASE ogloszenia...

Jivanmukta

11-16-2010 07:52 AM
Jerry Stuckle

Hi guys Lets say I have a table: Stats (id, person_id, creation_date) I want to select stats for person_id = 1. I need to retrieve a count(*) for...

pac Man

11-16-2010 07:08 AM
pac Man

Hello, I'me not able to solve a character set problem. I have two linux PC: PC1 is OpenSuSE 10.2 and PC2 is OpenSuSE 11.3. Database is on PC2. Table...

Alessandro Topo Galileo

11-15-2010 08:59 AM
Alessandro Topo Galileo

"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 15 Nov...

me

11-15-2010 04:27 AM
me

hi, all I'm handling something about sharding (or partition) recently. What I want to do is to add more machines or nodes to my system so...

Abioy Sun

11-15-2010 04:26 AM
Abioy Sun

Is the root user's name hard coded somewhere in MySQL or is it just any old name with all privileges? Thank you, Joe

Joe Hesse

11-14-2010 01:26 PM
Sherm Pendley

Since recently queries conversion became one of the most demanded features for competing migration tools. It wouldn't be an exaggeration to say that...

DBConvert.com - Database conversion solutions

11-14-2010 10:16 AM
DBConvert.com - Database conversion solutions

Yellowfin’s latest Business Intelligence (BI) application for the iPhone and iPad is now available from Apple’s App Store. BI software analyzes and...

JTP PR

11-14-2010 06:29 AM
JTP PR

I want to create a result set that contains the patient numbers and episode numbers of patients that have had transactions or payments in the prior...

bill

11-14-2010 06:01 AM
bill

Hi guys I have a problem in sorting rows for a table that is connected to a many-to-many table. Here is the structure: Table Person id,...

pac Man

11-13-2010 03:54 AM
Helmut Chang

Hi, I have a table that contains orders, but I only want to select the latest orders from every client. Every order has a client_id, so I tried...

jhaagmans

11-12-2010 12:55 PM
strawberry

Hi to everybody, i would like to find every record where the inserted text is not UTF-8, it's possible? The official MySQL manual doen'st report...

MacMax

11-11-2010 12:18 PM
MacMax

Hi guys! I'm rather new to MySQL Cluster, so let me ask a qustion that might seem a noobie one ;) Say, I have a cluster consisting of 4 data nodes,...

vadim

11-10-2010 11:55 AM
Peter H. Coffin

"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 08 Nov...

me

11-08-2010 04:28 AM
me

I have a daemon that's both an RPC server and a Mysql client. The daemon is linked with libmysqlclient_r.so.12. The Mysql server runs mysql-4.0.18....

Gary Mills

11-08-2010 03:09 AM
Axel Schwenke

Hello, I am working on an application working with a version 5 of mySQL. In our mySQL server, binary logging is enabled as replication of the...

Yo

11-05-2010 07:04 AM
Axel Schwenke

I want to do an update to a field that I left blank when I left it out of a mass insert. However, I'm having trouble thinking of how to phrase it....

Steven Lefevre

11-04-2010 03:18 AM
Álvaro G. Vicario

Hello, I am looking for a way to know the number of requests currently running on my mySQL database. I found the SHOW FULL PROCESSLIST command...

Yo

11-03-2010 11:53 AM
thoughtcrimes

hi all, i have a table that contains aes_encrypted data. is there a STANDARD way to backup restore it or should i write some php (or perl or...

cb

11-03-2010 03:19 AM
Álvaro G. Vicario

I'm trying to put together a table of transactions which are applied to accounts, the account holders are listed in another table. I'd like to have...

Robert Billing

11-02-2010 06:03 PM
Robert Billing

Hello, I am wondering what would be the most efficient way to synchronize two slave databases to a master database.. Basically I need an efficient...

Devin M

11-02-2010 03:16 PM
John Nagle

And for another question, how do I use records from one table to select records from a second, such as: CREATE TABLE answer SELECT * FROM table1...

Charles

11-01-2010 07:41 AM
Charles

"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 01 Nov...

me

11-01-2010 03:57 AM
me

I have a table where two or more columns together must be unique. How tell mysql that col-a + col-b must be unique in a row? How do you spell...

SpreadTooThin

10-31-2010 03:08 PM
The Natural Philosopher

Hi, Can someone smart please let me know what's wrong with this statement? UPDATE table CASE WHEN type='longvalue' THEN SET longvalue='Results' ELSE...

cronoklee

10-31-2010 09:09 AM
cronoklee

can you use the group by clause twice in an sql statement? sql = "SELECT PatientName as 'Patient Name', PatientID as 'Patient ID', PatientDOB as...

SpreadTooThin

10-29-2010 03:39 PM
matt

I have an unknown MySQL version where PASSWORD("admin") returns a 16- char string, 43e9a4ab75570f5b Can anyone tell me what encryption method this...

ashore

10-28-2010 10:58 PM
Jerry Stuckle

In part one of our mini blog series exploring cross-industry uses and benefits of data analysis – Data analysis for the Retail Industry – we explored...

JTP PR

10-28-2010 08:12 AM
Jerry Stuckle

I'm trying to set up a table that has the fields: cab number call number latitude of cab longtitude of cab Latitude of call Longtitude of call And...

Charles

10-27-2010 02:18 PM
Charles

Hello, I am working on a C++ app using a MySQL database in version 5.0. For the moment, the requests for the databse are coded in the C++ part and...

Yo

10-26-2010 02:46 PM
Jerry Stuckle

I think I need a good book to help me wrap my head around how to construct effective SQL queries - this hit-and-miss thing is not working out well...

MikeB

10-26-2010 12:13 PM
Robert Hairgrove

Hello, I'm working on an application in C++ using a MySQL 5 database with ADO connection. I send an UPDATE query and I'd like to know how many rows...

Yo

10-25-2010 11:25 AM
The Natural Philosopher

"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 25 Oct...

me

10-25-2010 05:03 AM
me

Hi, I have a table with player names, scores, maps, and groups. A player can optionally belong to a group and one or more players can belong to...

MikeB

10-24-2010 05:59 PM
MikeB