.com/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Original Message -
From: Sukhjinder K. Narula
To: Mike Blezien
Cc: MySQL List
Sent: Tuesday, October 08, 2013 8:08 AM
Subject: Re: Check for numeric values
Hi,
You could use regular expression to do this, here is the example with the
reference site that might help
Hello,
I need to select some data from a table where a column is not a numerical value
but can't seem to get the right syntax for this.
Basically we need to do something like this:
SELECT * FROM tablename WHERE column_name (IS NOT A NUMERIC VALUE)
what is the correct syntax to accomplish thi
inal Message -
From: Simon Griffiths
To: 'Mike Blezien' ; 'MySQL List'
Sent: Sunday, February 12, 2012 10:26 AM
Subject: RE: Formatting Numbers with commas
Please see
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_format
Reg
- Original Message -
From: "Christoph Boget"
To: "Mike Blezien"
Cc: "MySQL List"
Sent: Tuesday, August 31, 2010 1:06 PM
Subject: Re: Even or Odds numbers
is there a function, using MySQL 5.0v, that can detect if a numerical value
is either an Ev
Hello,
is there a function, using MySQL 5.0v, that can detect if a numerical value is
either an Even or Odd number
Thanks,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
http://www.thunder-rai
z" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'MySQL List'"
Sent: Monday, November 24, 2008 9:21 AM
Subject: RE: Special Characters
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent
Hello,
we are in the process of setting up a database with members data and other info.
We'll need to enter names with special characters, i.e:
apostrophes: O'Rourke
tildes: Magglio Ordóñez
titlo: Anaïs
hyphen: Chun-Myers
Is there some special table setup required, collation or storage e
Hello,
we have a column in a table, called tag numbers, which start with numerical and
alpha characters, IE:
012345
123456
LH12345
KB055698
47899901
MO558585
... etc.
now what I need to do is to display all the tag numbers, but order by their
alpha prefix, either DESC or ASC. What is the
- Original Message -
From: "Mike Aubury" <[EMAIL PROTECTED]>
To: ; "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "Jerry Schwartz" <[EMAIL PROTECTED]>
Sent: Monday, June 25, 2007 3:44 PM
Subject: Re: Birthday format
I might be wrong - but isn&#
thanks, worked prefectly,
Mike
- Original Message -
From: "Jerry Schwartz" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'MySQL List'"
Sent: Monday, June 25, 2007 3:01 PM
Subject: RE: Birthday format
Chris,
- Original Message -
From: "Chris Boget" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Monday, June 25, 2007 2:15 PM
Subject: Re: Birthday format
we have a simple query to calculate someones birt
Hello,
we have a simple query to calculate someones birthday:
SELECT (TO_DAYS(CURDATE()) - TO_DAYS('1952-10-06')) / 365;
= 54.75
Now is there away, using SQL, to remove the .75 without rounding off. we just
want the '54' value. We can do it easy enough with our Perl programming, but was
won
Hello,
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: "MySQL General"
Sent: Monday, May 14, 2007 10:26 AM
Subject: Re: Scheduled backups
J Trahair wrote:
Hi Everyone
I have set up a scheduled backup using MySQL Administrator. Stored
connection, database, dates and
d yes I got a few errors, as other people have mentioned in this thread.
But they all appear to be related to overseas timezones so I'm not too
concerned about them.
-Ryan
Mike Blezien wrote:
Out of curiousity, what should be done if they results are different. We
checked on one of boxes and got t
Out of curiousity, what should be done if they results are different. We checked
on one of boxes and got two different results:
SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'),
-> UNIX_TIMESTAMP('2007-03-11 03:00:00');
+---+
have you try using the datatype YEAR for you table field/column ?
Mickalo
- Original Message -
From: "John Berman" <[EMAIL PROTECTED]>
To:
Sent: Monday, February 19, 2007 11:45 AM
Subject: Year - Field type
Hi
Using mysql4
Sure this is an easy one a field in my dbase is year of b
Chris,
this is something very similar to what we are attempting to accomplish:
http://www.papajohnsonline.com/restlocator/RestaurantLocator
Mike
- Original Message -
From: "Chris W" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MYSQL
Hello,
we are working on a small project which needs to calculate the closest distances
from an address and/or zipcode entered into a search box. It will read from a
MySQL database of companies, which store their address and zipcodes.
looking for the best way to approach this. I've seen some zip
It's PHP I believe, oscommerce web site, MySQL 4.0.27. this is for an associate
of ours and I am not much of a PHP programmer, strickly Perl :)
Mike
- Original Message -
From: "Dan Buettner" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]&
Hello,
occassionally we come accross this error:
2013 - Lost connection to MySQL server during query
not all the time, but now and then, no real pattern that we can see of find in
the logs. but appear to happen mainly with SELECT's
is there a way to fix this or trace it down to a cause?
TIA
Is this list still working ?
Mickalo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Gerald,
- Original Message -
From: "Gerald L. Clark" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Thursday, June 08, 2006 8:40 AM
Subject: Re: correct syntax
Mike Blezien wrote:
Hello,
we need to query
Hello,
we need to query one of database tables that sore usernames, and many of them
have spaces in them that need to be removed. what would be the correct function
to identify each username column value that has a space(s) in them?
TIA,
Mike(mickalo)Blezien
--
MySQL General Mailing List
F
Hi Sheeri,
Is your 'u.modified' column a TIME datatype '00:00:00'
Mike
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Wednesday, May 17, 2006
Hello,
this is a continued problem we are having from a earlier posting to the list
regarding a query. We need to calculate the SUM of the column
'agent_product_time' which is a TIME datatype column and according to the
manual:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-type-overvie
Gordon,
thank you, works prefectly now.
Mike
- Original Message -
From: "Gordon" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'MySQL List'"
Sent: Tuesday, May 16, 2006 3:17 PM
Subject: RE: Baffled by
Peter,
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Tuesday, May 16, 2006 1:25 PM
Subject: Re: Baffled by error
Mike,
>How would this query be constructed w
Peter,
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Tuesday, May 16, 2006 1:07 PM
Subject: Re: Baffled by error
Mike Blezien wrote:
Hello,
MySQL 4.1.12
tr
corrected it and still the same error.
Mike
- Original Message -
From: "Chris Sansom" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Tuesday, May 16, 2006 12:56 PM
Subject: Re: Baffled by error
At 12:29 -05
Tried that, still same error. If I remove the 'AND
SUM(c.agent_product_time) >= '500'
then it works, but I need this in the query.
Mike
- Original Message -
From: "Ing. Edwin Cruz" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[E
Hello,
MySQL 4.1.12
trying to figure out why I keep getting this error with the following query:
SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS mins
FROM account a LEFT JOIN calls c ON c.account_id = a.id
WHERE c.calldate >= DATE_SUB(NOW(),INTERVAL 14 DAY) AND c.agent_id =
=21121
HTH
Keith
In theory, theory and practice are the same;
in practice they are not.
On Fri, 21 Apr 2006, Nicolas Verhaeghe wrote:
To: 'Mike Blezien' <[EMAIL PROTECTED]>,
'MySQL List'
From: Nicolas Verhaeghe <[EMAIL PROTECTED]>
Subject: RE: Olde
Hello,
I am attempting to upgrade one of our older servers running RH 7.3
w/glibc-2.2.5-44
it's currently using 3.23.58 and tried installing 4.0.26 rpm's for linux, but
won't install due to the following error:
libc.so.6(GLIBC_2.3) is needed by MySQL-shared-4.0.26-0
libpthre
- Original Message -
From: "tuxlinsecure" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 18, 2006 11:41 AM
Subject: Change datadir in rpm installation
Hi,
I am a newbie. I need to change the datadir after the rpm installation
How to do it?
Thanks,
in your my.cnf under the mysql.ser
Jim
- Original Message -
From: "Jim Winstead" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Thursday, April 13, 2006 7:28 PM
Subject: Re: Download older versions
On Thu, Apr 13, 2006 at 07:13:55PM -0500,
Hello,
I'm trying to locate the RPM downloads for MySQL version
4.0.26(4.0.26-pc-linux-gnu-i686), for a RH/7.3 system, but can't seem to find
them. Doesn't MySQL site have older version archives where these older RPM's can
be downloaded ... if so, where would they be located ??
TIA,
Mike(mi
Hello,
is there a MySQL function to determine the total days of any given month, IE if
current month is April, is there a function or query to find the total days of
the month?
TIA,
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Soluti
997-12-31 23:59:59','1997-12-30');
-> 1
mysql> SELECT DATEDIFF('1997-11-30 23:59:59','1997-12-31');
-> -31
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Sat, 1 Apr 2006, Rhino wrote:
To:
Jorrit,
- Original Message -
From: "Jorrit Kronjee" <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 01, 2006 7:46 AM
Subject: Re: Getting number days between 2 dates
Mike Blezien wrote:
Hello,
I'm sure this is a simple query but haven't come up with a g
Hello,
I'm sure this is a simple query but haven't come up with a good approach. Need
to get the number of days between two dates. IE: today's date: (2006-04-01 -
2006-03-05)
need to calculate the number of days between these dates.. what is the best
query statement to accomplish this?
TIA,
Hello,
I'm alittle unclear on how too update multiple tables. We have two tables with
the same column name:
account.state
account_service.state
when we update the account table, we also need to update the account_service
table with the same value for the 'state' column. Can this be done with
Mike,
- Original Message -
From: ""Mike Blezien"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 22, 2006 3:42 AM
Subject: Problem restarting server
Hello,
we had to reboot our server and now we can&#x
Hello,
we had to reboot our server and now we can't get MySQL started, in the error log
it states:
==
060321 19:34:13 mysqld started
060321 19:34:13 [Warning] Asked for 196608 thread stack, but got 126976
InnoDB: Error: log file ./ib_logfile0 is of
Hello,
MySQL version: 4.1.10a
we are getting this error when attempting to connect to our MySQL database:
install_driver(mysql) failed: Can't load
'/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBD/mysql/mysql.so'
for module DBD::mysql: libmysqlclient.so.10: cannot open shared
OK, I think I got it now. Thanks for the additional info, that helps alot.
Rhino wrote:
- Original Message - From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Friday, February 17, 2006 7:49 AM
Subject: Database design help
Hello,
we curre
Hello,
we currently have a small database setup for affilates and visitor/leads. I
believe we have a "one to many" application, one affiliate can have several
visitor/leads but each visitor can only be assigned to one affiliate.
What I need to know if this the best design for this setup. Basi
Andy,
thank you, this is very helpful understanding the UK postcode scheme, appreciate
your input.
Andy Eastham wrote:
Hi,
There is a database available which maps post codes to grid references.
This is controlled by the Royal Mail.
See http://www.royalmail.com/portal/rm/jump2?mediaId=400
Yes, after some further research, I found a Perl Modules that handles this queit
nicely.
thx's
[EMAIL PROTECTED] wrote:
I need to do a search query on the columns called
Name of business "the name of the business"
Town "Local town or city name"
Postcode" this is the same
Hello,
I need to do a search query on the columns called
Name of business "the name of the business"
Town "Local town or city name"
Postcode" this is the same as your zip code"
Category"this is type of business ie dress shop bakers"
XY "this is the table
is the list still working ?
--
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://thunder-rain.com/
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
--
MySQL General Mailing List
For list archives: http://lists.mys
Hello,
we are working with a database that stores UK postcodes, which are different
then US zipcodes. I've found alot of information for working with zipcodes,
locating closed distances within a zipcode range, but haven't found anything
regarding working with UK type postcodes.
Was hoping someon
Hello,
we are working with a database that stores UK postcodes, which are different
then US zipcodes. I've found alot of information for working with zipcodes,
locating closed distances within a zipcode range, but haven't found anything
regarding working with UK type postcodes.
Was hoping so
Hello,
we are working with a database that stores UK postcodes, which are different
then US zipcodes. I've found alot of information for working with zipcodes,
locating closed distances within a zipcode range, but haven't found anything
regarding working with UK type postcodes.
Was hoping someon
Hello,
we are currently running std. MySQL 4.0.26 on an old production server using RH
7.3, using the std rpms downloaded from:
http://sunsite.informatik.rwth-aachen.de/mysql/Downloads/MySQL-4.0/
we would like to upgrade to 4.1.15, which I believe is the current stable
release, and was wonde
[EMAIL PROTECTED] wrote:
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 10:08:24 AM:
Hello,
[EMAIL PROTECTED] wrote:
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 08:34:56
AM:
Hello,
I am trying to put together a single query from across 4 tables and
Hello,
[EMAIL PROTECTED] wrote:
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 08:34:56 AM:
Hello,
I am trying to put together a single query from across 4 tables and
not having a
problem getting the results needed. table str
Hello,
I am trying to put together a single query from across 4 tables and not having a
problem getting the results needed. table structure:
##
CREATE TABLE IF NOT EXISTS job_posts (
jobid int(6) unsigned NOT NULL auto_increment,
job_vacan
Hello,
I have a search query to build on two table below is the table structure, and I
need to build a query to search on specific cities(or all cities),specific
subjects(or all subjects) and specific levels(or all levels)
# Table structure for tt_jobs and tt_jobbids
# tt_jobs
pid int(6)
Simon Garner wrote:
Mike Blezien wrote:
Hello,
when using the AVG function like this:
SELECT AVG((5+8+10)/3) AS rate;
it returns NULL??
the AVG can be used to do a literal math calculation ??
TIA
That doesn't make any sense... AVG is a GROUP BY function.
If you have 3 rows with values 5, 8 a
Hello,
when using the AVG function like this:
SELECT AVG((5+8+10)/3) AS rate;
it returns NULL??
the AVG can be used to do a literal math calculation ??
TIA
--
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
=-=-=-
Gleb Paharenko wrote:
Hello.
Unicode is usually used in such cases.
Mike Blezien <[EMAIL PROTECTED]> wrote:
Hello,
we are working on a project that will be using multiple languages to be
displayed and stored in a database, for producing various text strings in
english and the language ass
Hello,
we are working on a project that will be using multiple languages to be
displayed and stored in a database, for producing various text strings in
english and the language associted with it's english counter part.
What do we need to consider before creating the database and tables that wil
Hello,
we are working on a project that will be using multiple languages to be
displayed and stored in a database, for producing various text strings in
english and the language associted with it's english counter part.
What do we need to consider before creating the database and tables that wil
Hello,
Sorry for the slightly OT question :)
Hoping we have some expert MySQL Function to perl function people on the list.
Is there an equivelant function in perl for converting IP's, the same as MySQL
functions: INET_ATON('IP_ADDRESS_STR') and INET_NTOA('STR')
TIA,
--
Mike(mickalo)Blezien
=-=-=
Hello,
what type of privileges need to be assigned and/or changed when upgrading form
MySQL 4.0.24 to 4.1.10 in order to allow users use of the mysqldump utility.
Users where allowed to use the mysqldump to backup their databases and worked
fine with 4.0.24, till the upgrade to 4.1.10 which no w
Jigal van Hemert wrote:
From: "Mike Blezien"
we started getting these table handler errors 12, not all the time, but
just now
For errors from the operating system you can use perror to find out the
description of the code:
http://dev.mysql.com/doc/mysql/en/perror.html
Regards, Jigal.
Hello,
we started getting these table handler errors 12, not all the time, but just now
then. this is a FreeBSD 4.9-RELEASE O/S, w/MySQL 4.0.24 installed. The database
in question is used by this vBulletin BBS system. Not sure it's a problem with
the BBS or how MySQL is configured. Was wonder if
Hello,
I'm trying to figure out how sort a column alphabetically, but some of the
values start with a numerical value. So when I do the ORDER BY column_name all
the values starting alphabeticlly are listed first, then the numerical values
after that.. can this be done in a single query..
MySQL
mos wrote:
At 01:54 PM 9/14/2004, you wrote:
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
Why?
Mysql 3.23.52
Joe,
By default MySQL has a 4 letter minimum for fulltext searches;
words must be at least 4 letters in length otherwise they won't get
added. Si
Michael,
Michael Stassen wrote:
Mike Blezien wrote:
Hello,
Not sure this is possible to do with SQL or if needs to be done with
in the application programming language we're using(Perl), but I need
to get the a weekdate, IE
SELECT EXTRACT(DAY FROM NOW())
which would return 30
Now what I ne
Hello,
Not sure this is possible to do with SQL or if needs to be done with in the
application programming language we're using(Perl), but I need to get the a
weekdate, IE
SELECT EXTRACT(DAY FROM NOW())
which would return 30
Now what I need to do, is if the query above is greater or less then 15
html> for more.
Michael
Mike Blezien wrote:
Hello,
MySQL version 4.0.20
I'm trying to figure out, if it's possible to do, with one query to
update a single table.
Query #1
select m.memid from members m left join active a
on a.memid = m.memid where a.acct_days > 0 and m.account = 1
Hello,
MySQL version 4.0.20
I'm trying to figure out, if it's possible to do, with one query to update a
single table.
Query #1
select m.memid from members m left join active a
on a.memid = m.memid where a.acct_days > 0 and m.account = 1;
Query # 2
update members set account = 2 where memid in (r
Hello,
Happen to come accross this articale
http://www.securiteam.com/unixfocus/5BP0420DFQ.html
and was wondering, using 4.0.20, if we need to make some changes or has this
been addressed by MySQL staff ??
TIA,
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publish
cancel this, found my problem :) this query worked:
SELECT * FROM subscribers ORDER BY acctid DESC LIMIT 1
Original Message
Subject: Query last record in table
Date: Mon, 05 Jul 2004 13:52:28 -0500
From: Mike Blezien <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Organi
Hello,
what is the most effecient way to query the last record in a table, if querying
the primary key(acctid) column ??
I've tried "select *,max(acctid) as lastid from subscribers where acctid =
'lastid' group by acctid"
but this returns nothing ??
TIA :)
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=
_clients| status variable.
Those searchable docs are very handy for looking up error codes, etc.
David.
Mike Blezien wrote:
Hello,
I recently noticed this error in our mysql error log file:
Aborted connection 5439 to db
Hello,
I recently noticed this error in our mysql error log file:
Aborted connection 5439 to db: 'database_name' user: 'someuser' host:
`localhost' (Got an error reading communication packets)
-
Hello,
Somehow the mysql server time is set 3 hours earlier than the system time(CDT),
is there a way to correct this so they both are the same ?
TIA
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-
thx's for the input :)
Mike
Jigal van Hemert wrote:
From: "Mike Blezien" <[EMAIL PROTECTED]>
040601 9:17:20 Warning: Asked for 196608 thread stack, but got 126976
Is this type of Warning something to be concerned about or is this common
or how
best to fix ??
--quote
Hello,
Noticed this morning when restarting MySQL, saw this in the error log file:
Version 4.0.20(RPM's)
---
040601 9:17:17 /usr/sbin/mysqld: Normal shutdown
040601 9:17:18 InnoDB: Starting shutdown...
040601 9:17:20 InnoDB: Shutdown completed
040601 9:17:20 /usr
Hello,
got this error when upgrading our MySQL:
rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm
Preparing...### [100%]
file /usr/lib/libmysqlclient.so.12.0.0 from install of MySQL-shared-4.0.20-0
conflicts with file from package MySQL-shared-compat-4
Hello,
got this error when updating our MySQL:
rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm
Preparing...### [100%]
file /usr/lib/libmysqlclient.so.12.0.0 from install of MySQL-shared-4.0.20-0
conflicts with file from package MySQL-shared-compat-4.
Hello,
is it possible to change the default character set for one mysql user without
affecting the mysql global character set setting, via the the user's .my.cnf
option file ??
thx's
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solut
Hello,
is it possible to change the default character set for one mysql user without
affecting the global character set setting, via the the user's .my.cnf option
file ??
thx's
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions t
Hello,
this maybe a more related issue with DBI API but I thought I try first posting
here to see why we would be getting this error (24) - Too many open files
Error Message:
DBD::mysql::st execute failed: File './mysql/user.MYD' not found (Errcode: 24)
What would be causing this type of error
Hello,
Trying to fix this problem "mySQL error 1016"
I found this at the InnoDB site.
Another symptom of an out-of-sync data dictionary is that MySQL prints an error
that it cannot open a file yourtablename.InnoD
Hello,
What is the recommend alternative to REPAIR TABLE for InnoDB tables, this does
not work with Innodb table types ??
TIA
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Ho
FYI...
Just connected to the www.mysql.com site this morning with no problems :)
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN: [EMAI
I think your looking for the ROUND(N,D) function, IE:
select round('3.4285714285714',2) as miles;
3.43 miles
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.jus
Hello,
we are currently running MySQL version 3.23.58, and plan to upgrade to 4.0.18
via the RPM's on a RH/Linux system,... can we retain all the user privileges and
databases without loosing any data and our user privileges after the upgrade...
we do have backups of all the databases.
Is ther
t;[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 9:02 AM
Subject: Re: Transaction Not supported
On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like:
I dont think that transactions are supported (yet?) by the PERL DBI.
to "Mike Blezien" <[EMAIL PROTECTED]>. My
Hello,
I keep getting this error when attempting to utilize a database that has Innodb
tables, and using transactions. This is from a Perl/DBI script too:
Error:
Transactions not supported by database at module. bla..bla
I realize this maybe a DBI question, but I thought I'd check here first
Thx' Alex.
do the old RPM's need to be removed first before upgrading ??
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN: [EMAIL PROTEC
Hello,
we are currently running MySQL 4.0.15 w/InnoDB tables on a RH/Linux 9.0 and
would like to upgrade. the current RPM's installed are:
MySQL-client-4.0.15-0
MySQL-embedded-4.0.15-0
MySQL-devel-4.0.15-0
MySQL-shared-compat-4.0.15-0
MySQL-shared-4.0.15-0
MySQL-server-4.0.15-0
MySQL-bench-4.0.1
Hello,
we are currently running MySQL 4.0.15 w/InnoDB tables on a RH/Linux 9.0 and
would like to upgrade. the current RPM's installed are:
MySQL-client-4.0.15-0
MySQL-embedded-4.0.15-0
MySQL-devel-4.0.15-0
MySQL-shared-compat-4.0.15-0
MySQL-shared-4.0.15-0
MySQL-server-4.0.15-0
MySQL-bench-4.0.1
g
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN: [EMAIL PROTECTED]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Fred van Engen wrote:
On Tue, Jan 20, 2004 at 04:10:44PM -0600, Mike Blezien wrote:
I've been looking at this S
Hello all,
I've been looking at this SQL query a dozen times or more, but keep getting a
syntax error message, Query:
SELECT ai.affilid,ai.create_date,CONCAT(ai.fname,' ',ai.lname) AS
name,aw.siteid,ai.email,as.username,as.status
FROM affiliate_info ai,affiliate_signup as,affiliate_website aw
W
Try using this command instead:
rpm -e --nodeps (the RPM you want to remove)
Eve Atley wrote:
I've been trying to install a later version of MySQL (4.0.16). The Redhat
default install is 3.x, and using rpm -e fails to remove the default
packages due to 'dependencies'. How can I safely and success
Hello,
we are in the process of upgrading our machine and currently running the
following RPM's
MySQL-server-4.0.15-0
MySQL-bench-4.0.15-0
MySQL-embedded-4.0.15-0
MySQL-devel-4.0.15-0
MySQL-client-4.0.15-0
MySQL-shared-compat-4.0.15-0
MySQL-shared-4.0.15-0
this is on a RH/Linux 7.3(i686)
do we
1 - 100 of 128 matches
Mail list logo
