On Mon, 23 Sep 2002 08:40:59 +0300 (EEST) Iikka Meriläinen
<[EMAIL PROTECTED]> wrote:
> On Mon, 23 Sep 2002, Daniel Kiss wrote:
>
> > Hi!
> >
> > At 00:56 2002.09.23._ -0300, you wrote:
> > >Do I loose
> > >too much performance using InnoDB tables in autocommit mode instead of
> > >using MyISAM
hans schneidhofer wrote:
>hi list,
>trying to do my first steps with mysql, i have done the following :
>mysql> USE mysql;
>Reading table information for completion of table and column names
>You can turn off this feature to get a quicker startup with -A
>
>Database changed
>mysql> INSERT INTO my
How do you select from two tables, without joining those tables?
I just want the results of one table slapped on the end of the results from
another table because I don't want the overheard of running two seperate
queries. For instance:
Lets say that I have these two tables (and thur values):
F
Hi,
If you have a host having the minus character '-' in the name the mysql command SHOW
GRANTS FOR fails.
Example:
SHOW GRANTS FOR root@MY-COMUPTER results in the error message
"You have an error in your SQL syntax near '-COMPUTER' at line 1".
It looks like the command processor stops the pa
Hi,
Is there a defined behaviour for handling the case-sensitivety for user- and hostnames?
I did not find any information on this at the docs for the 4.0.3 MAX version which I'm
using.
For example, the following database connections are valid:
root@localhost
Root@localhost
However, the follo
hi list,
trying to do my first steps with mysql, i have done the following :
mysql> USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> INSERT INTO mysql VALUES(localhost, sample_db,
'
hi,hope anybody can help :
since a few days I have more and more trouble with sending and receiving
mails from and to this list.
sending to results very often in such a message :
Von:Mailer-Daemon <[EMAIL PROTECTED]>
An: [EMAIL PROTECTED]
Betreff:NDN: ERROR 1146
Datum: 23
I have set up mysql under redhat 7.3 and imported the database from mysql
running on windows.
I have the root user running using passwords, but i cannot get the other
users to log on even thogh the passwords shoudl have been carrid across with
the import.
I have tried to reset the user passwords
Hi
I can create a database called test,
mysql> create database test;
Query OK, 1 row affected (0.03 sec)
BUT I can't create any other databases???
mysql> create database tem;
ERROR 1044: Access denied for user: 'ddb@localhost' to database 'tem'
mysql> create database proj;
ERROR 1044: Access d
On Mon, 23 Sep 2002, Daniel Kiss wrote:
> Hi!
>
> At 00:56 2002.09.23._ -0300, you wrote:
> >Do I loose
> >too much performance using InnoDB tables in autocommit mode instead of
> >using MyISAM tables?
>
> The real quiestion is: Why do you want to use InnoDB tables when you don't
> want to use it
Hi!
At 00:56 2002.09.23._ -0300, you wrote:
>Do I loose
>too much performance using InnoDB tables in autocommit mode instead of
>using MyISAM tables?
The real quiestion is: Why do you want to use InnoDB tables when you don't
want to use its transaction safe features?
Anyway yes. I'm sure it is
Joao,
> I think I've already asked this before, but I will try again. Do I loose
> too much performance using InnoDB tables in autocommit mode instead of
> using MyISAM tables?
Possibly, but "too much" is really relative on what your needs are. What
are you trying to achieve and what is more im
I think I've already asked this before, but I will try again. Do I loose
too much performance using InnoDB tables in autocommit mode instead of
using MyISAM tables?
Thanks.
Joao
sql
-
Before posting, please check:
http://www.
MySQL newbie seeking help and/or advice on storing data into a database.
I have a poetry section I'm trying to add to my site that will allow users to submit
some of their work for public viewing. An example is located here:
http://www.nubiint.com/nuwoez/nuwoez.htm.
By clicking on any one of the
from perror
143 = Conflicting table definition between MERGE and mapped table
On Sunday, Sep 22, 2002, at 18:36 America/Anchorage, David Herring
wrote:
>
>
> Hello,
>
> I get the following error when trying to access a table created of
> TYPE=MERGE
>
> mysql> describe yy;
> ERROR 1016: Can't
Hello,
I get the following error when trying to access a table created of
TYPE=MERGE
mysql> describe yy;
ERROR 1016: Can't open file: 'yy.MRG'. (errno: 143)
Reducing the number of colums in the tables to be merged removed the
problem.
Any ideas gratefully received,
Dave
( MySQL version:
Oops... I meant Microsoft SQL Server and Oracle, not MySQL and Oracle.
Matt
- Original Message -
From: "Matt Hargraves" <[EMAIL PROTECTED]>
To: "Arthur Fuller" <[EMAIL PROTECTED]>; "David Kramer"
<[EMAIL PROTECTED]>
Cc: "mysql mailing list" <[EMAIL PROTECTED]>
Sent: Sunday, September 22,
I have a copy of Kylix 1.0, which I put on a recent RH 7.3 install. It
is running MySQL 3.23.49. I therefore d/l 3.23 driver for kylix.
I then did the following:
*Copied the driver to the kylix\bin file
*Created the symbolic link(Does it matter what dir this is
executed from?
We were told by David Axmark of MySQL AB to stop using MySQLGui and switch
to MyCC. MySQLGUI is apparently dead.
- Original Message -
From: "David Kramer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 16, 2002 12:52 PM
Subject: MySQL Gui Install and Setup for Win2K
Thanks Heikki,
Is there an easy way for me to see which version of glibc a particular
RPM was compiled against?
Adrian Liang
Em: [EMAIL PROTECTED]
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 21, 2002 1:34 PM
To: [EMAIL PROTECTED]
Subj
I have a table with a few million rows, wth 633 columns. I want to
create 10 inidices on this table, six single-column and four two-column
inidices. The database will be loaded once and remain static, and
queried many times. Please note that this is a "small" prototype for
the actual databa
Hello all,
I am currently using perl to import some information into a mysql db. At
this point in time I have two issues:
1. The text files that are being imported contain both english and french
text. My text editor (textpad) gladly displays the text with all proper
hyphens and accentuated c
Section 6.5.3 of the MySQL documentation has some slight mistakes:
Under the "create_definition:" section, the following line appears:
or CHECK (expr)
But this syntax doesn't appear to actually be supported yet (it produces an
error rather than being silently ignored).
Under the "type:" s
Following this conversation myself (also a perl db newbie :) ... before
always just used php) and curious if you know definitely what db vendor you
are going to be using (mysql in this case), any reason to use dbi; as
opposed to just using vendor specific or net::mysql; . Is it just a
portability
At 14:24 -0500 9/22/02, Gerald Preston wrote:
>Paul,
>
>Thank you!! I had installed DBD, but I did not know that I had to
>install DBD::mysql.
>
>THANKS SO MUCH!!!
I take it from your tone that your script works now? :-)
DBI (I assume that's what you mean by "installing DBD", because there is
Paul,
Thank you!! I had installed DBD, but I did not know that I had to install DBD::mysql.
THANKS SO MUCH!!!
Jerry
Paul DuBois wrote:
> At 13:33 -0500 9/22/02, Gerald Preston wrote:
> >David,
> >
> >I am not getting any where.. Do I have create mysql.pm on
> >my system or can just
At 13:33 -0500 9/22/02, Gerald Preston wrote:
>David,
>
>I am not getting any where.. Do I have create mysql.pm on
>my system or can just copy the file onto my system.
>I do not understand why MySQL did not create this file.
Because it's not part of MySQL. It's part of DBD::mysql, the
David,
I am not getting any where.. Do I have create mysql.pm on my system or can
just copy the file onto my system.
I do not understand why MySQL did not create this file.
Thanks,
Jerry
David Lloyd wrote:
> Gerald,
>
> > Now I am getting the following:
> >
> > install_driver(mysql
On Sun, 22 Sep 2002, Randy Johnson wrote:
> What's this error mean?
>
> Warning: Wrong parameter count for mysql_query()
Exactly what it says. You called mysql_query (PHP?) with the wrong number
of parameters/arguements. Ie, it might expect 2, and you only gave it 1.
--
Sapere aude
My mi
Shaun,
The length can be any value between 1 and 255. (As of MySQL Version 3.23,
the length of CHAR may be 0 to 255.) See
http://www.mysql.com/doc/en/CHAR.html
If you're looking to find the maximum length of the values in a particular
column, use something like this:
In table 'tablename' for c
Hi all,
I need to be able to tell what the maximum length of a char column is. Can
I query the database for this information?
Shaun
list filter: mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hey there,
That means that the MySQL server is unable to find the mysql socket. Check
your error log for more info.
Stuart
---
Perlboy.org - Professional Perl Programming Services
Carpet-Head.com - Sally's Blog
-Original Message-
From: Winnie Kwok [mailto:[EMAIL PROTECTED]]
Sent: Mond
What's this error mean?
Warning: Wrong parameter count for mysql_query()
thanks
Randy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Is there an easy way to turn logging or SQL statement executions on or off without
having to restart with a changed my.cnf file? Just want to log queries to try and
sort out some performance problems.
Thanks,
O.
(sql)
-
Gerald,
> Now I am getting the following:
>
> install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains;
>C:/Perl/lib C:/Perlsite/lib .) at (eval 1)
> line 3;
>
> I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I
>fix this?
No, it's separate f
David,
Thanks,
Now I am getting the following:
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib
C:/Perlsite/lib .) at (eval 1)
line 3;
I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix
this?
Thanks,
Jerry
David Lloy
Gerald,
> #!perl
>
> use strict;
> use DBI();
>
> # Connect to the database.
> my $dbh = DBI->connect("DBI:mysql:database=club;host=localhost",
>"jwp", "x",
> {'RaiseError' => 1});
>
> $drh = DB
Hi!,
I am lost! I am running in win 98 and my perl code is:
#!perl
use strict;
use DBI();
# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=club;host=localhost",
"jwp", "x",
{'R
After i install the Redhat 7.3 and mysql
i cannot connect to the mysql server , it shutdown automatically
[root@localhost root]/usr/bin/safe_install &
[1]2023
[root@localhost root]Starting mysql daemon with databases from
/var/lib/mysql
020923 00:36:23 mysqld ended
[1]+ Done /u
did you run the mysql_install_db script to create the mysql database and
populate it with the bare values necessary for mysql run?
SK
On Thursday, September 5, 2002, at 05:57 PM, Darryl Hoar wrote:
> Greetings,
> I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL
> website.
>
Paul,
You need to run another server on a different port with a different socket
path.
See http://www.mysql.com/doc/en/Multiple_servers.html
And http://www.mysql.com/doc/en/mysqld_multi.html to manage multiple MySQL
servers.
Cheers,
Andrew
-Original Message-
From: Paul Maine [mailto
Shane Allen wrote:
> configure:12730: checking style of gethost* routines
> configure:12773: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions
>-fno-rtti
> -fpermissive -I/usr/local/mysql-glibc-2.2.2/include conftest.cc >&5
> gcc: installation problem, cannot exec `cc1plus': No suc
I am aware that this is an error of my own making, however . . .
I am unable to install my sql because the scipt fails with
a duplicate key error
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing
I'm writing a website statistics system and have been using GROUP BY
TO_DAYS(time) in the sql to aggregate results for different days,
however there doesn't seem to be an equivalent function for other time
periods such as hours and months. Will I be able to use:
GROUP BY (MONTH(time),YEAR(time))
Yes, I now the problem with MySQL,
Can anyone send me te solution?
Greetings
---
B. van Velzen
VelzArt
Mobile : +31(0)653382221
Mail : [EMAIL PROTECTED]
Info : [EMAIL PROTECTED]
http://www.velzart.nl
===
hi list,
trying to do my first steps with mysql, i have done the following :
mysql> USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> INSERT INTO mysql VALUES(localhost, sample_db,
'
I desire to configure MySQL in such a way that it will permit me to have two
different PHP/MySQL e-commerce applications running concurrently on my
development system. The table names and table structure are the same on both
applications(and databases). I have received a SQL backup from the new
cl
>From: MySQL <[EMAIL PROTECTED]>
>
> From: "Madscientist" <[EMAIL PROTECTED]>
>
> You might also consider using two integer type fields - one for the
> numerator and another for the denominator. This way storage and recovery are
> easy and the mathematics are wide open.
> _M
>
>I suspect
Interesting,
http://mysqlfront.sstienemann.de/
Still works.
Stuart
---
Perlboy.org - Professional Perl Programming Services
Carpet-Head.com - Sally's Blog
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Iikka Meriläinen
Sent: Sunday, 22 September 200
Hrm,
I wouldn't mind taking this over, or at the very least, taking over the
website and releasing the current version. I have quite a bit of Windows
programming experience as it is so I should be able to make patches etc.
where needed.
Anyone know where I can find more info? I can host it at Pe
Hello,
As they say on the site, it is discontinued. My guess is that there were
no active developers. Quite a shame, though, as MySQLFront was simply the
best frontend for MySQL.
I _really_ hope that someone will pick up the development from where it
was left off and continue the development of
Hi All,
Does anyone know what happened to the MySQL-Front project, which was at
http://www.anse.de/mysqlfront/ ?
Thanks,
Kevin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.
52 matches
Mail list logo
