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
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
is appreciated.
Best Regards,
Terry
(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
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
this?
Thanks,
Terry
Terry Babbey
Infrastructure Specialist
Information Technology, Lambton College of Applied Arts Technology
[EMAIL PROTECTED], 519.542.7751 x3293
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
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
]
--
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
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
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:
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
'),
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
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
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
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
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
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
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
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
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
- 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 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]
(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
...'/'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
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
- 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, 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
/ -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
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
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
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
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]
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
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
, 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]
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
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
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
, 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
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
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
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
=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
- 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
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
/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
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
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
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
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
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
\
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
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
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:
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]
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
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
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
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
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
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
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
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
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]
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]
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
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
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
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]
.
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
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
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
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]
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
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
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]
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
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
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
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
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
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
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]
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
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
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
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
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
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
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
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
.
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]
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
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
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
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
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
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
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 - 100 of 169 matches
Mail list logo