Re: Can't Connect Localhost

Hi John, Starting over…. What is the "error message"? Terry ___ Terry J Fundak Systems Engineer Network Design and Security Solutions for SMBs Tech Support - Client and Server Systems TJSoftworks 1834 Chadwick Court Santa Rosa, CA 95401 (707) 849

RE: Multiple joins from same table?

Shawn, Thanks for the info, it does help indeed. I had also replied back to Gary to thank him as well, but I don't think that it made it to the list... so to Gary, thanks as well. Regards, Terry Terry Van de Velde Email: bya...@rogers.com Phone: (519) 685-0295 Cell:  (519) 619

Multiple joins from same table?

isitor = teams.team_no - Any help is appreciated. Best Regards, Terry

Re: DATATYPES

andra Prajapati > > > > --- > avast! Antivirus: Inbound message clean. > Virus Database (VPS): 080908-0, 08/09/2008 > Tested on: 09/09/2008 13:40:08 > avast! - copyright (c) 1988-2008 ALWIL Software. > http://www.avast.com > > > Terry http://www.confexdb.co.

Re: DATATYPES

atabase (VPS): 080908-0, 08/09/2008 > Tested on: 09/09/2008 13:40:08 > avast! - copyright (c) 1988-2008 ALWIL Software. > http://www.avast.com > > > Terry http://www.confexdb.co.uk/ --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 080908-0, 08/09/2008 Tested

RE: Migrate HUGE Database

Thanks to all for the quick replies. Yes, the mysqldump worked perfectly. Boy do I feel like a newbie now! If I use the method below, will that transfer the mysql admin database too with the user information? Thanks, Terry -Original Message- From: Rolando Edwards [mailto:[EMAIL

Migrate HUGE Database

this? Thanks, Terry Terry Babbey Infrastructure Specialist Information Technology, Lambton College of Applied Arts & Technology [EMAIL PROTECTED], 519.542.7751 x3293

Re: Selecting just 'N' first rows

Look up the LIMIT clause of SELECT statement, also ASCENDING/DESCENDING - depending on how you want it. Remember LIMIT can take a number and an offset. Terry - Original Message - > *From:* Renito 73 <[EMAIL PROTECTED]> > *To:* mysql@lists.mysql.com > *Date:* Sun, 9 Se

RE: seoparator help

n scanned for viruses by BlackSpider MailControl > - www.blackspider.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > No virus found in this incoming messa

Re: seoparator help

decimal places number_format($fieldvalue, 2) Regards Terry http://booksihaveread.awardspace.co.uk - Original Message - > *From:* coolcoder <[EMAIL PROTECTED]> > *To:* mysql@lists.mysql.com > *Date:* Thu, 23 Aug 2007 03:55:27 -0700 (PDT) > > Was wondering if anyo

Re: user permissions to all DB

Just to verify, will that include all new databases? On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote: > Terry wrote: > > Hello, > > > > I want to grant a user all permissions to all DBs on the system as > > well as any new DBs that show up. I want to avoid

user permissions to all DB

Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permissions everytime a new DB is added. Is there a way to do this? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: MySQL Daylight Savings Time Patch - easy check

these time zone tables - are they ever used, should I > populate them or not? > > -Ryan This may depend on where you live? I tried your select above and got two different answers. Trying: SELECT UNIX_TIMESTAMP('2007-03-25 01:00:00'), UNIX_TIMESTAMP('2007-03-25 02

Re: UPDATE question

On 5/3/06, Barry <[EMAIL PROTECTED]> wrote: Cummings, Shawn (GNAPs) schrieb: > > If I have 4 Fields (FIELD1, FIELD2, FIELD3 & FIELD4) > > I can do this easily; > > UPDATE TABLE_NAME SET FIELD4 = FIELD1; > > But -- how do I do it so that FIELD4 = FIELD1 & FIELD2 ??? I can't seem > to find any

Re: How to select the last entry per item

On 4/27/06, Brian J. Matt <[EMAIL PROTECTED]> wrote: > As the items move new time stamped entries are added to the > database. How would you query to find the current location of all > the items currently in the system. As you might expect we don't want > to replace the entry for an item when a l

Re: mySQL Backups

On 4/12/06, Tim Lucia <[EMAIL PROTECTED]> wrote: > Would you not lock tables on the slave? The idea of catching it up implies > this is way it is done. Catching up means once replication can proceed once > the tables are unlocked (on the slave). > > At least that is the way I read it... On the s

mySQL Backups

On 4/11/06, Dana Diederich <[EMAIL PROTECTED]> wrote: > We use a dedicated replicated instance for backups. > > Every night, we lock all of the tables, and dump all of them to > compressed files, and unlock them afterwards. It takes a while to catch > up, but that doesn't hurt anything. I too use

Re: CREATE TABLE x AS with ENGINE = ARCHIVE

On 3/28/06, Peter Brawley <[EMAIL PROTECTED]> wrote: > >I require something along the lines of this: > > >CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE > > CREATE TABLE tblname ENGINE=archive SELECT * FROM request_log; > > PB Excellent. Exactly what I need. Thanks :-) -- MySQL Gene

Re: CREATE TABLE x AS with ENGINE = ARCHIVE

On 3/28/06, Pure Web Solution <[EMAIL PROTECTED]> wrote: > I dont think that it is possible to specify the engine when creating a table > this way, you could however create the table using the: > > CREATE TABLE old AS SELECT * FROM request_log > > and then issue an alter table command setting the e

CREATE TABLE x AS with ENGINE = ARCHIVE

Hi, I'm using MySQL 4.11. Is it possible to use the CREATE TABLE x AS syntax alongside the ENGINE = x pragma, since this would make archiving of tables very simple. I require something along the lines of this: CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE If this cannot be done t

-help

Terry Spencer Haigh Consultancy Services Tel: +44 (0)116 262 3966 Fax: +44 (0)116 262 3946 (Leciester Office) Fax: +44 (0)870 052 4572 (Terry) Mob: +44 (0)7796108244 www.haigh-cs.co.uk <http://www.haigh-cs.co.uk>

Re: working on Microsoft® Windows Server™ 2003

- Original Message - > hi, > > can new mysql work on Microsoft® Windows Server™ 2003 > > regards > > prao > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAI

join question

JOIN B b ON (a.id = b.id AND a.date > b.date AND ?) Any suggestions would be appreciated. Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Row Count Discrepency

row count in admin (or SQLyog or whatever), not an actual count, because of the way it does (or doesn't) store row information. MyISAM tables, on the other hand, show accurately because they store the rowcount as part of the table data. Terry -- MySQL General Mailing List For li

Re: Replication problem

ppear in logs on either server. This GUI has been in use for over a year, but we only switched on the replication system a couple of weeks ago, and this is the first 'occasional' update - that was frequently used on the old master-only system without problems. Thanks again for the hint

Replication problem

elect' into a 'create table temp select from...'/'insert ... select from temp'/ 'drop table temp' set. This insert ... select stuff is not done on a regular basis, and then only by an administrator. Ideas welcome Cheers Terry -- MySQL General Mail

Re: Flushing logs on replication setup

- Original Message - > Terry Riley wrote: > > I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in > > house test setup). > > > > This vaguely duplicates what is set up on the live servers, except > > that the slave is 4.1.3 on N

Flushing logs on replication setup

e taken before flushing, or you won't ever see that logged data again. Is this the way it is meant to be? I don't want to institute any log rotation policy on the slave of the live setup if this happens. Regards Terry Riley -- MySQL General Mailing List For list archives: http:/

Connect issues

message # find / -name mysql.sock /tmp/mysql.soc Setting the location of mysql.sock in my.conf [client] socket = /tmp/mysql.sock Causes error Any suggestions? Thanks Terry

RE: Hour counts

_TIMESTAMP() and subtract one form the other. Divide the result by 3600 (60*60 = seconds in an hour) to obtain the fractional hours. Terry -Original Message- From: Gyurasits Zoltán [mailto:[EMAIL PROTECTED] Sent: 27 July 2005 17:12 To: mysql@lists.mysql.com Subject: Hour counts Hello Al

a question about MySQL installation

Dear, I have installed MySQL4.1. But why it can not startup when I open my computer? Also, how can I test MySQL can run or not? Thanks for your advice. Best Regards, Terry

compiling mysql on macosx 10.4

does anybelly know why the following happens? i am using macosx 10.4 and ./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug sql_list.h: At global scope: sql_list.h:401: warning: inline function `ba

Slightly Off Topic - MySQL Administrator

's not being destroyed by the 'rpm -e'. Does anyone out there happen to know what that is? I've looked at the archives for the MySQL-GUI and find no reference to this... Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Compressing after Deletion

David, According to the documentation, OPTIMIZE will also work on InnoDB tables. Will that produce the same result as your ALTER TABLE ? Cheers Terry - Original Message - > Hi Chris, > > For MyISAM/BDB tables use OPTIMIZE TABLE ; > For InnoDB tables try ALTER TABLE

Re: lost connection DURING query?

ive MySQL datasource connection, and dispense with ODBC? I know it doesn't help the immediate problem, but it would remove one less reliable link in the chain. Terry > > > [MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log]Lost connection to MySQL > server during query > >

Explain and indexes

sible keys, but none used by the query; key = null. Can anyone suggest why? How can I optimise this? Thanks Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: New to MySQL on Linux

Thanks, Joshua - just the sort of info I needed. Off to find a more recent distro Cheers Terry - Original Message - > On Friday 11 February 2005 09:15, Terry Riley said something like: > > Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, > > that ha

Re: New to MySQL on Linux

Thanks to all who replied - food for thought... Cheers Terry - Original Message - > Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, that > had an apparently unusable XP SP2 OS on it, I decided to wipe the disk > and install my first Linux instead, using a

New to MySQL on Linux

load? I am confused by the plethora of options available for Linux. Just need something that is relatively simple to install (either 4.1.9 or 5.0.x). Suggestions, please? Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Re: Excluding Rows

, vapall where fh1109.state = ssa1202.state and fh1109.cd = ssa1202.cd and fh1109.state = vapall.state and fh1109.cd = vapall.cd and ssa1202.state = vapall.state and ssa1202.cd = vapall.cd AND ssa1202.state NOT IN('TX','PA','ME') Terry - Original Message -

Re: Flush_time question and related item

y-write, so I assume therefore that there is no harm in changing flush_time to zero. Any ideas on the second part of my question (which tables are counted)? Cheers Terry > > > Terry Riley <[EMAIL PROTECTED]> wrote: > > We're running mostly with InnoDB tables, about 5% > &

Flush_time question and related item

is 130. What other tables are counted in the opened_tables calculation; does this include tables that may be opened twice under different aliases? Does this include temporary tables (created by MySQL)? Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mys

Re: Locking Issue?

Heikki, - Original Message - > Terry, > > - Original Message - > From: "Terry Riley" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Monday, December 06, 2004 8:15 PM > Subject: Locking Issue? > > > > Can so

RE: Locking Issue?

- Original Message - Thanks for those hints, Dathan (see below): > > -Original Message- > From: Terry Riley [mailto:[EMAIL PROTECTED] > Sent: Monday, December 06, 2004 10:12 AM > To: [EMAIL PROTECTED] > Subject: Locking Issue? > > Can someone help,

Locking Issue?

et=16M set-variable=key_buffer=8M log-bin= log_slow_queries= [mysql] local-infile=1 Any pointers as to what I may be doing wrong? Please? Yes, I know we should upgrade to 4.1.7, and we will - soon. Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Partial Restore

.select sequence took about 20 seconds on my beat-up, memory-starved machine. Took me longer doing the backup/transfer to dummy. So I have found *a* method for doing what I need, while quite a few of you have been away enjoying (hopefully) your Thanksgiving holiday. It would be useful if anyone c

Partial Restore

ng 4.1.3/Apache/WinNT, with hopes of upgrading to 4.1.7 before going live, though I doubt if the MySQL sub-version is relevant. I'd appreciate any help or guidance or advice on suitable tools. Cheers Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Error

You can't - auto_increment cannot have a default value, AFAIAA. Terry - Original Message - > mysql> create table list_admin ( > -> admin_id int(11) default '0' not null auto_increment > -> ); > ERROR 1067 (42000): Invalid default value for &

mysql and leftt outer join

can get a left outer join to work that links two table, but not more. So how woulds you construct the above select to use only left outer joins??? Thx,Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Assertion failure (MySQL Administrator)

the Server and the Administrator, but am unable to until we have some downtime. Can I assume that, as the server is still running (apparently without problems) that the reported fault is only to do with Admin trying to read the log files, and nothing more serious? TIA Terry Riley -- MySQL Gener

RE: 4.1.4 still reports itself as 4.1.3b-beta

All sorted now, Ian. - Original Message - > Hope this helps > > If not try this (joking): > > http://foldoc.doc.ic.ac.uk/foldoc/foldoc.cgi?RTFM > > Ian > -- That's what was missing. LOL > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: 4.1.4 still reports itself as 4.1.3b-beta

y it continued to use the older beta, though I thought I had. (FX: talks to self - 'must read the instructions *first* next time'). Thanks for your help, guys. Running the 'mysqld --version ' on the command line convinced me that I had actually installed it. Cheers Terry

RE: 4.1.4 still reports itself as 4.1.3b-beta

ePath\ Never having had to fiddle with the registry much in the past, can I presume that if I ignore the first two and change the third one to read 'mysqld' instead of 'mysqld-opt', save and reboot, I should get the right one started? As you can tell, I'm a litt

RE: 4.1.4 still reports itself as 4.1.3b-beta

Victor C:\MYSQL\BIN\mysqld-opt --defaults-file="C:\WINDOWS\my.ini" MySql is what the path-to-executable states. If I remember rightly, the new version should be mysqld, period. Is that what's wrong? Will I have to tweak the registry to change that? Cheers Terry - O

Re: 4.1.4 still reports itself as 4.1.3b-beta

s for 4.1.4gamma, so it does look as though the upgrade went through, as far as copying files is concerned. Just restarted again with no change (just in case). Any other clues? Terry - Original Message - > Terry Riley <[EMAIL PROTECTED]> wrote: > > I have tried several instals

4.1.4 still reports itself as 4.1.3b-beta

mysql. Have I done something stupid, or are others seeing this, too? Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Using CREATE PROCEDURE/FUNCTION

I think you'll find that 'create procedure' and 'create function' don't appear until version 5.0 of MySQL. Which is why you get a syntax (are you sure you have the right version?) error. Regards Terry - Original Message - > Hi! > Anybody knows ho

Re: Help: Retrieving time stamp

t is useful in testing to have php output the full SQL query text to the browser, just so you can see it is correct before proceeding. Cheers Terry - Original Message - > Is there something wrong with this code ? > Still confused after reading the manual. > > $rsJo

Re: Fairly lame question

field in the manual for how to create it. Cheers Terry - Original Message - > I think this can be done, but tried a few times with > no success. I want a column in a table that sets a > timestamp. > Instead of passing a value from the form though is > there a way mySql woul

RE: Strange Text Field

Stuart Could this be something as simple as the fact that you have a field with a space in its name ('Contact Email'), which is sometimes called as 'Contact Email' and sometimes as 'Contact_Email'? I'm not even sure if a blank space is actually allowed in

Re: recommended books for web app.

I'd go along with that recommendation. Terry - Original Message - > Welling & Thomson is terrific. > - Original Message - > From: Kerry Frater > To: "MySQL List" > Sent: Thursday, August 12, 2004 8:09 AM > Subject: recommended book

Re: Joing two fields in a query

CONCAT() is what you need! SELECT CONCAT(Firstname,' ',Lastname) AS Name FROM Users; Terry - Original Message - > Hi, > > Is it possible to join two fields in a query so that they are displayed > as one column? For exmaple: > > SELECT Firstname + '

Re: type=heap problem...

I think the error is self-explanatory - you can't use auto_increment in a heap table (but you can have an index) Terry - Original Message - > I couldn't get temporary table to load into memory using type=heap, > here's > the sample error as following: >

Re: Query Cache

Thanks to all who replied. Regards Terry Riley - Original Message - > We have the query cache turned on, and it appears to be working well. > > However, there appears to be no indication in the manual as to the time > that a cached query remains in memory. In the abs

Query Cache

if the cached query is called before the timeout. Regards Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Bin-log strangeness

ed by the documentation), but I'm still miffed by this set of entries. Any hints would be gratefully accepted. Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL user passwords and ColdFusion MX6.1

passwords. Killing these off, restarting with --old-passwords and redoing them as 16-char passwords allowed CF to register the DSNs. Hope this might help someone else who's going prematurely bald. Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Small Bug in 4.1.3 beta ?

No problem, Heikki. It's just a bit disconcerting to see '1' when '0' is expected. As for larger numbers, I realise that the rowcount is only an estimate for InnoDB. Cheers Terry - Original Message - > Terry, > > thank you for reporting this. Sinc

Small Bug in 4.1.3 beta ?

alpha. SELECT COUNT(*) retrieves the correct number, however. This is not the case for the MyISAM tables, which show the correct numbers at all times. Is this supposed to happen? Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

DATE_FORMAT & DISTINCT

MX)? Can't see why the DISTINCT clause should change a string to a ByteArray Any help would be appreciated. Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Full text search problem

'm not mistaken. Hope that helps Terry --Original Message- > Hi > > I have a fulltext search on a dbase for lost pets. > My problem is the following: > > I have dog in the database called "May May" which doesnt show up in the > sear

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

Just a suggestion, Kevin, but how about changing from INT to BIGINT? Terry --Original Message- > We have a table with a primary index which is INT NOT NULL > AUTO_INCREMENT. > > After inserting ~87,000,000 entries, we started seeing error 1062, > ER_DUP_ENT

Spatial extensions and GIS

coordinates. I have 2 problems: 1) The Distance nor the Buffer functions have not been implemented. 2) How can I use MySQL to help me convert from lat / long to distances in miles (or KM)? Thanks. Terry. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: mixing GROUP BY, AVG and COUNT

gt; -- > Chris W If I understood the question correctly, what you need is something like: SELECT @totaldates:=COUNT(DISTINCT date) FROM Table; SELECT COUNT(*)/@totaldates AS Average FROM Table; Regards Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.

Re: field = order, data not inserting?

Probable cause: 'order' is a reserved word in MySQL (as used in 'order by'). Terry --Original Message- > I have a field named "order" i think im missing something obvious, but i > cant find it. > When i insert something on the fi

Re: Limit in sub-query - when can we expect it?

Also interested in answer to this one. Terry Riley --Original Message- > Hi List, > > When can we expect limits in sub-queries? I am currently on 4.1.0. > > 1235 - This version of MySQL doesn't yet support 'LIMIT & > IN/ALL/ANY/SOME >

calc field ?

How do you set up calculated fields in mysql? Thx,Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Processlist

Occasionally, when looking at the processlist using MySQLAdmin, I see entries 'unauthenticated user' 'reading from net' Would some kind person tell me what this means, and if I'm in danger of having data compromised? Thanks Terry Riley -- MySQL General Mailing Lis

Re: How do I determine the row number or key when table has no key

Take a look at LIMIT in the Manual Cheers Terry --Original Message- > eg. say a table is created using: > > create table fred (f1 char(10), f2 int) > > Then it has neither keys nor an AUTO_INCREMENT field. > > Let's say 1000,000 records ar

RE: New to MySQL

Thanks Peter, Will try out XAMPP. Regards -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED] Sent: 17 March 2004 10:50 To: Terry Smith; [EMAIL PROTECTED] Subject: RE: New to MySQL Hi To use phpMyAdmin you need a webserver and php installed - the code suggests you either

RE: New to MySQL

ginal Message- From: Terry Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 4:25 AM To: [EMAIL PROTECTED] Subject: New to MySQL I have just started having a look at MySQL. I have the server installed and running with the default settings and I now need to create a database and t

New to MySQL

I have just started having a look at MySQL. I have the server installed and running with the default settings and I now need to create a database and tables. I will be testing all locally on WinXPpro. I would like to use phpMyAdmin but am having some trouble displaying the index.php page. IE show

Re: error in nested query?

Subselects are only available from 4.1 - that's why you have an error. Terry --Original Message- > Hi all > I have Mysql 3.23.45 on linux. > > while trying this command : > SELECT outbox_id > FROM outbox > WHERE send_time=(SELECT MAX(send_time) FR

Re[3]: Update field conditionally

> Hello Terry, > > Tuesday, March 9, 2004, 6:25:00 PM, you wrote: > > TR> Good point, Richard. I was perhaps in a little bit too much of a > > hurry > TR> putting that together, and didn't even consider that! > > No worries. One other thought that

Re: Update field conditionally

See below: --Original Message- > Hello Terry, > > Tuesday, March 9, 2004, 5:11:00 PM, you wrote: > > I know you have some solutions to the original problem already, but I > just wanted to make one small observation: > > TR> The fields are to

Re: Update field conditionally

an be fairly certain that the record exists (or can code around it if it doesn't), so I'll probably stick with what I've got. Thanks anyway! Terry > > - Original Message - > From: "Terry Riley" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>

Re: Update field conditionally

Thanks, Jeremy What I actually needed was: UPDATE Table SET CounterValue = CounterValue+1, CounterStartDateTime = IF(CounterStartDateTime IS NULL, Now(), CounterStartDateTime) This prevents it going back to NULL if the value is already not NULL. Thanks again. Terry --Original

Update field conditionally

-line manual, and cannot find any reference to such conditional updates. Perhaps I missed it. Any clues, please? Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: uppercase field constraints

Think that is for your script to work on, i.e. INSERT INTO table (field1, field2) VALUES (UCASE('form.field1'), form.field2) depending on the syntax of your programming language (and which MySQL version you are using). The above works on 4.1.1. Terry

Re: any ideas about it

Try ABS() Terry --Original Message- > Hi all, > > I m looking for any function or a work around to fetch numerical data > without its sign (-10 --10, 10 --> 10). Any ideas? > > Thanx -- MySQL General Mailing List For list archives: http://lis

Re: SQL Query

I think it should be: SELECT * FROM articles WHERE sectionID=1 ORDER BY Entrydate Desc LIMIT 1,10 Terry --Original Message- > Any idea what is wrong with the following: > > > SELECT * From articles ORDER BY EntryDate DESC > LIMIT 1,10 > WHERE SectionI

Re: Problem while installing MySQL, etc.

Thanks, Matt - I managed by unzipping it all to a new directory then renaming the directories so that the new one was c:\mysql and the old one became c:\mysql_4017, then run the mysql_fix_privilege_tables script. Cheers Terry --Original Message- > Sharma and Terry, >

Installation of 4.1.1 on XP

. How can I upgrade from 4.0.17, please? Or even start again from scratch with 4.1.1? Regards Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Running 4.0.17 and 5 on same machine

Thanks, Bruce, Roger Terry Riley --Original Message- > Currently running 4.0.17 InnoDB on XP/Apache 2.0.47; client wants to > investigate using capability for stored procs in v5, but doesn't have > another machine on which to experiment. Can these two be run

Running 4.0.17 and 5 on same machine

Currently running 4.0.17 InnoDB on XP/Apache 2.0.47; client wants to investigate using capability for stored procs in v5, but doesn't have another machine on which to experiment. Can these two be run on the same machine (though not at the same time)? Regards Terry Riley -- MySQL Ge

RE: mysqldump ?

Yes, that seems to be part of the problem. I still seem to be loosing some images though. And how can I upload to PHPMyAdmin without altering the comments that mysqldump creates. Terry On Wed, 15 Oct 2003 12:05:19 -0500, Christensen, Dave wrote: >Are you attempting any sort of editing

Re: mysqldump ?

For the free web server, the transfer was web based using MyPHPAdmin. To test it on my RedHat 8.0 box(my home network server,) I copied the file to my Samba directory with Windows Explorer Then I switched over and signed on and did the import. On Wed, 15 Oct 2003 11:37:32 -0500, Paul DuBois wrot

mysqldump ?

I have a mysql 3.23 running under win98. I also have a database with a largeblob, which has a jpeg image in it. Now I am trying to upload this to a free server using the following command to export the table: bin/mysqldump -u user --password=mypass mydatabase mytable > dumpdir\mytable.sql The

PHP/MySQL/MyODBC drivers

I need to know the syntax to link two tables together that are in two seperate DB's using the ODBC drivers in PHP. Can anyone help with an example? Thanks Terry L. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: combining fields in select

g wrong or is there a different way to achieve this > with mysql? > select CONCAT(TRIM(firstname),' ',surname) AS fullname from people should work Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   >