Heyho!
Robin Lynn Frank wrote:
I hope this question doesn't sound too dumb, but since I can't afford
to screw it up...
I have a table with 98,000 records. I want to globally replace the
content of one field where the content is
XXX diverse_text
with
XXX non-diverse_new_text
In other word
Right, I understand that, but then *why* can a user create another user, with
all the priveleges they have, but with now password. That seems like a great
security hole. It seems that the GRANT syntax should allow the setting of a
password upon account creation without requiring access to the
Good morning,
I'm working on Windows XP Professional and I'm using EasyPHP1-7 with Apache
1.3.27, PHP 4.3.3, PHPmyAdmin 2.5.3, MySql 4.0.15.
1 - I must start up Easy PHP with [EMAIL PROTECTED] If I try to work with
other users by the user parameter in config.inc.php, PHPmyAdmin doesn't
work.
2 -
hello,
thank you for info.
but i want one graphics tool which is free.
i m using perl and mysql.
i am also searching for the graphics tool which i can use for the data in
mysql table or the output by my perl program.
if anyoneknow abt this please do reply
===
We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers
in -
mysql-connector-java-2.0.14-bin.jar
Do these drivers work with MySQL 4.1.8? hey seem to be working fine with
4.0.14 version of MySQL.
Is there any compatibility data available for all these JDBC drivers and
MySQL vers
[snip]
I have a table with about 50 fields in it, I want to copy certain records
into another identical table...
i.e
INSERT INTO mail_inbox (userid, subject, message, blah blah) (Select
userid, subject, message, blah blah... from mail_inboxold where userid = 10)
Is there an easy way to do thi
[snip]
Given a search string of 'NA&SD' my default Fulltext search doesn't find it.
Wondered why?
[/snip]
Quote from http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html:
"MySQL uses a very simple parser to split text into words. A "word" is any
sequence of true word characters (letters, digits
On Mon, Jan 10, 2005 at 11:44:48AM -0800, Eduardo Castro wrote:
> Is there a way to encript the password in the text file? Or anothe way
> to connect to my sql with an encripted password?
Any authentication token you store in a text file will be just
as useful as an unencrypted password, since on
Daniel Gaddis wrote:
does anyone know of a utility that will processes the query log to rerun
the queries?
The program would need to...
...strip the leading non query info from the line
...handle queries that span multiple lines
...change databases when appropriate before queries
...add the ; to th
Hi,
i'm using mysql-alpha ver 5.0.2.
while i was using a cgi script, i discovered that SELECT querys using
DISTINCT and a duplicated field crashes mySQL server.
i.e.
SELECT DISTINCT id, id FROM table;
aparently, it does not happen with all the tables, but more than 50%
where could i report the bu
From 5.0.1 you can write database-specific stored procs but the
language is SQL not Perl, see
http://dev.mysql.com/doc/mysql/en/Stored_Procedures.html.
PB
sam wrote:
Hi,
Can anyone tell me where I can download examples for creating Stored
Procedure in perl DBI?
It seems that I can't create adva
Sabeer-
Welcome to the list! I'm pretty much a lurker here, but I have learned
a lot. You've come to the right place to get your MySQL questions
answered.
Good luck!
- James
On Jan 10, 2005, at 2:06 PM, sanoj zubair wrote:
Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my bes
Sabeer-
Welcome to the list! I'm pretty much a lurker here, but I have learned
a lot. You've come to the right place to get your MySQL questions
answered.
Good luck!
- James
On Jan 10, 2005, at 2:06 PM, sanoj zubair wrote:
Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my bes
Hello.
You may use some recommendations from:
http://dev.mysql.com/doc/mysql/en/Full_table.html
"Jocelyn Fournier" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've just encountered a strange problem when trying to update a table :
>
> UPDATE searchmainhardwarefr0, searchjoinhardwarefr0 S
Hello,
I plan to reorder some columns of my table. So I am
using ALTER TABLE STATEMENT .. with CHANGE syntax as
suggested at:
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE_problems.html
I believe its the only way to reorder columns? Is
there something better?
If CHANGE is the best option, is th
Hi Bruce,
Thanks for the advice. I'm glad to hear you have so many of these
machines successfully in production! Our machines are currently
fitted out with 2Gig of RAM each so I won't face the process memory
limit right away. That's actually more than enough to fit all our
keys in memory anyw
does anyone know of a utility that will processes the query log to rerun
the queries?
The program would need to...
...strip the leading non query info from the line
...handle queries that span multiple lines
...change databases when appropriate before queries
...add the ; to the end of the query
Hi, is it is not the place to discuss DAO, ignore me and sorry ^^
but I have a question about DAO, I write my DAO and include all
function that to select / insert / update / delete record from
database. Therefore all interaction between database and the outside
world are by DAO. No direct access
Hi Brent, thanks for your comments! An unbiased outside pov always helps!
On Thu, 6 Jan 2005 14:32:16 -0500, Brent Baisley <[EMAIL PROTECTED]> wrote:
> While part of the problem may be OS X, Apple is still optimizing parts
> of the OS, I would say the "problem" is that you are comparing it to a
Given a search string of 'NA&SD' my default Fulltext search doesn't find
it. Wondered why? Is there a fix? Thanks for the help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OOPS! the ON AND was a typo. Sorry! Should have been just ON. I am
puzzled why it worked but I am glad it did.
That's what I get for too much cut-and-paste at the end of the day. I
apologize to everyone!
What actually made it work was not the ON AND (yuck!) but the LEFT JOIN.
What you were tr
Hello, thanks for helping! Here is the output of the requested statements on
live database:
SHOW CREATE TABLE avatardata;
| customavatar | CREATE TABLE `customavatar` (
`userid` int(10) unsigned NOT NULL default '0',
`avatardata` mediumtext NOT NULL,
`dateline` int(10) unsigned NOT NULL defa
Jason Martin wrote:
Does anyone know of a web-based tool that will let you graph
arbitrary data out of of MySQL? I'm thinking of something that
lets you define a select statement, some graph options and
produce a graph.
JPGraph produces some *very* nice graphs from PHP.
There are some graphing m
I hope this question doesn't sound too dumb, but since I can't afford to
screw it up...
I have a table with 98,000 records. I want to globally replace the
content of one field where the content is
XXX diverse_text
with
XXX non-diverse_new_text
In other words, if the content of the field st
Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my best Here.
Sabeer MZ
__
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
--
MySQL General Mailing List
For list arch
Hello,
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
According to it I can specify a name/id for a relation
on and after 4.0.18. Before that InnoDB provides an
internal id/number.
I was just curious - what happened before 4.0.18 or
3.23.x. Was an ID still provided by Inn
sam wun wrote:
Gleb Paharenko wrote:
Hello.
Use -e command line option for mysql client program. For example:
mysql -u root -p test -e 'drop view v'
Hi, does it take wildcard? something like:
mysql -u root -p test -e 'drop view v*'
Or even drop all view tables (only affect the view tables):
my
Gleb Paharenko wrote:
Hello.
Use -e command line option for mysql client program. For example:
mysql -u root -p test -e 'drop view v'
Hi, does it take wildcard? something like:
mysql -u root -p test -e 'drop view v*'
Thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysq
Jason Martin wrote:
Does anyone know of a web-based tool that will let you graph
arbitrary data out of of MySQL? I'm thinking of something that
lets you define a select statement, some graph options and
produce a graph.
I'm afraid I'm not aware of anything as simple to use as you describe,
but you
Nope no issues.
> -Original Message-
> From: Daniel Kasak [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 09, 2005 6:51 PM
> To: mysql@lists.mysql.com
> Subject: MySQL-4.1 and PHP
>
> Hi all.
>
> Does anyone know if there are any issues with PHP-4.1 and MySQL-4.1?
> I assume I'll hav
Given a search string of 'NA&SD' my default Fulltext search doesn't find
it. Wondered why? Is there a fix? Thanks for the help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
What is the equivalent of oracle's rowid (which is a 16digit unique
one) in mysql 4.0.20?. To achieve the same functionality is there any
alternative method in MySQL?. Please help me in this.
Thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message
Hi Michael!
Before the holiday you tried to help me with a problem that I had
over-simplified and made more confusing than it was. I'll now try again,
and also by giving the columns their right names.
My table consists of parsed outputs from a bioinformatics tool called
blast. Every 'sbj_name' (w
Hi..
I've got an ISP, and all of our customers have databases in our mysql
system.
My backup command is:
mysqldump --force --opt -A -p' | gzip -c >
/var/sqlbackup/mysqldump-`date +\%A`.sql.gz
This has worked fine for some time.
Now, however, I get an error message:
mysqldump: Got
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on the page http://dev.mysql.com/doc/mysql/en/InnoDB_Locks_set.html
This statement is confusing.
"If you do not have indexes suitable for your query and MySQL has to scan the
whole table to process the query, every row of the table will become locked"
Is it saying that all at once at the beg
Hi, I am trying to connect to my sql using a php script, but I do not
want to store the MySQL user password in a text file.
Is there a way to encript the password in the text file? Or anothe way
to connect to my sql with an encripted password?
Thanks.
--
MySQL General Mailing List
For list a
Have a look at your /var/log/messages for messages around the time the
table crashes . It really should not crash this much. Is there a
quota system on your box ? I once had a table marked corrupt and
though I tried hard to find where the problem is, I was not able to.
Eventually, it turne
Hi,
Can anyone tell me where I can download examples for creating Stored
Procedure in perl DBI?
It seems that I can't create advance reporting with basic operations
(select, create) in perl dbi, so I m looking for whether Stored Proc in
MySQL can solve my problem.
Thanks
Sam
--
MySQL General Ma
Does anyone know of a web-based tool that will let you graph
arbitrary data out of of MySQL? I'm thinking of something that
lets you define a select statement, some graph options and
produce a graph.
Thanks,
-Jason Martin
--
You can't go home again, unless you set $HOME.
This message is PGP/MIME
Andy,
- Alkuperäinen viesti -
Lähettäjä: "Andy Davidson" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Lähetetty: Tuesday, January 04, 2005 5:02 PM
Aihe: Re: BIG InnoDB problems!
...¨
On Mon, 3 Jan 2005, Heikki Tuuri wrote:
the problem you had was serious corruptio
Hi all.
Does anyone know if there are any issues with PHP-4.1 and MySQL-4.1?
I assume I'll have to recompile PHP ( and Perl and other stuff that
talks to MySQL ), but other than that, are there any gotchas I should
know about?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific
42 matches
Mail list logo
