RE: SELECT single row from 2 tables with WHERE clause

Many thanks Peter. That's the definition I was after. Kerry -Original Message- From: Peter K AGANYO [mailto:[EMAIL PROTECTED] Behalf Of Peter K AGANYO Sent: 19 February 2007 00:35 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: SELECT single row from 2 tables with

Re: using contraints on Mysql

In the last episode (Feb 25), Raúl Andrés Duque Murillo said: > I'm looking for using FIELD CONSTRAINTS on Mysql but I can't find > it ... Doesn't Mysql implement it?? > > For example: > age int > 0 You can do those checks with triggers: http://dev.mysql.com/doc/refman/5.0/en/triggers

using contraints on Mysql

Hi. I'm looking for using FIELD CONSTRAINTS on Mysql but I can´t find it ... Doesn´t Mysql implement it?? For example: age int > 0 Thanks, RAUL DUQUE Bogotá, Colombia - Do You Yahoo!? La mejor conexión a Internet y 2GB

Re: Really worried about DELETE statement

At 06:13 PM 2/25/2007, Miles Thompson wrote: Would someone please check this delete query? This should delete all rows from the geodesic_user_data that have no match in the subscriber table, but another set of eyes would be appreciated. DELETE geodesic_user_data FROM geodesic_user_data LEFT

Really worried about DELETE statement

Would someone please check this delete query? This should delete all rows from the geodesic_user_data that have no match in the subscriber table, but another set of eyes would be appreciated. DELETE geodesic_user_data FROM geodesic_user_data LEFT JOIN subscriber ON geodesic_classifieds_userda

Re: Mysql on linux - choosing the right filesystem

On 2/24/07, Jean-Sebastien Pilon <[EMAIL PROTECTED]> wrote: Hello, I would like to get some of your input on file systems to use with mysql. Should I use a journaling filesystem ? Should I choose a different one based on what I store (log files, myisam dbs, innodb datafiles, etc ) ? Is there an

Re: SQL and PHP: Incorrect errorcode

Joern, is the client version of mysql in PHP the same as your client libs on the server (where you run perror)? PHP is often times compiled with its own mysql libs and you have to specifically tell PHP to build with the system mysql libs if you want to. Just a thought. Atle On Sun, 25 Feb 2007,

Re: Qustion

Peter Brawley a écrit : S/he is asking how to transcend a 2G table size limit. Nessah, file size limits are usually due to the operating system. I think Windows FAT32 systems impose a 2G limit. PB - Juan Eduardo Moreno wrote: What a fu...? On 2/24/07, nessah arezki <[EMAIL PROTECTED]>

Re: Qustion (translated)

Juan Eduardo Moreno a écrit : What a fu...? On 2/24/07, nessah arezki <[EMAIL PROTECTED]> wrote: Bonjour ; Je suis un étudiant en fin de cycle. Dans le cadre de mon projet de fin d'étude, je devais transférer une base de données sous Access à MySQL. J'ai effectué le

Re: Qustion

S/he is asking how to transcend a 2G table size limit. Nessah, file size limits are usually due to the operating system. I think Windows FAT32 systems impose a 2G limit. PB - Juan Eduardo Moreno wrote: What a fu...? On 2/24/07, nessah arezki <[EMAIL PROTECTED]> wrote: Bonjour ;

Re: Qustion

What a fu...? On 2/24/07, nessah arezki <[EMAIL PROTECTED]> wrote: Bonjour ; Je suis un étudiant en fin de cycle. Dans le cadre de mon projet de fin d'étude, je devais transférer une base de données sous Access à MySQL. J'ai effectué le transfère par Excel Mais j'ai t

How to compile mysql with ut8?

Hello everyone, I'm new to this list, so I hope that this is the right one for this question. My system runs on Debian sarge with Apache2 and mysql-server-5.0 installed with apt-get, the mysql package comming from the dotdeb backdoor. My server is going to host a forum that is actually on a

Qustion

Bonjour ; Je suis un étudiant en fin de cycle. Dans le cadre de mon projet de fin d’étude, je devais transférer une base de données sous Access à MySQL. J’ai effectué le transfère par Excel Mais j’ai trouvé un problème ; les tables de MySQL ont une taille Limitée à

Re: MySQL Daylight Savings Time Patch - easy check

- Original Message - > *From:* Ryan Stille <[EMAIL PROTECTED]> > *To:* mysql@lists.mysql.com > *Date:* Sat, 24 Feb 2007 15:28:25 -0600 > > Ryan Stille wrote: > > Paul DuBois wrote: > >> At 4:40 PM -0600 2/20/07, Ryan Stille wrote: > >>> Is there an easy way to test to see if MySQL already

SQL and PHP: Incorrect errorcode

Hello folks, I was playing around with my PHP code that shall report any SQL error. To test this code I made an error in a SQL query by changing the table name in the field list to a table that did not exist. This triggered the following error: Error message: 'Unknown table 'q' in fiel