Re: From Oracle to the MySQL Database Server

__ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --

Re: Annoying article about MySql

> MySQL is very robust, VERY fast, and has a very tiny footprint compared > to other database products. Thanks! ;-) Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz &l

Re: are my queries bloated?

> Thanks very much for responding to my questions about this, Arjen. You're quite welcome. This kind of stuff (optimising) is an important subject in MySQL training courses (www.mysql.com/training/). Regards, Arjen. -- MySQL Training Worldwide, http://www.my

Re: are my queries bloated?

the way, this is the kind of cool stuff you learn as part of a MySQL training course (www.mysql.com/training/), the bit we call "Make The Dolphin Fly" ;-) Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __

Re: sort_buffer size

t_buffer as they would for record_buffer, and I know you've got notes for that one ;-) The setting shouldn't necessarily be exactly the same, but similar considerations apply. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ _

Re: optimize for SELECTs on multiple large tables

y) Adding an index shouldn't affect other apps, so that's easy. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ /

Re: optimize for SELECTs on multiple large tables

INSERTs very fast, and MySQL is very, very good at > this. The only problem is, it is slow when it comes to SELECTs on > multiple large tables, and i'm not sure how to optimize it for that.) I'm confident that the MySQL server can do it just as fast, if not faster. Regards, Arjen.

Re: Upgrade MySQL

a backup! But you can simply stop the service (no need to uninstall the service or mysql), and run the setup.exe of the new version. Then you can start the service again. It's that easy. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __

Re: Re: Problem with GROUP BY ... DESC

was just sheer luck, as it depends on the order the server reads the data rows Anyway, I've sent a note to the developers about this, including a sample reproducing it. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __

Re: MySQL access denied from localhost

u have to do FLUSH PRIVILEGES to have the server reload that info; if you use GRANT/REVOKE statements, that is not necessary. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL

Re: Gemini compile error

Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/

Re: possible to loop through increments when end reached?

se you'll need some safeguards, but that applies to the other method too. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__

Re: localhost problem

llation.html and next pages, for instructions all the way. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ /

Re: Getting Started

allation.html No sense in starting out with such an old version Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical

Re: dec is treated as a reserved word.

ed on your info I checked the script and made some changes: 2 keywords and all 15 synonyms had been missing. DEC was one of the synonyms, of course. The online manual should reflect this change soon. So, thanks for the feedback! Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/traini

Re: question!!!

Hi, - Original Message - From: "Webmaster" <[EMAIL PROTECTED]> > I have Mysql,Php and apache webserver running on Freebsd 4.3 RELEASE, I > need to connect via Web to an application done in php but that requests me > user and password. You may wish to be more specific about exactly what

Re: how to handle circular references if DB enforces ref. integrity

o update two tables at the exact > same time so that referential integrity never gets violated? You can do this by putting the two updates inside a transaction, using the InnoDB table type instead of MyISAM. No problem. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/trainin

Re: how do you find out which table fields are foreign keys?

hrough which column). I think that's good coding practice. This just keeps the situation very clear to me, while coding, without having to look up the table schema or rely on constraints. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ /

Re: pdf and html-split manuals

bsite, or use the online searchable manual (www.mysql.com/doc/). If there is a change in server behaviour since a specific version, this is also documented, so there should be no confusion. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/

Re: connection question

ove the single quotes, or change them to double quotes. PHP does not expand variables for single-quoted strings. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz &l

Re: Bug Report - SELECT Does Not Recognize Column Alias

mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com -

Re: Solution for testing PHP/MS Access on Linux

ng through a good wrapper. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_

Re: automatic index for not null unique columns?

from a client, the output uses backticks like `version` which also prevents any probs. So, sneaky though it may be, it will actually work! ;-) You said you were using 3.23.32 if you get different out there from described above, it has been fixed since. Okidoki? Regards, Arjen. -- MySQL Train

Re: OT: Securing username and password in script file

HP with MySQL" courses that are being developed. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia

Re: MySQL has transactions, foreign keys, and an option for NO DEFAULT

c/c/o/configure_options.html I do believe this option addresses the issue put forward by Frank and Shelby. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <

Re: Active maintenance of 3.23 tree

ql/alternate.html), for instance in HTMLs, or PDF format (if you want to print it for comfy reading). Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> /

Re: Licensing question

has some examples on when a commercial license is required and when it is not. You will also find contact info there, in case you have more questions. Hope this helps. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Re: Actively contributing to MySQL development

SQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ w

Re: The schedule of MySQL 4.1

when will it be released? The aim is around December/January for alpha release. See http://www.mysql.com/doc/N/u/Nutshell_Stepwise_Rollout.html Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Ar

Re: throughput

ysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --

Re: merging fields

solution. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/

Re: databases

ww.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia

Re: Multiple field separators

you don't need to specify any inclosure characterrs. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/

Re: full-text search problem

atabase for storage. RDBMS are very good at summarizing, selecting sets of data according to search parameters, etc. But you have to design your tables with this in mind, otherwise you miss out on all the benefits. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/traini

Re: Use of MySQL with large tables

select statement to create the temporary table and allow you to pick (sets of) rows at will. FYI, optimization techniques are an important part of MySQL training courses (http://www.mysql.com/training/). Regards, Arjen. -- Get Official MySQL Training Worldwide, http://www.mysql.com/training/

Re: Window-based client program for MySQL (server in Linux)

. Finally, there is MySQLfront (www.mysqlfront.de), a native Windows tool that can connect directly to MySQL (ie. no MyODBC layer required). Regards, Arjen. -- Get Official MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. A

Re: aggressive dolphin?

- Original Message - From: "Theo Richel" <[EMAIL PROTECTED]> > I am a very dedicated user of Mysql, but I am somewhat disappointed that you > chose the dolphin for your logo because of the good nature of this animal. > [...] > Unlike most animal killers, which eat their prey, dolphins see

Re: Logging connections

- Original Message - From: "Tadej Guzej" <[EMAIL PROTECTED]> > How would I log connections to MySQL server? > I need the time user connects and the time user disconnects. It's a workaround, but the general MySQL log actually has this information. Here's a sample: /usr/sbin/mysqld,