Hello all,
Does anyone have an estimate of when MySql 4.1 will be released for
production.
MySql.cm says soon.
Please advise, would that likely be weeks/months?
Kind regards
Emmanuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
Hello *
Question:
Is there a (cheap) way to find out if a MyISAM Table is
already compressed, before running a myisampack on it ?
Goal:
-In a script that regularly compresses Tables
i'd like to check before packing. In case the script
has previously been started and already done the compre
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 12:49 am, Emmanuel van der Meulen wrote:
> I've looked in several books and searched Google but cannot get a way of
> doing this. It seems Oracle has a 'FIRST' in their select which they use
> for such a use case. But I do not
I think I get what you are trying to do and it sounds good (though I am
still a beginner). The only thing I can think that might cause a problem is
since you have more then a couple of tables you MAY have to write joins for
all of them . Only you would know if you can do that and/or be comfortabl
Hello all,
I see a similar question was asked before, but it was not answered. I hope
someone can assist me.
My query uses two tables. The query selects one row on table b for each row
on table a, but uses between in the select.
It can only ever return one row from table b, for each row on tabl
I've been having a tough time importing
comma-delimited files into my database tables. I just
discovered that most of the errors are similar to this
one:
"060 " is not a valid integer value
I checked my spreadsheet - Microsoft Works - and
discovered that there's a space after many of my
numerals.
Dennis Gearon wrote:
Please CC me, I am on digest.
What is an int(11) as in the following table creation statement? I
looked online at the documentation, and not only is the documentation
MUCH different than the last time I looked at it, (been awhile), but I
didn't see anything related to a para
Please CC me, I am on digest.
What is an int(11) as in the following table creation statement? I
looked online at the documentation, and not only is the documentation
MUCH different than the last time I looked at it, (been awhile), but I
didn't see anything related to a parameter to the size of
--
=
- Linux rocks!!! http://www.dedserius.com/
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
Blank does not mean bad try to connect with mysql client
if not try
#netstat -nvatp |grep mysql
if you see nothing
#locate .err
You shold find some file lie .err
#tail /path/to/that_file.err
aslo you may try
#cat /var/log/messages |grep mysql
Peter Zyumbilev
Project Manager
Mansion P
[EMAIL PROTECTED] [/tmp]# locate mysql.server
/usr/share/mysql/mysql.server
[EMAIL PROTECTED] [/tmp]# /usr/share/mysql/mysql.server start
[EMAIL PROTECTED] [/tmp]#
it seems nothing ... should I have to see in some log file ?
Thanks.
- Original Message -
# locate mysql.server
# /path/t
# locate mysql.server
# /path/to/mysql.server start
what error it gives ?
Peter Zyumbilev
Project Manager
Mansion Productions Inc.
AIM: peterZmansion
YMS: peterZmansion
MSN: [EMAIL PROTECTED]
Skype: peterZmansion
ICQ: 108984925
support: http://support.hostmansion.com (24/7)
email: [EMAIL P
One simple option would be to add a footnote column. And add in your code, if
footnote column is NOT NULL then add a * on to population and
show footnote at the bottom.
population footnote
100 null
200*yada yada
>>Suppose I have several columns of numberals - are
Suppose I have several columns of numberals - area,
popoulation, etc. - and I want to include asterisks
and footnotes, as in below:
200
4200
258*
234
24
2581
2400
What are some good strategies for doing this? You
really aren't supposed to include asterisks in integer
columns, right?
It would al
At 16:00 +0200 6/6/04, Martin Olsson wrote:
Hi,
First, if I install MySQL on a win32 system which are the default
account and from which hosts can those be accesses? Which of these
accounts am I encouraged to remove or change the password of? I know
that the "root"/"" accounts needs to be change
At 1:54 -0400 6/6/04, Minuk Choi wrote:
I have redhat9. I removed the RPM install of MySQL, and instead installed 3
copies of MySQL-4.0.20 BINARY distributions into my /usr/local/ directory,
under the helpful instructions of Thierno Cisse.
However, it seems like now, the PHP RPM installation canno
saiph wrote:
create database url;
use url
create table cath
(
name varchar(10) primary key,
) type=innodb;
create table site
(
url varchar(40) primary key,
aline varchar(40),
cath varchar(10),
constraint fk_cath foreign key(cath) references cath(name)
Noway :(
[EMAIL PROTECTED] [/etc]# vi my.cnf
[EMAIL PROTECTED] [/etc]# service mysql start
[EMAIL PROTECTED] [/etc]# mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/usr/local/lib/mysql.sock' (2)
[EMAIL PROTECTED] [/etc]# vi my.cnf
[EMAIL PROTECTED] [/etc]# service mysql sta
Thansk for your suggestion Steve, see what I have.
I don't know why by default server wants a sock in /var/lib/mysql and why it
doesnt exists anymore ?
How to create a new one ?
A search
[EMAIL PROTECTED] [~]# find / -name mysql.sock
/var/tmp/mysql.sock
/tmp/mysql.sock
/usr/local/lib/mysql.sock
I
On Sat, 5 Jun 2004 21:10:42 -0600
"Daniel Isenhower" <[EMAIL PROTECTED]> wrote:
> > First off, I assume you are using a version of mysql able to
> > handle
> sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries)
>
> Ugh... I feel dumb :) I'm using 4.0
No worries, there are too many
On Sun, 6 Jun 2004 15:48:37 +0200
Dimitri Bosiers <[EMAIL PROTECTED]> wrote:
> INSERT INTO
> pages(hidden,name,page_number,data,is_section_root,layout_id,group_
> id) VALUES(1,'nieuwe pagina',100,'',2,1,@LID);
>
> this fails with a "ERROR 1216: Cannot add a child row: a foreign key
>
> con
Hi,
First, if I install MySQL on a win32 system which are the default
account and from which hosts can those be accesses? Which of these
accounts am I encouraged to remove or change the password of? I know
that the "root"/"" accounts needs to be changed but what else is there?
Secondly, if I mo
I have a problem with my innodb database wich freaks me out ,
first a description of the involving tables :
mysql> describe pages ;
+-+--+--+-+-
++
| Field | Type | Null | Key | Default | Extra
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter wrote:
| Hi,
| Thanks for the reply :-))
| Any corruptions on MyIsam tables ? Cause in my case tables seems to
| crash a lot on the freebsd machines, processor almost die on 4.x ...
|
Nothing like this.
I have a lot of MyISAM tables and a view I
Hi,
Thanks for the reply :-))
Any corruptions on MyIsam tables ? Cause in my case tables seems to crash a lot on
the freebsd machines, processor almost die on 4.x ...
Best regards,
Peter Zyumbilev
Project Manager
Mansion Productions Inc.
AIM: peterZmansion
YMS: peterZmansion
MSN: [EMAIL
David
looking at
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Any of the field- or line-handling options can specify an empty string ('').
If not empty, the FIELDS [OPTIONALLY] ENCLOSED BY and FIELDS ESCAPED BY
values must be a single character.
Addionally it is a good idea to say FIELDS TERMIN
--Original Message-
> I have a table where the date a record was added is recorded in the
> date column. I can get count of how many records were entered on each
> day by doing this
> SELECT COUNT(*)
> FROM table
> GROUP BY date;
>
> I can get a total number of records by do
- Original Message -
From: "Klaas Geldof" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 06, 2004 10:19 AM
Subject: Re: Get fields in one field, separated by comma's
> - Original Message -
> From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED
create database url;
use url
create table cath
(
name varchar(10) primary key,
) type=innodb;
create table site
(
url varchar(40) primary key,
aline varchar(40),
cath varchar(10),
constraint fk_cath foreign key(cath) references cath(name)
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 05, 2004 9:50 PM
Subject: Re: Get fields in one field, separated by comma's
> "Klaas Geldof" <[EMAIL PROTECTED]> wrote:
> >
> > I have a question about MySQL queries. First
30 matches
Mail list logo
