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

Re: Granting users localhost access

rName'; FLUSH PRIVILEGES; Regards, Schalk Sebastian Mendel wrote: Pam Astor schrieb: OK I tried running:> > > > update mysql.user set host = 'locahost' where user = 'AUserName';> > Substituting AUserName for a real username,> > > > got the retu

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 pa

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

Re: Query returns to many results

after having already called for all ablb column values with ablb.* ? PB - Schalk wrote: Greetings All, Please have a look at the following query: SELECT abm.mem_number, abm.first_name, abm.last_name, abm.area_represented, abm.age, abm.sex, abm.cup, ablb.*, ablb.jp + ablb.rc + ablb.fs

Re: Query returns to many results

George Law wrote: Schalk , You need to specify the unifying column between your ablb and abm tables. ie - in your where, "and ablb.id=abm.id" Once you get this so it returns expected results, you can run the query, prefaced with "explain" and it will give you an idea

Query returns to many results

kids. However, when this query is run it returns 20,700 results :0 Any idea why this is? Also, any help or pointers as to how I can optimize this query will be much appreciated. Thank you! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.De

Re: 1064 error

Thanks Roger, I wondered whether it was the spaces that caused the problem. Roger Baklund wrote: Schalk Neethling wrote: Greetings What might be causing the 1064 error in the following query? SELECT mem_number, first_name, last_name, area_represented, joining_points + E-Model Challenge

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

Last Update

Greetings Is there a way to get the last update date for an entire table not just a single row? More specifically, is there a way to do this with Java? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers -- MySQL General Mailing

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

RE: MySQL and Point of Sale

Hey there! Does anyone know where I can find information regarding connecting MySQL and a Point of Sale device? Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel

FULLTEXT

I am using the following command on MySQL 4.0.18 ALTER TABLE tablename MODIFY columnname FULLTEXT; I keep getting an error regarding FULLTEXT. Where am I going wrong? Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding

RE: No suitable driver

Try changing driver to Driver Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This

RE: Query on large text field

article's content? Any pointers and suggestions will be welcomed. Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED]

RE: Query problem

ifornia: State Court. Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za   This message contains informatio

RE: Question

Why is the following query retuning doctype's different to what is asked for? SELECT * FROM documents WHERE jstate = 'California: State Court' AND doctype = 'Verdict' Any ideas? Kind Regards Schalk Neethling Web Developer.Designer.Prog

RE: MySQL statements

Hi there Can someone tell me what process MySQL follows to process SQL statements/queries? Is it top down or bottom up? Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel