I'm not an expert or affiliated with MySQL in any way, but to the best of my
knowledge the following is true:
MySQL (and it's source code) fall under the GNU Public License
http://www.mysql.com/doc/en/GPL_license.html
Abide by the rules on that page and the software is entirely free.
Wouldn't this also work?:
mysql -u root -p -e CREATE TABLE t$date(...) yourdatabase
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 12:46 PM
To: Julian Zottl; Andy Eastham; Mysql List
Subject: RE: DB design question - shell scripting...
Robert [EMAIL PROTECTED] wrote:
Having problems using 'LOAD DATA LOCAL INFILE' from a UNIX client talking to
a Win32 server. I've read the documentation several times now and have had
zero success with this command.
My server has the appropriate permissions configured in the MY.INI file
Hi!
There was a bad bug in the Windows version of the 4.0.15 mysql client. All
queries lasting more than 30 seconds time out with Error 2013 in the client.
Since the changelog entry in the release note of 4.0.16 Oct 22th did not
highlight this bug enough, I am sending this email to mailing
At 23:34 -0800 11/21/03, Chris wrote:
Wouldn't this also work?:
mysql -u root -p -e CREATE TABLE t$date(...) yourdatabase
Sure.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 12:46 PM
To: Julian Zottl; Andy Eastham; Mysql List
Subject:
I can't seem to locate a manual for the Control Center -- is such a
thing available and if so, where?
Thanks,
Dan Wilterding
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 8:53 -0600 11/22/03, Dan Wilterding wrote:
I can't seem to locate a manual for the Control Center -- is such a
thing available and if so, where?
There is not.
Thanks,
Dan Wilterding
[EMAIL PROTECTED]
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are
Can anyone help me to figure out why suddenly I
cant gain access into MySQL database with my password,
which I assigned myself and which was working fine
until yesterday when access was suddenly denied to me
with the following meassage:
Error 1045: Acess denied for user: '[EMAIL PROTECTED]'
At 11:23 -0500 11/21/03, Mark Marshall wrote:
Got it. mysqladmin version showed the 4.0.4 version.
The Find is what clued me in. It did indeed find two mysqld
executables. One in /usr/local/share/mysql/... and the other in
/usr/local/mysql/share/mysql/...
I copied the right one over the wrong
Hi,
I have been experiencing some problems regarding my server. I
recently tried reinstalling mysql and php and phpmyadmin to no
avail.
(I use apt-get remove/install mysql mysql-server mysql-devel php
php-mysql on RedHat 8.0. I have text mode only since it's a P166)
I seem to get a query
OK
Some development with the initial problem.
I have two OS X OS's running 10.2.6
My main one I installed the mySQL on and am having trouble with is
still not working.
As a test I installed mySQL on my second on and went through the
configuration straight after installation. Everything this time
At 21:43 + 11/22/03, Rob Snow wrote:
OK
Some development with the initial problem.
I have two OS X OS's running 10.2.6
My main one I installed the mySQL on and am having trouble with is
still not working.
As a test I installed mySQL on my second on and went through the
configuration straight
Hello,
I need the ability to round off dollar amounts to the
nearest 100th of a dollar amount, IE $14.9564 to $14.96 or
$132.1123 to $113.11
can this be accomplished with MySQL SQL function ??
TIA
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
At 16:34 -0600 11/22/03, Mike Blezien wrote:
Hello,
I need the ability to round off dollar amounts to the nearest 100th
of a dollar amount, IE $14.9564 to $14.96 or $132.1123 to $113.11
can this be accomplished with MySQL SQL function ??
Sounds like a job for TRUNCATE().
At 9:34 -0600 11/21/03, Paul Fine wrote:
Can anyone tell me what is better to use for items such as names and
addresses? I suspect VARCHAR(max anticipated length) but why? Is it because
Text will pad?
What do you mean by Text will pad? I can think of two distinct
possibilities,
only one of which
Thanks Paul.
but I think the function I was looking for was ROUND(X,D),
the TRUNCATE(X,D) just 'trims' it :)
IE using the value 123.336 and I needed it to round off to
123.34 in this case.
mysql select truncate(123.336,2);
+-+
| truncate(123.336,2) |
Hi!
Use the round() function.
round(14.9564, 2) = 14.96
round(32.1123, 2) = 113.11
Bye
Hello,
I need the ability to round off dollar amounts to the nearest 100th
of a dollar amount, IE $14.9564 to $14.96 or $132.1123 to $113.11
can this be accomplished with MySQL SQL function ??
--
Hi all:
How does one get away with creating a column name that
is more than one word -let's say a column named John
Smith? I know John_Smith is an option but I'd like
two separate words.
Thanks
J
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
Hi Mark,
Keep in mind that the CAST() function doesn't work in MySQL 3.23. If you
want something that will work with 3.23 and 4.0+, you can just add 0.0
to your expression:
SELECT 0 - unsigned_col + 0.0 AS alias FROM ...
The result will have .0 on the end then, but I think you can take care
of
Hi,
!= and are not optimized currently because I think it's assumed that
with
a b
more rows will NOT match b than do match. Therefore it's faster to do a
table scan.
That assumption is not true in all cases of course, which is why I think
it will be optimized in the future to estimate how
At 18:09 -0800 11/22/03, joffrey leevy wrote:
Hi all:
How does one get away with creating a column name that
is more than one word -let's say a column named John
Smith? I know John_Smith is an option but I'd like
two separate words.
Quote it with backticks: `John Smith`
On Fri, Nov 21, 2003 at 01:15:52PM -0700, Matt Sturtz wrote:
Thanks for the quick reply--
Yes, this is a common strategy, actually.
Any tricks to getting the tables converted on the master without the
slaves knowing about it (IE how can I do 'alter table' on the master
without it being
you could try encasing the name with backticks:
CREATE TABLE `My Table`(`My Column` INT);
-Original Message-
From: joffrey leevy [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 22, 2003 6:09 PM
To: [EMAIL PROTECTED]
Subject: question about column names
Hi all:
How does one get
i have a backup copy created using mysqldump called
test-dump-Sat.sql.
i need to restore it into the test database on my
remote Solaris server.
after getting into mysql i gave command:
use test;
mysql test test-dump-Sat.sql;
i got the following error:
ERROR 1064: You have an error in your SQL
I have never seen an error like this one, are the RPMs setup for dynamic
libraries?
ERROR 1126: Can't open shared library 'diff.so' (errno: 0
/lib/tls/libc.so.6: unexpected reloc type 0x0$ôç¿_½)
Sincerely,
Jason Pyeron
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-
Our old lcs.MYSQL.so from MySQL 3.23 give the same garbage out.
This has worked on many RedHat 7.3 / MySQL 3.23.xx boxes.
On Sun, 23 Nov 2003, Jason Pyeron wrote:
I have never seen an error like this one, are the RPMs setup for dynamic
libraries?
ERROR 1126: Can't open shared library
26 matches
Mail list logo