- 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
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: "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
--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
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
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
-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
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
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
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
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
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
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
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)
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
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
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
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
# 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
[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
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
--
=
- Linux rocks!!! http://www.dedserius.com/
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
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
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
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.
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 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
-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
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
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
30 matches
Mail list logo
