Re: INTEL vs. SPARC

is varchar-field an an integer-field was one of the major results we wanted. both field for themselfs had around 400.000 rows in the result-set. the intersection (WHERE myvarchar="mac" AND myint=1) only gives 130 to 500 rows. so we finally did something we should have done long before :

Re: INTEL vs. SPARC

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05.07.2004, at 15:51, JOUANNET, Rodolphe wrote: do you use innodb or myisam tables ? myisam tables. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (Darwin) iD8DBQFA7P39vkHn/oGTPXURAs+EAJ9dV7ZOQWolUHQcO/CF9UHTx/XhAgCffhfY 73za73KJJjTaGsz1vHxVoqg=

Re: intel vs sparc?

the intel. thanks for the hint mac -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi there, hope this haven't been discussed in that kind of detail in older topics: the facts in short: - - we have the same mysql-version (4.0.18) for an intel-machine and a sparc-machine. - - we have a table with

Re: INTEL vs. SPARC

e mysql is a 32bit-version. cu mac -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (Darwin) iD8DBQFA5bd5vkHn/oGTPXURAk+hAJ9HsMq4smLeJ5efK4/+L8wdM7BmcgCfYjMH gLOf+KCDirJtaTYnTlFpSJY= =PuhY -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: INTEL vs. SPARC

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi andrew, Are you running Linux or Solaris on these servers? sparc: solaris 9 intel: debian-linux (2.4.21-kernel) with regards klaus -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (Darwin) iD8DBQFA5acJvkHn/oGTPXURAlG4AJ9iAHBuX3n/RhCFzN9uj1ssC2VRAg

INTEL vs. SPARC

will do, but we also need sort of guidelines for future projects. thanks in advance for your suggestions. with regards mac -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (Darwin) iD8DBQFA5YJVvkHn/oGTPXURApvwAKDBBcLtRH+S1+tBLsrFNmimtSki+gCgkQA6 MEQxsqwYzRjQx+lN+epJtao= =2VNS -END PGP SIGNAT

2 datatables 1 db

Hi, Im running phpwebsite. I installed and then it crashed with dbs left untouched. I reinstalled and directed the new install to existing dbs. But a new set of data tables were created and phpwebsite now reads the new tables which are now empty. Eg, I have say mod_calendar_events which is old

Re: How do I select 'all related' in a many-to-many relation?

Harald Fuchs wrote: > That's easy: [Excellent MySQL code example snipped] Thanks, that was exactly what I was looking for. /mac - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: How do I select 'all related' in a many-to-many relation?

uot;Blue" Hmm, does this only return one row for each Manufacturer? I'll have to check it out. Well at least I know I can't use the same trick here as I did in my first query, since I don't know how many colors I could get returned. /mac -

How do I select 'all related' in a many-to-many relation?

not found any answers. The mysql website mentions UNION, but as I said I am using MySQL v3.23. Could anyone point me in the right direction? /mac -- Protect yourself from spam, use

Unable to execute mysql on OS X

Hi, MY_system:= macos 10.2 Darwin kernel version:= 6.0 Mysql server version:= 3.23.52 Mysql server is installed and work great except... I can't run the mysql executable localted in the bin directory The terminal returns me: dyld: bin/mysql Undefined symbols: bin/mysql undefined

installing on linux

) Why is this, and what do I do!? THANKS- Mac

installing on linux

) Why is this, and what do I do!? THANKS- Mac

Re: accessing

would you mind going into a little more detail...i'm near clueless about all this..thanks- mac - Original Message - From: Dominggus Andy A <[EMAIL PROTECTED]> To: 'Mac Martine' <[EMAIL PROTECTED]> Sent: Friday, January 26, 2001 12:38 AM Subject: RE: accessing

accessing

and made a php file to retrieve that datai keep gettin an error saying : MYSQl connection failed: access denied for user mailto:[EMAIL PROTECTED] (using password: no) in commmon_mail.php line 115 in my common_mail.php file i have: $dbhost="fleabags.com"; $dbname="ma

new mysql account

-installing to set up the other account, but it remembers all my old info and wont let me enter new info. mysqladmin does not open to where i can type anything this is what i want to do, right? wither way, any help would be great! i'm very new here. thanks- mac

new mysql account

-installing to set up the other account, but it remembers all my old info and wont let me enter new info. mysqladmin does not open to where i can type anything this is what i want to do, right? wither way, any help would be great! i'm very new here. thanks- mac

Re: odbc_connect();

oh, true..thanks! actually its now saying: isnt odbc_connect() a predefined function? Fatal error: Call to unsupported or undefined function odbc_connect() -hmmm... mac - Original Message - From: Thiemo Nagel <[EMAIL PROTECTED]> To: Mac Martine <[EMAIL PROTECTED]>; <[

Re: odbc_connect();

oh, true..thanks! actually its now saying: isnt odbc_connect() a predefined function? Fatal error: Call to unsupported or undefined function odbc_connect() -hmmm... mac - Original Message - From: Thiemo Nagel <[EMAIL PROTECTED]> To: Mac Martine <[EMAIL PROTECTED]>; <[

odbc_connect();

hello- I'm getting a parse error here...any ideas why? This is my first try at databases, php, mysql and odbc, so. the database is one which i made in MSaccess... thanks- if(!(odbc_db = odbc_connect($odbc_dsn, $odbc_userid, $odbc_password))) <---PARSE ERROR ON LINE ABOVE-

Re: MORE basics!!

'. Isnt that what I want to do somehow? Thanks! Mac - Original Message - From: Jacques Venter <[EMAIL PROTECTED]> To: Mac Martine <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, January 24, 2001 1:18 AM Subject: RE: basics!! > Hi Mac, > > You shou

Re: basics!!

other error.. any help? thanks- mac - Original Message - From: Jacques Venter <[EMAIL PROTECTED]> To: Mac Martine <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, January 24, 2001 12:08 AM Subject: RE: basics!! > Hi Mac, > > This is actually

basics!!

e are very basic , I know, but whomever could take the time to explain how to get this all started, I would GREATLY appreciate it!!! I have scripts waiting to be played with! Thanks so much! Mac