Hi - I have some tables designed to keep track of order. The main table contains a session id, address and date. Linked to this I have a table of...

AT

05-10-2006 09:16 AM
AT

Hi, I would like to .. UPDATE TABLE1 SET STATE = A WHERE OCCUPIED = Y everynight

Jared

05-10-2006 08:27 AM
No bother

hi first of all i am new to mysql and maybe that is my problem ... i have an sql to show up a picture gallery on my website. SELECT tabBilder.Bid...

AT

05-10-2006 03:26 AM
AT

Hi All, I'm trying to determine the number of days between today and the value in a datetime field in a table. It appears my version of MySQL...

AT

05-09-2006 08:19 PM
AT

Hi, I've spent hours trying to optimize this simple query: SELECT count(sites_jobs.id) as jobCount, sites_jobs_categories.frn_site_id,...

AT

05-09-2006 12:46 PM
Bill Karwin

If I have a GROUP BY statement, which groups my multiple fields, e.g.: SELECT ......GROUP BY date, store can I have multiple ORDER BY statements...

Ike

05-09-2006 12:35 PM
Bill Karwin

Hi there I have a list of jobs scheduled in a MySQL table, with start dates and end dates, like so: SchedID | JobID | StartDate | EndDate ...

Good Man

05-09-2006 12:25 PM
Good Man

A while ago I had some help from here to make a batch file that would dump my db. Everything was working just fine until 2 days ago and I just...

Robert Blackwell

05-08-2006 03:16 AM
Robert Blackwell

hey all... i have mysql 4.1.14 running in a master slave setup.. in a local network.. The problem i am having, that the replication status on slave...

Kami

05-08-2006 01:57 AM
Kami

Hi, I am working with an application with a high rate of inserts/updates/deletes into a particular table, and recently am getting the following...

AT

05-08-2006 12:22 AM
AT

Implemented web application using MySQL to maintain inventory of the office PC's/laptops/Routers/hubs and other stuff, here we are using MySQL as...

GS

05-07-2006 08:35 PM
AT

Hello, nuB problem... I connect from a Windows command line ...mysql\bin>mysql myuser mypass and all that ever gets displayed is this help text...

zorro

05-07-2006 06:52 AM
zorro

Through Java, I am attempting to connect to a MySQL 4.12 server on a remote computer. I can connect fine via php. I cann connect fine via Java,...

Ike

05-05-2006 06:21 PM
Ike

I have a need to get a list of currently connected users in a query for use in a view. I know the syntax for show processlist, but as of yet...

No bother

05-05-2006 03:54 PM
Thomas Bartkus

hi to all I use this query SELECT SQL_CALC_FOUND_ROWS * FROM prods LIMIT 100,10; I'd like to know how many rows this query returns without limit,...

andrea azzini

05-04-2006 11:36 AM
Bill Karwin

Is it possible to count the number of columns that match certain conditions and return a single value? For example in the database we have a record...

JJ

05-03-2006 10:18 PM
JJ

Hi, I have noticed when I do a Left Outer Join in short form that many rows become missing as result of null values. i.e Left Outer Join (t1,t2,t3)...

Jared

05-03-2006 06:25 PM
Jared

Hi all, Is possible to retrieve all columns and alias them all at once. Eg, normally you would write select * from products which would return id...

sks

05-03-2006 11:08 AM
sks

Hello. I have got a MySQL 4.1 that we use wit vBulletin.... We had a crash last week and I've been able to restore the data up to September 2005 as...

AT

05-01-2006 11:11 AM
AT

Hi! I succesfully exported my locally stored db using the following syntax: mysqldump -u root --password=111 finance > sqlbk.dump Now I created...

Vadim

04-30-2006 05:23 AM
Vadim

I am getting myOdbc error 518 Sqlstate- HY001 Invalid application buffer type when I try to retrieve all table names. I am using version mysql Ver...

AT

04-28-2006 09:30 PM
AT

$if1 = "IF(s.student_ethnicity_interest_other IS NOT NULL AND s.student_ethnicity_interest_other != '', " . " ...

phillip.s.powell (AT) gmail (DOT) com

04-28-2006 02:37 PM
phillip.s.powell (AT) gmail (DOT) com

Hello I have the following sql string to run as a command in my VB6 project to update mysql table strSQL = "LOAD DATA INFILE " & ImportFile & "...

Ian Davies

04-28-2006 10:00 AM
Thomas Bartkus

I'm wondering if something like this can be done in mysql... I have two tables I want to pull data from. One table will contain a unique user_id...

xhenxhe

04-28-2006 07:07 AM
xhenxhe

¨ë¸ EMBROIDERED CUSTOM , OVERRUNS PATCHES, POLICE., FIRE, FBI, BOY SCOUT, MILITARY À²³¹ Founded in 1931, we have been specializing in the...

AT

04-28-2006 04:45 AM
AT

Hi! I imported some table (about 1500 records) using "LOAD DATA LOCAL INFILE..." (command line console). No warnings, no skipped, no deletes - all...

Vadim

04-27-2006 04:57 PM
Bill Karwin

Thanks for the help in advance, It has been over 5 years since I have messed with FreeBSD and I have never messed with MySQL until now so forgive me...

AT

04-27-2006 03:49 PM
AT

Hi, I am having a problem getting into a database. The user who normally access it just received a new machine and does not remember his connection...

AT

04-27-2006 06:30 AM
AT

Hi, I'm learning the ropes with PHP and MySQL at the moment, and I've run into a puzzle. I'm using PHP to process a form and insert some simple...

smedstadc

04-26-2006 06:49 PM
smedstadc

I have 2 virtually identical tables and wish to move data between them. Basically one table is called "live_table" and the other is...

Phil Latio

04-26-2006 02:37 PM
AT

Newbie questions here... Reading the MySQL manual regarding InnoDB databases, can someone confirm that: 1. if the server is rebooted, AUTO_INCREMENT...

Phil Latio

04-25-2006 12:21 PM
Bill Karwin

Can i make multiple inserts into a table using one statement. the statement: INSERT INTO table1 (UserName) VALUES (SELECT DISTINCT UserName...

AT

04-25-2006 12:16 PM
Bill Karwin

Dear Mysql-ians, I want to calculate the standard deviation of data that are in multiple columns. I know how to calculate the STD of 1 column (e.g....

stefaan.lhermitte@agr.kuleuven.ac.be

04-25-2006 10:08 AM
AT

Hi, in a shell script of mine I'm executing a mysql SELECT in batch mode. I want to use the return value for other sql statements. The problem I'm...

fritz-bayer (AT) web (DOT) de

04-25-2006 02:33 AM
fritz-bayer (AT) web (DOT) de

Hello, I have query which work in mysql 4 In mysql 5 I have error 1054. this is this query: select count(p.products_id) as total from

AT

04-24-2006 02:22 PM
Bill Karwin

Hi all Can someone help me with the syntax to my stored procedure? Every time I try to run it I receive the error code 1064. I checked my...

Hieronimus

04-24-2006 02:16 PM
Bill Karwin

Hey! I need to dynamically create an SQL statement within a MySQL 5.0.20 stored procedure. -- PSEUDO CODE create procedure DynSQLTest ( in sTable...

Fred

04-24-2006 02:14 PM
Bill Karwin

SELECT ip FROM db1.table1 WHERE ip IN ( SELECT ip_network FROM db2.table2 WHERE name = <value> ) Basically, the way the data shows up in the first...

Kreeves

04-24-2006 10:50 AM
Kreeves

I am trying to optimize a search engine. let's say I have 3 tables. one has titles, one has words, and an index where each title is broken into...

none

04-23-2006 09:58 PM
Michael Austin

I have two job queues doing complimentary work and writing their output once a minute into a file. The files for each minute have to processed in...

umangjaipuria@gmail.com

04-23-2006 12:16 AM
umangjaipuria@gmail.com

I am trying to create a simple multitable database. The first table keeps track of alumni of my association including an id#(key, auto_increment),...

bob.herbst@gmail.com

04-22-2006 10:11 PM
Gordon Burditt

Hello everyone, I am using a custom php class where i have wrapped all the mysql connection settings and query functions. Instead of calling...

saifmsg@gmail.com

04-22-2006 07:05 PM
Bill Karwin

HI, I have a Questionnaire table that has a column "SchoolId"(int). I want to return the questionnaire table with the name of the school rather than...

jullietta.jung@gmail.com

04-22-2006 06:57 PM
Bill Karwin

Hi netters, I am used in MYSQL + PHP. Sometimes POSTGRESQL + PYTHON/ZOPE was used. Now I have to build a bibliography system that stores a lot...

kleinhans

04-22-2006 07:19 AM
kleinhans

Stop me if you've heard this one... I want to create a "data dictionary" table of all my user tables in a certain database. The data dictionary (my...

Matt

04-22-2006 03:25 AM
Jeff North

I have a client that desires a new application for use at several stores in different cities. He wants "real time" access to all store data and...

Jim Hubbard

04-21-2006 04:36 PM
Gordon Burditt

Hello, I'm having a problem replicating a simple database using the binary log replication, here is the problem: When the master sends an update to...

Juan Antonio Villa

04-21-2006 04:07 PM
Gordon Burditt

Hi, I transferred a VB6 application using MySql 3.51 Drver From Windows 98 platform to XP. I downloaded MySql 3.51 set up the ODBC driver...

Joel

04-21-2006 11:53 AM
Bill Karwin

I installed version 5.0.19 for OS X 10.4. In the documentation, it says it runs the mysql_install_db script for you. I started the server and ran the...

macbrando@gmail.com

04-21-2006 09:49 AM
macbrando@gmail.com

Hi, Well the following query is not the one i will use but it's the same prob : SELECT sum(country_id ) , count( country_id ) FROM Tbl_Country,...

trihanhcie@gmail.com

04-21-2006 07:23 AM
trihanhcie@gmail.com