From: "Will K." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, April 14, 2002 23:21
Subject: Scanning Directory/Inserting Image Links to DB
> Can someone recommend a Perl script/technique that will scan a Unix
> directory of image/text files, and then insert the l
Greets Folks,
Can someone recommend a Perl script/technique that will scan a Unix
directory of image/text files, and then insert the links into a MySQL
database? I used to have a good one, but it got misplaced... Doh!
Thanks,
Will
MySQL is the 'standard' MySQL. MySQL-Max include high end features, for
big systems. Things like InnoDB, for one. Stuff that the average user
might not want.
So, essentially, it just tells you what features are in that release.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Or
Hi!
- Original Message -
From: "SDiZ (UHome)" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, April 15, 2002 7:51 AM
Subject: Re: How does DISTINCT really work ?
> I think every thing are documented.
>
> http://www.mysql.com/doc/B/u/Bugs.htm
Actually, with a pconnect, there would be a trade off. Since it uses a
shared connection, the last insert ID could change between the update
and calling the api function. But as I said, it doesn't matter for the
counter.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original M
mysql:
mysql-4.01
binary package
windows
also the same in linux source/binary package
when SHOW VARIABLES
got:
-
character_set gbk
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos
german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew w
I'm now trying to UPDATE the three records with one query.
Once the data is INSERTED into the db with this -
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15'),
('2','Mark','AA2','2002-04-16'),
('3','Mark','AA3','2002-04-17');
a form page is displayed wher
hi,
I am starting my Mysql Serevr like this..
> cd /bin/sbin
> mysqld-max --user=root
Is there any another method which doesn't require starting the server by
Root..(root privileges)
please, help me out in this direction.
Thanks and regards,
Chetan Lavti
-
Hi All!
And Hello MySQL spam filter. SQL. Query.
How to I tell the 'load data infile' statement to ignore certain fields,
eg the first 10 fields of each record?
Thanks!
Dan
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+
Hello,
I am using Red Hat 7.1. When i use rpm query, it says that I have My SQL
3.23 Server and Client installed. Where can i find the installation
directory.
I am planning to use 4.0.1. How useful it is to uninstall 3.23 and
install 4.0.1 for development purpose.
Thanks
-Jayakumar
---
Hi.
Just use
INSERT INTO mytable (id,name,job_number,job_date)
VALUES ('1','Mark','AA1','2002-04-15'), ('2','Mark','AA2','2002-04-16'),
('3','Mark','AA3','2002-04-17') [and so on...]
Also see http://www.mysql.com/doc/I/N/INSERT.html
Bye,
Benjamin.
On Sun, Apr 14, 2002 at 11:10:22PM
Hello,
I am new to MySQL. Can anyone tell me what is the difference between
MySQL and MySQL Max.
Thanks
-Jayakumar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi.
There is a one-query method to do that and it is even explicitly
documented: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
(under LAST_INSERT_ID([expr])). This requires an UPDATE and using a
client API function like mysql_insert_id(). No locks needed and the
operation is atomic (i
Many thanks for that.
cheers
Mark
On Mon, 15 Apr 2002, Kittiphum Worachat wrote:
> Hi.
>
> insert into mytable (id,name,job_number,job_date) values
> ('1','Mark','AA1','2002-04-15'),('2','Mark','AA2','2002-04-16'),('3','Mark',
> 'AA3','2002-04-17'),
>
> Kittiphum Worachat,M.T.
> www.ha
At 05:14 15/04/02 +0200, Carsten Gehling wrote:
>> Fra: Simon Byrnand [mailto:[EMAIL PROTECTED]]
>> Sendt: 15. april 2002 04:00
>
>> I'm currently running MySQL 3.23.40 on Redhat 6.2 and its working nicely.
>> It was installed from binary RPM's.
>>
>> I'm not trying to update to 3.23.49, but beca
On Sun, 2002-04-14 at 22:17, Craig Westerman wrote:
> I'm needing counter for site that receives 80 to 120 hits a minute at peak
> load. Many I
> have tried cause excessive server load and need to be deactivated or they
> lose data and return to zero without warning. All tried so far have been
> w
Hi.
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15'),('2','Mark','AA2','2002-04-16'),('3','Mark',
'AA3','2002-04-17'),
Kittiphum Worachat,M.T.
www.hatyailab.com
>
> Does anyone know if it's possible to insert mutilple records into 1 table
> in one q
> Fra: Simon Byrnand [mailto:[EMAIL PROTECTED]]
> Sendt: 15. april 2002 04:00
> I'm currently running MySQL 3.23.40 on Redhat 6.2 and its working nicely.
> It was installed from binary RPM's.
>
> I'm not trying to update to 3.23.49, but because the binary RPM's
> available
> require GLIBC 2.2 (Re
"Craig Westerman" <[EMAIL PROTECTED]> writes:
> I'm needing counter for site that receives 80 to 120 hits a minute
> at peak load. Many I have tried cause excessive server load and need
> to be deactivated or they lose data and return to zero without
> warning. All tried so far have been written
Does anyone know if it's possible to insert mutilple records into 1 table
in one query?
Something like -
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15')
insert into mytable (id,name,job_number,job_date) values
('2','Mark','AA2','2002-04-16')
insert int
I'd recomment PHP4 using pconnect and MySQL. And I'd /not/ use locking
on the table. Run a query to update the row, then run a select to grab
the current total. In the case of a counter, it doesn't require the
precision that most things would. (i.e., it's okay if the row you read
doesn't have the
These guys have written a PHP/MySQL counter script thats available for
download.
http://www.kastle.net/products/php/dbcounter/
I've used their old one thats writes to a text file rather than a MySQL db
and its very good also.
cheers
Mark Dale
On Sun, 14 Apr 2002, Colin Faber wrote:
> Having
Having objectively looked at both I would say a simple DBI perl app
running under mod_perl with Apache::DBI installed would be your best
bet for performance. Connection pooling is something you'll need to
keep the overall load down.
PHP's pconnect is good but seems to be a bit broken in it's poo
I'm needing counter for site that receives 80 to 120 hits a minute at peak
load. Many I
have tried cause excessive server load and need to be deactivated or they
lose data and return to zero without warning. All tried so far have been
written in Perl writing to a file.
Anyone here know of a count
Hi All,
I'm currently running MySQL 3.23.40 on Redhat 6.2 and its working nicely.
It was installed from binary RPM's.
I'm not trying to update to 3.23.49, but because the binary RPM's available
require GLIBC 2.2 (Redhat 6.2 uses 2.1) I need to compile it from source or
source RPM.
I've "install
> > > I'm quite sure it does not matter if I write
> > > t_person.dperson_id = d_person.dperson_id AND
> > > or
> > > d_person.dperson_id = t_person.dperson_id AND
> > > but please tell me if it does... :o)
> >
> > Logically there is no difference, however prevailing wisdom suggests
> > th
Hello all,
I'm attempting to migrate a postgresql dbase to a mysql dbase and
was wondering if anyone had any general tips or suggestions... maybe a
tool or script or link that may be of some help.
I greatly appreciate any info anyone may have. Thanks
Bradley
-
Did you FLUSH the permissions? (aka, reload the server, in phpMyAdmin)
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Mark Roberts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 14, 2002 5:31 PM
To: [EMAIL PROTECTED]
Subject: Question about grants/p
> It is not apparent from your question, where the problem lies. Why not
> show us what you have so far?
> SQL is used to retrieve data from relational databases. Are you really
> intending to retrieve FROM a web page?
Sorry, I meant that I am writing a PHP web page that takes input from a user
t
Hey!
I use Windows 2000 Professional Service Pack 2, and mySQL 3.23.49 max nt.
On each startup of the database I get the following Error in my Event
Viewer --> System log, under
'Computer Management' in W2K:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7
I created a database named: rcs
I then granted access as such:
grant all on rcs.* to rcs@localhost identified by 'password' with grant
option;
I then tried to run an sql file as such:
./mysql -h localhost -u rcs rcs -p < database_schema.sql
Then I get the following error message:
[robert@ser
mysql... see below, got caught be the filter of this list...
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Kevin Smith" <[EMAIL PROTECTED]>
Sent: Sunday, April 14, 2002 3:13 PM
Subject: Re: auto_increment setting the start number
> Your message cannot be posted because it appears t
Hi,
Lets say that I am the admin on mysql server, how can
i know which tables currently are being locked? And if
they are locked by someone else, how to do I remove
the locks.
Thank you.
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with Tur
* DL Neil
> > I'm quite sure it does not matter if I write
> > t_person.dperson_id = d_person.dperson_id AND
> > or
> > d_person.dperson_id = t_person.dperson_id AND
> > but please tell me if it does... :o)
>
> Logically there is no difference, however prevailing wisdom suggests
> that you
Jocelyn,
the below shows a bug in the MySQL DISTINCT operation. If you specify
DISTINCT, you should not get duplicate rows.
I have forwarded this email to Monty.
Have you tried myisamcheck on the tables?
If the tables are small, could you please upload them to the 'secret'
directory in the MyS
In fact I couldn't suppress the LIMIT as it would return a lot of rows ;)
However the order by doesn't seem to have any effect.
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Carsten Gehling" <[EMAIL PROTECTED]>; "Fournier Jocelyn [Presence-PC]"
<[EMAIL PROTECTED]>; <[EMAIL
Hi Roger,
> consider this select statement as an example:
>
> SELECT d_person.dispname, d_title.title
> FROM d_person, d_title, s_first, s_last, t_person, l_first, l_last
> WHERE
> t_person.dperson_id = d_person.dperson_id AND
> t_person.dtitle_id = d_title.dtitle_id AND
> l_first
Well done Carsten!
Which may bring us back to the relationships between the data/columns
being used to control the query.
Jocelyn: Did you try out my previous suggestions?
Please advise,
=dn
- Original Message -
From: "Carsten Gehling" <[EMAIL PROTECTED]>
To: "Fournier Jocelyn [Presence-P
Yes but when it's written "DISTINCT is converted to a GROUP BY on all
columns", which columns are included in "all columns" ? :)
Thanks,
Jocelyn
- Original Message -
From: "Carsten Gehling" <[EMAIL PROTECTED]>
To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>; "DL Neil"
<[EMAIL P
> Fra: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
> Sendt: 14. april 2002 19:22
> In fact what it's odd is when I use EXPLAIN, I don't see anywhere DISTINCT
> in the EXPLAIN result :
That's because the MySQL optimizer converts your distinct into a group by.
Read more here:
http:/
Hi everyone,
Apologies, I'm coming very late into this conversation, but perhaps I
can disperse some of the confusion...
Rob's original question:
*
I'm curious about how MySQL deals with time zones.
Our machines are located in the GMT time zone, and recently rolled over
to
British Standard Ti
In fact what it's odd is when I use EXPLAIN, I don't see anywhere DISTINCT
in the EXPLAIN result :
mysql> EXPLAIN SELECT DISTINCT topic FROM
searchmainhardwarefr7,searchjoinhardwarefr7 WHERE
searchmainhardwarefr7.numreponse=searchjoinhardwarefr7.numreponse AND date
>='2002-03-24' AND (mot='test')
check the manual for GRANT. The knowledge you seek is contained therein.
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Alex Lui [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 14, 2002 10:56 AM
To: [EMAIL PROTECTED]
Subject: data
Hi Jocelyn,
I don't have a quick/sure answer for you, but am wondering about the
relationship between the date and topic columns - I note that the '429s
are interspersed by other values.
I'm a great believer in the KISS principle (simple things amuse simple
minds!)
May I suggest taking out the l
Hi,
So why does I obtain duplicates numbers for 'topic' with the first query
with DISTINCT ? (perhaps a bug ?)
Regards,
Jocelyn Fournier
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday,
Hi Ben,
> I have a database table which includes a timestamp(14) field.
>
> I would like to construct an SQL statement that pulls out records
between
> two dates, based on this field (i.e. time is not important, date is).
>
> So a user input "01/01/2001" -> "01/01/2002" and I want to retrieve
all
Hi gordon,
> This is NOT needed as of now..
> (just future-thinking on my part),
>
> Hi there... Im just experimenting with a new database,
> & i'm wondering..
>
> Is there a way in which I can create a column in a
> mysql table to be a unique number/reference.. - & once
> set, I dont need to
Hi Jocelyn,
> I wonder how works DISTINCT when using it with the following join.
> Ex :
>
> mysql> SELECT DISTINCT topic FROM
> searchmainhardwarefr7,searchjoinhardwarefr7 WHERE
> searchmainhardwarefr7.numreponse=searchjoinhardwarefr7.numreponse AND
> (mot='test') AND date >= '2002-03-24' ORDER B
Hi All,
Can anybody tell me how to restrict someone from using a specified database?
eg: user is not allowed to use database mysql for security reason.
TIA
Alex Lui
-
Before posting, please check:
http://www.mysql.com/manua
Hi
I appear to be having problems with replication and temporary tables.
Up until last week, we have had replication working without any serious
problems for 3/4 months; then one of the developers decided to use two
temporary tables as work areas.
Immediately, replication stopped on the clien
Hi all,
I have a database table which includes a timestamp(14) field.
I would like to construct an SQL statement that pulls out records between
two dates, based on this field (i.e. time is not important, date is).
So a user input "01/01/2001" -> "01/01/2002" and I want to retrieve all
records t
This is NOT needed as of now..
(just future-thinking on my part),
Hi there... Im just experimenting with a new database,
& i'm wondering..
Is there a way in which I can create a column in a
mysql table to be a unique number/reference.. - & once
set, I dont need to keep maintaining it.. (or s
* Daniel Jarrett
> I'm just wondering..
>
> say i have a members table as my main table in MYSQL..
> and in that table i have a field named month, that will be one of twelve
> options.
>
> would it be better practice to have the month field linked to
> another table
> called months and have the m
>Description:
After installing the mysql server i moved it to my home dir under SQL. Tried
running the configure script first. Then i tried mysqladmin version but it
doesnt help. It says that not able to find /tmp/mysql.sock file.
The message prompted is as follows.
./bin/mysqladmin version
./bin
* Roger Ming Hieng TING
> > I read the installation guide on the web and there is a part
> > where it is stated that if we don't have permission to create file in
> > /usr/local we should perform the installation as root. What do u mean
> > by perform installation as root. How should it be don
Dear all
check this new tool at
http://amr.activechannel.net
http://amr.activechannel.net/setup.zip
SQL server users will love it , same query analyzer but more powerful
Amr Salah
_
Get your FREE, Private email today - [EMAIL PR
On Sun, Apr 14, 2002 at 08:50:46AM +0200, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to
Hi Gokce,
You can check the following (especially the second one);
1. Make sure that you have provided a password to root account on the server
box;
grant all on * to 'root'@'%' identified by 'your_root_password';
% here means that you can login to your server box as root from a
58 matches
Mail list logo
