Need Help Migrating DB from MySQL 5.0.x to MySQL 4.0.x

When I perform a dump in mysql5 to mysql 4 DB, I get the error (below). Does anyone know how I can resolve this? QUERY (windows server from the cmd prompt) mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME] --password=[PASSWORD] --host=[HOST] [TARGET DB] ERROR MESS

How Can I Auto Delete my Binary Files?

I'm running a RHEL 4.1 and MySQL 4.0.26 so a lot or the more recent commands available in 5.0.x aren't available to me. Does anyone know of any scripts or anything I can use to delete files that arent being used or run by my slave servers? It's pretty safe to say that I can delete log files o

Updating/Adding comments

base. Will it re-create or mess up any of my indexes? Is there an easier way to add comments to a column? Thanks! Shaun McQuaker -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Storing Apache logs in MySQL.

I pull Apache (combined format) logs, daily, from a number of mirrors, back to a central server for processing. I'd like to somehow load them in MySQL for analysis. 1) Does anyone know of a script that can parse the logs and load them? (I presume I can get the DB schema from it.) 2) Can MySQL han

MySQL RPMs for RH9?

I have a client who has a RH9 server that I'm not allowed to upgrade to something newer. It has MySQL 3.23.58 on it and I need to replace that with the newest I can get. The MySQL-AB site doesn't seem (unless I missed it, which is quite possible) to have any RPMs for RH9 anymore. Can anyone point

Question Concerning (innodb_buffer_pool_size)

I'm currently running RHEL4.1 64-bit, mysql 4.0.26 w/ 4GB RAM and have my innodb_buffer_pool_size set to 2GB, My question is, can I increase my ram to 8GB and set innodb_buffer_pool_size to 4GB or even 6? Thanks

Re: Working out Square Footage with Feet and Inches

""Nicolas Verhaeghe"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] ""RedRed!com IT Department"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Jay Blanchard wrote: >> [snip] >> I read this as a SQL syntax question, not a math word problem. As in >> >> SELECT ..., (

Re: Working out Square Footage with Feet and Inches

""RedRed!com IT Department"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Jay Blanchard wrote: >> [snip] >> I read this as a SQL syntax question, not a math word problem. As in >> >> SELECT ..., (some expression equaling sq ft) AS sqft... >> [/snip] >> >> Cool, then do it! >> >

Working out Square Footage with Feet and Inches

Hi, I have measurements of rooms stored in a table for each house in feet and inches, does anyone know how can I work out the square footage? Thanks for your advice -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Problem with UNION

Hi, The following 3 queries on their own produce more rows than if I UNION them together: SELECT CONCAT('Y',DATE_FORMAT(Date,'%Y')) AS Booking_Year, CONCAT('M',DATE_FORMAT(Date,'%c')) AS Booking_Month, CONCAT('USR_', B.User_ID) AS User, Booking_Status, CONCAT('W_', Work_Type_ID) AS Day_Type, '1'

Cleaning Bin-Log Files

Does anyone know of a method or script that will automatically delete bin-log files after x days? I've got a few customers, all utilizing a master and slave server... my problem is that the harddrives often get filled to capacity if they go unchecked over a few months. Most of this is attributed

Need help configuring INNODB (Customer is ready to sue)

I have a customer who has been in production for a few weeks now having converted from MyISM to INNODB. We have been experiencing a few problems with our application. With that said, could you take a look at the info below from my "show INNODB status" and let me know if you see any problems based

INNODB Questions and Optimization help

ny responses as possible. Shaun = 060207 19:04:03 INNODB MONITOR OUTPUT = Per second averages calculated from the last 16 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 11216, signal count 11214 M

Re: Optimizing Tables - Trimming Data

+++---+-++---++-+-+---++++---+---

Optimizing Tables - Trimming Data

Hi, I am trying to optimize my data and am currently looking at indexes etc. Someone has suggested the following as well: 1. Ensure that there is no whitespace at the beginning or end of entries 2. Use 1 or 0 instead of yes or no. If point 1 is true then is there a way to trim all whitespace da

Re: Postcode Search

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Shaun" <[EMAIL PROTECTED]> wrote on 01/23/2006 11:51:32 AM: > >> Hi, >> >> We have a dataset of uk postcodes and their relevant X-Coordinates and >> Y-Coordinates, a table of prope

Postcode Search

Hi, We have a dataset of uk postcodes and their relevant X-Coordinates and Y-Coordinates, a table of properties (houses), a table of users and a table of offices - users work in an office - table structures below. Is it possible to run a search of all properties in the properties table that co

CONCAT() And Columns

Hi, I am trying to update a field so that it retains its contents plus the contents of another column like this: UPDATE MyTable SET Comments = CONCAT(Comments, 'Old_ID_Field = ', Old_ID_Field) WHERE Table_ID = 1; However I just get a blank Comments field, any ideas why this is happening? Than

Re: UPDATE Date Column

Thanks Patrick, Will this work on 3.23? ""Patrick Herber"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Do you mean something like that? > > UPDATE tablename SET date2=DATE_ADD(date1, INTERVAL -3 MONTH) > > Regards, > Patrick &g

UPDATE Date Column

Hi, I have a 2 Date Columns in my table, how can I update the 2nd date column so that the dates are 3 months previous to the orignial date column for every row. Thanks for your advice -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Wrap Tag Around Result

Hi, Is it possible to wrap an tag around a column in a resultset? For example: SELECT Firstname FROM Users; Matthew Mark Luke John Becomes: Matthew Mark Luke John I need to do this with pure SQL - no server side scripting... Thanks for your advice -- MySQL General Mailing List For lis

Probelm with date grouping

ORDER BY YearWeek DESC; +++-++---+-+ | YearWeek | Status | User_ID | User_Firstname | User_Lastname | Total_Hours | +++-++---+-+ | 2005-48-12 | Open | 1 | Shaun | x| 14.7

INSERT SELECT Problem

Hi, The following query worked fine: INSERT INTO Allocations(Project_ID, User_ID) SELECT P.Project_ID, U.User_ID FROM Users U, Projects P, Clients C WHERE P.Client_ID = C.Client_ID AND U.Client_ID = C.Client_ID AND Project_ID =".$project_id) However I want to add a column to the INSERT part of

Re: Multiple INNER JOINS

Hi Peter, I am using version 3.23.54, unfortunately I have no control over this :( "Peter Brawley" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Shaun, >I am having problems with the following query: I am >trying to join Tax_Bands and Property_Types to Pro

Multiple INNER JOINS

Hi, I am having problems with the following query: I am trying to join Tax_Bands and Property_Types to Properties but the query seems to be joning Tax_Bands to Properties. SELECT P.*, Tax_Band, Property_Type FROM Properties P INNER JOIN Tax_Bands USING(Tax_Band_ID) INNER JOIN Property_Types USI

Confusion Over Numeric Types

Hi, When I create a table using my ISP's web control panel and I create a column with a type of TINYINT it automatically creates a column with a value of TINYINT(4). After looking at the documentation on the MySQL site it is not exactly clear what this means: http://dev.mysql.com/doc/refman/5

Upgrade confusion.

I have a CentOS-3 (RHEL 3 equivalent) with MySQL 4.1.9 installed from the MySQL site. The RPMs I'm using are: MySQL-server-4.1.9-0 MySQL-client-4.1.9-0 MySQL-devel-4.1.9-0 MySQL-Max-4.1.9-0 MySQL-shared-compat-4.1.9-0 I see that 4.1.14 is the latest version. When I went to download the latest RPM

UK Address Standard

Hi, Is there a standard for field names / types for holding data on addresses in the UK? Thanks for your advice -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A Complicated Report

"Peter Brawley" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Shaun, > > >We have a database that keeps track of days worked and days taken off by > >staff. All days worked / taken off are held in a table called Bookings. > >Staff wor

A Complicated Report

Hi, We have a database that keeps track of days worked and days taken off by staff. All days worked / taken off are held in a table called Bookings. Staff work on Projects and each project will have various Work_Types, days taken off are not related to projects and are held in Unavailability_D

Re: INSERT SELECT

Sorry guys, Worked it out, if anyone is interested here is the query: INSERT INTO Allocations(Project_ID, User_ID) SELECT P.Project_ID, U.User_ID FROM Users U, Projects P, Clients C WHERE P.Client_ID = C.Client_ID AND U.Client_ID = C.Client_ID AND Project_ID = 2 ""Shaun"&quo

INSERT SELECT

Hi, I have four tables: Projects, Users, Allocations and Clients. A Client will have many projects and many Users, Users are allocated to Projects via a link table - Allocations. When I add a project I want to have an option of allocating all users to the project, can this be done with a select

Date Ranges

Hi, Given two dates, can Mysql calculate and return all the dates that occur between them? Thanks for your advice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Counting Entries

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Shaun" <[EMAIL PROTECTED]> wrote on 09/01/2005 05:38:01 AM: > > >> >> The corrected query should read: >> >> SELECT m.name as month, YEAR(b.Booking_Start_Date) as year,

Re: Counting Entries

""Shaun"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:56:23 PM: >> >>> >&

Re: Counting Entries

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:56:23 PM: > >> >> <[EMAIL PROTECTED]> wrote in message >> > news:[EMAIL PROTECTED] >> > "Shaun" <[EMAIL PR

Re: Counting Entries

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:04:20 PM: > >> >> <[EMAIL PROTECTED]> wrote in message >> > news:[EMAIL PROTECTED] >> > "Shaun" <[EMAIL

Re: Counting Entries

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 02:43:33 PM: > >> Hi, >> >> This query counts the number of entries in the Bookings table per month, > is >> it possible for this

Counting Entries

Hi, This query counts the number of entries in the Bookings table per month, is it possible for this query to return a zero where there are no entries for a particular month? SELECT COUNT(Booking_ID) AS "Num_Bookings" FROM Bookings WHERE User_ID = 1 AND Work_Type_ID = 12 AND DATE_FORMAT(Booking

UK Bank Holidays

Bank Holiday dates? Thanks for your help. Shaun -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ENCODE / DECODE

Hi, Is it possible to update all my encoded data with another password? Thanks for your advice -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Problem with query

From: "Jon Miller" <[EMAIL PROTECTED]> To: Subject: Problem with query Date: Tue, 24 May 2005 19:40:32 +0800 Quite new to MySQl and queries in general and would like some help in the following query: select prDate, prName, prLEmployee, prDescription, prTotalHours, prLStatus, prCompletionDate,

Re: 2 Joins in 1 Query

From: [EMAIL PROTECTED] To: "shaun thornburgh" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: 2 Joins in 1 Query Date: Mon, 23 May 2005 12:20:05 -0400 "shaun thornburgh" <[EMAIL PROTECTED]> wrote on 05/23/2005 10:18:29 AM: > Hi, > > T

RE: 2 Joins in 1 Query

Hi, Unfortunately that doesnt work, I need to LEFT JOIN Bookings to Weeks but keep the current join on Projects there as well, any ideas? From: "Peter Normann" <[EMAIL PROTECTED]> To: "'shaun thornburgh'" <[EMAIL PROTECTED]>, Subject: RE: 2 Joins

2 Joins in 1 Query

Hi, The following query produces the number of bookings per project grouped by week: SELECT WEEK(Booking_Start_Date) AS "WEEK", SUM(IF(B.Project_ID = "23", 1,0)) AS `Project A`, SUM(IF(B.Project_ID = "42", 1,0)) AS `Project B` FROM Bookings B INNER JOIN Projects P USING (Project_ID) WHERE B.Bo

Update Email Column

Hi, Is it possible to update all the domain names for an email column? I want to change everyones email address to my domain for a test site, so can I change the email address column such that everything after @ is changed to mydomain.com? Thanks for your advice -- MySQL General Mailing List F

UPDATE Query

Hi, I am getting an error on the following query and but can't understand why, the syntax looks fine to me! mysql> UPDATE CSV_Upload_Data SET SUBSTRING(PRACT_ASCII, 16, 6) = '11' WHERE Insertion_ID = 190716; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that cor

ERROR 1111 (HY000): Invalid use of group function

Hi, I keep getting thw following error when i include this line: AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1 mysql> SELECT PRACT_NUMBER, -> COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) -> FROM CSV_Upload_Data -> WHERE CSV_File = 'ICS' -> AND CHAR_LENGTH(PRACT_NUMBER) > 4 -> AND COUNT(SUBSTR

Remove 1st 3 Chars

Hi, is it possible to alter fields in a column by removing the first three characters? i.e. change 100123456789 to 123456789 Thanks for your help -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can I find this data?

2 | Day 2 | +--++--+---+ 2 rows in set (0.00 sec) mysql> Do you see my problem here?! Any advice would be greatly appreciated... Shaun From: [EMAIL PROTECTED] To: "shaun thornburgh" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: How can

RE: How can I find this data?

gt; Here you can see that Practice 11049 has four bookings. The two for project 32 are ok, but the two for project 3 do not have a booking where the day type is 1. I hope this makes sense! Thanks again for your help. Shaun From: "Jay Blanchard" <[EMAIL PROTECTED]> To: "sh

How can I find this data?

Hi, I have four tables among others in my database: Bookings, Work_Types, Practices & Projects. Bookings occur in a Practice for a Project and have a Work_Type. A Practice can have many Bookings but must have one and only one Booking where the Work_Type.Day_Type = 1. This rule was introduced aft

Help with a DATETIME query please!

Hi, I am trying to create a query that returns a users availability for the next ten days using version 4.1.11. A user has 8.5 hours available per day so a users availability is equal to 8.5 less any bookings they have on that day. I have a table called Bookings (see below), and each 'Booking' h

HELP WITH A DATE QUERY USING 4.0.17

Hi, I have a table called Bookings which holds start times and end times for appointments, these are held in Booking_Start_Date and Booking_End_Date. I have a page on my site that runs a query to produce a grid to show availiability per day for the next ten days for each user of the system. Use

TIME Difference Using 4.0.17

Hi, I have a DATETIME COLUMN in my table and i need to be able to perform an update on all colmns that are 48 hours old as specified in that column. As I am using 4.0.17 I am unable to use the TIME() functions, is there another way to do this? Thanks for your help -- MySQL General Mailing List

Help with a JOIN query please

Hi, I have ( among others ) three tables in my database: Claims, Expenses and Mileage. A claim can contain many expense entries and many mileage entries. I am using the follwing query to show the total expenses and mileage per claim for a particulare user: SELECT C.*, SUM(E.Amount) AS Amount, S

Column Order

Hi, Is it possible to change the order of columns in a table after the table has been created? Thanks for your help -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL & CRON

Hi, I have a web based that allows users to upload XML files and insert them into the database, however some of these files are large and are causing the webserver to timeout. Is it possible to create a cron job that can insert the xml files say every hour, then the users of the site would only

LOAD DATA INFILE & XML

Hi, Is it possible to use the LOAD DATA INFILE to load an XML file into a table? Thanks for your help -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help with a query please

From: "Rhino" <[EMAIL PROTECTED]> To: "shaun thornburgh" <[EMAIL PROTECTED]>, Subject: Re: Help with a query please Date: Mon, 21 Feb 2005 08:22:29 -0500 - Original Message - From: "shaun thornburgh" <[EMAIL PROTECTED]> To: Sent: Monday

Help with a query please

Hi, I am having trouble with the following query: SELECT U.User_ID, U.User_Firstname, U.User_Lastname FROM Users U, Allocations A WHERE (U.User_ID = A.User_ID OR U.User_ID = 101) AND A.Project_ID = '12' AND ( U.User_Type = 'Staff' OR U.User_Type = 'Manager' OR U.User_Type = 'Administrator' ) ORDER

Re: LOAD DATA INFILE using 4.0.17

No just every row needs to be unique. Sorry for the confusion... From: "Robert Dunlop" <[EMAIL PROTECTED]> To: "shaun thornburgh" <[EMAIL PROTECTED]>, Subject: Re: LOAD DATA INFILE using 4.0.17 Date: Tue, 15 Feb 2005 15:06:19 -0800 So what you meant was every

Re: LOAD DATA INFILE using 4.0.17

Hi, Thanks for your reply, but the problem I am facing is that there may be duplicate values in the uploaded file and I dont want these to appear in my table... From: Bastian Balthazar Bux <[EMAIL PROTECTED]> To: shaun thornburgh <[EMAIL PROTECTED]> Subject: Re: LOAD DATA INFILE

LOAD DATA INFILE using 4.0.17

Hi, I have a table with 26 fields, each row in this table must be unique. I can't define all of the fields to be primary keys as the limit is 16. Therefore before I insert data I have to check that each row is unique. Data is to be inserted into this table from files uploaded to the server - CSV

LOAD DATA INFILE Opposite

Hi, The following function loads data from a file: http://dev.mysql.com/doc/mysql/en/load-data.html Is there a function like this that I can use to save the results of a query to a CSV file for the user of my PHP application to donwload? Thanks for your help -- MySQL General Mailing List For lis

Add an ENUM Column

Hi, Is it possible to add an ENUM column to a table after it has been created? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

upgrading from 4.1.8 to 4.1.9

I'd like to upgrade my RHEL ES v3 u4 server from MySQL 4.1.8 to 4.1.9. It's using rpms from the MySQL site, and the new ones will be from there as well. Assuming I shut down MySQL and any apps that use it, is it as simple as upgrading the rpms? Will the apps be affected by the change? -ste

Re: ENCODE & DECODE

_DATA_ENC_FORENAME, "test_password" ) FROM DATA_TABLE_PID_ mysql> Any ideas? From: Jeff Smelser <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Re: ENCODE & DECODE Date: Fri, 4 Feb 2005 10:20:14 -0600 On Friday 04 February 2005 09:51 am, shaun thornburgh wrote: > I have a table

ENCODE & DECODE

Hi, I have a table where users upload various data items via a web site. Some fields in the table are named DATA_ENC... to denote that the data should be encrypted uusing the encode function. This all works fine, however when I come to selecting the data from the table I would like to be able to

Re: SHOW TABLES Problem

his? From: "Gabriel PREDA" <[EMAIL PROTECTED]> Reply-To: "Gabriel PREDA" <[EMAIL PROTECTED]> To: "shaun thornburgh" <[EMAIL PROTECTED]>, Subject: Re: SHOW TABLES Problem Date: Wed, 2 Feb 2005 13:48:43 +0200 Because it does not know REGEXP... only LIKE patter

SHOW TABLES Problem

Hi, The syntax for show tables from the manual is: SHOW [FULL|OPEN] TABLES [FROM db_name] [LIKE 'pattern'] so whay doesnt the following query work: SHOW TABLES LIKE REGEXP 'PID_[0-9]+'; Thanks for your help Shaun -- MySQL General Mailing List For list archives: http://list

Undo function?

Hi, I get very nervous when I log onto my database via SSH and type in queries manually. Take the following query for example: Delete FROM Users WHERE User_ID = 5; If I hit return before I start typing WHERE then things would be disastorous! Is there any type of undo function with MySQL? Thanks

SHOW COLUMNS Syntax Using 3.23.54 Please!

Hi, I am trying to get all field names from my table that begin with letter X or Y, however the following statement and many variations I have tried produce an error: SHOW COLUMNS FROM TABLE LIKE "X%" OR LIKE "Y%" Any help here would be much appreciated :) -- MySQL General Mailing List For list ar

SHOW COLUMNS Syntax Using 3.23.54

Hi, I am trying to get all field names from my table that begin with letter X or Y, however the following statement and many variations I have tried produce an error: SHOW COLUMNS FROM TABLE LIKE "X%" OR LIKE "Y%" Any help here would be much appreciated :) -- MySQL General Mailing List For list

Re: Can Mysql hold possible field values?

Hi Guys, Thanks for your replies, i have also found SET which appears to do the same thing, is there a reason why everyone suggested ENUM as opposed to SET? Thanks for your help From: Mattias J <[EMAIL PROTECTED]> To: "shaun thornburgh" <[EMAIL PROTECTED]>, mysql@lists.mysq

Can Mysql hold possible field values?

Hi, I am attempting to create a database and have a query. Is it possible for mysql to contain the possible field values in the database rather than creating the options in the application? For example Field_A can only be Yes or No, Field_B can be 50% or 80% etc. I feel that creating the applica

A Complicated SELECT query

booking is? If I am checking for a 'Booking' I need to check that B.Project_ID = P.Project_ID and if I am checking for a 'Task' I need to check that AND B.Task_ID = T.Task_ID AND T.Project_ID = P.Project_ID. Thanks for your help Shaun Table Definitions: mysql> DESCRIBE Booking

Re: Help with a join query please!

A.Project_ID = 11 ORDER BY User_Firstname; Thanks, Shaun From: [EMAIL PROTECTED] To: "shaun thornburgh" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com,[EMAIL PROTECTED] Subject: Re: Help with a join query please! Date: Wed, 29 Dec 2004 15:58:43 -0500 "shaun thornburgh" <[EMA

RE: Help with an UPDATE query please

the Tasks Project_ID. This is what I need to do: UPDATE Bookings B SET B.Task_ID = T.Task_ID WHERE T.Task_Name = 'Booking' AND B.Project_ID = T.Project_ID However I dont know how to introduce the Tasks T alias into the query! Thanks for your help, Shaun From: "Jay Blanchard"

Re: Help with a join query please!

ticular project. Thanks again for your help! From: [EMAIL PROTECTED] To: "shaun thornburgh" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com,[EMAIL PROTECTED] Subject: Re: Help with a join query please! Date: Thu, 23 Dec 2004 10:14:24 -0500 So -- what's the field that relates a boo

Help with an UPDATE query please

Hi, I am having trouble with an UPDATE query. I have three tables as defined below. My database holds data for bookings. Each booking relates to a project. Each project has many tasks, one of which is a booking. I have now added the column Task_ID to the bookings table. How can I update all the

rpms for rhel

Which rpms are the right ones to use for RHEL v3u4? I'm not sure which release of mysql I need, yet, but looking at the site, I'm not sure how to tell which are the ones that would even be appropriate for my system. TIA, -ste -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Help with a join query please!

Hi, Thanks for your reply but that produces exactly the same result... Any ideas? From: Sasha Pachev <[EMAIL PROTECTED]> To: shaun thornburgh <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: Help with a join query please! Date: Tue, 21 Dec 2004 14:57:43 -0700 shaun thornbur

Help with a join query please!

int(11) | YES | | NULL| | | Booking_Credits | int(11) | YES | | NULL| | +--+--+--+-+-++ 19 rows in set (0.00 sec) Thanks for your help here, Shaun -- MySQL General Mail

Re: Help with a join query please

From: "Rhino" <[EMAIL PROTECTED]> To: "shaun thornburgh" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> Subject: Re: Help with a join query please Date: Thu, 16 Dec 2004 14:59:48 -0500 ----- Original Message - From: "shaun thornburgh" <[EMAIL

Help with a join query please

'11' ORDER BY User_Firstname; I hope this makes sense! Shaun -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Optimizing MySQL

Thanks, I changed the permissions, restarted, and everything is working great now. Thanks a lot. > Shaun wrote: > > Thanks for your help Dathan, I will make the required changes. I just have > > one other problem. > > > > I'm not sure what queries don't

Re: Optimizing MySQL

Thanks for your help Dathan, I will make the required changes. I just have one other problem. I'm not sure what queries don't use an index. I've attmepted to turn on the slow-queries-log, but nothing ever shows up in the file. Here's what I have in the my.cnf [mysqld] skip-locking set-variable

Optimizing MySQL

Hello, I was wondering if a more knowledgeable person could help me out with my configuration and let me know how I could further optimize MySQL. Here's the hardware on my dedicated server: Processor #1 Vendor: GenuineIntel Processor #1 Name: Intel(R) Pentium(R) 4 CPU 2.40GHz Processor #1 speed

Help with a DATETIME Query Please Using 3.23.54

er it fails if the booking spans more than one day. For example I have a booking that starts at 9am on 2004-10-31 and ends at 10am on 2004-11-02, and for this the query returns one hour, when it should be 24! Any pointers regarding this would be most apprecited Shaun -- MySQL General Mailin

List of Dates Grouped by Week

Hi, I am creating an online timesheet application. Most parts are done, however I have a problem displaying a list of unapproved timesheets. Here is my timesheet table: mysql> DESCRIBE Timesheets; +---+-+--+-+++ | Field | T

A Complicated DATETIME query using 3.23.54

Hi, I have a table called Bookings which holds information for bookings(!) for staff members in my database: mysql> DESCRIBE Bookings; +---+-+--+-+++ | Field | Type| Null | Key | Default| Extra

Re: SELECTING Non existing Dates

-+ 10 rows in set (0.00 sec) mysql> Any ideas? From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: SELECTING Non existing Dates Date: Wed, 20 Oct 2004 15:10:51 +0200 Hello Shaun, > I have query that I am using to try to get the number

SELECTING Non existing Dates

chieve this but unfortunately not! If someone could show me where I am going wrong I would be most grateful. Many thanks, Shaun -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

COUNT Problem

Hi, I have the following two tables in my database: mysql> DESCRIBE Projects; +--+--+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-++ | Pro

Joing two fields in a query

Hi, Is it possible to join two fields in a query so that they are displayed as one column? For exmaple: SELECT Firstname + ' ' + Lastname AS 'Name' FROM Users; I hope you can see what I am trying to achieve from SQL here! Thanks for your help __

Updating Names Column

Hi, In my Users table I have one column for users names, I need to modify this now so that users have a column for first names and a seperate column for last names. My question is how can I update the current users in the table so that their details are stored correctly? Many thanks for your he

Help with a join query

Hi, I am having trouble with a LEFT JOIN. I have three tables: Users, Projects and Allocations. Users can be allocated to zero or more projects and a project can be allocated to zero or more users. Table descriptions are below. How can i select a users details and all of the pojects they are al

Help with a SELECT Query

Hi, I use the following query to extract information about a practice in my database. However if the practice system id hasnt been set then the query won't work. SELECT P.*, S.System_Name FROM Practices P, Systems S WHERE P.Practice_ID = '".$_SESSION['ses_practice_id']."' AND S.System_ID = P.Sy

Help with a Date Query Please!

Hi, I have a table called Bookings which holds start times and end times for appointments, these are held in Booking_Start_Date and Booking_End_Date. I have a page on my site that runs a query to produce a grid to show availiability per day for the next ten days for each user of the system. Use

  1   2   >