Re: Autoindexing

2006-06-23 Thread Keith Roberts
| +-+ | 201 | +-+ 1 row in set (0.02 sec) mysql HTH Keith Roberts In theory, theory and practice are the same; in practice they are not. On Fri, 23 Jun 2006, Tom Ray [Lists] wrote: To: mysql@lists.mysql.com From: Tom Ray [Lists] [EMAIL PROTECTED] Subject

RE: New to the group

2006-06-22 Thread Keith Roberts
to what php is, and what it can do. HTH Keith Roberts In theory, theory and practice are the same; in practice they are not. To unsubscribe from this list, please see detailed instructions already posted at: http://marc.theaimsgroup.com/?l=php-installm=114138567814319w=2 On Thu, 22 Jun 2006

Re: Problem With Join Syntax

2006-06-14 Thread Keith Roberts
| ipf_1 | ipf_2 | ipf_3 1 2 JohnSmith email_addy Which will allow you to retrieve all the values you want from the table as one row without having to repeat the userid column? HTH Keith Roberts In theory, theory and practice are the same; in practice they are not. On Wed, 14 Jun

Re: my-huge.cnf quite outdated

2006-06-12 Thread Keith Roberts
Jun 2006, Gaspar Bakos wrote: To: Keith Roberts [EMAIL PROTECTED] From: Gaspar Bakos [EMAIL PROTECTED] Subject: Re: my-huge.cnf quite outdated Hi, Keith, RE: This seems to be the way things are with mysql nowdays. Is it not time for the developers to take a serious look into culling

Re: my-huge.cnf quite outdated

2006-06-11 Thread Keith Roberts
reasons? I would really like to see a slim and trim version of mysql, the SQL commands, and the supporting cli programs, that is up to date and has a very fast learning curve. Just my little gripe. Kind Regards Keith Roberts In theory, theory and practice are the same; in practice

Re: Books on MySQL 5

2006-06-09 Thread Keith Roberts
by getting these two books together. Regards Keith Roberts In theory, theory and practice are the same; in practice they are not. On Fri, 9 Jun 2006, Chris White wrote: To: mysql@lists.mysql.com From: Chris White [EMAIL PROTECTED] Subject: Books on MySQL 5 As always, thanks ahead of time

Re: Transfer users and permissions between servers

2006-06-07 Thread Keith Roberts
Are you moving to a new unpopulated server, or are there already mysql users on the new server? If it is a new server with no other mysql users onboard, then I guess it is as easy as copying the mysql system database (/var/lib/mysql/mysql on my system) across to the new server, with the other

Re: mysql edition problem

2006-06-02 Thread Keith Roberts
: 0eaa7a8ec18699ce550db1713a27cda3 | Signature HTH Keith Roberts In theory, theory and practice are the same; in practice they are not. On Fri, 2 Jun 2006, yuan edit wrote: To: mysql@lists.mysql.com From: yuan edit [EMAIL PROTECTED] Subject: mysql edition problem my operating system is linux redhat 9.0. i am

Re: Keyword - MySQL 4.1

2006-05-29 Thread Keith Roberts
, _, and $. The identifier quote character is the backtick (`): mysql SELECT * FROM `select` WHERE `select`.id 100; Or could you just use an ALTER TABLE statement to change the name in your database, and then change the div name in your application code? HTH Keith Roberts In theory, theory and practice

Re: [suse-security] fou4s for 10.1?

2006-05-24 Thread Keith Roberts
There is no reason why you cannot use diffeent package managers for your system. The only thing is do not run two managers at the same time, as they require exclusive access to the rpm database. Trying to use more than one package manager, or multiple instances of the same one is not a good

Re: SPAMs

2006-05-24 Thread Keith Roberts
Check this out, it works a treat for me: http://www.tmda.net Regards Keith In theory, theory and practice are the same; in practice they are not. On Wed, 24 May 2006, Jørn Dahl-Stamnes wrote: To: mysql@lists.mysql.com From: Jørn Dahl-Stamnes [EMAIL PROTECTED] Subject: Re: SPAMs On

Re: Sparse 1.0b - framework for MySQL programs

2006-05-22 Thread Keith Roberts
are not intended to apply to software. They should not be used for software. So I'm not entirely sure why you're recommending it. ^^; It is released under the GPL. --Daniel Keith Roberts [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi Daniel. Distribute it under the CC

Re: Sparse 1.0b - framework for MySQL programs

2006-05-20 Thread Keith Roberts
Hi Daniel. Distribute it under the CC license? http://creativecommons.org/about/licenses/index_html Keith In theory, theory and practice are the same; in practice they are not. On Fri, 19 May 2006, Daniel Orner wrote: To: mysql@lists.mysql.com From: Daniel Orner [EMAIL PROTECTED] Subject:

Re: Looking for free MySQL Administrator

2006-05-20 Thread Keith Roberts
http://www.phpmyadmin.net/home_page/index.php I think phpmyadmin will allow you to make changes to multiple columns at once. For any major changes to a database such as you describe, if you have the disk space, I would advise copying the database and performing your changes on the copy, just

Re: Find invalid email formats using MySQL query.

2006-05-20 Thread Keith Roberts
Well, mysql has support for regex matching. The thing is though, why store invalid email addresses in you database? I think what you are doing is the right approach. Check the email address validity first in php BEFORE saving it to the database. At least you then know you are only storing

RE: Find invalid email formats using MySQL query.

2006-05-20 Thread Keith Roberts
Probably the most efficient place to do this sort of field checking would be using javascript in the browser. That would stop the bad addresses even being sent down the line to the server in the first place. Keith In theory, theory and practice are the same; in practice they are not. On Sat,

Re: MySQL, PHP and Yahoo webhosting

2006-05-16 Thread Keith Roberts
Hi. call this function, phpinfo(); in a *.php file. That should return alot of usesfull info. Make sure the mysql extension is being loaded. If so check the value of the following php config var: ; Default socket name for local MySQL connects. If empty, ; uses the built-in ; MySQL defaults.

Is there any way to search a whole database for a value?

2003-03-11 Thread Keith Roberts
I need to look in several different tables/columns in a database for a particular value. If I find it, I need to update it. Is there any way to search/update every table/column in one query in a particular database? -- Keith Roberts IT Manager - Laptops For Less 2995 White Star Anaheim, CA