Dave Kennedy [EMAIL PROTECTED] wrote on 03/06/2005 05:09:36 PM:
SELECT sum(col1) AS total1
FROM t1
GROUP by col1
SELECT col1, sum(col2) AS total2
FROM t2
GROUP by col2
Table t1 contains 4 rows to sum for each value in col1
Table t2 contains 8 rows to sum for each value in col2
If one select
Hi,
is it or will it ever be possible to access
an embedded data base and a remote server with the
same binary?
That would make installation of our software simpler
because we now have to offer two variants
--
Wolfgang
--
MySQL General Mailing List
For list archives:
From: Tom Crimmins
On Monday, March 07, 2005 23:03, GH wrote:
Greetings, I would like to know if it is possible to do a mail merge
in Microsoft Office with a mySql database as the source?
Thanks
You can use install MyODBC, set up a DSN, and then use this in Office.
Alternatively you could use OpenOffice.org (http://www.openoffice.org/)
which has built in MySQL support.
Alternatively, you could switch to MS Access, which is very well
supported by Microsoft Office.
:-)
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase,
I have 200 tables with regular datetime fields. I link these tables
through ODBC to an ACCESS database where I can run standard ACCESS append
queries or even copy/paste append into the linked table. ODBC handles the
conversion just fine.
One caution, MySQL timestamp maps to ACCESS datetime but
Does Open Office have a MSPublisher like program?
On Tue, 8 Mar 2005 12:43:01 +0100, Jigal van Hemert [EMAIL PROTECTED] wrote:
From: Tom Crimmins
On Monday, March 07, 2005 23:03, GH wrote:
Greetings, I would like to know if it is possible to do a mail merge
in Microsoft Office with a
For the answer to that question, you might just want to go see for
yourself. http://www.openoffice.org/
Steve
At 08:16 AM 3/8/2005, you wrote:
Does Open Office have a MSPublisher like program?
On Tue, 8 Mar 2005 12:43:01 +0100, Jigal van Hemert [EMAIL PROTECTED]
wrote:
From: Tom Crimmins
On
From: GH
Does Open Office have a MSPublisher like program?
I'm not familiar with Publisher, but I gues that it is supposed to help you
make publications in a kind of desktop pulishing way.
In the article at http://www.newsforge.com/article.pl?sid=04/10/04/150207
the author compares Writer (the
I know that this is a little off topic, but if you want a real Desktop
Publishing Suite, try Adobe
(InDesign, specifically). They cannot do MailMerges like in OpenOffice or M$,
but it's much easier
to use than M$ and looks a lot more professional.
As a side note, OpenOffice, as of 1.1.2, does
Hello.
Execute FLUSH PRIVILEGES after granting.
See:
http://dev.mysql.com/doc/mysql/en/flush.html
http://dev.mysql.com/doc/mysql/en/privilege-changes.html
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/user-resources.html
Connect to the
Hello.
MySQL cannot resolve this servers hostname for brief
periods around the same time every day.
You can disable the hostname cache by starting the server with the
--skip-host-cache option.
But the performance can slow down. You may use nslookup to check the correct
work of the
Hello.
Is the option well set and in the right place ?
Yes. If your mysqld reads this file (use --defaults-file command line
option to be sure).
No.2
This slowness problem could occur also on a server running SuSe Linux
8.2 ?
Usually using MySQL server on Unix gives better
Hello.
MySQL keeps throwing error 1114 on temp files
Are you using InnoDB tables?
1114 (ER_RECORD_FILE_FULL)
InnoDB has run out of free space in the tablespace. You should reconfigure
the tablespace to add a new data file.
Homam S.A. [EMAIL PROTECTED] wrote:
MySQL keeps
Hello.
The time is calculated at mysql client. This is a time of executing query
and getting results.
and nice_time seemed to me that this function calculate the time.
This function formats the time to human-readable format.
Kenken PA [EMAIL PROTECTED] wrote:
Hi All,
I
Hello.
Put all your character_set_xxx variables to hebrew. See:
http://dev.mysql.com/doc/mysql/en/charset-connection.html
John Berman [EMAIL PROTECTED] wrote:
How's this
+--+---+
| Variable_name| Value
Thank you all for your responses.
The reason that I am currently asking about Publisher is that i do
certificates for programs that my organization runs and I am able to
in publisher mail merge the Proper Names of both the recipients and
signatories onto the certificate plus print the wording,
Hi,
I have installed mysql on my system using tar file. But when i start mysql
it generates following error and shuts down.
Plz help me out to run the MySql server as i have important data on it.
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld
Starting mysqld daemon
From: S.Yousaf Shah [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: MySql error...
Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT)
Hi,
I have installed mysql on my system using tar file. But when i start mysql
it generates following error and shuts down.
Plz help me
Hi,
Have a look in the error file which is in mysql/data and called hostname.err
to have more information on why it is shutting down.
With that info you usually can find more help on the mysql website.
Good luck!
From: S.Yousaf Shah [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To:
Hi,
I don't have an answer for you yet - but I encountered exactly the same
situation with one of my systems last weekend. Unfortunately, the error file
sheds no light at all on the situation. In my case:
[EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err
050304 07:30:36 mysqld started
If you're starting the process as a non-system user then the var
directory and anything under it should be owned/writable by that user.
If you're starting it as root then the var directory should be
owned/writable by mysql:daemon. If you don't have the Mysql user setup
then the mysqld daemon won't
Hi,
I am a new mysql user. I installed a MySQL, PHP and Apache on my
computer with Windows XP.
All my php scripts run fine unless I try to connect to mysql
?php
echo start here;
$a = mysql_connect(localhost, test, test);
echo $a;
echo stop here;
?
I don't get any response even error message
Hi, I just learned to query a flat or .txt file into a result ARRAY by
line number using
//?php
// Get a file into an array. In this example we'll go through HTTP to get
// the HTML source of a URL.
//$lines = file('http://www.w-ifc.com/test/SCORE.TXT');
// Loop through our array, show
[snip]
I am a new mysql user. I installed a MySQL, PHP and Apache on my
computer with Windows XP.
All my php scripts run fine unless I try to connect to mysql
?php
echo start here;
$a = mysql_connect(localhost, test, test);
echo $a;
echo stop here;
?
I don't get any response even error
[snip]
My question as a new amatuer programmer is ...
What direction do I need to go to use the variables assigned so that
I can store the info that the script has read into the mySQL DB? as
I would like to keep it functions correct to standard.
Thanks ahead for your valuable time.
Wik
True. I forgot to mention, when doing the normal install from the tar, the
files/databases for mysql and test both refused to create, although I see no
error message indicating that. I believe that the root issue has something
to do with the permissions during the make install.
//jjs
If you downloaded the source tar and built Mysql doing a make/make
install then you won't have a database.
To create the baseline databases you need to run mysql_install_db which
creates the mysql and test databases under the var directory. Its also
worth copying one of the .cnf files from
Also, check to make sure the partition where your log directory is (ie.
/var) isn't full.
Move, compress, or delete some of the old logs, then restart mysql server.
Reconfigure your log rotation scheme to avoid this in the future.
HTH,
Joey
~~
Joseph Karalius
mysql_connect('localhost', 'my_user', 'my_pass')
or die(mysql_error()):
On Tue, 8 Mar 2005 11:28:47 -0600, Jay Blanchard
[EMAIL PROTECTED] wrote:
[snip]
I am a new mysql user. I installed a MySQL, PHP and Apache on my
computer with Windows XP.
All my php scripts run fine unless I try to
Thankx to all,
I have solved the problem, the problem was with the permissions.We have to
give the ownership of the mysql directory to mysql user and the run the
configuration file.
Regards,
--Yousaf
yousaf jschmidtYousaf
Hi,
I don't have an answer for you yet - but I encountered exactly the
Thanks will do this.
In the same dBase there a lots of tables were the data is in English - I
assume they will be ok ?
John B
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 07 March 2005 21:12
To: mysql@lists.mysql.com
Subject: Re: Hebrew
Hello.
Put all your
If Publisher XP's mail merge can find data in ACCESS try linking the tables
into an ACCESS database and then tying Publisher to the ACCESS database.
Sounds klunky but it might work.
-Original Message-
From: GH [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 9:37 AM
To: J.R.
OK I've honestly banged my head against everying, but as far as I can tell
MySQL has *NO* real logging support. You have three options, log
everything as text, log all queries as binary, or nothing.
What I want/NEED is connection logging and some sort of ERROR logging. I'm
getting an
So, I installed MySQL. Accidentally locked myself out of the database
trying to make it secure. Tried to re-install MySQL, now every time I
tell it to Start MySQL Server through the control panel, it asks for
authentication, then immediately goes back to stopped. It won't
launch.
Is there a
Under UNIX/linux use syslog, for me /var/log/messages shows login/auth error
Mar 6 05:39:11 orion pdns[1865]: gmysql Connection failed: Unable to
connect to database: Access denied for user 'root'@'localhost' (using
password: NO)
Now for dropped sockets/connections you need to enable logging
--On Tuesday, March 08, 2005 15:03 -0500 Daniel Fisla [EMAIL PROTECTED]
wrote:
Under UNIX/linux use syslog, for me /var/log/messages shows login/auth
error
Mar 6 05:39:11 orion pdns[1865]: gmysql Connection failed: Unable to
connect to database: Access denied for user 'root'@'localhost' (using
I'm glad I'm not the only one that thinks the logging in mysql blows chunks
Every other piece
of server software can log it's authentication issues and disposition,
why can't MySQL? Oracle can do this, Postgres, DB2, etc etc etc.
--
MySQL General Mailing List
For list archives:
I see your point, especially when not being in control of client software.
You may be in a hard position.
I assume your did already some research into this so I won't give you the
RTFM answer. :-)
Adding in your logging code should not be that hard, well, it depends what
kind of logging you'd
--On Tuesday, March 08, 2005 15:44 -0500 Daniel Fisla [EMAIL PROTECTED]
wrote:
I see your point, especially when not being in control of client software.
You may be in a hard position.
I assume your did already some research into this so I won't give you the
RTFM answer. :-)
Yes lots :( That's
You need to kill the mysql process, then you can startup MySQL from the
command line with the --skip-grant-tables option. MySQL will then load
without checking for any passwords, it will be completely open. You can
then log in as a guest and change the root password.
sudo
If you want to start from scratch, kill the mysql process and delete
the mysql directories in /usr/local/
On Mar 8, 2005, at 2:47 PM, Jeff Justice wrote:
So, I installed MySQL. Accidentally locked myself out of the database
trying to make it secure. Tried to re-install MySQL, now every time I
Hi all,
I have a table which contains amoung other things, search terms used on
our web site. What I'm trying to do is select the count of distinct
search terms in one query. I think this is possible, but I can't seem
to get the syntax quite right. I've tried things like the following
John Nichel [EMAIL PROTECTED] wrote on 03/08/2005 04:40:00 PM:
Hi all,
I have a table which contains amoung other things, search terms used on
our web site. What I'm trying to do is select the count of distinct
search terms in one query. I think this is possible, but I can't seem
to
[EMAIL PROTECTED] wrote:
snip
Try something that looks like:
SELECT searchTerms, Count(1) as frequency
FROM your_table_name_here
GROUP by searchTerms
ORDER BY frequency DESC
LIMIT 10;
That will give you the 10 most frequently appearing searchTerms in the
table your_table_name_here. The GROUP BY
Okay, here's a brief synopsis, with suggestions made and tried:
Cannot get MySQL to launch. A process is never started in the activity
monitor. What exactly is the name of the process I should see?
Tried uninstalling MySQL by deleting the MySQL directories in
/usr/local/. (after first making
Il giorno mar, 08-03-2005 alle 13:46 +0100, Martijn Tonies ha scritto:
Alternatively you could use OpenOffice.org (http://www.openoffice.org/)
which has built in MySQL support.
Alternatively, you could switch to MS Access, which is very well
supported by Microsoft Office.
:-)
mmhhh
I have looked in the documentation and either I am not looking for the
right thing or have simply overlooked it. But my question is this, I have
a database with 35 Million records, and I need to delete about 25 million
of those. After deletion I would think that I would need to compress,
shrink,
Hi Chris,
For MyISAM/BDB tables use OPTIMIZE TABLE your table name;
For InnoDB tables try ALTER TABLE your table name TYPE=InnoDB;
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408
Is there a flag in MYSQL to automatically escape special characters
like single quotes with a backslash? Instead of using a C API or PHP
addslashes() funciton for each field I'd need to escape?
Thanks,
Scott.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Scott Klarenbach wrote:
Is there a flag in MYSQL to automatically escape special characters
like single quotes with a backslash? Instead of using a C API or PHP
addslashes() funciton for each field I'd need to escape?
I don't think you've thought that through completely. How would
MySQL know
Haha! Great point. I guess it's time for me to call it a day and get
some sleep :-).
Thanks,
Scott.
On Tue, 08 Mar 2005 18:23:24 -0500, Keith Ivey [EMAIL PROTECTED] wrote:
Scott Klarenbach wrote:
Is there a flag in MYSQL to automatically escape special characters
like single quotes
I think I got it working I am printing out the records that I need...
a bit of a 2 stepper but nice since I can store the queriy since that
can not be done just yet in MySql
On Tue, 08 Mar 2005 23:47:09 +0100, dixie [EMAIL PROTECTED] wrote:
Il giorno mar, 08-03-2005 alle 13:46 +0100, Martijn
I have a msaccess program reading the serial port every 200 mili sec.
Each time it has to record the data from the port to a linked mysql
table.
I run the program and run fine but after a while ( not the same elapsed
time) I start getting that the odbc fail to connect to the server error
3151.
Osvaldo Sommer wrote:
I have a msaccess program reading the serial port every 200 mili sec.
Each time it has to record the data from the port to a linked mysql
table.
I run the program and run fine but after a while ( not the same elapsed
time) I start getting that the odbc fail to connect to the
Daniel:
The program is an interfase for a weigth system in a Retail
environment.
The program query the weigth system for new data every 200 miliseconds,
if new data is received it has to be stored in the database. The table
has automatic correlative, the data in ascii, the date and time
Hi Gleb,
Thanks for your help.
(I'm sending again, because first I just sent this only to you to use
Reply of Gmail, not use Reply to all.)
Well, is end_timer calculating the time?
--
static void end_timer(ulong start_time,char *buff)
{
nice_time((double) (start_timer() - start_time) /
Osvaldo Sommer wrote:
Daniel:
The program is an interfase for a weigth system in a Retail
environment.
The program query the weigth system for new data every 200 miliseconds,
if new data is received it has to be stored in the database. The table
has automatic correlative, the data in ascii, the
In the documentation, it doesn't mention which version
of MySQL supports the CASE statement, but it refers to
stored procedures, so is it only supported for 5.x?
I can't get any example of a CASE statement work in
MySQL.
The reason I'm asking is because in other SQL
dialects, such as T-SQL, you
Homam S.A. wrote:
In the documentation, it doesn't mention which version
of MySQL supports the CASE statement, but it refers to
stored procedures, so is it only supported for 5.x?
I can't get any example of a CASE statement work in
MySQL.
snipped
For example, I can execute the following in MS
Tweakers.net has completed a comparison of 9 serial ATA RAID 0/1/5/10
controllers at:
http://www.tweakers.net/reviews/557
There is a specific section on MySQL performance in the section:
http://www.tweakers.net/reviews/557/25
Just thought these articles would be of interest to some (it's
Hello, I installed MySQL 4.1.10 on Debian Ubuntu based following these
directions:
http://dev.mysql.com/doc/mysql/en/installing-binary.html
I then logged in, changed root password, used test database, etc.
Now after reboot I cannot connect. I get this:
[EMAIL PROTECTED]:/usr/local/mysql/bin #
Alternatively you could use OpenOffice.org
(http://www.openoffice.org/)
which has built in MySQL support.
Alternatively, you could switch to MS Access, which is very well
supported by Microsoft Office.
:-)
mmhhh MySQL Vs. Access MS... just a little be different :-)))
Yes, very
62 matches
Mail list logo