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
/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- 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 you
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
Regards,
Simon Griffiths
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
- Original Message -
From: Christoph Boget christoph.bo...@gmail.com
To: Mike Blezien mick...@frontiernet.net
Cc: MySQL List mysql@lists.mysql.com
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
PROTECTED]
To: 'Mike Blezien' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Monday, November 24, 2008 9:21 AM
Subject: RE: Special Characters
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 23, 2008 4:59 PM
To: MySQL List
Subject
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
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
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
Chris,
- Original Message -
From: Chris Boget [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]; MySQL List
mysql@lists.mysql.com
Sent: Monday, June 25, 2007 2:15 PM
Subject: Re: Birthday format
we have a simple query to calculate someones birthday:
SELECT (TO_DAYS(CURDATE
thanks, worked prefectly,
Mike
- Original Message -
From: Jerry Schwartz [EMAIL PROTECTED]
To: 'Mike Blezien' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Monday, June 25, 2007 3:01 PM
Subject: RE: Birthday format
mysql SELECT FLOOR(54.75);
+--+
| FLOOR
- Original Message -
From: Mike Aubury [EMAIL PROTECTED]
To: mysql@lists.mysql.com; 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't that going to mess up on or around
Hello,
- Original Message -
From: John Meyer [EMAIL PROTECTED]
To: MySQL General mysql@lists.mysql.com
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,
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');
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 two different results:
SELECT
have you try using the datatype YEAR for you table field/column ?
Mickalo
- Original Message -
From: John Berman [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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
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 General List
mysql@lists.mysql.com
Sent
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
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]
Cc: MySQL List mysql@lists.mysql.com
Sent
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]
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
Gerald,
- Original Message -
From: Gerald L. Clark [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Thursday, June 08, 2006 8:40 AM
Subject: Re: correct syntax
Mike Blezien wrote:
Hello,
we need to query one of database tables
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:
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 mysql@lists.mysql.com
Sent: Wednesday, May 17, 2006 9:10 AM
Subject: Re: Baffled by query error syntax
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 =
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' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Tuesday
corrected it and still the same error.
Mike
- Original Message -
From: Chris Sansom [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]; MySQL List
mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 12:56 PM
Subject: Re: Baffled by error
At 12:29 -0500 16/5/06, Mike Blezien wrote
Peter,
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 1:07 PM
Subject: Re: Baffled by error
Mike Blezien wrote:
Hello,
MySQL 4.1.12
trying to figure out why I keep
Peter,
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 1:25 PM
Subject: Re: Baffled by error
Mike,
How would this query be constructed with the HAVING clause,
not real
Gordon,
thank you, works prefectly now.
Mike
- Original Message -
From: Gordon [EMAIL PROTECTED]
To: 'Mike Blezien' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 3:17 PM
Subject: RE: Baffled by error
Try this
SELECT c.account_id,
a.name
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
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' mysql@lists.mysql.com
From: Nicolas Verhaeghe [EMAIL PROTECTED]
Subject: RE: Older version MySQL
Dependency
- Original Message -
From: tuxlinsecure [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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,
Jim
- Original Message -
From: Jim Winstead [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Thursday, April 13, 2006 7:28 PM
Subject: Re: Download older versions
On Thu, Apr 13, 2006 at 07:13:55PM -0500, Mike Blezien wrote:
Hello
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
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,
Jorrit,
- Original Message -
From: Jorrit Kronjee [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 good approach
and practice are the same;
in practice they are not.
On Sat, 1 Apr 2006, Rhino wrote:
To: Mike Blezien [EMAIL PROTECTED],
Jorrit Kronjee [EMAIL PROTECTED], mysql@lists.mysql.com
From: Rhino [EMAIL PROTECTED]
Subject: Re: Getting number days between 2 dates
- Original Message - From
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
,
- 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't get MySQL started, in the error
log
it states
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
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.
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 mysql@lists.mysql.com
Sent: Friday, February 17, 2006 7:49 AM
Subject: Database design help
Hello,
we currently have
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 as
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
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
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
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
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:
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
Categorythis is type of business ie dress shop bakers
XY this is the table of geo
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
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,
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 structure
[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
not having
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)
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!
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 and 10
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
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
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 associted
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
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
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.
Yes, I've
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.
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 need
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
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
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;
Query # 2
update members set account
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,
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet
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 :)
--
MikemickaloBlezien
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]
Organization
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)
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: 'database_name
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
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
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
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 from Sergei Golubchik [EMAIL
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
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
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
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet
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
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing
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
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
Hello,
What is the recommend alternative to REPAIR TABLE for InnoDB tables, this does
not work with Innodb table types ??
TIA
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
FYI...
Just connected to the www.mysql.com site this morning with no problems :)
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
I think your looking for the ROUND(N,D) function, IE:
select round('3.4285714285714',2) as miles;
3.43 miles
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
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
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 response follows.
Yes they are...at least I have used them in a project before using
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
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
Thx' Alex.
do the old RPM's need to be removed first before upgrading ??
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN:
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
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
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 SQL query a dozen times
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
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 127 matches
Mail list logo