Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
"Advanced Data Generator" (version 1.6.2)
A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, man
I am not that clever, but I would just create a Web Service (WS) on the
Server that the Laptop call whenever the laptop want to push the date into
the server database.
I heard something about something called rsync, but I think that is
restricted to Linx, Unix.
/Peter
-Original Message-
hi, Peter
Try this:
select a.name, sum(if (b.table_a.id is NULL,0,1)) as indid from table_a a
left join table_b b on(a.id=b.table_id.id) group by a.id;
best regards,
Leo Huang
2006/6/1, Peter Lauri <[EMAIL PROTECTED]>:
Hi,
I have a table table_a and table_b:
table_a {
id
name
}
table_b {
Hello,
I have been using MySQL version 4.0 because I have experienced problems since
version 4.1 and later versions...
I tried to update to version 5.0 but problems remain, in short
Due to my stupidity I had been using latin1 encoding for my database even
though everything seemed quite smo
I need to upgrade a MyISAM DB, one of the tables has the structure:
CREATE TABLE old_event_data (
event_id MEDIUMINT UNSIGNED NOT NULL,
p1 UNSIGNED INT NOT NULL,
...
p30 UNSIGNED INT NOT NULL,
part UNSIGNED TINYINT(1) NOT NULL
);
This is 'event data', each event having 6 entries wit
Ioannis Anifantakis wrote:
> Hello,
>
> I have been using MySQL version 4.0 because I have experienced problems since
> version 4.1 and later versions...
>
> I tried to update to version 5.0 but problems remain, in short
>
> Due to my stupidity I had been using latin1 encoding for my databa
To whom it may concern,
I'm involved in lots of C# coding with several coders.
I have a gripe with MySQL which may be easy to solve in future development.
C# has two DateTime constants:
DateTime.MinValue = '0001-01-01 00:00:00.000'
DateTime.MaxValue = '-12-31 23:59:59.999'
rsync is a *nix utility that synchronizes two file systems, one local and
one remote (typically). It is used to produce mirrors / backups / etc. You
would not want to use it to synchronize database (raw) files via the file
system.
If you include a timestamp field, you can use that to copy across
Ben Clewett schrieb:
To whom it may concern,
I'm involved in lots of C# coding with several coders.
I have a gripe with MySQL which may be easy to solve in future development.
C# has two DateTime constants:
DateTime.MinValue = '0001-01-01 00:00:00.000'
DateTime.MaxValue = '-12-31
Hi Barry,
This will happen when comparing against a TIMESTAMP field.
CREATE TABLE a ( t TIMESTAMP );
SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
I understand that TIMESTAMP cannot handle this date. But I would hope
to be able to compare against this date without MySQL giving the
warnin
Rob, to clarify, your new 'index' column will be based on the value of
the 'part' column and individual column names from the old table?
Perhaps something like this, where [colnum] is derived from column name
like p1? (part+1)*[colnum]
Dan
Rob Desbois wrote:
I need to upgrade a MyISAM DB
> Rob, to clarify, your new 'index' column will be based on the value of
> the 'part' column and individual column names from the old table?
That is correct.
> Perhaps something like this, where [colnum] is derived from column name
> like p1? (part+1)*[colnum]
The actual formula I want to use i
There may be a technique for that in SQL, but I sure don't know it.
I'd likely approach this problem with an external language like perl.
You'll still end up processing about 15 million inserts, so it'll take a
while, but it shouldn't actually end up being all that rough on your
database server
On Tuesday 06 June 2006 15:38, [EMAIL PROTECTED] wrote:
> Quoting Barry <[EMAIL PROTECTED]>:
> > Well my msql doesn't give me any errors using that query.
> > neither a warning.
>
> Ditto.
>
> usemysql> use test;
> Database changed
> mysql> CREATE TABLE a ( t TIMESTAMP );
> Query OK, 0 rows affecte
Quoting Barry <[EMAIL PROTECTED]>:
> Ben Clewett schrieb:
> > Hi Barry,
> >
> > This will happen when comparing against a TIMESTAMP field.
> >
> > CREATE TABLE a ( t TIMESTAMP );
> >
> > SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
> >
>
> Well my msql doesn't give me any errors using tha
Duncan Hill wrote:
On Tuesday 06 June 2006 15:38, [EMAIL PROTECTED] wrote:
Quoting Barry <[EMAIL PROTECTED]>:
Well my msql doesn't give me any errors using that query.
neither a warning.
Ditto.
usemysql> use test;
Database changed
mysql> CREATE TABLE a ( t TIMESTAMP );
Query OK, 0 rows affect
Hi Barry,
This is what I get:
mysql> CREATE TABLE a ( t TIMESTAMP );
Query OK, 0 rows affected (0.25 sec)
mysql> SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Empty set, 1 warning (0.00 sec)
mysql> SHOW WARNINGS;
+-+--+
Ben Clewett schrieb:
Hi Barry,
This will happen when comparing against a TIMESTAMP field.
CREATE TABLE a ( t TIMESTAMP );
SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Well my msql doesn't give me any errors using that query.
neither a warning.
This "might" be a problem with windows.
Wi
Ben Clewett schrieb:
Hi Barry,
This is what I get:
mysql> CREATE TABLE a ( t TIMESTAMP );
Query OK, 0 rows affected (0.25 sec)
mysql> SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Empty set, 1 warning (0.00 sec)
mysql> SHOW WARNINGS;
+-+--+--
Hi all,
We have a copy of an old version of a database and a huge LOG file ( 9
Gig ) ( not the binary log unfortunately but the GENERAL QUERY LOG )
started when we put this database live.
The only solution I see would be to run the queries from this log file
to the database. What do you think?
Nenad Bosanac schrieb:
Hi
I have one problem that i can`t resolve.
still need advice or is it solved?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Hi Barry,
> Well removing 'explicit' warnings for every user having problems with
> 3rd party modules would have mysql without any warnings nowadays ;)
>
> i think that your mono should get more stable.
I completely take this on board. This is a bug outside MySQL.
Warnings are very useful. Wh
Hi, Jeremy,
RE:
> Looks like a bug. The code in question is:
> >
>if (num_info.dval > -FLT_MAX && num_info.dval < FLT_MAX)
> sprintf(buff, "FLOAT(%d,%d)", num_info.integers,
> num_info.decimals);
>else
> sprintf(buff, "DOUBLE(%d,%d)", num_info.integers,
> n
On Mon, Jun 05, 2006 at 10:16:05PM -0700, Ken Williams wrote:
> Anyone know if 4.0.27 will be fixed for the mysql_real_escape issue?
> (http://lists.mysql.com/announce/364)
>
> 4.1 and 5 have been already, kinda wondering why 4.0 hasn't.
It will not, because 4.0 does not have this bug.
Jim Winst
Hello,
Is it possible to tell myisamchk where the intermediate files (.TMD) must be
created.
Because my database are big and these not enough space in his directory.
I try with --tmpdir but this doesn't work.
I use myisamchk ver 2.7 and mysql 4.1.11
thank's
Nuno
--
MySQL General Mailing
Ben Clewett wrote:
(I know that TIMESTAMP has a far smaller date range than DATETIME.
But all our data has to be time-zone independent. Therefore TIMESTAMP
is the only field appropriate for our use.)
try and see if this works
SELECT * FROM a WHERE cast(t as datetime) > '0001-01-
Hi,
what type of password algorithum does mysql 5.x uses for encrypting passwords?
and how does these algorithum keeps the password in secure.
Regards,
Shivaji.
Hello,
Have you taken a look at the following sections in the manual?
http://dev.mysql.com/doc/refman/5.0/en/user-names.html
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
Thanks,
Jimmy Guerrero
Sr Product Manager
My
Ben Clewett wrote:
> C# has two DateTime constants:
>
> DateTime.MinValue = '0001-01-01 00:00:00.000'
> DateTime.MaxValue = '-12-31 23:59:59.999'
>
>
> MySQL really doesn't like these values, it shows warnings:
>
> +-+--+-+
[snip]
what type of password algorithum does mysql 5.x uses for encrypting
passwords? and how does these algorithum keeps the password in secure.
[/snip]
Here is some helpful info;
http://www.mysql.com/search/?q=password+security&charset=
--
MySQL General Mailing List
For list archives: http://
Can you run rsync on Windows environment?
-Original Message-
From: Tim Lucia [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 6:32 PM
To: 'Peter Lauri'; 'Jason Dimberg'; mysql@lists.mysql.com
Subject: RE: UPDATE from one server to another
rsync is a *nix utility that synchronizes t
Ask our mutual friend, Google. It has lots of answers for you.
-Original Message-
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 10:09 AM
To: 'Tim Lucia'; 'Jason Dimberg'; mysql@lists.mysql.com
Subject: RE: UPDATE from one server to another
Can you run rsync o
On 6/6/06, Jason Dimberg <[EMAIL PROTECTED]> wrote:
I am working on an application where data will be collected on laptops
and then uploaded to a central database once the laptop is able to
connect to the network after being in the field. I was initially
thinking of using MS Access as a front en
Rob Desbois wrote (06-06-2006 15:22):
Rob, to clarify, your new 'index' column will be based on the value of
the 'part' column and individual column names from the old table?
That is correct.
Perhaps something like this, where [colnum] is derived from column name
like p1? (part+1)*[colnum]
T
Hi, List!
I'm a little bit confused with (IMHO) poor query performance.
I have a table with 1'000'000 records.
Table consists of 2 service fields and a number of data fields. Service
fields are status and processor_id (added for concurrent queue processing).
The question is why are updates s
On 6/6/06, Eugene Kosov <[EMAIL PROTECTED]> wrote:
Hi, List!
I'm a little bit confused with (IMHO) poor query performance.
I have a table with 1'000'000 records.
Table consists of 2 service fields and a number of data fields. Service
fields are status and processor_id (added for concurrent que
Hi all,
I'm currently looking for a tool that will take XML and produce a database
from it. Not really looking for anything in particular at this point, just
sort of scoping around. Anyone know of such a tool?
--
Chris White
PHP Programmer/DB Sloth
Interfuel
--
MySQL General Mailing List
Fo
Hi,
I am using Java to maintain a MySQL database. I have a table in the
database created by:
"CREATE TABLE track_char ("
+ "id INT UNSIGNED NOT NULL AUTO_INCREMENT,"
+ "PRIMARY KEY (id),"
+ "name CHAR(40),"
[snip]
I'm currently looking for a tool that will take XML and produce a
database
from it. Not really looking for anything in particular at this point,
just
sort of scoping around. Anyone know of such a tool?
[/snip]
MySQL kinda' has a built-in tool
http://dev.mysql.com/tech-resources/arti
Hi Rob,
So each of the old rows splits into 30 new rows.
Really 180 rows, right?
The existing table has about 85000 rows, equating to over 15 million in the new
structure.
Ways I have tried end up creating massive queries or just hogging the server
for absolutely ages - what is the best wa
[snip]
Now, when I try to update the rotX, rotY, and rotZ fields, I have to put
a double into it, ints don't work. But then, when I print out the
database, it looks like this:
Which clearly indicates that it is storing the rot fields as ints.
I am just wondering why I can't give it an
Any idea why libmysqlclient_r.so is not being created when I compile after a
configure --without-server?
I did two other boxes this morning and everything went just fine. Now this one
(RH 9) is not getting it's libraries created. The compile/install looks like
it works just fine.
--ja
--
Right...the thing is that they are supposed to be INTs, but I can only
successfully perform an update query if I use doubles for the fields...?
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 1:59 PM
To: Thomas Amundsen; mysql@lists.mysql.com
[snip]
Right...the thing is that they are supposed to be INTs, but I can only
successfully perform an update query if I use doubles for the fields...?
[/snip]
Do a describe on the table and make sure that they are INTs, then show
us the update statement.
"because it is hard to read"
"why?"
Here is what it gave me when I did describe:
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(10) unsigned | NO | PRI | NULL
[snip]
Here is what it gave me when I did describe:
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(10) unsigned | NO | PRI
Hi Gaspar,
OK, thanks for the info. Seems like procedure analyse() has some other
bugs, for example despite controlling the number of possible enum
fields to e.g. 16, it returns an enum with 256 elements.
By the way, I opened a bug for this issue:
http://bugs.mysql.com/20305
Regards,
Jere
It seems to work with INTs when I do it from the MySQL commandline. I
guess something is weird with the JDBC connector or something...
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 2:26 PM
To: Thomas Amundsen; mysql@lists.mysql.com
Subject:
[snip]
It seems to work with INTs when I do it from the MySQL commandline. I
guess something is weird with the JDBC connector or something...
[/snip]
May I suggest echoing your query out so that you can see what it is
trying to insert?
--
MySQL General Mailing List
For list archives: http://list
Ahhh! I should have thought of this beforehand.
The query I was sending using doubles:
UPDATE track_char SET rotX = 0.0, rotY = 0.0, rotZ = 0.0WHERE name =
'Tom'
The query I was sending using ints:
UPDATE track_char SET rotX = 0, rotY = 0, rotZ = 0WHERE name = 'Tom'
There was a missing space bet
[EMAIL PROTECTED] wrote:
Any idea why libmysqlclient_r.so is not being created when I compile after a
configure --without-server?
Compile MySQL with --enable-thread-safe-client configure option.
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based
hey what is happening. Thank you for this list.. THank you for having me.. I
would appreciate your assistance if you are familiar with this...
first off, I KNOW F¡¢K ALL about mySQL.
Now..
I'm doing this tutorial and it tells me to install phpmyadmin, mySQL, etc.
I get to a screen in phpmyadmi
Daniel da Veiga wrote:
On 6/6/06, Jason Dimberg <[EMAIL PROTECTED]> wrote:
I am working on an application where data will be collected on laptops
and then uploaded to a central database once the laptop is able to
connect to the network after being in the field. I was initially
thinking of using
On 6/6/06, tomáz rezistänz <[EMAIL PROTECTED]> wrote:
I have no idea how to log in to mySQL... can you help?
/bin/mysql.exe for Windows
/usr/bin/mysql (AFAIK) for *ix like
YMMV
Run it with "-u root -p" and you can provide your password.
That's the problem with wizards and howtos, you gotta K
!!
I apologize..
I should have mentioned that I am using a Mac in OSX 10.4.5
My main concern is should I begin logging into mSQL using the terminal or is
this done from a browser??... Yes, I am know nothing.. no commands.. nada..
On 6/6/06, Daniel da Veiga <[EMAIL PRO
I wish I could uninstall mySQL and start over but I don't know how..
On 6/7/06, tomáz rezistänz <[EMAIL PROTECTED]> wrote:
!!
I apologize..
I should have mentioned that I am using a Mac in OSX 10.4.5
My main concern is should I begin logging into mSQL using the termi
Jason Dimberg wrote:
> I am working on an application where data will be collected on laptops
> and then uploaded to a central database once the laptop is able to
> connect to the network after being in the field. I was initially
> thinking of using MS Access as a front end with linked tables thr
Hi All,
Hope this is the right list to post to, excuse if it is not ;-)
Server scenario:
Dedicated server running MySQL 4 and secondary process inserting data into
MySQL
How does one calculate what the values should be for the following areas in
the my.cfg file to give optimal performance:
58 matches
Mail list logo
