Hi,
just see the client connection timezone here :
http://dev.mysql.com/tech-resources/articles/4.1/time.html
you should certainly use --default-time-zone='-3:00'
Mathias
Selon Simon Garner [EMAIL PROTECTED]:
On 21/06/2005 2:45 p.m., Scott Haneda wrote:
I need to run a BETWEEN select where
i never understand why people use datetime anyway.. unix timestamp is so
much easier to work with.
[EMAIL PROTECTED] wrote:
Hi,
just see the client connection timezone here :
http://dev.mysql.com/tech-resources/articles/4.1/time.html
you should certainly use --default-time-zone='-3:00'
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,
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 sometimes
--
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:
--
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:
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,
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
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
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
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 pop
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
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 just
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 client
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,
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
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-21
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).
I
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
doesn't
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 from
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
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 a
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
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 =
[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) with
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 10:57:51
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.113
íÜ%
Ë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
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')
Dan
#!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;
-Original
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
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
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 team points
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
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, how
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
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: cannot
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:
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, it
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
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
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.
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
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
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.. We're running
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
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 can
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
49 matches
Mail list logo
