TOM GUGGER INDEPENDENT RECRUITER 419-537-9447 tgugger (AT) sbcglobal (DOT) net

TOM GUGGER

10-18-2006 11:51 AM
TOM GUGGER

Hi! Have a problem with mod_auth_mysql. Compilation and installation of module done ok: # /usr/local/apache/bin/apxs -c -L/usr/lib/mysql...

zhenya.tkachenko@gmail.com

10-18-2006 08:06 AM
zhenya.tkachenko@gmail.com

Suppose we have to design a database for a recruitment agency. There will be a table "candidates" with fields "candidateid","last name","first name"...

phlype.johnson@gmail.com

10-17-2006 11:26 AM
Skarjune

Hello, I have a "slight" problem with the mySQL C API. I want to bind vectors for output/input prepared statements. However, the C API does...

The|Godfather

10-17-2006 09:07 AM
The|Godfather

what does a ~ mean in URL names? I see it a lot especially on .edu sites - nancy -

namcy@byuk.co.uk

10-17-2006 07:00 AM
Gordon Burditt

When I installed MySql on the Windows 2000 Proffessional ,it works fine.But I followed the same installation steps in Windows 2k Advanced Server.It...

divya

10-17-2006 05:37 AM
divya

In the my.cnf file, under I have log-error=/path/to/error log file directive. The last entries in this file are over an year ago. In case of MYSQL...

ipy2006

10-17-2006 05:17 AM
ipy2006

I am using 5.0.26-NT on Windows 2000. I have need to use a reference in the outer from clause in a subquery in the select clause. Consider the...

No bother

10-16-2006 07:27 PM
No bother

Hi, I try to use mysqli through ADODB to connect to my MySQL (5.0.15) database. I try to execute such a part of code: $date =...

njord

10-16-2006 02:38 PM
njord

First I should point out, that 99.99% of the time I have no problems with my server. Yes, it is semi busy but nothing that should bring MySQL server...

FFMG

10-16-2006 03:21 AM
FFMG

Hi, I have both MySQL 5 client and server running on a Linux Fedora Core 5 machine (x86 Desktop PC). Regarding hte client, what can I do to change...

laredotornado@zipmail.com

10-15-2006 08:54 PM
laredotornado@zipmail.com

Hi, Trying to connect to the MySQL server I get the classic error message ERROR 2002 (HY000): Can't connect to local MySQL server through...

Christian

10-13-2006 09:59 PM
Christian

hello, i have a database where there is a main table, documents, and then a relationship table doc_topics with one entry for each topic into which a...

plaidthermos@hotmail.com

10-13-2006 03:03 PM
plaidthermos@hotmail.com

Hello I have a table that I reckon its primary which is an autoincremented value is going to increase rappidly. I would like to know what is the end...

djjelly@gmail.com

10-13-2006 02:22 PM
djjelly@gmail.com

Hi I have two tables: first "points" with id, latitude and longitude, second "zipcodes" with id, zip, latitude, longitude. Id like to ask the query...

Ralph

10-13-2006 12:45 PM
Ralph

There appears to be an error with the database. You can try to refresh the page by clicking here. Error Returned mySQL query error: SELECT...

Thaqalainnaqvi@gmail.com

10-13-2006 07:46 AM
Thaqalainnaqvi@gmail.com

Kind readers, I am currently developing an app with PHP 5 & MySql 5. The following select statement works as expected from the MySql command line...

Diogenes

10-12-2006 12:59 PM
Diogenes

I want to run MySQL on server but it only be accessible to programs on localhost. I see that port 3306 is open on server so I need to close it. How...

Paul

10-11-2006 02:10 PM
Paul

Hi All, I'm trying to use the slow-query-log (with --log-queries-not-using-indexes enabled) to determine if any queries need optimization, and have...

Dave Hammond

10-11-2006 12:36 PM
Dave Hammond

Sorry, I double-posted this to comp.databases.mysql, big apologies. I forgot that I was subscribed to this NG as well.... Hi there I am trying to...

Good Man

10-11-2006 10:45 AM
shakahshakah@gmail.com

I can code around it for now but it would be handy to have a function similair to last_insert_id() that returns the primary key value of the last...

ctalkobt@gmail.com

10-11-2006 10:00 AM
ctalkobt@gmail.com

Hi All, I am loading data to a child table from a text file. the text files also contains data not referenced by parent key. while loading the...

kutty

10-11-2006 07:38 AM
Devi

Greetings! I've recently been trying to do something, which apparently looks like it may be a little odd.. I'm not finding anything in the manuals...

michael.martinek@gmail.com

10-09-2006 09:43 PM
michael.martinek@gmail.com

I recently upgraded my Mac (running OS 10.4.8) to Apache 2.0.52, MySQL 5.0.24 and PHP 4.3.9. While I seem to be accessing the latest MySQL from the...

Craig Bailey

10-09-2006 03:30 PM
Craig Bailey

Hi. I read somewhere that there is a limit to the way the score is calculated. As far as I remember the problem was that if the keyword in the search...

kristian

10-06-2006 07:47 AM
kristian

The udf was working fine for several days, then suddenly it stopped executing. In my investigation, I attempted to execute the function (named...

TahoeKid

10-05-2006 03:55 PM
TahoeKid

Hi, How do I change the place where the mysql socket file gets created? I thought it was in the my.cnf file by changing the "socket"...

laredotornado@zipmail.com

10-05-2006 10:20 AM
Bill Karwin

If I have a field, `lastname`, and in the WHERE predicate of my SELECT statement I want to test if it is LIKE 'Smith' without regards to case (i.e. I...

Ike

10-05-2006 10:00 AM
davie

Hi, I am trying to create stored procedures in MySQL. Does anyone have a suggestion on a good IDE to use. I have been working with the MySQL Query...

bshumsky06@yahoo.com

10-04-2006 11:15 PM
Bob

USING:ORACLE 9i For each of the following tasks, determine (a) the SQL statement needed to perform the stated task using the traditional approach...

butterflyTee

10-04-2006 12:53 PM
butterflyTee

I am by no means a SQl Jedi as will be apparent by my question, but I can usually figure out a select statement on my own. I have one today though...

kevinjbowman

10-04-2006 09:25 AM
lark

Perhaps posted it on wrong forums initially as I got only one response (which was helpful but I was looking for more). Please help if you...

10-03-2006 02:57 AM
The|Godfather

Hi all I have a column of type enum('A', 'AP', 'CR', 'D', 'DL', 'H', 'HD', 'HH', 'R', 'S', 'PL'). i want to sort the result by 'DL', 'H','A',and the...

vjyanand@gmail.com

10-02-2006 08:40 PM
Peter

What's the structure of the table? You could go... UPDATE table SET newdatefield = STR_TO_DATE(olddatefield); and then delete the string date...

Peter

10-01-2006 10:24 PM
Peter

Hallo, I am searching on documentation and on web and on groups but I can't find an answer to my question: I want to use replication from one...

asteddy@tin.it

09-29-2006 11:30 AM
asteddy@tin.it

I am new to myssql and am using a mysql database with the following tables Table Itinerary itinerary_id int(4) ship_id int(4) itinerary_title...

Pankaj

09-29-2006 05:14 AM
strawberry

Hi, That's my first time to send mail to this address for asking help. Sorry for my poor english firstly. My case is like this: Many guys are using...

Hans

09-29-2006 03:51 AM
Hans

Hello I have a rather large database (about 102 megabytes when dumped to an SQL file) and need advice on backup software for MySql databases. So far...

deepstar@gmail.com

09-28-2006 08:09 PM
David Ayres

Hello, I need help with building query, basically I need to select all records from one table that don't exists in second table with status 1,...

bpforte@gmail.com

09-27-2006 11:23 PM
www.1-script.com

I have "tableA" with column "a" and "tableB" with column "b". Column "a"has new material to, i need to run somthing like upgrade? please help. give...

fhelik

09-27-2006 10:09 PM
fhelik

If I have a procedure that will be run simultaneously by several people which requires the use of a temporary table is there a way for the table to...

No bother

09-27-2006 08:39 PM
Jerry Gitomer

Greetings! We have a few master/slave mysql server pairs. The problem is that the slave disconnects often from the master. Of course, it reconnects...

noident@my-deja.com

09-26-2006 06:36 PM
noident@my-deja.com

Hi! A simple question maybe... I have a datetime column in a table, and want to automaticly insert local (Norwegian) time into the column. (I use...

ojorus

09-26-2006 10:24 AM
Jonathan

Hey all I have four tables - person, movie, rating and rel_movie_rating. The important columns in these tables are person.id, movie.id...

deepstar@gmail.com

09-25-2006 03:42 PM
strawberry

I have a forum table where the field Forum_ID of the first thread corresponds to itself in the field Forum_Ancestor, and 0 (zero) for the field...

RioRanchoMan

09-25-2006 11:27 AM
Skarjune

I'm trying to get mysql working on Fedora Core 4. Actually trying to start the program mysqld without fatal errors. I posted this message first on...

tomzam

09-25-2006 10:00 AM
tomzam

Hello, Does anyone know of a detailed reference for the MYISAM file format? I'm afraid I may need to do some forensics on a crashed...

Wesley T Perkins

09-24-2006 10:41 PM
Wesley T Perkins

Hi there, I was wondering if it's possible to Clear MySQL's History Remotely. Considering that you only have root access to the database but...

mdavila78

09-23-2006 10:36 AM
mdavila78

Hello Everyone, I just ran into this issue, and I am hoping that some of you may be able to help. I am developing a web-based PHP application with...

torpecool@yahoo.com

09-22-2006 03:27 PM
torpecool@yahoo.com

In MSSQL you can create a table with a computed column, like this... CREATE FUNCTION CubicVolume -- Input dimensions in centimeters. (@CubeLength...

peterloh@gmail.com

09-22-2006 12:21 AM
Bill Karwin