From: "Keith Ivey"
> Jigal van Hemert wrote:
>
> > Maybe because dates before Jan 1, 1970 have an undefined timestamp and
dates
> > beyond 2038 cannot be used with 32-bit integers? Quite a few people were
> > born before 1970 and sometimes one needs to store their date of birth
too?
>
> Yes, but bi
When i run the queries below they all work just fine
SELECT sum(consultation)+ sum(laboratory) FROM nairobi,familymembers WHERE
familymembers.dependantid = nairobi.memberid and familymembers.memberid =
"AKI1"
SELECT sum(consultation)+ sum(laboratory) FROM riftvalley,familymembers WHERE
f
Raj Goel wrote:
>Dan,
>
> Here's what I've narrowed it down to:
>
> We're updating FROM Access TO MySql.
>
> If the column in Access is blank/empty, then the error pops up.
>
> If the field has data, then the error does not pop up.
>
> So, somewhere, either Access, or
Hi Guys,
I have been searching for the answer to this question for a while. The
answer is so obvious, yet there was no useful source of documentation
that showed it. I am using the load data infile syntax rather than the
command line utility. To get the warnings the "show warnings" command
is s
Edward Maas wrote:
>"You Tried to assign the Null value to a variable that is not a
> Variant data type."
> From my searching, I was unable to find how to set fields to variant
> data types. Secondly, I am not sure which field is causing the error.
No kidding. Looking into my crystal ball, I
Dear Community,
My team and I have been experiencing an interesting mysql error
during the past few weeks of testing. Here is the scenario we are
trying to accomplish. We are essentially working to use MsAccess as a
windows client for a linux based mysql databases. We have installed
myO
On Tue, 21 Jun 2005, Kevin Burton wrote:
> >Out of curiosity, how many queries are we talking and what sort of
> >complexity level? I've had replication setups do 600 (simple) updates/s
> >and slaving was current most of the time and never more than 1 second
> >behind.
> >
> >
> Mostly INSERTS.. W
db1 corruption # cat > my.sql
DROP TABLE IF EXISTS service_contacts;
CREATE TABLE service_contacts (
croeated datetime NOT NULL default '-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO service_contacts VALUES ('2006-06-14 10:27:40');
db1 corruption # mysqladmin -u root -
Not sure if this is a known issue or not.. but I haven't seen it
documented anywhere.
Anyway. My past thinking was that you should always use as many
connections as you have tables (at least with myisam). This way in the
worst case scenario you could have locks open on all tables instead of
Atle Veka wrote:
On Mon, 20 Jun 2005, Kevin Burton wrote:
We're noticing a problem where if we were to write to the master with
multiple threads that our slave DB will fall behind.
Note that we're trying to perform as many inserts as humanly possible
and the load on the master is 1.
Petr,
Thanks for the reply!
> I think you are looking for --extern option of the test suite. I
> corrected the README file. The changes should be propagated to the
> public repository soon, but you could check the commit mail for more
> details right now:
> http://lists.mysql.com/internals/26266
Hello David,
I think you are looking for --extern option of the test suite. I
corrected the README file. The changes should be propagated to the
public repository soon, but you could check the commit mail for more
details right now:
http://lists.mysql.com/internals/26266
Petr
On Tue, 2005-06-21
Hello.
The situation is not clear for me. Are you
able to connect and execute queries on server
using mysql command line client?
Alex Aris <[EMAIL PROTECTED]> wrote:
> How do backup at the client side?
> I don't have an account, nor a shell on the server
> side. When I give the path, i
Hello.
Probably there is a solution for your task. But for a pity
MySQL supports REGEXP only for comparison and nothing more.
A sad joke is that issues about phone numbers and regexps regularly
appear in the list, sometimes without any answer. However search in archives at:
http://lists.my
Hello.
It looks to me like you have downloaded a wrong binary...
peter sumser wrote:
>
>
>>Description:
>
> Starting scripts/mysql_install_db --user=mysql (alternatively with
> --force), I get the following msg:
> "
> scripts/mysql_install_db: line 1: ./bin/my_print_defaults:
Hello.
These are some active bugs with different versions of MySQL
Administrator. Check if your problem remains with the latest one.
>Hi All,
>
>I'm trying to take scheduled backup from mysql administrator and it
>always
>gives me a popup with this message.
>
>"Enter user name and
On Mon, 20 Jun 2005, Kevin Burton wrote:
> We're noticing a problem where if we were to write to the master with
> multiple threads that our slave DB will fall behind.
>
> Note that we're trying to perform as many inserts as humanly possible
> and the load on the master is 1.
Out of curiosity, ho
Hi;
I have run into 'potholes' with CMP beans on Sun's Java App Server 8.1.
While googling around I [think I] see that Sun's Server doesn't really
'like' mysql. (When it comes to CMP beans.)
Question: Honest please! Is this supposed to work? (Nothing fancy, not
even auto generated pk.)
What's t
David Legault wrote:
> Thanks for the reply, but I think you misinterpreted what I'm looking
> for here.
>
> For the first query I want to be able to get a row record of (in one
> query possibly)
>
> team_name for first team (team_id1)
> team_name for second team (team_id2)
> and each of these tea
According to the README, mysql-test-run supports an --external option:
db1 mysql-test # grep -a1 external README
If you want to run the test with a running MySQL server use the --external
option to mysql-test-run.
However it doesn't actually support it:
db1 mysql-test # ./mysql-test-run --exte
The manual is a little unclear on per-table-tablespaces in 4.1/5.0
(http://dev.mysql.com/doc/mysql/en/multiple-tablespaces.html)
Using per-table-tablespaces ignores the innodb_data_file_path (yes, it
uses it for the ibdata files, but not for the tablespace/data-files for
the individual tables)
#!perl
use strict;
use warnings;
sub foo {
warn "wantarray() in foo() is: ", wantarray(), "\n";
my @r = 3 .. 8;
return @r;
}
my @x = foo() or warn "in ... or warn() #1\n";
warn "[EMAIL PROTECTED]: @x\n";
my $x = foo() or warn "in ... or warn() #2\n";
warn "\$x: $x\n";
> -Origi
It's a Big O of N.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 21, 2005 9:39 AM
> To: Dan Bolser
> Cc: mysql@lists.mysql.com
> Subject: Re: Query Complexity (big 'O')
>
íÜ%
ËYÁw%m6óWraÝÂTOíYJf:d ÀûwW
¡u©4
5~ò©XT$©ÜôïmezøÅÈPPmoOAéÊÆÄ̾µ« ñɱü
düqÆw/LqGÕ°Áï?ê
Ý
J'¦Iê*F¢Ôð¾ Ò7±Å>íi(âo«ÝÕϨcÒï&:
þ3`RXÈÃo¿OЯ7x¼Só>ºnH
%þ¨Xij×ë;§Q)N.£}Oª-®9uóhn9HÉU0ø0øî~àEØd¬«ÙmLóË~(èv»$;6ßî}U3¹rÛ(´Ê¸U/£Sx«Þ¦/-TcGQ`«½_^¨¹ÙZæT2³Øïó¬ÉºÓîm.ï9
Õuîi;û
Hi,
My "bad". I forgot to explain that the IP address returned is NOT that of
the machine where I'm running the program (the Linux server). That address is
different from the one returned.
Sorry for the confusion.
George
[EMAIL PROTECTED] wrote:
>looking at this the ipnumber 192.168.2.1
On 6/21/05, comex wrote:
> I have a table:
> create table example(time datetime, username varchar(255));
Please tell me you didn't actualy use "time" as identifier :)
> timeusername
> 2005-06-21 15:58:02 user1
> 2005-06-21 14:58:02 user1
> 2005-06-21 11:57:51 user2
> 2005-06-21 1
[EMAIL PROTECTED] wrote on 06/21/2005 01:56:50 PM:
> Hi everyone,
> Trying to connect to a MySQL database from a Linux Server using PERL
> to a Windows Machine with a MySQL database (5.0.6). I can connect
> successfully on the windows box but cannot on the Linux server! I
> ran a SQLTRACE (DBD)
Hi everyone,
Trying to connect to a MySQL database from a Linux Server using PERL to a
Windows Machine with a MySQL database (5.0.6). I can connect successfully on
the windows box but cannot on the Linux server! I ran a SQLTRACE (DBD) with the
following output:
imp_dbh->connect: dsn = databas
Oliver Elphick wrote:
We have an application that has just upgraded to Debian sarge with mysql
upgrading from 3.23.49 to 4.0.24. As far as I know I have followed all
the procedures for upgrading the database.
Some queries always fail in DBD::mysql (in DBI) although they work OK
with the mysql
> How would you like to see that information GROUPed and what does that
> grouping represent (physically). In essence, I am asking you to describe
> what information you are determining by the grouping process, what does each
> GROUP mean to you?
Grouping just means that somebody visited twice in
Hi all,
I've was wondering if anyone is using MySql as their main ERP
production database, if so how stable and reliable is it?
Thanks for your comments
Stephane
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
comex <[EMAIL PROTECTED]> wrote on 06/21/2005 12:46:00 PM:
> > Basically it boils down to the fact that with SQL you have to use
> some other way of telling
> > each group apart other than position (or interposition, as you say
> in your example). The fact
> > that you have entries in your table
> Basically it boils down to the fact that with SQL you have to use some other
> way of telling
> each group apart other than position (or interposition, as you say in your
> example). The fact
> that you have entries in your table from user1, user1, user2, user1, user2,
> user3, and user1
> doe
Dan Bolser <[EMAIL PROTECTED]> wrote on 06/21/2005 09:51:06 AM:
> Hello,
> I am interested in the theoretical time / space complexity of SQL
queries
> on indexed / non-indexed data.
> I think I read somewhere that a JOIN on an indexed column is something
> like O[mn*log(mn)] (m rows joined to n
comex <[EMAIL PROTECTED]> wrote on 06/21/2005 11:07:35 AM:
> I have a table:
> create table example(time datetime, username varchar(255));
> timeusername
> 2005-06-21 15:58:02 user1
> 2005-06-21 14:58:02 user1
> 2005-06-21 11:57:51 user2
> 2005-06-21 10:57:51 user1
> 2005-06-2
Will this work?
GROUP BY maxtime, user
ORDER BY maxtime DESC
comex wrote:
I have a table:
create table example(time datetime, username varchar(255));
timeusername
2005-06-21 15:58:02 user1
2005-06-21 14:58:02 user1
2005-06-21 11:57:51 user2
2005-06-21 10:57:51 user1
2005-0
On 6/21/05, Dan Bolser wrote:
>
> I am interested in the theoretical time / space complexity of SQL queries
> on indexed / non-indexed data.
I doubt this is the right list for theory.
> Specifically I want to know the complexity of a query that does a
> 'cross tabulation'
>
> SELECT
> X,
>
if you are accessing mysql server using phpmyadmin
(http://sourceforge.net/projects/phpmyadmin/), then you have an option
to export the databases in many formats, I guess this should work in
your case...
Kishore Jalleda
On 6/21/05, Alex Aris <[EMAIL PROTECTED]> wrote:
> How do backup at the clien
Dan Bolser wrote:
> Hello,
>
> I am interested in the theoretical time / space complexity of SQL queries
> on indexed / non-indexed data.
>
> I think I read somewhere that a JOIN on an indexed column is something
> like O[mn*log(mn)] (m rows joined to n).
>
> I assume without an index it is ju
Jigal van Hemert wrote:
Maybe because dates before Jan 1, 1970 have an undefined timestamp and dates
beyond 2038 cannot be used with 32-bit integers? Quite a few people were
born before 1970 and sometimes one needs to store their date of birth too?
Yes, but birthdates are generally DATE, not D
Hi All,
I'm trying to take scheduled backup from mysql administrator and it always
gives me a popup with this message.
"Enter user name and password for the account under which the task will be
executed."
it shows me username and password for my windows account and when I click
"ok" on the po
I have a table:
create table example(time datetime, username varchar(255));
timeusername
2005-06-21 15:58:02 user1
2005-06-21 14:58:02 user1
2005-06-21 11:57:51 user2
2005-06-21 10:57:51 user1
2005-06-21 09:57:51 user1
The query:
select COUNT(*), username, MAX(time) as max
How do backup at the client side?
I don't have an account, nor a shell on the server
side. When I give the path, it thinks it is the path
on the server. How do I tell mysql that it is a path
on the client side?
thanks,
alex
Oliver Elphick wrote:
>which returns 0 rows, works correctly in mysql. But when it is passed
>through this statement in Perl:
>
>my @row = $dbh->selectrow_array($sql) or
>&failed(__FILE__, __LINE__,
> "Failed to run the sql statement with error
>
Hello,
I am interested in the theoretical time / space complexity of SQL queries
on indexed / non-indexed data.
I think I read somewhere that a JOIN on an indexed column is something
like O[mn*log(mn)] (m rows joined to n).
I assume without an index it is just O[m*n]
Specifically I want to k
We have an application that has just upgraded to Debian sarge with mysql
upgrading from 3.23.49 to 4.0.24. As far as I know I have followed all
the procedures for upgrading the database.
Some queries always fail in DBD::mysql (in DBI) although they work OK
with the mysql client.
For example, thi
--
Peter Sumser
Im Gässle 8
79199 Kirchzarten
+49-(0)7661-61747
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: instal
--
Peter Sumser
Im Gässle 8
79199 Kirchzarten
+49-(0)7661-61747
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: instal
From: "Sebastian"
> i never understand why people use datetime anyway.. unix timestamp is so
> much easier to work with.
Maybe because dates before Jan 1, 1970 have an undefined timestamp and dates
beyond 2038 cannot be used with 32-bit integers? Quite a few people were
born before 1970 and someti
On 21/06/2005 6:55 p.m., Sebastian wrote:
i never understand why people use datetime anyway.. unix timestamp is so
much easier to work with.
Because DATETIME is stored natively as a date and time, which means you
can then use the date and time SQL functions with them (such as
DATE_ADD, DATE
50 matches
Mail list logo
