Any report tools that can be use with Mysql that you guys can recommend?
Any free mysql report generators?
Thanks,
Nestor :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sean c peters wrote:
Hi all.
I am trying to figure out if there is a way to configure MySQL so that when
inserts occur on decimal fields where the value being inserted has more
precision than the field specification, then the value inserted is rounded
instead of truncated.
Rounding is what
On Wednesday 20 July 2005 10:06am, Les Schaffer wrote:
> I am working on a MySQL application where laptops will be collecting
> data into local MySQL tables, and then once a week they will be
> network-connected to a central server where they will "check in" their
> new data and "check out" new ass
any ideas on this? google has not helped.
can temp tables be innodb? can they have fk?
mysql>
mysql> create temporary table bvolsetparents
-> (
-> volset int not null,
-> ancestor int not null,
-> primary key (volset,ancestor),
-> foreign key (volset) REFERENCES bvolset
Also check out EMS MySQL Manager. I looked at every MySQL tool I could
get my hands on, and ended up buying a license of this.
Main site is here:
http://sqlmanager.net/products/mysql/manager/
Feature list is here:
http://sqlmanager.net/en/products/mysql/manager/features
It also has access v
It's a bit weak on foreign keys, no support for procedures and views (if
you're looking at MySQL 5) from a gui perspective (from what I have
found). Other plus points are it has a http tunnel feature if you host
your mysql database with someone (requires php on the hosted server), so
you can ac
Hi Karam,
I have seen you recommending SQLyog on the list for quite some time by
now. May I ask, are you just a REALLY happy customer or otherwise somehow
involved in the company which is producing it posting from your private
e-mail ;-) ?
Best regards
Nils Valentin
Tokyo / Japan
http://www.be-k
Greetings!
I have begun using the preferences pane that came in the official
binary [4.1.12] instead of always manually starting & stopping the
server. This is a nice improvement as Mac OS X client edition doesn't
come with this, and i've only recently seen it in the package.
However, it d
You might try --xml or --html with a different separator.
Greg
--
Greg Fortune
Enterprise Systems
Eastern Washington University
Phone: 509-359-6690
Email: [EMAIL PROTECTED]
On Wednesday 20 July 2005 03:28 pm, Dan Bolser wrote:
> +--+---+++-+
>
On Wed, 20 Jul 2005, Peter Brawley wrote:
>Dan
>
>/>Hello, I made the above report by hand after using a GROUP_CONCAT
> >query. Is there any way to make this kind of format automatically in
> >MySQL?/
>
>How about HTML output (mysql ... -H)?
Yeah, I found that works, for example also with
'GROU
Which version of mysql are you exporting from and inserting into?
[EMAIL PROTECTED] wrote:
Hi all,
I am trying to create a table on the remote server from a table I created on my local sever but it never seems to
work
CREATE TABLE `sheet1` (
`id` int(10) NOT NULL auto_increment,
`title` v
Hello,
When I am trying to download mysql from the repository, I am running into
some problem. Earlier about a month back, it was working fine, but its only
recently I am facing this problem.
Anyone can please shed some light on it?
Thanks.
This is the command which I am using
bk clone bk://m
Dan
>Hello, I made the above report by hand after using a GROUP_CONCAT
>query. Is there any way to make this kind of format automatically in
>MySQL?
How about HTML output (mysql ... -H)?
PB
--
Dan Bolser wrote:
+--+---+++-+
| G_ID
on 7/20/05 2:23 PM, sean c peters at [EMAIL PROTECTED] wrote:
> Hi all.
> I am trying to figure out if there is a way to configure MySQL so that when
> inserts occur on decimal fields where the value being inserted has more
> precision than the field specification, then the value inserted is roun
+--+---+++-+
| G_ID | TOTAL | G2 | NR | ASSEMBLY_LISTING|
+--+---+++-+
| 1132 |34 | 1 | 1 | 1bf3-1,1bgj-1,1bgn-1,1bkw-1,1cc4-1, |
| | ||| 1cc6-1,1cj2
Hi all.
I am trying to figure out if there is a way to configure MySQL so that when
inserts occur on decimal fields where the value being inserted has more
precision than the field specification, then the value inserted is rounded
instead of truncated.
For example, if i have a column:
Acres DE
group by date_format(field_type_date,'%Y/%m' )
-Original Message-
From: Jerry Swanson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 20, 2005 1:08 PM
To: mysql@lists.mysql.com
Subject: Group by Month
I have query that pulls data between to dates. How to group the data by
month?
--
Hi Chris,
I have run into this myself before as well, where the partition housing
the bin log filled up. In our case, there weren't failed queries on the
master; the integrity of data on the master was fine, and the slave was
simply out of date, but not error-full. However, even in that case (
"me you" <[EMAIL PROTECTED]> wrote on 07/20/2005 03:05:30 PM:
> Hello,
>
> Having some problems trying to get the correct data from MySQL. I need
to
> grab a bunch of information based on a date the user selects (no problem
> there). However, this is an events type situation, where I want t
Hello,
Having some problems trying to get the correct data from MySQL. I need to
grab a bunch of information based on a date the user selects (no problem
there). However, this is an events type situation, where I want to give
people an easy option to move forward or backwards through the dat
Love it - use it all the time. Saw it at the Mysql conference, bought
it that night. Use it every day. Well worth $50.
I'm contemplating buying SQLyog Enterprise for $49 dollars (non-commerical)
for personal use. Do anyone use it and how does it fare in your opinion?
--
Power to people, Linux
Hello,
I find SQLyog Enterprise an indispensable tool.
Your $49 will be saved within the first 3 days of use
because of improved productivity with MySQL.
Karam
--- Scott Hamm <[EMAIL PROTECTED]> wrote:
> I'm contemplating buying SQLyog Enterprise for $49
> dollars (non-commerical)
> for perso
Les Schaffer <[EMAIL PROTECTED]> wrote on 07/20/2005 12:06:46 PM:
> I am working on a MySQL application where laptops will be collecting
> data into local MySQL tables, and then once a week they will be
> network-connected to a central server where they will "check in" their
> new data and "che
Hello.
> | | open_files_limit | 50
You have a very low value for open_files_limit. Increase it to
several thousands. See:
http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html
Please next time send you answers to the list.
> On 7/20/05, Gleb Paharenko <[EMAIL PR
[snip]
I have query that pulls data between to dates. How to group the data by
month?
[/snip]
It would be better if you showed use the query, but heh...our mind
reading skills are getting pretty good. At the end of your query put the
line;
GROUP BY month
--
MySQL General Mailing List
For list a
I have query that pulls data between to dates. How to group the data by month?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Eric Jensen <[EMAIL PROTECTED]> wrote on 07/20/2005 02:00:26 PM:
> I have a field that was set as a unique key when created via:
> UNIQUE KEY `username` (`username`)
>
> I no longer want it unique, but can't see a way with ALTER TABLE to
> remove it. It isn't the Primary Key or an index. The de
www.mysql.com/doc
search drop index
Eric Jensen wrote:
I have a field that was set as a unique key when created via:
UNIQUE KEY `username` (`username`)
I no longer want it unique, but can't see a way with ALTER TABLE to
remove it. It isn't the Primary Key or an index. The describe looks
lik
I have a field that was set as a unique key when created via:
UNIQUE KEY `username` (`username`)
I no longer want it unique, but can't see a way with ALTER TABLE to
remove it. It isn't the Primary Key or an index. The describe looks
like this:
+--+-+--+-+-+--
Ok,
The entire table looks like this:
ip | hostname | mac_current | mac_change | port_current | port_change
The IP addresses are harvested via netflow (a different table) and or
arpwatch (an event). This new table is to augment the current
information that is within the netflow tables but speci
Hello
GP> Similar questions have been asked before. For example:
GP> http://lists.mysql.com/mysql/184088
Thank you. I found something interesting:
SELECT @rand_id:= CAST( 1 + MAX(id)*RAND() AS UNSIGNED) FROM history;
SELECT * FROM history WHERE id >= @rand_id LIMIT 1;
But this query can retur
I am working on a MySQL application where laptops will be collecting
data into local MySQL tables, and then once a week they will be
network-connected to a central server where they will "check in" their
new data and "check out" new assignments for data collection.
given a set of rows in a set
Nuno Pereira wrote:
> Hi all,
>
> I have a MySQL server version "4.1.10a, for pc-linux-gnu (i686)"
> installed (from official binary RPMs) and running.
>
> My question is if there are problems from updating the server to the
> most current version of the 4.1.x series, specially things that fail t
I have already test and it doesn't work, my stunnel doesn't work properly. I
have asked my question on stunnel-users mailing list but i d'ont have answer
for the moment...
Thanks for your help!
Original Message
Subject: Re: Re-2: Socket Problem (20-juil.-2005 16:11)
From:[
Put a index on col3 and it will be faster. That's the only way as far as I
know.
--
Chris.
- Original Message -
From: "Michael Monashev" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 20, 2005 3:04 PM
Subject: random rows selection
Hello,
How to select 5 random rows from big tabl
Hello.
Are you able to connect to 3306 port on your localhost using telnet or
netcat? You should check if stunnel works properly on Linux.
Bastian Balthazar Bux <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>> When i try
>>
>> mysql -h server --port=3306 --protocol=TCP -u us
Hello.
Similar questions have been asked before. For example:
http://lists.mysql.com/mysql/184088
Search in archives at:
http://lists.mysql.com/mysql
Michael Monashev <[EMAIL PROTECTED]> wrote:
> Hello,
>
> How to select 5 random rows from big table with WHERE claus
Hi all,
I have a MySQL server version "4.1.10a, for pc-linux-gnu (i686)"
installed (from official binary RPMs) and running.
My question is if there are problems from updating the server to the
most current version of the 4.1.x series, specially things that fail to
work, or database curruptio
Hello,
How to select 5 random rows from big table with WHERE clause?
This query very slow on 1 mln rows:
SELECT col1, col2 FROM table WHERE col3=123 ORDER BY RAND() LIMIT 5
Have you a faster one?
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://g
[EMAIL PROTECTED] wrote:
> When i try
>
> mysql -h server --port=3306 --protocol=TCP -u user --password=xxx it works!
>
> The real problem is when using stunnel, i have to do as if i will connect to
> a local server... On windows it works but not on linux... :(
>
> Original Message ---
Hello.
Please, provide more information on your's application logic.
To catch events which occurs for the table use triggers. See:
http://dev.mysql.com/doc/mysql/en/triggers.html
Unfortunately they're available only in MySQL 5.0.x, which is still
beta.
Paul Halliday <[EMAIL PROTEC
When i try
mysql -h server --port=3306 --protocol=TCP -u user --password=xxx it works!
The real problem is when using stunnel, i have to do as if i will connect to a
local server... On windows it works but not on linux... :(
Original Message
Subject: Re: Socket Problem (20-jui
Hi all,
Juan Pedro Reyes Molina wrote:
I have been able to create your table in my mysql 4.1.12
I think your remote server is in mysql 4.0 series
I had the same problem some days ago.
I can almost garantee that the local server is running MySQL 4.1.x, and
I can garantee (99.99% sure)
Cabbar Duzayak wrote:
...
I have setup cronjobs to take daily backups of my db using mysqldump.
But the problem is, mysqldump requires the password to be passed via
command line, which means anyone on the same machine can take a peek
at my password using "top", "ps -ef", etc.
Is there a way of a
Hello.
First check if you are able to establish TCP connection to port
which is linked by stunnel. Telnet or netcat could be helpful in this
case. Use --host=xxx --protocol=tcp --port=xxx to explicitly specify
connection parameters. See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-t
Hi,
I have a table that looks something like this:
ip | mac_current | mac_change
now if I have an entry that looks like this
10.0.0.1 | 11:11:11:11:11:11:11 | NULL
If the next time the script runs and the mac has changed, how can I
catch this and put the new MAC into mac_change?
Ultimately,
Hello.
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
"Manish" <[EMAIL PROTECTED]> wrote:
> Hi,
> Platform is red hat linux-9..
> my hardware is 2.8GHz pentium-4 with 512 GB ram..
> softwares are Bugzilla 2.18 ,mysql-standard-4.0.15-pc-linux-i686
Hello.
> table_cache size is 64. I also discovered that the server does not
> close the tables automatically, e.g. if you open two windows and start
MySQL usually closes tables only in some cases. See:
http://dev.mysql.com/doc/mysql/en/table-cache.html
What error do you obtain when
Hi,
For confirming that password is shown or not in ps -ef,
just try to connect to your server using your password ,then in a new
window just do ps -ef --width 400 |grep mysql
You will find the output like below which doesn't show the password
-uroot -px xxx
Atleast it is not showing in
> mysql is trying to connect to localhost by default.
Yes, i know that, but with stunnel, when i connect to localhost, it is suppose
to connect to the remote server.
LinuxBox -> 3306 -> stunnel -> 3307 <> 3307 <- stunnel <- 3306 <- Server
On my linux box, i try to connect to local port 330
[EMAIL PROTECTED] wrote:
Hi,
i try to use mysql with stunnel (http://stunnel.org) in order to encrypt my
mysql connections. I know that mysql-4.x supports SSL but i can't compile it on
my windows box.
When i try to use stunnel on my windows box, it works,
i just have to use this command :
m
Hi,
i try to use mysql with stunnel (http://stunnel.org) in order to encrypt my
mysql connections. I know that mysql-4.x supports SSL but i can't compile it on
my windows box.
When i try to use stunnel on my windows box, it works,
i just have to use this command :
mysql -u user --password=xxx
Hi all,
The moral of the story, is don't run out of disk space, but it's a bit to
late for that now.
A quick scenario One master server, two backups replicating from the
master. Our data and bin logs are on two different partitions, and the
partition holding the bin logs, ran out of disk spa
Hi all,
We have a Mysql 4.0.24 running on FreeBSD 4.11
Yesterday server started to refuse new connections, while the
established connections did function properly. I discovered that the
problems start when the number of open tables reaches 20, the
table_cache size is 64. I also discovered that th
Hi Manish,
How you r connecting to mysql.
Just try the same way.
What bugs keyword stand in the command.
Perhaps you have to use
mysqldump -S /tmp/mysql.sock2 -uroot
Regards,
Anurag
-Original Message-
From: Manish [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 20, 2005 12:14 PM
To: mys
Manish wrote:
Hi,
Platform is red hat linux-9..
my hardware is 2.8GHz pentium-4 with 512 GB ram..
softwares are Bugzilla 2.18 ,mysql-standard-4.0.15-pc-linux-i686,
httpd-2.0.40-21
now problem is when i m trying to take back up of mysql by passing the
command..
/usr/local/mysql/b
56 matches
Mail list logo