Re: Install MySQL on Windows XP

Hi there Yuan, Hopefully this article can be of some help to you: http://schalkneethling.alliedbridge.com/php/php-mysql-apache-set-up-how-to/ Regards, Schalk yuan edit wrote: Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server su

Re: Granting users localhost access

Hi Pam, If you want to grant a specific user remote access i.e. from a shell or from an application that resides on a different machine then you will have to adjust the query I sent earlier: update mysql.user set host = '%' where user = 'AUserName'; FLUSH PRIVILEGES; The above two queries wi

Re: Granting users localhost access

Hi there Pam, This should do the trick: update mysql.user set host = 'locahost' where user = 'username' Regards, Schalk Pam Astor wrote: How do I grant users, who already have a password, localhost access? I don’t want to change their passwords at this time. __

Tips for migration

HI All, Can anyone give me some pointers, help, point me to articles with regards to transfering a MSSQL database to MySQL? Thanks! Schalk Neethling -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Creating Password & Username with phpMyAdmin

on and you are set. HTH Schalk Neethling AlliedBridge (code.google.com/p/alliedbridge) David Blomstrom wrote: Sorry for the beginner's question, but I'm confused. I can easily create passwords and usernames for my online databases by going into my C-Panel and clicking a MySQL ico

1064 error

GP + Limpopo Classic + SA Model Portfolio + Top Model Challenge + Gauteng Model Classic + Year of the Model AS total_points FROM modelcup.ab_leader_board All of the rows does exist in the table and all row names are correct. TYIA! -- Kind Regards Schalk Neethling Web

Re: SCO issue

ould then lead me to agree that looking at Pg would be a good idea. Hopefully MySQL AB will make all this clear one way or the other ... Rich Allen Dare & Do -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Busi

Re: Creating virtual rows question

DER BY total_points ASC -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_

Re: Creating virtual rows question

Jacques Thank you, I will give it a try. Jacques Marneweck wrote: Schalk Neethling wrote: Greetings Please have a look at the following code and let me know if this is the correct way to create a virtual row. Also, after having run this MySQL returns the error that the row total_points

Creating virtual rows question

emale' AND cup = 'kids' AND current_pos > 0 ORDER BY total_points ASC -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web

Re: Not sure about Error

Dan Yes, I completely overlooked that. Thanks! Dan Nelson wrote: In the last episode (Jun 23), Schalk Neethling said: I run the following query against MySQL: SELECT demographic_no, first_name, last_name, chart_no, sex, year_of_birth, month_of_birth, date_of_birth, family_doctor

Not sure about Error

= ichppccode.ichppccode WHERE allergies.description LIKE '%CARBACHOL%' MySQL returns the following error: Not unique table/alias: 'demographic' What exactly is meant by this statement :( Thank you in advance! -- Kind Regards Schalk Neethling Web Developer.Designer.Programm

Re: Restoring mySQL dump

ysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.vi

order by confusion

his to return the results as 1,2,3,4 etc.? Any help would be appreciated. Thank you! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[

Re: joining six tables by mutual column

#x27;t this work ? Have you an example ? Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Schalk Neethling [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 00:52 To: mysql@lists.mysql.com Subject: j

joining six tables by mutual column

an answer. Any help or pointers will be appreciated. Thank you. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECT

Windows Installer

ed to know whether there is a known bug. Thanks! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com

Re: MySQL Database Designer

MacOS X. Do you have a good suggestion? Regards, Andreas -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.c

Problem connecting to MySQL server

age is then returned: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Any ideas why this is happening? Any help on pointers to where I may find more answers will be appreciated. Thanks! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President V

Upgrade - Downgrade problems

install of MySQL 4.0.22. I would appreciate any help or pointers. I am on WindowsXP as the development machine. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax

phpMyAdmin and MySQL 4.1

using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding

Query question

#x27; When will a result be returned? When all of the statements in brackets find a result or if any of the three in brackets get's a result? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding emotionalize.conceptualize.visu

RE: LIKE question

If I search a field for 'doone' and one of the fields contains 'Lorna Doone' what is the best comparator to use as LIKE is skipping this one and I imagine '=' will do the same? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.D

RE: Cannot be null problem

When sending form data via a form I get the following SQL error ERROR:-- SQLException - Message: The url cannot be null SQLState: 08001 ErrorCode :0 What does this mean? The row url, is not set to be not null. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President

RE: Query problem

uments that match the doctype should be returned so I suppose before even bothering to check the rest of the query only those documents should be found. How do I go about ensuring that only documents that matches the doctype is returned and no other documents. Thanks for any help on this. -- K

RE: MySQL book

Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MySQL By* Paul DuBois <http://www.informit.com/safari/author_bio.asp?ISBN=0735709211> - New Riders Publishing -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President V

FULLTEXT search

When doing a MATCH() AGAINST() search. Does a result get returned only when all of the words in the AGAINST() 'tag' matches a document or if any words match. Basically is this an AND or OR type of result that is returned? Thanks! -- Kind Regards Schalk Nee