On Wed, Oct 24, 2001 at 04:12:27PM +0930, Andrew Braund wrote:
> > We've had good luck with ReiserFS.
> >
> > Jeremy
> > --
> > Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> > Technical Yahoo - Yahoo Finance
> > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
> >
>
>
>
> > MySQL
Avelino F writes:
> I managed to set the file permission and managed to send the output to the
> mysql database directory used. Do you know if there is a way to make mysql
> write to a remote directory?
As in on any machine in the world? No. As in on the client machine?
Not really, since ther
Teddy A Jasin writes:
> Hi,
> I have this mysql statement:
> select hpnumber,count(*) as counts from Mobile_Ringtone_Manialogs
> where counts > 10 and datesent between '2001-09-24' and '2001-10-24' and
> (returncode > 0 and returncode < 10) group by hpnumber order by counts DESC
>
> and i Get
> We've had good luck with ReiserFS.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 48 days, processed 1,051,983,004 queries (253/sec. avg)
^^
Are th
tim gales writes:
> Hi. I am trying to have type in a story into a form "textfield" and
> submit it using PHP into "blob" formatted field mysql database.
>
> When I submit, all the "returns" are removed and all the text runs
> together like on ebig paragraph. Is there a way to have mysql or P
Are you sure it doesn't have the line feeds in the database? Neither MySQL nor PHP
will strip them out, unless you do some fancy work to make it do that. I would guess
that your real problem is that when you display it in your HTML, it shows up without
"returns". This is standard HTML practi
On Wed, Oct 24, 2001 at 10:54:38AM +0800, Z Julian wrote:
> I want to use journaled file system on my computer. Can you give me
> some advice? Furthermore, could journeled file system improve the
> performance of mysql? If yes, which journeled file system is better
> for mysql? Thank you~~ :)
On Tue, Oct 23, 2001 at 01:43:32PM +0300, Heikki Tuuri wrote:
> Hi!
>
> Thank you for a detailed bug report. This bug is already fixed in
> the source release 3.23.43b available from http://www.innodb.com
Is there now a test case for it in the MySQL test suite, too?
Jeremy
--
Jeremy D. Zawodn
Hello,
I managed to set the file permission and managed to send the output to the
mysql database directory used. Do you know if there is a way to make mysql
write to a remote directory? Is there a global or local configuration that
can be specified where mysql will write to?
Regards,
Avelino
Hi,
I have this mysql statement:
select hpnumber,count(*) as counts from Mobile_Ringtone_Manialogs
where counts > 10 and datesent between '2001-09-24' and '2001-10-24' and
(returncode > 0 and returncode < 10) group by hpnumber order by counts DESC
and i Get this following error:
Unknown column '
Hi. I am trying to have type in a story into a form "textfield" and
submit it using PHP into "blob" formatted field mysql database.
When I submit, all the "returns" are removed and all the text runs
together like on ebig paragraph. Is there a way to have mysql or PHP
recognize the "returns" and
Hi
> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 23, 2001 12:55 PM
> To: 'David Turner'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail);
> '[EMAIL PROTECTED]'
> Subject: MySQL with MyODBC & Access
>
>
> I've recently setup
At 10:43 PM -0400 10/23/01, Avelino F wrote:
>Hello,
>
>After logging into mysql and selecting a database, I type select *
>from song into outfile 'data123.txt'; but receive the following
>error message:
>
>ERROR 1045: Access denied for user: 'avelino@localhost' (Using password: YES)
>mysql>
>
>
-Original Message-
From: kmlau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 9:42 AM
To: 'Bill Adams'
Subject: RE: pls help for index problem
Thanks yr promptly reply !!
It seems no any change(improvement) by running explain again after erase
quotes. I also ran the
At 6:59 PM -0700 10/23/01, Bob Purvy wrote:
>I'm doing just general feasibility studying of embedding MySQL in a
>networking product, and I have a question that I haven't been able
>to find the answer to after a fair bit of looking
>
>- is there some way to insert data that is already in IN
Hi~
I want to use journaled file system on my computer. Can you give me some
advice? Furthermore, could journeled file system improve the performance of
mysql? If yes, which journeled file system is better for mysql?
Thank you~~ :)
Julian
__
Hello,
After logging into mysql and selecting a database, I type select * from
song into outfile 'data123.txt'; but receive the following error message:
ERROR 1045: Access denied for user: 'avelino@localhost' (Using password: YES)
mysql>
I made sure the user has full permissions to the databas
Hi
I posted the question below a little over a week ago and I have not had any
responses. Can anyone let me know if my email lacked detail and that's why
I've had no responses or whether this is a bug? I can create a complete
script that creates the tables, populates them and runs the querries
I'm doing just general feasibility studying of embedding MySQL in a
networking product, and I have a question that I haven't been able to
find the answer to after a fair bit of looking
- is there some way to insert data that is already in INT UNSIGNED
form directly into a table, without c
I'm trying out MySQL-Front on a Win2k machine and it is having a problem
opening some of my InnoDb tables.
I can open any of my InnoDb tables if I explicitly specify the database
name in the Connection window. But if I leave the database name blank I'll
see the database tree in the pane on th
On Tuesday 23 October 2001 14:15, Garrett Marone wrote:
> Chances are, you need to type
> myisamchk -o *.MYI
>
> as you only want to run myisamchk on the Index file, which is typically the
> .MYI file.
> you probably typed myisamchk -o *
> which is wrong.
Heh. I think you're right. It does look
On Tuesday 23 October 2001 13:50, David Potter wrote:
> Dear list members,
>
> We are running Mysql 3.23 on Redhat Linux 7.1.
>
> We have an emergency. This is the first time we have ever had a problem.
> Our production database suddenly crashed. I have tried to repair the
> tables with myisamch
Chances are, you need to type
myisamchk -o *.MYI
as you only want to run myisamchk on the Index file, which is typically the
.MYI file.
you probably typed myisamchk -o *
which is wrong.
Try it out.
Garrett
On Tuesday 23 October 2001 05:10 pm, you wrote:
> Hi!
>
> On Oct 23, David Potter w
Sergei Golubchik <[EMAIL PROTECTED]> writes:
> Hi!
>
> On Oct 23, David Potter wrote:
> > Dear list members,
> >
> > We are running Mysql 3.23 on Redhat Linux 7.1.
> >
> > We have an emergency. This is the first time we have ever had a
> > problem. Our production database suddenly crashed. I
Hi!
On Oct 23, David Potter wrote:
> Dear list members,
>
> We are running Mysql 3.23 on Redhat Linux 7.1.
>
> We have an emergency. This is the first time we have ever had a
> problem. Our production database suddenly crashed. I have tried to
> repair the tables with myisamchk commands, -r,
David Potter wrote:
> Dear list members,
>
> We are running Mysql 3.23 on Redhat Linux 7.1.
>
> We have an emergency. This is the first time we have ever had a problem. Our
>production database suddenly crashed. I have tried to repair the tables with
>myisamchk commands, -r, -o, etc and nothi
David Potter <[EMAIL PROTECTED]> writes:
> We are running Mysql 3.23 on Redhat Linux 7.1.
Which version on MySQL, and where did you get it?
--
Trond Eivind Glomsrød
Red Hat, Inc.
-
Before posting, please check:
http://www.
Dear list members,
We are running Mysql 3.23 on Redhat Linux 7.1.
We have an emergency. This is the first time we have ever had a problem. Our
production database suddenly crashed. I have tried to repair the tables with
myisamchk commands, -r, -o, etc and nothing works.
Here is the output
Hi,
I think that will solve the problem, I created a tablespace without any
problems and now I will start porting the data over.
Thanks
Butch
-Original Message-
From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 10:41 AM
To: [EMAIL PROTECTED]; [EMAIL
Hi,
I know this problem has already been reported (but I don't remember the
solution :( ) :
I encounter the following error after installing gcc 3.0.1 and trying to
compile MySQL 4.0 :
mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x14): undefined reference to
`__cxa_pure_virtual'
mysqlbinlog.o(
I've recently setup MyODBC and MS Access to use a ODBC profile that
is global to everyone. What I did was make a new user in MySQL and then
create a MyODBC User DSN. I made the links to MySQL in Access using this
profile. The problem I'm having is this, when you initially go into MS
Access
>Description:
while doing mysql-test-run --local it fails on the binary test with
the following message:
/usr/compile/mysql-3.23.43/client/.libs/lt-mysqltest: At line 34: Result length
mismatch
---
*** r/binary.result Wed Oc
On 23-Oct-2001 Steve Meyers wrote:
>> > At a previous job, we tested a 32-bit hash function by running it
>> > against hundreds of thousands of unique URL's stored in our
>> > database. We found one collision. A 64-bit hash is billions of
>> > times better (4 billion, to be exact).
>>
>> Good
Hi,
Using
$ gcc -v
Reading specs from /usr/local/lib/gcc-lib/alphaev56-dec-osf4.0d/3.0/specs
Configured with: /misc/gcc-3.0/configure
Thread model: single
gcc version 3.0
on
$ uname -a
OSF1 unix V4.0 878 alpha
I get this:
Making all in mysys
make[2]: Entering directory `/applic/mysql.src/my
At 08:31 22/10/2001 -0700, [EMAIL PROTECTED] wrote:
Hi!
>So why won't WinMySQLAdmin work for a different user? The user in the
>my.ini file does exist in mysql.user with Host='%' and %_priv ='Y'. The
>error file contains 'MySql: ready for connections' but none of the other
>tabbed pages have
> I am not understanding why having a hash and the full url in the
> database would not take care of the collisions. Even if you had
> 10 collisions for a 16 bit hash (say), if your query was:
> SELECT ... WHERE hash=thehashvalue AND url='theurl' you would get
> very fast lookups on the hash a
Hi!
I changed now ha_innobase.h so that InnoDB allows
keys up to 7000 bytes in length. The change will be
in MySQL-3.23.44 and 4.0.1.
Regards,
Heikki
http://www.innodb.com
>Steve Meyers wrote:
>
>> > > At a previous job, we tested a 32-bit hash function by running it
>> > > against hundreds of
Steve Meyers wrote:
> > > At a previous job, we tested a 32-bit hash function by running it
> > > against hundreds of thousands of unique URL's stored in our
> > > database. We found one collision. A 64-bit hash is billions of
> > > times better (4 billion, to be exact).
> >
> > Good to know.
> > At a previous job, we tested a 32-bit hash function by running it
> > against hundreds of thousands of unique URL's stored in our
> > database. We found one collision. A 64-bit hash is billions of
> > times better (4 billion, to be exact).
>
> Good to know. I wonder how many collisions I'd
> > At a previous job, we tested a 32-bit hash function by running it
> > against hundreds of thousands of unique URL's stored in our
> > database. We found one collision. A 64-bit hash is billions of
> > times better (4 billion, to be exact).
>
> Good to know. I wonder how many collisions I'd
On Tue, Oct 23, 2001 at 05:05:04PM +0100, Stuart Otway wrote:
> Hi all,
>
> I wonder if anyone has experience with this.
>
> my servers are both setup with mysql. Im following the HOWTO on the MySQL
> website to set them up to replicate the data. Ive completed every step but
> I get this error
I understand that you only have one table. The query I gave you joins the same table
against itself, and aliases it to a, b, and c. The only question was whether the
depth is always the same.
Steve Meyers
> Hi
>
> I have one table and the depth is not always the same.
>
> Anyway thanks :
Hi List members,
I'm new to MySql and am working through Paul DuBois' book: MySql. In going
through his tutorials, I've downloaded his distribution that contains
pre-written mysql commands and data to make the manual entry easier. The
problem is that I can't seem to run any of his scripts. He
Neil,
I did a quick test of your data and this is what I got to work.
SELECT item.item, titles.title FROM item LEFT JOIN titles ON
item.title_id = titles.title_id;
The left join selects all the items from the 'left' table even if there
are no matching entries in the 'right' table. A bit of a w
If you are trying to gather meaningful statistics from your weblog, you
might wish to consider the open source program Analog
(http://www.analog.cx).It works on windows, *nix, and took me less than
5 minutes to set up. There is also fine documentation about weblog
processing in general at ht
Hi all,
I wonder if anyone has experience with this.
my servers are both setup with mysql. Im following the HOWTO on the MySQL
website to set them up to replicate the data. Ive completed every step but
I get this error in the logs on the slave system:
Slave thread: error connecting to master:
> Is the mysql XA compliant ?
No.
> Is there a JDBC driver which support the possible XA compliancy of mysql?
No. Some application servers (Jboss for example) provide wrappers for
non-XA-compliant databases (which there are many), but you can end up with
corrupted databases, as the full two
>Description:
*** merge.rejectTue Oct 23 11:51:23 2001
--- merge.resultWed Oct 3 12:21:17 2001
*** a b
*** 9,12
! 1 Testing
! 1 Testing
! 1 Testing
! 1 Testing
--- 9,12
! 3 t1
! 3 t2
! 2 table
! 2 table
*** in
Hello and a big thank's to all mysql team for your wonderfull
product.
I use a mysql table to store my apache's logs.
The table is like
CREATE TABLE IF NOT EXISTS log (
ip char(12) not null,
date datetime not null,
...
PRIMARY KEY ( date, ip )
);
Some times, people double click on a link s
Put the min clause in a having statement
ex.
select * from words group by count having min(count) > 50;
-Original Message-
From: David Hugh-Jones [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 4:25 PM
To: Haapanen, Tom
Cc: [EMAIL PROTECTED]
Subject: RE: selecting rows where
Rafal Jank wrote:
> Hi!
> Is there a possibility to rotate mysql error log without stoping the server?
I was waiting for someone else to respond. But some possibilities are 1: use
the apache program 'rotatelog'. Not sure how you would do this.
In Linux you can rename the file while the server
Alas, my version won't let me use min() in a where clause - it only seems to
let me use it in the select clause. Is there a workaround?
mysql> select * from words where min(count) > 50 group by count;
ERROR : Invalid use of group function
d
On Tuesday 23 October 2001 8:17 am, Haapanen,
TOMASSONI Dominique wrote:
> I stored a sql string in a file and when I launch it, it doesn't perform
> because the string is truncated before the end.
>
> Does mysql limit the length of an sql string ?
Not that I have ever run into. But ODBC does.
What command are you running? E.g. on linux
Martyn Wendon wrote:
> Hi,
>
> I'm new to MySQL and indeed SQL in general (coming from an MS Access and
> Flat Text File background).
>
> I have data in text form at the moment of the following fields:
>
> ID (Auto increment)
> ARTIST (Text up to 255 characters long)
> DESCRIPTION (Text up to 255
Hi Tom
I'm raring to try this out but whenever I try a "GROUP BY" on a select with a
join, I seem to get
ERROR : Invalid use of group function
E.g.
select * from words,pairs where words.word=pairs.word1 and pairs.word2=15451
and min(pairs.count/words.count) > 0.8 group by word2;
ERROR
Hi !!!
"
"
And coming to your problem, I belive it got fixed in the latest release.
Regards, venu
> -Original Message-
> From: Mark Arnold [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 6:20 PM
> To: [EMAIL PROTECTED]
> Subject: Experience with mm.mysql-2.0.x ?
>
>
> Hi,
[EMAIL PROTECTED] wrote:
> Hi all,
> Is it possible to have an external file as an attachment in MySQL?
> An example would be a .gif, .doc, .ppt, .ram etc.
> If there is no way directly have MySQL table to store an attachment, is there
> any work around?
> Any guidance will be appreciated.
To st
kmlau wrote:
> I encountered a problem about indexing. I want to add index on timerecord
> field in table gw (shown as below) to speed up query relating with time.
> However, I use explain command (explain select * from gw where timerecord =
> '010902') to analyze the performace. As a resul
Hi !!!
> -Original Message-
> From: Jyotirmoy Biswas [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 10:45 PM
> To: [EMAIL PROTECTED]
> Subject: Help:Running JDBC for MySQL on Linux
>
>
>
> Sir/Madam, I am having Linux RedHat v7.1 running on my P3 mac. I
> have successfull
"M. Alageswaran" wrote:
> Thanks man, I tried that but still no hope..
> when I did a ps -ef | grep mysqld there is nothing in my output!
-ef is for HP-UX (I think). For Linux you want 'ps ax |grep mysqld' note
there is no dash in front of the ax.
b.
At 20:29 22/10/2001 -0400, Butch Bean wrote:
Hi!
I had consulted the MySQL developer Tonu the responsible of the
RAID code about the use of RAID on Windows and he said me that
wasn't tested it on Win32. Then I will need to do the test and
discuss with him the results.
However if your problem is
On Tue, 2001-10-23 at 10:52, Ken Guest wrote:
> On Mon, 2001-10-22 at 23:49, Neil Zanella wrote:
> >
> > Hello,
> >
> > I would like to know if it is possible to issue a command from the
> > mysql command line interface which will read SQL commands contained
> > in a file and execute them immedi
Hi all,
I have two tables (Titles(title, title_id, ...), Item(item_id, title_id,
...)) which have a common field (title_id) which I intend to use to join the
tables together. However, some Items have title_id's which do not match any
title_id in the Titles table, don't ask me why it's someone els
I stored a sql string in a file and when I launch it, it doesn't perform
because the string is truncated before the end.
Does mysql limit the length of an sql string ?
How do I do to execute my all sql string ?
-
Before postin
McGrotty, Charles writes:
> I have been bashing my head for a couple of hours now trying to
> create an enum field which will hold a true or false (1 or 0)
> value, but I always get an error when I try to create the enum
> field.
An ENUM can only hold strings, so you're probably missing
the quo
David Hugh-Jones writes:
> The student table has an "average grade" column which shows that student's
> average grade last year. The "grades" table has a column for subject (e.g.
> English, Math) and a column for the grade achieved.
>
> Suppose I want to select all my students who have perfor
Wouter de Jong wrote:
>
> /proc/sys/fs/file-max:
> 32768
And what about file-nr and others (*-nr)?
sql
--
Ing. Michal Žejdl e-mail: [EMAIL PROTECTED]
Sokolovská uhelná, a.s. tel.: +420 168 46-5418
---
On Sunday 21 October 2001 22:59, Chip wrote:
> I just installed mysql-3.23.43, apache-1.3.22, and php-4.0.6 all from
> source this evening (on freebsd-4.4-r). When I try to run safe_mysqld I get
> this;
>
> mysqld started
> Fatal error: Can't change to run as user 'mysql' ; Please check that the
>
Hi,
I have been bashing my head for a couple of hours now trying to
create an enum field which will hold a true or false (1 or 0)
value, but I always get an error when I try to create the enum
field.
What is the SQL syntax to create such a field in phpMyAdmin?
I tried to use the building tools
>> SELECT id_team,
>> sum(IF(m.id_visitor = t.id_team,m.visitor_score,
>> m.home_score)) AS But_pour,
>> sum(IF(m.id_visitor != t.id_team,m.visitor_score,
>> m.home_score)) AS But_contre
>> FROM tab_teams t, tab_matchs m
>> WHERE
Hi Kyle,
I know that various verions of FreeBSD had thread problems from 4.1
and down. Is it possible for you to upgrade to FreeBSD 4.4 or 4.3?
3.0 is very old and has many bugs, (unless you have been patching
it!). After upgrading to 4.4 you can install MySQL from ports in
several different
By reading the online manual-split.tar, I try to do some examples but one
doesn't work.
(For this time, I didn't configure mysql).
To (re)-product this error:
CREATE TABLE shop (
article INT(4) UNSIGNED ZEROFILL DEFAULT '' NOT NULL,
dealer CHAR(20) DEFAULT '' NOT NULL
My perl app that loads the tables reached 2gb and bang! It is only halfway
done! I had converted from Oracle which doesn't give a second thought as
long as the tablespace is large enough.
Has anybody turned on raid for the windows version?
Turning this feature on in Unix appears simple, but wh
Kyle,
Need a bit more info, what version of mysql? Have you granted the other
host(s) permission to use mysql? are you using mysqladmin to stop and start the
daemon?
cheers,
m!
Kyle B wrote:
> Hi all,
>
> I am going to try and describe my problem as best as possible. here it goes.
>
> Am
This might work ... but I don't have a suitable database to test with ...
select * from students,grades
where students.id=grades.id
and min(grades.grade - students.average_grade) > 0
group by students.id
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: David Hugh-Jones [mailt
Hi,
> SELECT * FROM students,grades WHERE students.ID=grades.ID AND grades.grade
>
> students.average_grade
>
> This doesn't work. It gets me all the occasions where a student has beaten
> his average. But I only want students who have never gone below their
> average! In other words, I want to s
OK, I have a tricky SQL syntax problem I would like to share.
For simplicity's sake, I'll use an analogy. I have two tables, of students
and grades, each with a "ID" column for use in joins, corresponding to a
student's ID.
The student table has an "average grade" column which shows that stud
Hi!
Try our 3.23.44 binary for Linux as soon as it is out, and let us
know if the problem persists.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\
Thanks Tom,
That has worked an absolute treat.
thank you very much
Leon.
-Original Message-
From: Haapanen, Tom [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 10:54
To: 'Leon Noble'
Cc: [EMAIL PROTECTED]
Subject: RE: Very untidy
select hour(ts), count(ts) from dundeefw
where date=$
Dear,
Is the mysql XA compliant ?
Is there a JDBC driver which support the possible XA compliancy of mysql?
Kind regards,
Luc Gevaert
ComCor Belgium
tel: +32 (0)3 309 95 30
GSM(B): +32 (0)479 27 47 20
Fax(B): +32 (0)3 309 05 47
E-mail: [EMAIL PROTECTED]
[EMAIL PROTECTED] writes:
> >Description:
>The following is the error message:
> #scripts/mysql_install_db
> Could not load program ./bin/my_print_defaults:
> Dependent module libz.a(shr.o) could not be loaded.
> Could not load module libz.a(shr.o).
[skip]
Hi!
This is a known defic
Hi,
I'm new to MySQL and indeed SQL in general (coming from an MS Access and
Flat Text File background).
I have data in text form at the moment of the following fields:
ID (Auto increment)
ARTIST (Text up to 255 characters long)
DESCRIPTION (Text up to 255 characters long)
PRICE (Decimal up to
Hi!
Thank you for a detailed bug report.
This bug is already fixed in the source release
3.23.43b available from http://www.innodb.com
You can look at latest bug information at
http://www.innodb.com/bugfixes.html
Regards,
Heikki
>Description:
> Using the following statement on empyt inn
>Description:
Using the following statement on empyt innobase tables crashes the
MySQL-Server:
select MAX(col3) from crashTable where col1 = 1 and col2 = 7;
>How-To-Repeat:
CREATE TABLE IF NOT EXISTS crashTable (
col1 SMALLINT UNSIGNED NOT NULL,
select hour(ts), count(ts) from dundeefw
where date=$date and action=1
group by hour(ts)
Assuming "ts" is your timestamp column ...
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Leon Noble [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 05:45
To: [EMAIL PROTECTED]
Subject:
hi,
I encountered a problem about indexing. I want to add index on timerecord
field in table gw (shown as below) to speed up query relating with time.
However, I use explain command (explain select * from gw where timerecord =
'010902') to analyze the performace. As a result, it seems the q
On Mon, 2001-10-22 at 23:49, Neil Zanella wrote:
>
> Hello,
>
> I would like to know if it is possible to issue a command from the
> mysql command line interface which will read SQL commands contained
> in a file and execute them immediately without having to cut and
> paste them one gpm buffer
Thanks man, I tried that but still no hope..
when I did a ps -ef | grep mysqld there is nothing in my output!
Pleas.. somebody make this thing work.
- Original Message -
From: Pankaj Gautam
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001 4:3
Hi all,
can someone look at my very untidy code and maybe give me some pointers.
Searching for values by the hour.
etc
for ($i = 0; $i <= 23; $i++)
{
$query = "select count(num) as mycount from dundeefw where date=$date
and action=1 and time=hour($i)";
// Execute query
$result = m
I have created a mysql based intranet and it has occurred to me that I
need to find out how to manage the log files but I cannot find them.
I downloaded the binary
mysql-3.23.41-pc-linux-gnu-i686.tar.gz
and installed to /usr/local/mysql
where should I look? Are they turned off by default ???
ch
I get this error message when trying to log in to remote MySQL database
server...
what does this mean?
how can I solve this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
Chris Book writes:
> My actual data has " represented as "", so I need to set it up this way. I
> would prefer to work with the files the way they are now rather than
> re-export my data a different way, since that machine is inconvenient right
> now.
>
> I can export data using the same param
Placed At : BOM
Durga Prasad@SATYAM
10/23/2001 01:06 PM
Hi all,
Is it possible to have an external file as an attachment in MySQL?
An example would be a .gif, .doc, .ppt, .ram etc.
If there is no way directly have MySQL table to store an attachmen
93 matches
Mail list logo
