query with vars

I have two independently built tables of people. I am trying to match people from one with people from the other. The problem is that in one table they may have used "Ron" and in the other "Ronald". What I want to do is have a match if on something like "if 'Ronald" is like 'Ron%' but obvio

tutorial sites

Does anyone know of some good tutorial sites of using Apache, PHP and MySQL.? Just starting out and want to create a website (mine) where I can change up the data as often as I. Thanks Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtn

about mysql security

I get a concept about mysql security. It's named "five-tiered access control".Can you tell me the detail of this concept?

working w/UK postcodes

Hello, I need to do a search query on the columns called Name of business "the name of the business" Town "Local town or city name" Postcode" this is the same as your zip code" Category"this is type of business ie dress shop bakers" XY "this is the table

Re: [MySQL] Testing

Mike Blezien wrote: is the list still working ? Would you believe me if I said, "No."? -- W | It's not a bug - it's an undocumented feature. + Ashley M. Kirchner . 303.442.6410 x130 IT Dir

Testing

is the list still working ? -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://thunder-rain.com/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mys

UK Postcodes

Hello, we are working with a database that stores UK postcodes, which are different then US zipcodes. I've found alot of information for working with zipcodes, locating closed distances within a zipcode range, but haven't found anything regarding working with UK type postcodes. Was hoping someon

Re: SETting values to TABLE field at TRIGGER runtime - FLAW IN MYSQL TRIGGER IMPLEMENTATION?

Ferindo Middleton Jr wrote: Gleb Paharenko wrote: Hello. It seems that you forgot to OPEN the cursor. The trigger should be similar to this one: CREATE TRIGGER trigger_registration_and_attendance_before_insert BEFORE INSERT ON registration_and_attendance FOR EACH ROW BEGIN DECLARE schedule_c

UK Postcodes

Hello, we are working with a database that stores UK postcodes, which are different then US zipcodes. I've found alot of information for working with zipcodes, locating closed distances within a zipcode range, but haven't found anything regarding working with UK type postcodes. Was hoping so

UK Postcodes

Hello, we are working with a database that stores UK postcodes, which are different then US zipcodes. I've found alot of information for working with zipcodes, locating closed distances within a zipcode range, but haven't found anything regarding working with UK type postcodes. Was hoping someon

Re: SETting values to TABLE field at TRIGGER runtime

Gleb Paharenko wrote: Hello. It seems that you forgot to OPEN the cursor. The trigger should be similar to this one: CREATE TRIGGER trigger_registration_and_attendance_before_insert BEFORE INSERT ON registration_and_attendance FOR EACH ROW BEGIN DECLARE schedule_class_id INT; DECLARE schedu

Re: MySQL or PHP problem?

Hello. See: http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html im DeBoer <[EMAIL PROTECTED]> wrote: >Hi everyone, >I've recently tried installing webcalander http://www.k5n.us/webcalendar.php on >my FBSD box. >I'm using version 5.1.1 of PHP, version 5.0.17 of MySQL,

Re: SETting values to TABLE field at TRIGGER runtime

Hello. It seems that you forgot to OPEN the cursor. The trigger should be similar to this one: CREATE TRIGGER trigger_registration_and_attendance_before_insert BEFORE INSERT ON registration_and_attendance FOR EACH ROW BEGIN DECLARE schedule_class_id INT; DECLARE schedule_class_id_c

Re: Sorry for my n00bie question - mysql 5.0.18 with load data infile

Hello. For MyISAM tables you may want to use ALTER TABLE ... DISABLE KEYS, ALTER TABLE ... ENABLE KEYS as described in the manual: http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html Increasing of the bulk_insert_buffer_size can help as well. "George Law" <[EMAIL PROTECTED]> w

Re: Bringing mysql server back up?

Hello. >'/usr/local/mysql-standard-4.1.12-apple-darwin7.9.0-powerpc/data/' (Errcode: 13 [EMAIL PROTECTED] gleb]$ perror 13 OS error code 13: Permission denied Check that mysql user has access to this directory. "Jay Paulson (CE CEN)" <[EMAIL PROTECTED]> wrote: >I was doing some te

RE: missing mysqld.sock

Hi Jon, The socket is created on demand. The error message said the server failed to start, not that your socket has disappeared ipso facto the socket will not have been created. That is why you can't connect, your server is not running. You need to check the system and mysql logs as mentioned i