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-1000 Cell e

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-0987

Multiple joins from same table?

is appreciated. Best Regards, Terry

Re: DATATYPES

(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 on: 09/09/2008 13:44:05 avast! - copyright (c) 1988-2008 ALWIL Software. http://www.avast.com -- MySQL

Re: DATATYPES

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.uk/ --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 080908-0, 08/09/2008 Tested

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: 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

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 Sep 2007 10:05:52 -0500

RE: seoparator help

] -- No virus found in this incoming message. Checked by AVG. Version: 7.5.484 / Virus Database: 269.12.2/967 - Release Date: 22/08/2007 18:51 Terry http://booksihaveread.awardspace.co.uk -- No virus found in this outgoing message. Checked by AVG. Version: 7.5.484 / Virus Database: 269.12.4/969

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 anyone could help me

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:

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 having to modify permissions everytime a new DB

Re: MySQL Daylight Savings Time Patch - easy check

'), UNIX_TIMESTAMP('2007-03-25 02:00:00'); which is when BST sets in in the UK (where I am), gave me identical answers. My 2 cents-worth Terry www.confexdb.co.uk | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

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 examples

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

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 slave I

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 this

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

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 engine

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 General

-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/[EMAIL PROTECTED] Yes Terry Riley -- MySQL

join question

JOIN B b ON (a.id = b.id AND a.date b.date AND the row with the max dates from the possible join in b?) 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

(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 list archives: http://lists.mysql.com

Replication problem

...'/'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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Replication problem

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! Terry See: http://dev.mysql.com/doc/mysql/en/slave

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 NT4. On the test setup, if the logs

Flushing logs on replication setup

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://lists.mysql.com/mysql

Connect issues

/ -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

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 All! I would like to calculate the hour counts from 2 'datetime'. Example: 2005-07-27 18:00 and 2005-07-27 19:30 = 1,5 hour

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

Slightly Off Topic - MySQL Administrator

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: lost connection DURING query?

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 that during part threw me, but it may

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 your table name; For InnoDB tables try ALTER TABLE your

Explain and indexes

, 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 had an apparently

New to MySQL on Linux

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.mysql.com

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 an ancient

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 - How do I exclude some rows

Re: Flush_time question and related item

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% updates/inserts/deletes, the rest selects, on Windows NT. In setting table_cache to 256 from the default 64, we

Flush_time question and related item

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.mysql.com/mysql

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 someone help, please? We set up a server to handle a coldfusion

Locking Issue?

=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/mysql To unsubscribe:http

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, please? We set up a server

Re: Partial Restore

I need, while quite a few of you have been away enjoying (hopefully) your Thanksgiving holiday. It would be useful if anyone could point me at a simpler alternative, though. Cheers Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Partial Restore

/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 unsubscribe:http

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 'admin_id' How can I set default value to 0

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)

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 General Mailing

Re: 4.1.4 still reports itself as 4.1.3b-beta

is 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 (Windows XP), using

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 - Original Message

RE: 4.1.4 still reports itself as 4.1.3b-beta

\ 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 little wary of this. Cheers Terry

Re: 4.1.4 still reports itself as 4.1.3b-beta

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 - Original Message - I have tried

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 unsubscribe:

4.1.4 still reports itself as 4.1.3b-beta

of 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 how to use CREATE PROCEDURE and CREATE

Re: Help: Retrieving time stamp

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. td?php echo $rsJobShortDat-Fields('DATE_FORMAT

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 field names Cheers Terry Riley

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 would automagically stamp

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 books for web app. I am looking to port

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 + ' ' + Lastname AS 'Name' FROM Users; I

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: mysql create table tblheap

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 absence

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

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

of the 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/mysql

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. Since the cardinality reported by SHOW

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

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

. 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 search results. A dog called Doggy Doggy does show up however. I

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_ENTRY. We can get

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

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.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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 field order via PHP, no data on all of my fields

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 subquery' Query: -- MySQL General

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 List For list archives: http

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 are then inserted into table fred. I

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

RE: New to MySQL

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 tables

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: 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) FROM outbox WHERE subs_id=myid

Update field conditionally

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: 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

Re: Update field conditionally

route, rather than the other way around. And I really don't think I want to have a Select, Update, Select routine I can 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

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 be CounterCode (Varchar 10), CounterValue

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 occurred to me that might help with the original

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 --Original

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://lists.mysql.com/mysql To unsubscribe

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 SectionID=1 I want to return all

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, I

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]

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 General

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 on the same

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

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

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

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/[EMAIL

Re: combining fields in select

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   >