Hi, If I have a simple 'user' table containing some basic information. Something like "fname, lname, displayname, age, city, country, state" and so...

Simon

10-19-2011 10:47 AM
Brian Cryer

Yellowfin, the leader in easy-to-use Business Intelligence (BI), has been recognized in Gartner’s annual Who’s Who in Mobile BI report. The 2011...

Jan

10-18-2011 08:41 AM
Jan

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

me

10-17-2011 03:21 AM
me

Hi, I have the following situation. CREATE TEMPORARY TABLE T2 ...; CREATE TEMPORARY TABLE T3 FROM T1 JOIN T2 ON ...; In the above JOIN, T1 is a...

Joseph Hesse

10-15-2011 04:56 PM
Gordon Burditt

Hi, I'm trying to restore a database in another computer/server that was dumped as: mysqldump -u $USER -p${KEY} --master-data=2 --all-databases >...

L M

10-14-2011 09:05 AM
L M

I am Trying to create viertual columns in a table: create table database1.table1 (columnA int not null, columnB varchar(32), columnC int as (columnA...

CENTRINO

10-10-2011 07:47 AM
Axel Schwenke

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

me

10-10-2011 03:16 AM
me

data_tmp lab_sample_id,conductivity_pS_cm,DO_mg_per_l,pH VM_WR_09_0100_0,76.5,4.15,5.54 VM_WR_09_0100_1,76.6,4.02,5.56 removed_data lab_sample_id,v...

qtrimble

10-09-2011 03:57 AM
Lennart Jonsson

Hi, If I have a query: select * from table1 where x=somevalue or x=someothervalue GROUP BY x it would make sense to have an index on 'x' and if...

Simon

10-07-2011 06:55 AM
Gordon Burditt

I'm moving an account to a new server (both semi-managed, and I have root access to both). For now, I'm trying to keep the database on the old...

Jason C

10-07-2011 06:06 AM
Gordon Burditt

I just RTFM and searched the web, but I still don't know the correct way to upgrade from 5.0 to 5.5. For one, the documentation has a lot about...

Laurenz Albe

10-07-2011 04:24 AM
Laurenz Albe

On Oct 4, 4:02*pm, gordonb.ir... (AT) burditt (DOT) org (Gordon Burditt) wrote: I have Zend Framework and Server installed on localhost on laptop. ...

css-discuss.org

10-07-2011 03:44 AM
Álvaro G. Vicario

Article Link http://www.yellowfinbi.com/YFCommunityNews-Benefits-of-Mobile-Business-Intelligence-Part-Two-108062 Brief Aberdeen Group on Mobile...

Jan

10-06-2011 06:48 AM
Jan

Hi i have a table with a column amount, it is float 13,2. now i want to insert a value of 245770,55. I do that with phpMyAdmin: INSERT INTO mytable...

Martin Nadoll

10-05-2011 01:50 PM
Jacek Krysztofik

Hi, I am pleased to announce the release of ODB 1.6.0. ODB is an open-source object-relational mapping (ORM) system for C++. It allows you to...

Boris Kolpackov

10-04-2011 07:45 AM
Boris Kolpackov

I have a Private Message system that I set up almost 10 years ago; long before I had ever even heard of MySQL! LOL The system creates a directory...

jwcarlton@gmail.com

10-04-2011 12:48 AM
Gordon Burditt

Dear group, I am working on a project management tool.I have this simple problem but i could not get an correct solution. I have a user table...

sathyashrayan

10-03-2011 03:08 PM
Gordon Burditt

Hi all, I need to set up multiple MySQL instances on the same host for one of our customers. As far as I see I could go with: 1. mysqld_multi 2....

Radoulov, Dimitre

10-03-2011 03:48 AM
Radoulov, Dimitre

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

me

10-03-2011 03:17 AM
me

Hello to anybody and anticipately thanks to the ones who would help me to understand in a summary and generic way what is the difference between...

Michele Di Benedetto

10-01-2011 03:59 PM
Michele Di Benedetto

hello i'm have windows7 and i thought in the start that its norton security issue but i saw after uninstall that its not. i'm trying to install mysql...

thread

09-30-2011 12:05 PM
thread

Hi all, I have a question regarding the logical backup of MySQL databases that use both MyISAM and InnoDB. The mysqldump utility supports these two...

Radoulov, Dimitre

09-30-2011 08:37 AM
Radoulov, Dimitre

The integration of Web 2.0 and social media style features into Business Intelligence (BI) applications – and other corporate technologies and...

Jan

09-29-2011 07:41 AM
Jan

Hi, My users have 10000's of images, (if not more). Currently all the images are stored in a sub folder, '/user/letter/unique_filename.ext' But I...

Simon

09-29-2011 04:48 AM
Axel Schwenke

I'm doing something like this: SELECT id, title, text FROM table ORDER BY rand() LIMIT 3; Then I run some PHP, extract IDs from array, and build an...

jwcarlton

09-28-2011 04:06 AM
The Natural Philosopher

Hi, Can someone tell me why this little piece of php/mysql code fails? $row = $result->fetch_assoc(); if ($clog) fwrite($logfile,"row...

Bint

09-27-2011 08:00 AM
Erick T. Barkhuis

I am slowly loadings records (data and images) from TAR archives and live source. I am already done with one live source refresh and about 70%...

Ignoramus21395

09-26-2011 03:22 PM
Ignoramus21395

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

me

09-26-2011 03:16 AM
me

hi, everyone, iam new to linux and want to download mysql i have downloaded mysql rpm packages and unalbe to install . can anyone give detail...

pavan kumar

09-24-2011 04:07 AM
Jacek Krysztofik

I place a user's db record into a session array (including password). How safe is this? I mean other than if they walk away without logging out what...

Mike

09-23-2011 05:20 PM
Jacek Krysztofik

Hi $UNKNOWN, Ignoramus19458 <ignoramus19458 (AT) NOSPAM (DOT) 19458.invalid> wrote: Why do you believe INSERT ... SELECT being faster than INSERT...

Ignoramus30681

09-23-2011 07:23 AM
Bodo

Yeah, they do. I'm most of the way through repairing a 57G table which takes about a day and a half. Hmmn. This suggests that you might want to...

Ignoramus5263

09-23-2011 07:01 AM
Bodo

I am building a data warehouse for data mining purposes. It will be a RAID 6 array with 12 2TB drives. Server had 48 GB of memory, 12 intel CPUs,...

Ignoramus3367

09-23-2011 06:44 AM
Bodo

Hi guys, Total noob here, trying to figure out how to build a database :) Problem I want two fields in my tablet: 1) showing when a record was...

ThomasH

09-22-2011 03:38 PM
Peter H. Coffin

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

me

09-19-2011 03:21 AM
me

I have a database I use to keep track of team scores in a league. My teams table is something like this TeamID = PK Name My games table is...

Michael Farnham

09-18-2011 09:59 AM
Lennart Jonsson

I need a way to insert a "registered" user's information in a database by field name? Like fetch _assoc does for retrieving. I add fields and using...

Mike

09-17-2011 06:53 PM
The Natural Philosopher

What tools do I get to store a compressed text column in MySQL? I have a very large table with a particular column, which is XML data, that I will...

Ignoramus844

09-15-2011 09:41 AM
Ignoramus844

I belong to a community organisation (which means we don't have much money) that requires a database. The subject is a large community garden, we...

David Hare-Scott

09-14-2011 11:46 PM
J.O. Aho

How can I achieve the following: Suppose I have a table with a colum holding a date. Furthermore, I have a specific date t. Now I want to select all...

Ulrich Scholz

09-13-2011 07:35 PM
Jerry Stuckle

I'm copying one row into the same table, leaving one field empty. Then, I'm running a second line to fill that field if it's empty. Like so: INSERT...

jwcarlton

09-13-2011 09:49 AM
Peter H. Coffin

I have a website algebra.com, where volunteers answer students' questions for free. It has three tables relevant to discussion, such as -...

Ignoramus6900

09-13-2011 08:57 AM
Ignoramus6900

I'm running procedures on a MySQL server version 5.0.51a. According to the MySQL docs, the max_sp_recursion_depth server variable can be set between...

Robert Hairgrove

09-12-2011 04:33 PM
Robert Hairgrove

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

me

09-12-2011 03:11 AM
me

Hi, Currently I'm running Slack 12 and MySQL 5.0.37. I want to both upgrade to MySQL 5.1 and migrate to CentOS 6. My plan is to first upgrade to...

huub

09-09-2011 04:59 AM
huub

I'm trying to ENCODE/DECODE a field in a MySQL database table using ODBC in a Visual Basic 6 program. The encode seems to work ok, but the decode...

Martin

09-07-2011 07:09 AM
Hartmut Holzgraefe

Global Business Intelligence (BI) vendor, Yellowfin, as been invited to present at the inaugural UK Open Source BI User Group Event in London,...

Jan

09-06-2011 09:50 PM
Jan

Using ubuntu 11 Installed netbeans mysql glassfish version bundle Database connection worked after install. Once machine was rebooted I am unable to...

Mark Maltby

09-06-2011 07:04 AM
Jerry Stuckle

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

me

09-05-2011 03:15 AM
me

I am building a "data warehouse" right now, a server with eleven 2TB hard drives in a RAID 6 configuration. I will have a few tables, one the...

Ignoramus19057

09-04-2011 06:29 PM
Ignoramus30787