I am a newbie to Data Warehousing, and am about 2/3 the way through Ralph Kimball's "The Data Warehouse Lifecycle Toolkit." It's nine years later,...

Dano

08-11-2006 03:07 PM
Dano

Hello all, I am attempting to bring over a MySQL database from a Windows XP server to a Sun Solaris server. I seem to be having permission problems,...

dborenst@gmail.com

08-11-2006 10:59 AM
dborenst@gmail.com

Hi I'm in need of creating reporting database. What I have to do it is to replicate only half of tables to next database so reports could query only...

Radek

08-11-2006 09:07 AM
Steven Musumeche

I am trying to optimize a union query for which the union result is a type of all, but when each component is explained the types are either ref or...

No bother

08-11-2006 07:50 AM
No bother

Hi all , I have sql statement below...

AT

08-11-2006 04:06 AM
strawberry

Hi, I have a table, which is loaded once and never updated. One of its columns is string (titles up to 100 chars). The content of this column will...

Vadim

08-11-2006 03:58 AM
Vadim

After creating a new user and executing "mysqladmin flush-privileges" I have lost all my privileges, I cant connect as root or any other user. Any...

razedk

08-10-2006 05:25 PM
razedk

Hello My web hosting company has lost my data due to the mysql software failing, it only affected those people using innoDB engine. I asked them why...

mantrid

08-10-2006 12:43 PM
Bill Karwin

I want to do the equivalent of SELECT id from TABLE WHERE text='text' only fast solution I found is: SELECT id,text from TABLE WHERE MATCH(text)...

AT

08-10-2006 10:39 AM
jmichel

Ok, I was making some changes in privileges and must have deleted the localhost account... it seems I'm pretty much locked out. Is there...

Bill H

08-08-2006 01:24 PM
Bill H

So I need to load lots of data into my database. So I discover LOAD DATA INFILE. Great! This little gem loads my CSV in blazing times (compared...

greywire (AT) gmail (DOT) com

08-08-2006 10:15 AM
Thomas Bartkus

Hi I wish to perform a search on a column of a table. The column contains surnames. I wish the results to return the entries which contain more...

Stephen Preston

08-08-2006 06:00 AM
strawberry

Hi All, can a mysql trigger call a php script? If so, how? I basically want a php script to be called everytime a field in the mysql table receives a...

AT

08-08-2006 03:59 AM
AT

Lets say i have a database where users can upload their dvd collection. I want to be able to do a query where i can select all the users who have a...

ryan

08-06-2006 05:08 PM
Jerry Gitomer

Hi All, I'm new to mySQL. Is it possible to cluster mySQL on a Windows 2003 cluster. I need to create HI reliability mySQL database that IIS...

Lion

08-06-2006 04:46 PM
Lion

hi, i'm new to sql i'd appretiate if someone would helpme out with this doudt i have CODE: CREATE TABLE entry ( uno int(6) NOT NULL...

AT

08-06-2006 01:48 PM
Bill Karwin

Hi! My company make several flash-based games, and I use php to communicate with mysql to provide highscore-lists. My problem is this: When I save a...

ojorus

08-06-2006 07:58 AM
Norman Peelman

------=_NextPart_000_016C_01C3453B.E114CE50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable i downloaded...

jp

08-05-2006 11:19 AM
sxd

I use the DES_ENCRYPT and DES_DECRYPT with the string 'sfG3853ncr1pt' I can't seem to encrypt the number 227968199 because I tried several times and...

AT

08-04-2006 04:27 PM
AT

I've been using a document management system called FileFox on a Windows 95 platform and need to migrate the data from FileFox (apparently stored in...

AT

08-04-2006 12:27 PM
AT

Hi all , I have 2 table as show below : When do join the 2 table using SQL statement , how i going to order by Table A sw_version then Table B...

AT

08-04-2006 12:19 PM
No bother

I have a table which has, among other fields, a date field. I want to get a count of records where certain criteria are met for, say, three days in...

No bother

08-04-2006 10:55 AM
strawberry

Can anyone recommend, preferably based on first-hand experience, a vendor that supplies Mysql training over the web, or other Internet medium? I...

No bother

08-04-2006 10:16 AM
No bother

Hi all I'm interested in exploring the match query for a site in doing. can u return the relevance of a match query in percentage form? Also where...

mcyi2mr3 (AT) googlemail (DOT) com

08-04-2006 09:48 AM
mcyi2mr3 (AT) googlemail (DOT) com

I volunteer for a non-for profit group and they have alot of names in a multiple databases. the problem is that some people are in...

Stephen

08-04-2006 07:11 AM
Stephen

(originally posted in database.myodbc by mistake) I'm trying to speed up a fulltext search (MySQL 5.0.21, table has 670,000 records, about...

AT

08-04-2006 06:55 AM
AT

How would I write the query for mySQL to get all the records in a table that were written in tha last 10 minutes? I have a timestamp field (fldTime)...

Dave

08-03-2006 02:54 PM
Dave

Hello all Is there a yes/no boolean datatype with mySQL? I can't seem to find if there is, and I have used an int type set to 1 or 0 but that breaks...

Dave

08-03-2006 05:56 AM
Dave

Hi, We have a mysql database for which I would like to create a documentation. For this I am searching for some tool that can read the database...

AT

08-03-2006 02:41 AM
AT

Hi all, Is there a way to get a list of all the words in a specified fulltext index? I'd like to be able to query the index for instance to get...

Ruben van Engelenburg

08-03-2006 02:31 AM
Ruben van Engelenburg

Hi there, I'm not sure how to select the last 3 items in ascending order. This does the trick in descending order: select * from...

Nick Weisser

08-02-2006 02:36 PM
Thomas Bartkus

Hi My mysql 4.1 has a username max char limit of 16, how to enlarge it? thanks from Peter (cmk128 (AT) hotmail (DOT) com)

AT

08-02-2006 02:02 PM
AT

SELECT table1.url FROM table1, table2 WHERE table1.linkid=table2.id AND table1.type='xyz' AND table2.status IN( 'Yellow')...

AT

08-02-2006 01:54 PM
AT

Hi there, Apologies for cross-posting... Does anyone know of any good tools - third party or otherwise - that will check your MySQL database for...

AT

08-02-2006 11:42 AM
Bill Karwin

I need some quick help with constructing a MYSQL query to help solve a small problem that I have. I havea table in my database where I need to...

AT

08-02-2006 11:42 AM
AT

Folks: We have a web-based app that's _really_ slowing down because multiple clients are writing their own private data into a single,...

Randy

08-01-2006 04:12 PM
Randy

I know this has been asked before and yes, I have read the section in the documentation about it. But, my question is: If I have setup mysql with...

AT

08-01-2006 01:46 PM
Bill Karwin

When I ran version 4, mysql would start as many mysqld process as it needed. This would vary depending upon how busy it was. As a lay perosn I will...

AT

08-01-2006 12:15 PM
AT

Hello, I must sort a table width only one column. Inside the field I have, for example, hard disk capacity (something like '100Gb' or '80Gb'...

andrea.demagistris (AT) libero (DOT) it

08-01-2006 08:51 AM
andrea.demagistris (AT) libero (DOT) it

Does linking tables with JOIN offer any significant performance advantage or does it just make things more simple from a...

AT

08-01-2006 12:00 AM
AT

Hello all! We make use of a PACS (Picture Archiving and Communication System) and system to store DICOM (Digital Imaging and Communication in...

Jonathan

07-31-2006 01:33 PM
Jonathan

Hi All, i need to know how to solve the error in the following query: UPDATE table1 SET StopTime = NOW() WHERE StationId = (SELECT StationId FROM...

AT

07-31-2006 12:58 PM
Bill Karwin

Hi I connect to my MySQL database using MyODBC. I have a table called 'log' in a database called 'home'. When I try to do an insert like...

Control Freq

07-31-2006 06:28 AM
superfly

I have a small LAN with my workstation (Win98SE), a Win/2000 system and a Linux system. I have MySQL servers running on the last two systems and I...

clb

07-31-2006 12:37 AM
Bill Karwin

hi all. How do i enable pooling on mysql connection? this is my string. DRIVER={MySQL ODBC 3.51 Driver};" + "SERVER=dfdfd;" + "DATABASE=dbname;"...

AT

07-30-2006 02:43 PM
parez

Hi Everybody, I have a SQL server on a Linux Fedora machine and I try to use a GUI to connect to database I used different GUI like "Toad for...

Sam

07-29-2006 07:54 PM
Bill Karwin

Hi! Im writing a asp.net webapp and I need some help with scheduling of a stored procedure. I'd like to know if it's possible to have a stored...

AT

07-29-2006 07:38 PM
Bill Karwin

Hi All, I've been trying to build a Ruby-on-Rails plus MySQL application. I'm running Ruby 1.8.2, Rails 1.1.4 and MySQL 5.0.15-nt...

Richard

07-28-2006 05:52 PM
AT

I have transferred the data from Access to MySQL using MySQL's tool. The transfer worked great and saved me a lot of time (thanks MySQL). Now I'm...

Mike

07-28-2006 02:47 PM
Mike

Hi.. I'm facing a problem during inserting records in Mysql database. My table consists of 9 fields. When i try to insert 1000 records to this...

kokul_k

07-27-2006 10:52 AM
andrea azzini