Dear all,
I have InnoDB files which I thought belonged to a certain database
within the DATA directory.
However when I re-installed these files and managed to restart MySQL,
any query will produce the following error in mysq.err
050321 23:42:00 InnoDB error:
Cannot find table urlmonitor/request
Hello,
Are there any good rfcs or other documents that would assist in the
discussion I'm having with our organization's Oracle programmers in
regards the following:
Oracle DB -> MySQL
They recommend:
~ col~col ~col~ col'",~col
NOTE::I placed the '" in for a reason.
I am looking for:
"col","col"
Please stop writing "high priority" e-mails to a mailinglist.
Although the problem might be important for you, it's in no
way important for the receiver (which is quite a lot of people).
People will answer mailinglist questions for free, in their time.
I hope you understand.
--
Martijn Tonies
Hi,
I'm having a similar problem using the LOAD DATA. I get an intermittent error:
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
The command is:
LOAD DATA local infile 'pipefile' into table FACT_TABLE fields terminated by
'~' lines terminated by '\n';
I cannot
How does one insert records based on some kind of meta data or key in
particular table belonging to a merge table?
I have a network logging program and would like to partition the table so that
analysts can query certain tables belonging
to the merge table instead of the whold table to corelate e
On Monday 21 Mar 2005 16:32, Michael Stassen wrote:
> Which is the first hit if you enter "md5 crypt" in the manual's search box.
I use the manual offline, because my connection is too slow.
I wonder why the encryption-function chapter is not in my manual.
--
symbulos partners
-.-
symbulos - et
You could make your polling query as light weight as possible.
Create a new table with a single integer. When an update happens
increment that integer. Your polling query will then just be a select
from that table to see if the number has been incremented from the
last time it performed the operat
My reply below:
"mel list_php" <[EMAIL PROTECTED]> wrote on 03/21/2005 11:49:26 AM:
> Hi,
> Sorry for the late reply, out for the week-end!
>
> Here is the information you asked for (I modified the columns' type as
you
> suggested)
> mysql> show create table matches\G
> ***
Ben Clewett <[EMAIL PROTECTED]> wrote on 03/21/2005 11:36:45
AM:
> Dear MySQL,
>
> I have an application which need to wait for some data to change, then
> act on this change.
>
> I am polling the MySQL once a second using "SELECT ..."
>
> I believe there is an alternate method where a thread
Hi,
Sorry for the late reply, out for the week-end!
Here is the information you asked for (I modified the columns' type as you
suggested)
mysql> show create table matches\G
*** 1. row ***
Table: matches
Create Table: CREATE TABLE `matches` (
`
Dear MySQL,
I have an application which need to wait for some data to change, then
act on this change.
I am polling the MySQL once a second using "SELECT ..."
I believe there is an alternate method where a thread can be made to
wait for some change, therefore avoiding the expensive polling and
Tom Crimmins wrote:
On Monday, March 21, 2005 09:27, symbulos partners wrote:
Dear friends,
where is the description of the functions md5 in the manual? where is
the description of the function crypt()?
are there are good alternatives?
http://dev.mysql.com/doc/mysql/en/encryption-functions.html
Whi
symbulos partners <[EMAIL PROTECTED]> wrote on 03/21/2005 10:25:27 AM:
> > I don't think so. You already have the country's name in it's own
language
> > on the countryToLanguage table, don't you? What name in which language
is
> > the "defaultName" column supposed to represent? If you can defin
On Monday, March 21, 2005 09:27, symbulos partners wrote:
> Dear friends,
>
> where is the description of the functions md5 in the manual? where is
> the description of the function crypt()?
>
> are there are good alternatives?
http://dev.mysql.com/doc/mysql/en/encryption-functions.html
--
T
Does anyone know anything about the MySQL (3.x) Driver that comes installed
with coldfusion? No luck with yahoo search or coldfusion documentation.
Hi all,
I am trying to create a datasource for mysql database. I tried using the
mysql (3.x) driver but i got this error:
Connection verification fa
Dear friends,
where is the description of the functions md5 in the manual? where is the
description of the function crypt()?
are there are good alternatives?
--
symbulos partners
-.-
symbulos - ethical services for your organisation
http://www.symbulos.com
--
MySQL General Mailing List
For li
> I don't think so. You already have the country's name in it's own language
> on the countryToLanguage table, don't you? What name in which language is
> the "defaultName" column supposed to represent? If you can define what the
> *contents* of that field is supposed to be, then you should be able
Mahmoud Badreddine wrote:
I got it working , thank you.
I only could do what I wanted to do in multisteps however. I couldn't
figure out the nested querying , and it's bugging me.
Here's how I issued it.
mysql> update tableDummy set newDate=(select
str_to_date('(concat(DayVal,".",MonthVal,".",YearV
Pintér Tibor (tibyke) wrote:
Select * from where date > _2005-01-07_ and date <
DATE_ADD(_2005-01-07_, INTERVAL 24 HOUR)
However is there a simpler way of doing it by just passing one date like
Select * from where date = _2005-01-07_
you may also go for "... WHERE year(foo)=a AND month(foo)=b AN
symbulos partners <[EMAIL PROTECTED]> wrote on 03/21/2005 08:08:53 AM:
> Dear friends
>
> we have a problem here.
>
> We have 3 tables
>
> - table language (id int not null auto_increment primarykey,
languageName
> tinytext)
> - table country (id int not null auto_increment primarykey, defaul
Dear friends
we have a problem here.
We have 3 tables
- table language (id int not null auto_increment primarykey, languageName
tinytext)
- table country (id int not null auto_increment primarykey, defaultName
tinytext, defaultLanguage tinytext)
- table countryToLanguage ((languageID int, coun
sguazt sguazt wrote:
Hi!
From: Philippe Poelvoorde <[EMAIL PROTECTED]>
Reply-To: "'mysql@lists.mysql.com '"
To: mysql@lists.mysql.com
Subject: Re: Queries inside UDF
Date: Thu, 17 Mar 2005 08:22:46 +
..
You can actually access a DB within a UDF, but you should do the same
than when you're usi
In article <[EMAIL PROTECTED]>,
"Pete Moran" <[EMAIL PROTECTED]> writes:
> Hi All,
> Is there a simpler way of doing a select for a given date, for instance if I
> have a datetime field called date
> And so its populated with a load of values such as
> 2005-01-07 09:00
> 2005-01-07 10:00
> 200
Hello.
I think you should rebuild php with the 4.1.10 libraries.
Search in the archives at
http://lists.mysql.com/mysql
about successful solution for similar problem(s). See:
http://dev.mysql.com/doc/mysql/en/old-client.html
Asad Habib <[EMAIL PROTECTED]> wrote:
> I just i
Hello.
>Error: 'Unknown MySQL server host
> 'server5.domain.com' (1)' errno: 2005
Does the problem remain if you remove the following line
from the my.cnf on the server8:
skip-networking
"Chris Mason" <[EMAIL PROTECTED]> wrote:
> I have two servers, server5.mydomain.com a
Hello.
If you can't find rpms with this driver, you may
install it manually. At first you should install unixODBC
or iODBC. Then install MyODBC using binary tarball. See:
http://dev.mysql.com/doc/mysql/en/myodbc-unix-tarball-installation.html
Put the correct information in configurati
Hello.
You may use netstat -nlpt to find open tcp ports and the name of the program to
which each
socket belongs. If you see a listener on port 3306, then this is the source of
the problem.
i?aki <[EMAIL PROTECTED]> wrote:
> Hi, in a fedora i install mysql 4, i upgrading to mysql 4, bu
> Select * from where date > _2005-01-07_ and date <
> DATE_ADD(_2005-01-07_, INTERVAL 24 HOUR)
>
> However is there a simpler way of doing it by just passing one date like
>
> Select * from where date = _2005-01-07_
you may also go for "... WHERE year(foo)=a AND month(foo)=b AND
dayofmonth(f
28 matches
Mail list logo
