Hi, I've a Mysql 5.0.66sp1 source distribution on a RedHat 5.4 64bit and my problem is that when I make a remote connection to the mysql server...

iass

01-17-2010 09:06 AM
Ivan Saez

Scenario --------- 1. My client has a database on its web server. 2. I am running a portal on another web server. 3. At a particular time, I need...

sl@my-rialto

01-16-2010 06:06 AM
The Natural Philosopher

I intend to create a database to enumerate / explore a large search space. It'll grow to any available capacity - I've got about 350GB available,...

ReaanB

01-15-2010 08:22 AM
ReaanB

Hi! I'm trying to create a trigger that upon INSERT in one table, data is taken from another table and logged alongside the id of the newly inserted...

CALdan

01-14-2010 10:43 PM
CALdan

I've read rand() is slow, so I dont want to use it. I've searched on Google and looked at possible alternatives but they always do it for 1 row, or...

Frank Peterson

01-12-2010 05:23 PM
toby

Jerry Stuckle is consistent top poster in terms of number of posts and bandwidth occupied in: comp.lang.php comp.databases.mysql Jerry Stuckle...

The Natural Philosopher

01-12-2010 10:10 AM
phpCodeHead

Hi There, I'm having a bit of a problem with a MYSQL query, I think it’s a simple one, only I can’t figure it out! I'm trying to select dates...

BPG

01-12-2010 01:17 AM
BPG

I was developing an application for myself, but now other users want to use the software. Short of modifying the database names in my application, ...

SpreadTooThin

01-12-2010 12:03 AM
Gordon Burditt

ravel wrote: OK, how slow is "slow"? 1 second? 1 minute? 1 hour? How many rows do you have in each of the tables? What indexes do you have on...

ravel

01-11-2010 11:18 AM
Peter H. Coffin

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

me

01-11-2010 03:13 AM
me

given a postal weight, and a table of costs and services versus weight ranges, what's the simplest way to pick the lowest weight that is more than a...

The Natural Philosopher

01-09-2010 12:38 PM
The Natural Philosopher

Hi, I've never used triggers before & am having problems getting one to work correctly. I have created an application that pulls info about users...

Jason

01-09-2010 06:50 AM
Jason

I am trying to reset a field UPDATE addresses SET telephone = NULL WHERE addressid=114; Field telephone is defined as NOT NULL. I can change NULL...

bruce

01-08-2010 09:36 AM
Captain Paralytic

Hi there, I'd like to duplicate all tables within a database. I know how to duplicate individual table like this: CREATE TABLE new_table1 LIKE...

Ross

01-07-2010 04:38 PM
Axel Schwenke

Not sure if I'm pointing myself down the right learning path, but here we go. I'm writing a stored procedure (sproc). In this sproc, I have a temp...

Casey

01-06-2010 05:30 AM
Willem Bogaerts

I got this error starting mysql from installation: sh-3.2# /usr/local/mysql/bin/mysql -user=mysql ERROR 2002 (HY000): Can't connect to local MySQL...

JRough

01-05-2010 07:20 PM
JRough

Dear all, Although I'm using MySQL, this is more of a general SQL question, so apologies in advance if it should be posted elsewhere! If I have the...

ChrisW

01-04-2010 05:22 AM
Lennart

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

me

01-04-2010 03:21 AM
me

Arne Vajhøj wrote: Yes, they do. But the do not recommend using pools which have connections which are unused for great lengths of...

RVic

01-03-2010 08:57 PM
Jerry Stuckle

I would encourage all of you to sign this petition. Down with Oracle's stranglehold with the database...

Steffan A. Cline

01-02-2010 01:30 AM
J.O. Aho

The basic steps in the mysql binary installation instructions README: shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell>...

JRough

12-31-2009 05:22 PM
Captain Paralytic

Hi, if in my web application I started to save data in MyISAM I can at any time to bring them to innodb? thanks in advance

alberto

12-31-2009 05:15 PM
Captain Paralytic

houghi wrote: I don't think you understand what Peter is saying. In a larger project with multiple people working on it, ANY alteration to the...

Derek Turner

12-29-2009 08:52 PM
Jerry Stuckle

Derek Turner: Right. So here we have a 'status' attribute for entity Event. Or yu could introduce a workflow-like manner of registering statuses by...

Derek Turner

12-29-2009 05:18 AM
Jerry Stuckle

Hi, I need to make a copy of a db. This is for testing purposes. The copy will be resident on the same machine. So, a 'show databases' would look...

gamename

12-28-2009 12:51 PM
gamename

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

me

12-28-2009 03:10 AM
me

I like MYSQL Administrator. I like MYSQL Query Browser. I like MYSQL System Tray Monitor. Please don't take away them. thanks.

Ccming

12-28-2009 03:09 AM
Álvaro G. Vicario

In Oracle, the way to create auto-increment field is to create a sequence and update via trigger. But since MySQL does not have sequence, what are...

Ryan Chan

12-27-2009 05:35 PM
Gints Plivna

If I have the folllowing query: SELECT associates.username, ups.d, DATE_FORMAT(ups.t , '%T') as 'Time' FROM associates, ups WHERE...

RVince

12-25-2009 03:37 PM
RVince

I am building a PHP/MySQL application that lets users vote for answers to survey questions, in order to determine the most popular answers to each...

Robert Maas, http://tinyurl.com/uh3t

12-24-2009 01:19 PM
Robert Maas, http://tinyurl.com/uh3t

Hi Guys, Hoping someone could point me in the right direction, i am trying to run a report to get the amount of live and relinquished...

David

12-23-2009 04:03 AM
David

I was trying to think of how to do an exact phrase search database design yesterday, and this is the design that I came up with. You'd start off...

D Finnigan

12-22-2009 01:48 PM
D Finnigan

Hi all, I was informed by our security team about recent attack attempts related to the following MySQL issue/bug: MySQL_Check_Scramble_Auth_Bypass...

Radoulov, Dimitre

12-22-2009 07:33 AM
Peter H. Coffin

Bonjour, je suis sous Server version: 5.0.83-standard-log MySQL Community Edition - Standard (GPL) J'ai des connexion du type quand je regarde les...

user@domain.invalid

12-21-2009 02:34 PM
user@domain.invalid

I found it -- first of all that WHERE is not supposed to be in there, but that didn't fix it. I needed to use LIMIT by itself, without the ORDER...

Bint

12-21-2009 01:15 PM
John Nagle

Hi, I'm open-sourcing some of my work and including some scripts to set up the database component of the project. Because there's a...

Taliesin Nuin

12-21-2009 01:01 PM
John Nagle

Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 21 Dec 2009 08:55:28 GMT Stats Begin...............: Mon, 14 Dec...

me

12-21-2009 03:11 AM
me

Hi all. I've have a list of IPs (unique, ~45k rows) and i'd like to make a query that returns for each IP the city/country wich belongs to. The...

Giovanni

12-20-2009 02:10 PM
Giovanni

Hi All, I need to do this kind of query. Consider a table composed by 2 fields, the first Date as DateTime and the second Value as Double. This...

fittizio

12-20-2009 01:02 PM
Jerry Stuckle

Is there a command to see how much total resources were used to construct a result set? I have some reports I'm running in php, and on my web host,...

lawpoop

12-17-2009 01:40 PM
lawpoop

Captain Paralytic wrote: Eggzaggly. -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex...

SQL newbie

12-16-2009 11:22 AM
edward

Many, many thanks to all who contributed and tried to help me. In the end I did it the 'Windows way' and simply reinstalled the OS. Id been messing...

Derek Turner

12-15-2009 10:32 AM
�lvaro G. Vicario

Hi all, can any one have mysql cerfification model question papers or materials . If any one have could you share with group. thanks and...

sudheer

12-15-2009 02:35 AM
sudheer

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

me

12-14-2009 03:15 AM
me

I'm just starting to play with mysql on my own machine (apache2 on localhost). I have phpmyadmin installed on the same machine (linuxmint...

Derek Turner

12-11-2009 09:09 AM
Derek Turner

Hi everybody, I'm just wondering if there is a way to let each user in a defined database, have access to only their created tables . not other...

kevin kitenik

12-11-2009 07:27 AM
kevin kitenik

Hi everyone, a few weeks ago I saw a tutorial for mysql replication with two servers that looked like this: Server A is master of Server B, who is...

Yukari

12-10-2009 07:03 AM
Yukari

Hi, everyone This set of ideas was originally inspired by the adressbook of the mail client sylpeed-claws where you can define your own keys for...

Walter Anger

12-08-2009 11:31 AM
Walter Anger

Hi - I have a table with entries representing the stock for three shops, a fruit shop, a fish shop and a bakers. Each shop adds new items of stock on...

btnw

12-07-2009 10:04 PM
btnw

My replication server is segfaulting for a reason that is currently unknown. The log is as follows below: 091207 15:16:11 Neither --relay-log nor...

mahmoud abdelkader

12-07-2009 04:09 PM
mahmoud abdelkader