To Whom it may concern,
I've noticed a bug with the Billionium. Now that we have hit 1 Billion
seconds since the beginning of the Epoch mysql will NOT work properly with a
MIN clause involving seconds before the Billionium.
To clarify, I have a script that keeps track of
To Whom it may concern,
I've noticed a bug with the Billionium. Now that we have hit 1 Billion
seconds since the beginning of the Epoch mysql will NOT work properly with
a
MIN clause involving seconds before the Billionium.
To clarify, I have a script that keeps track of the seconds of
Ok, no answers yet, but more information:
master log:
010909 3:15:36 failed in send_file() : Failed reading file name
Should the same file used on the master for the load inline be already on
the slave? Or MySql takes care of moving it for us... I try to move myself
before the sql and didn't
Matthew Harting writes:
Which table type would you
recommend using for transaction support?
InnoDB, unless you have a small database and plenty of RAM.
At least that's what others who have actually tried it have
said. Since what I'm doing isn't really in need of transactions
I'm sticking
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
--Forwarded message --
Return-Path: [EMAIL PROTECTED]
Delivered-To: [EMAIL PROTECTED]
Received: (qmail
Only to make sure we don't have any OS-specific I tried your test on my
Win32 installation. Same result:
--- snip
mysql create table test (seconds bigint not null primary key);
Query OK, 0 rows affected (0.00 sec)
mysql insert into test values (998556700), (113720), (11);
Query OK,
Hi!
A new sub-version of mysqlgui for Windoes has been uploaded to MySQLGUI page
on www.mysql.com.
This is a sub-release, titled 1.7.5-2 and contains fixes for
several bugs that have been reported on Windows platform.
Among other bugs there is a bug of keys not working in a spreadsheet.
Deryck,
Since you already got a reply that it can't be done, here's a suggestion how it
*could* be done (jus a general approach - since you mention usnig ASP):
- use an SQL command to gather all the table names in the database
- store the names in a list or array (ASP)
- use ASP to loop over
Brian,
I assume you are using MyISAM tables. The reason
for your problem probably is that your computer
does not give the latin1 codes to the accent
characters you type in. For example, the DOS
prompt in Win NT gives them different codes from
latin1, and consequently a similar test fails on
my
Hi!
Note that the [EMAIL PROTECTED] mailing list is only meant for
repeatable bugs report with full examples. We at MySQL AB will ensure
that all bug reports of this type are promptly answered and all bugs
are fixed or documented (if the final fix has to be delayed to a
future MySQL version
On 09 Sep 2001 17:23:39 +1000, Jason Brooke wrote:
To Whom it may concern,
I've noticed a bug with the Billionium. Now that we have hit 1 Billion
seconds since the beginning of the Epoch mysql will NOT work properly with
This is NOT MySQL bug. I posted separate message with needed
Hi there,
I am Alex, an underguaduate working on my final year project. I would
like to find out if there is a way to tabulate the total number of Sundays
between two dates (for example 2001-01-31 and 2001-04-31) without
creating any tables at all. I tried SQL statements like SELECT
MySQL was till version 3.22.??? shareware
and you had to pay for it when used commercialy (like in your case).
You had only 30 days free useage for, lets say, developing
- if you would use this aldery versions
- in case on new development does not make much sence -
you would have to pay.
since
hello
i have a question regarding a mySQL query sentence:
i have a mysql database named club with tables disciplines, results,
Swimmers and competitions
columns in tables are:
disciplines:
sif_discipline int(8)
discipline varchar(7)
gender char(1)
pool int(8)
Hi,
I have a table with the format of :
char(20),int(7),char(32)
the Date char(20) contents in actually a number(seconds since 1970) -
I want to use a select query that will give the max value according to
number value of that column.
select @last:=MAX(Date) from stat1;
What I need to know
It would be better to use joins. Something like this:
SELECT swimmers.surname_swimmer , swimmers.name_swimmer , swimmers.born ,
results.result , results.scale , competitions.date_competition
FROM results
left join disciplines on results.sif_discipline = disciplines.sif_discipline
left join
You should probably reply to the correct email - according to your email
body, it appears that it was me who made the claim that there was a mysql
bug when I was simply replying to the person who actually did make the
claim.
jason
On 09 Sep 2001 17:23:39 +1000, Jason Brooke wrote:
To Whom
Hi,
Has any one tried using Goldmine with MySQL ?
Thanks,
Oren
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Ok, got no emails, but I believe I found the problem , which I would
consider a bug.
My LOAD DATA INFILE query was running from a bash script, which was
executing the query thru a command line mysql call. The LOAD DATA was
loading the file into 2 tables on 2 different databases.
Something like:
Hi I am trying to update a table that is full of customer ID's using another
table with the following command
update customers set row_id=mc.id where tele=mc.tele;
But it give me the error
ERROR 1109: Unknown table 'mc' in where clause
The table mc does exist I am pretty lost on this one
I will have you served for a violation of federal law if you do not remove
immediately!!
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Philip Mak [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 10:48 PM
Subject: Re: Perl DBI: Same column name in
Umm,
Is he drunk or something? Report to a federal law?
It's like a mail from a mailing list, i mean... whats wrong with these
people.
On Sun, 9 Sep 2001, Nev and Emel Gokcen wrote:
I will have you served for a violation of federal law if you do not remove
immediately!!
- Original
Nev and emel,
Stop being an asshole and take your name out of the mailing list. It
does work you know
-Original Message-
From: Nev and Emel Gokcen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 09, 2001 2:05 PM
To: [EMAIL PROTECTED]
Subject: REMOVE NOW THIS IS THE SECOND TIME
Hi!
MySQL 3.23.42 is now released.
We recommend anyone using BDB tables or InnoDB tables with BLOB's to
upgrade to this new release.
If you are using InnoDB tables with BLOBS bigger than 8000 bytes, you
should do a mysqldump of the table and then drop and recreate the
table.
Most other bug
I just made the upgrade from 3.22 to 3.23.41 this weekend and had one little
hiccup.
I have a few users with host entries with wildcards (hostname = '%').
These users stopped working and were not able to login. When I added one
for the hosts they were connecting from, it began to work fine.
Will mysql run on Microsoft's windows ME operating system ?
Thank You,
Doug V.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
No, only Windows 95/98/200/NT
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Doug V [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 4:24 PM
Subject: windows ME
Will mysql run on Microsoft's windows ME operating system ?
Hi.
It cannot be done with a SQL command, except if the structure of all
involved tables is the same. In this case, have a look for MERGE
tables.
Else, you could create a temporary table and use
INSERT INTO temp SELECT ...
for all tables in question. Of course, you can simulate this in your
Thanx ben. But I have found a way to do it :
SELECT * FROM Asp, C, Cpp, Java, Javascript, etc... Where
If you know asp, write to me in private, I have something that (if you do
know asp) you might be able to help me with.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message
I have a V. 3.23.41 sql db installation on Windows 2k server.. Just
stopped and refuses to restart.. I have looked at just about everything.
Uninstalled and reinstalled, restored backups ... Nothing seem to be
working.. Checked through the registry, nothing seems to be off.. Any
ideas were to
Hi.
On Sun, Sep 09, 2001 at 10:52:49AM -0400, [EMAIL PROTECTED] wrote:
It would be better to use joins. Something like this:
Sorry? He did already use joins. You use LEFT JOINs, which have a
different meaning! So your query may give a different result as
desired. Additionally, LEFT JOINs are
I have 2 OS's. One is Linux and the other is WinME. MySql runs fine on
BOTH systems (it is running just fine on Win ME right now).
-w
- Original Message -
From: Doug V [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 2:24 PM
Subject: windows ME
Will mysql
Hi,
I'm using MySQL 4.0.0-alpha, and I'm wondering why sometimes I have so many
lock in my processlist (I don't see any non-locked INSERT which could cause
all the lock).
mysql show processlist;
+---+---+---++-+--+--+--
I have 2 OS's. One is Linux and the other is WinME. MySql runs fine on
BOTH systems (it is running just fine on Win ME right now).
-w
- Original Message -
From: Doug V [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 2:24 PM
Subject: windows ME
Will mysql
Hi.
On Sun, Sep 09, 2001 at 04:44:24PM -0500, [EMAIL PROTECTED] wrote:
Thanx ben. But I have found a way to do it :
SELECT * FROM Asp, C, Cpp, Java, Javascript, etc... Where
You know, that this is not really the same? You (should) get each code
of each table paired with each code from
Nh, you shouldn't be surprised, John.
Only stuff related to politics gets band, my friend.
Huh. Almost surprised you didn't know that...
##
--- John Coggeshall [EMAIL PROTECTED] wrote:
huh. almost surprised China lets
Hi, I would like to use the EXTRA field for
sorting and maybe caption, but I find no way
of setting it.
I tried like:
Alter table myTable
change myField myNewField varchar(255) DEFAULT 'a' EXTRA '3'
But that does not work.
I can not find anything in the documentation about this.
Thanks
At 8:44 PM -0500 9/9/01, Marcus Young wrote:
Hi,
I'm fairly new to MySQL. I'm trying to insert data into a table
where one field is derived from a SELECT on another table (a key)
and the other fields are defined directly (eg field_01=abcd) .
The formats I have been trying don't appear to be
Try to look at page 442 to 446 of the mySQL manual, it may give some help
on your field creation using insert select.
Regards,
Calvin Chin
[EMAIL PROTECTED]
Ipmuda Berhad - Building materials for tomorrow's world !
-Original Message-
From: Marcus Young [EMAIL PROTECTED]
To: [EMAIL
Description:
After a brief power failure, I rebooted the mysql server machine, and got this
error on startup:
Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/safe_mysqld: line 254: 1844 Segmentation fault (core dumped)
$NOHUP_NICENESS $ledir/$MYSQLD $defaults
At 4:29 PM -0500 9/9/01, Deryck Henson wrote:
No, only Windows 95/98/200/NT
What problems have you seen? It works under Windows ME for me.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Doug V [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 09,
Hi
I just came across these words in the mailing lists.
Can anyone tell me what are BDB tables and InnoDB tables .
I am new to mysql and would like to know what are they .
thanx in advance
Nilesh
-
Before
Hi
I just came across these words in the mailing lists.
Can anyone tell me what are BDB tables and InnoDB tables .
I am new to mysql and would like to know what are they .
thanx in advance
Nilesh
-
At 17:24 09/09/2001 -0400, Doug V wrote:
Hi,
Personally I didn't tried on Win ME. However some users had
reported it use without problem. To avoid the problem to
start without the DOS prompt screen, use WinMYSQLAdmin.exe
which you find at \mysql\bin directory.
Regards,
Miguel
Will mysql run
At 16:43 09/09/2001 -0500, Ken Sorenson wrote:
Hi,
Follow the step below:
- Install the MySQL stuff.
- Go to \mysql\bin directory with a DOS prompt screen.
- Type the command: mysqld-nt-max --remove (Even you don't have the
service, this don't provoke any problem).
- With the explorer open
45 matches
Mail list logo