RE: AMD64

MySQL converts MYSQL_TYPE_LONG to float before storing http://dev.mysql.com/doc/refman/5.1/en/c-api-prepared-statement-datatypes.html you may want to consider FIXED size datatypes for that requirement e.g. unsigned long *length HTH Martin __

RE: IN vs. OR on performance

basically the same criteria as IN vs EXISTS from http://decipherinfosys.wordpress.com/2007/01/30/in-vs-exists/ select select column list from TABLE_A where col1 in (Select col2 from TABLE_B) VS Select select column list from TABLE_A where exists (select

RE: Search based where claused and stored proc

Ben- did'nt see your solution? Martin __ Disclaimer and confidentiality note This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to please inform the sender. Any unauthorised dissemination

RE: Error -1

SELECT bunch_of_columns FROM bunch_of_tables WHERE MATCH (memos.note_text) AGAINST ('frog' IN NATURAL LANGUAGE MODE); You may want to consider implementing lucene for search engine capability http://lucene.apache.org/java/docs/ ? Martin __

RE: why is this happening?

Jim can you verify the process is quiesced from MySQL (master) mysqlSHOW PROCESSLIST ? Martin __ Disclaimer and confidentiality note This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to

RE: why is this happening?

what does the master db show for processlist ? master_mysqlshow processlist ? Martin __ Disclaimer and confidentiality note This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to please

RE: vs AND

there is no character matrix supported in the SQL92 spec located at http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt also there is no Truth Table for but there IS a truth table for AND conditionals. Martin __ Disclaimer and

RE: Enumerate MySQL Servers?

will you be supporting clusters? if not you can scan for listeners on 3306 HTH Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a

RE: Left join does not work with Count() as expected

--- if.id f.cnt fm.id fm.cnt -- - -- --- 1 1NULL 0 2 22 2 Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates

RE: DB crashing while dumping

Jason- can we see the schema and a few data rows for `soapware_charts_xmldocumentitems` says something about invalid pointers? Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official

RE: How can avoid 2 selects and 2 while? SOLVED

Jose- preface the product_id column with table ID e.g. table_1.product_id table_2.product_id or use the alias assigned to tableName Saludos Cordiales desde EEUU Martin __ Disclaimer and confidentiality note Everything in this e-mail and any

RE: InnoDB: Thousands of Tables or Hundreds of Databases?

I vote for 1 table per TableType this will keep your DB schema consistent with Architecture Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is

RE: MySQL View

My current understanding of the delta between Views and Temporary Tables Views are read only results from 1 or more tables ..in Oracle they are stored in TEMP tablespace http://www.psoug.org/reference/views.html Temporary Tables are tables which are created/updated/inserted and exist only for

RE: WHERE vs. ON

ON condition uses the same columnname from both source and target tables whereas any column expressions can go in the WHERE clause... Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the

RE: grabbing even addresses?

Jason try select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_ NUMBER(SUBSTR(ADDRESS,1,instr(ADDRESS,' ',1))),2) =0; SUBSTR(ADDRESS,1,INSTR(ADDRESS,'',1)) 1232 Main 1234 Main HTH Martin

RE: Certification Feedback?

Dan- I would concentrate on SQL certification first To know package foo does bar method for MySQL is a good extra tool to have in your toolbelt but more important for the bigger companies to be able to use your skillset for MySQL AND DB2 AND Oracle Martin

RE: Trying to work out why a join query is so slow

UNION all does a cartesian join ..maxiumum number of results will be delivered SELECT * FROM sites INNER JOIN sites.userid = users.ID; -- INNER JOIN users ON sites.userid = users.ID --ALSO put (hopefully UNIQUE indexes) on sites.userid and users.id Martin

RE: how can trace stored procedure usage?

Jim- you can try to port Oracles utldtree.sql Caveat Emptor: Hasnt been worked on since 92 and is VERY buggy! Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business

RE: timeout

from a purely network point of view PING works if ICMP traffic is allowed do a tracert and find out which intervening node is rerouting the traffic you might have something funky on the routing tables Martin __ Disclaimer and confidentiality note

RE: VC++ 2008 / MySQL debug / Unhandled exception

if Memory serves the LIBCMTD.lib library that you're excluding IS the MultiThreaded Library? Generally if you can run it thru debug you can get the CodeStack and InstructionPointer which will at least point to the exact location where it abended Saludos Cordiales desde EEUU!Martin

RE: How to Use Cascade Delete Properly

If you're not going to Cascade Delete you'll need to change ON DELETE CASCADE clause to ON DELETE SET NULL e.g. change FOREIGN KEY(id_b) REFERENCES b(id) ON DELETE CASCADE TO FOREIGN KEY(id_b) REFERENCES b(id) ON DELETE SET NULLhttp://dev.mysql.com/doc/refman/5.0/en/delete.html Martin

RE: Can a JOIN statement do this?

Happy New Year Mike- JOIN USING(colId) and or JOIN ON(table1.colId=table2.colIdentifier) will preserve the use of Indexes which is faster LIKE casts off Indexes and does a FTS HTH Martin Any recommendations on non-PHP Forum Software for Apache? __

RE: What files to install for Windows

Jerry is correct you are better off using the pre-packaged installer from the MySQL distro for the most part you are downloading (binaries) from some site creating a MYSQL_HOME environment variable to point to home folder for MySQL unzipping/uncompressing the distro to the MYSQL_HOME folder make

RE: Vexing permissions issue with partitioned CREATE TABLE

: Thanks, Martin, but that's not it. As I mentioned in my email, I'm running as MySQL root user with all priv bits set. I tried your suggestion anyway, but no change. Cheers, - Brad On Fri, Dec 5, 2008 at 4:34 PM, Martin Gainty [EMAIL PROTECTED] wrote: Brad- log

RE: Result ordering

instead of SELECT name, (CASE WHEN bar = 34 THEN 0 ELSE 1 END) AS rank FROM foo WHERE bar = 34 OR baz 100 ORDER BY rank ASC, baz DESC LIMIT 5; you can use order the query evaluation to perform inner subquery first select distinct foo.name,foo.bar,baz.bar from foo where exists (select *

RE: SELECT through many databases

as UNIONS may cause FTS you might want to look at using JOIN USING(ColumnWhichIsCommonForEveryTable) (then place unique Indexes on each of the Columns for all Tables) Martin __ Disclaimer and confidentiality note Everything in this e-mail and any

RE: is INSERT into VIEW supported

generally no as join conditions do not guarantee 1)the column to be inserted is unique 2)the column is updatable //Create a View based on 2 tables joined on location+id CREATE VIEW locations_view AS SELECT d.department_id, d.department_name, l.location_id, l.city FROM departments d,

RE: Tuning a MySQL desktop database

Quiesce ALL slaves if you have master/slave DB's Once you've implemented explain plans..check any SQL statements which produce Full Table Scans If so You'll want to implement Indexes on compsite columns for those join conditions to implement a Unique Constraint you will need to extract out the

RE: How to start mysqld server, What is the difference between a server and a server?

service usually indicates a background service such as Windows Service MySQL implements Windows Service Functionality thru mysqld-nt binary documentation is available at http://dev.mysql.com/doc/refman/5.0/en/multiple-windows-services.html a server is a standalone binary or even possibly a

RE: simple design choice

I would say providing a table to retain the users relevant details especially after marking as deleted would be a logical choice Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates

RE: Speed up slow SQL statement.

Hi Eric- the immediate challenge is to fic the join statement so make sure products.id is indexed make sure browse_nodes_to_products.product_id is indexed make sure browse_nodes_to_products.browse_node_id is indexed make sure browse_nodes.amazon_id is indexed there seems to be

RE: Odd crash with MySQL Embedded 5.1.28

2 items- check that the my.cnf file cannot be found on your path or your server groups are (usually just server, client) are incorrect Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the

RE: nagios server blocked

Agador- Thats LOT of errors I would recommend using the error log to determine whats causing these errors (and then fix) HTH Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official

RE: Help!

2 items I would increase bump key_buffer_size as suggested here http://dev.mysql.com/doc/refman/5.1/en/delete-speed.html also TRUNCATE instead of DELETE where TRANSACTION is not active Martin __ Disclaimer and confidentiality note Everything in

RE: Ancient, unsolved high-CPU problem -- vmstat, top and ps

. As for cron jobs, I have a number of command-line PHP scripts that perform regular queries. They've been running for about 10 days now. The current high CPU state started a couple days ago. On 22-Sep-08, at 8:30 PM, Martin Gainty wrote: curious if you have any cron jobs

RE: too many connections

in my.cnf configuration file try upping the number of connections max_connections=3072 to max_connections=6144 Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender.

RE: Show Master Status

Dave- we havent had a hurricane since up here since 1938..if you want to relocate your servers just give a holler and i'll lend you mine! Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the

RE: Show Master Status

to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Wed, 17 Sep 2008 13:14:36 -0500 From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: Show Master Status On Wed, Sep 17, 2008 at 12:54 PM, Martin Gainty

RE: Finding gaps

unless you cant spare a few milliseconds off of each insert.. i strongly suggest to use autoincrement http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html Martin __ Disclaimer and confidentiality note Everything in this e-mail and any

RE: sync

can you provide a testcase would justify 2 different DB schemas?If you're willing to stay with identical configurations take a look at http://dev.mysql.com/doc/refman/5.0/en/replication.htmlHTHMartin __ Disclaimer and confidentiality note Everything

RE: Impossible WHERE in explain

The key_len column indicates the length of the key that MySQL decided to use. The length is NULL if the key column says NULL. Note that the value of key_len allows you to determine how many parts of a multiple-part key MySQL will actually use. i do not know the definition of parameter

RE: mysql user and authentication ???

you can use GRANT statement to create and grant privs for a mysql db so users can access specific host DB servers @'server.domain' specific DB on specific Db Servers 'custom'@'server.domain'specific tables on specific DB customer.* specific privs

RE: starting mysqld on Linux fedora

also set the location of the binary$MYSQL = '/usr/local/bin/mysql';# path to mysql executablehttp://dev.mysql.com/doc/refman/6.0/en/installing-binary.htmlbefore invoking the binarybin/mysqld_safe --user=mysql (good call madan)Martin-__ Disclaimer

RE: performance key-value - int vs ascii ?

addresses the case for using ENUM over VARCHAR for low cardinality columns For performance issues on which sort algorithm does a join select is addressed at http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html ? Martin __ Disclaimer

RE: MyQuery 2.0

could'nt get database listings to display..all other commands and requests seem to work fine Tack! Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This

RE: recommended high availability setups

agador- did you look at replication implementations using master/slave configuration? http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-diffengines.html HTH/ Martin __ Disclaimer and confidentiality note Everything in this e-mail and any

RE: Time Zone Support

you'll need to set the datetime function before presenting date/time to the user http://www.w3schools.com/php/func_date_default_timezone_set.asp Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to

RE: another INNODB vs MYISAM question

Good Morning Mike and Brent Ive been following and implementing MYSQL tuning suggestions at http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html I did'nt see any suggestions on converting the entire DB to INNODB or converting the individual tables to INNODB Suggestions? Martin

RE: Multiple Query/Insert help

the only possible suggestion i have would be to disambiguate the selected columns with 'as' insert into games2 (sea_id,date,time,loc_id,hteam,vteam,div_id) ( select '36' as sea_id, game_date as date, begin_time as time, loc_id as loc_id, home_team_id as hteam, away_team_id as vteam,

RE: Multiple Query/Insert help

: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Saturday, August 16, 2008 9:50 AM To: Andy Shellam; Steven Buehler Cc: mysql@lists.mysql.com Subject: RE: Multiple Query/Insert help the only possible suggestion i have would be to disambiguate the selected columns with 'as' insert

RE: DROP TABLE IF EXISTS - doesnt??

I am certain the SQLBrowser program authors want to hear about this error It may be due to the fact that MYSQL procedures need to have a different delimiter (//) instead of ; e.g. use DBNAME; DROP PROCEDURE IF EXISTS TABLE_NAME; delimiter //; Anyone? Martin

RE: SELECT in NULL state for a long time

If you want MYSQL to process the SELECT, including information about how tables are joined and in which order usehttp://dev.mysql.com/doc/refman/5.0/en/using-explain.htmle.g. EXPLAIN [EXTENDED] SELECT select_optionsIf you want MySQL uses the stored key distribution to decide the order in

RE: Blocking HTML code in inserts?

I'm seeing this more and more I'm hearing the justification that its easier to put an pre-formatted anchor tag or href but you're right if html is stored in the DB then javascript can easily follow of course the overseas contractors sticking in href to their own sites sure does'nt help Glad to

RE: mysqldump

John and Dan- would have to see your constraint statement preferably the CREATE TABLE statement to make any kind of intelligent assessment here.. Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments

Mysqldump turn off quotes

How do I get mysqldump to turn off quotes e.g from INSERT INTO table to INSERT INTO table Thanks Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender

RE: revoke all on *.* ??

Pawel- the syntax is GRANT USAGE ON DB.* to '[EMAIL PROTECTED]' IDENTIFIED BY PASSWORD 'NeverShowYourPasswordInEmail' http://dev.mysql.com/doc/refman/5.0/en/grant.html HTH Martin Gainty __ Disclaimer and confidentiality note Everything in this e

RE: Spatial operators - DISTANCE

I would start by understanding MySQL spatial located at http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html FWIWMartin__Disclaimer and confidentiality noteEverything in this e-mail and any attachments relates to the official business of

Re: Comma's in data?

Good Morning Steve The insertion of comma in your Data works if your columns are VARCHAR and you have place Data Value in 'tick marks' e.g. mysql alter table test CHANGE test test VARCHAR(100); Query OK, 1 row affected (0.03 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql commit; Query OK, 0

Re: Can't drop database that shows up in show databases

Waynn- does the OS user you use to execute mysql have create/write/read/execute rights to the ./test folder? Martin- - Original Message - From: Waynn Lue [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, March 08, 2008 6:58 AM Subject: Can't drop database that shows up in show

Re: what is a schema? what is a database?

my understanding is that Namespace is a defined grouping of classes http://m5.eecs.umich.edu/docs/namespaceMySQL.html where MySQL triggers a namespace must be unique within the schema (database). http://markmail.org/message/m5icpi2luv6baijt?q=Joerg+Bruehe+AND+namespace

Re: grant user

You're always safe using your own localhost (127.0.0.1) but You probably want to re-think using a dynamically assigned address such as 192.168.xxx.xxx which can change anytime FWIW Martin- - Original Message - From: Hiep Nguyen [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday,

Re: what is a schema? what is a database?

http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html According to MYSQL doc: A schema is a database Wikopedia says a Schema is defined as: Pronounced as skee-ma, the structure of a database system, described in a formal language supported by the database management system (DBMS). In a

Re: table lock

Good Morning Eli I would consider implementation of mpm_common more specifically enabling inter process communication with mutex's such as what you see at http://httpd.apache.org/docs/2.0/mod/mpm_common.html#acceptmutex and then utilising the flock directive to either lock/unlock a file such

Re: [EMAIL PROTECTED] locations

Did you get a chance to look at mysqlhotcopy? http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html ? M- - Original Message - From: P. Evans [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, February 15, 2008 11:50 AM Subject: [EMAIL PROTECTED] locations Greetings, I've

Re: Decimal - Maximum is 30

Michael- I can certainly understand the upgrade based on the performance advantages of MySQL What would NASA use for its mapping GIS/Mapping software? Postgres has PostGIS Oracle has OracleSpatial MySQL has ? Many Thanks for the link Martin-- - Original Message - From: Michael Cole

Re: mysql to mysql conversion tool

http://drupal.org/project/convert2drupal NB: no pending tasks AND no developers working on any part of the project the author claims a release in january (but has'nt published anything yet..) Looks like you there is some work ahead of you.. Oi Vay! - Original Message - From: Sharique

Re: creating temp file, modifying data and putting into other table

the default DB is mysql to verify execute mysql client and then show the databases mysql show databases; ++ | Database | ++ | information_schema | | catalog| | mysql | | petclinic | | test |

RE: automation question

3 ideas come to mind- cron and or cruisecontrol for off-hours scriptingant for handling cross-platform scriptingmaven for implementing dependency checking as well as the ability to pull from online repositories Youtube.comI worked with a company last summer that implemented identical

RE: Help with query, (question simplified as last mail was very complicated to understand :))

the simple answer is and b.name='name3' ?Bon ChanceMartin__Disclaimer and confidentiality noteEverything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not

Re: Odd item in MySql error log

Good Morning Ben this is an acknowledged bug http://bugs.mysql.com/bug.php?id=20090 which was fixed in 5.1.22-beta + can you upgrade? Martin-- - Original Message - From: Ben Clewett [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 21, 2007 4:52 AM Subject: Odd item in

Re: Problem with a Procedure

: Tomas Hylander [EMAIL PROTECTED] To: Martin Gainty [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, November 26, 2007 1:38 AM Subject: Re: Problem with a Procedure Hi! I must say I cant see how this would help me. I know the tabels isnt empty since when running in query browsern I get

Re: How to auto repair db on hosting with quota

Artem set my.cnf in unix my.ini in windows set max_connections max_connections=100 M-- - Original Message - From: Steven Buehler [EMAIL PROTECTED] To: 'Artem Kuchin' [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, December 07, 2007 8:11 AM Subject: RE: How to auto repair db on

Re: help with select

mysql select idea.iid, concat(employee.first, ,employee.last),(SELECT concat( employee.first, ,employee.last) FROM EMPLOYEE where employee.eid=idea.submitted_by) from ide a,employee where idea.iid=1 and idea.completed_by=employee.eid; M-- - Original Message - From: Hiep Nguyen [EMAIL

Re: Spfile in Mysql......

persisting session-specific configuration items to system wide data stores does appear to be problematic.. perhaps sujatha could explain the reasoning behind this shift? M- - Original Message - From: B. Keith Murphy [EMAIL PROTECTED] To: 'mysql list' mysql@lists.mysql.com Sent: Tuesday,

Re: SELECT Speed

You seem to have an over-reliance on BTREE Indexes over BITMAPPED Indexes or HASH Indexes There are specific rules governing implementation of BTREE Index http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.h tm#sthref893 As well as specific rules governing use of HASH

RE: Incrementing a Private Integer Space

Dave is trying to establish an algorithm which would fit your requirement I can see column q is auto-increment which makes sense as you retain the capability to generate a unique row but jumping into the middle of a conversation without knowing the prior discussionWhat is/was/will be the

RE: Unusual sort

Hi Jim it seems that you cannot create an index with a function soyou will need to establish a separate 12 character column which has all of the URL entries insertedalphabetically in ascending order (fully padded with www. prefix)backup your DBALTER TABLE table ADD TwelveCharacterURL

RE: Problem with a Procedure

Tomas-I would effect a quick iterative check on the table(s) to see if they are empty e.g. SELECT count(trans2.nettovikt) from trans2; (If recordcount0) then SELECT SUM(trans2.nettovikt) FROM trans2 INNER JOIN artikel on trans2.artikel=artikel.artikel (If recordcount0) then SELECT

trouble selecting DB

Morning All- I connect to Mysql 4.0.13 using mysql_connect AND returned handle is not false then I call access to mysql_select_db which always returns NULL and causes Exception I also tried mysql_connect with supplied 4th param as DB with no joy The DB name is uppercase..does this matter?

Re: Images

Hodren How are you storing the image in MySQL..I assume longblob? What format will you use to display the image {jpg|gif|png}? Here is a script which will load the images to your AS movie http://www.actionscript.org/forums/showthread.php3?t=76421 HTH/ Martin This email message and any files

Re: MySQL database synchronizing from 2 locations

Richard- If you have 2 or more servers which you want to dedicate to MySQL you may want to look into MySQL Clustering To focus on sync'ing I would read about the the 'syncronisation replication' vs 'asynchronous replication' that the Participating Nodes employ

Re: MySQL and 'ODBC'@'localhost' error

You are attempting to login as ODBC If your scripts are using ODBC as the USER you will need to CREATE USER ODBC and GRANT necessary privs doc available at http://dev.mysql.com/doc/refman/5.0/en/adding-users.html M-- This email message and any files transmitted with it contain confidential

Re: Full Text Search, Storage Engines

Good Evening David- Have you considered using Lucene ? http://lucene.apache.org/java/docs/ M-- This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom this email message is addressed. If you have received this email message

Re: optimization help

Good Afternoon David sounds as if you have a number of non-unique indices (even possibly FTS!) slowing down queries..this should help you concentrate on the slower indices mysql select TABLE_NAME,COLUMN_NAME,INDEX_NAME from INFORMATION_SCHEMA.STATISTICS where NON_UNIQUE=1; Anyone else?

Re: greek collation sorting

I would wait until your DB is offline (such as on a weekend) Once you find the Character Set you want e.g. greek_general_ci http://dev.mysql.com/doc/refman/5.0/en/charset-se-me-sets.html then alter your DB to use that character set http://dev.mysql.com/doc/refman/5.0/en/charset-database.html

Re: ODBC Drivers 3 and 5

Good Morning Lucas From what i've been able to gather Type 3 is a bridging technology which accomplishes the ODBC-JDBC communication objective but is slower than native Type 4 thin client driver counterpart as there are a min of 3+ components which are used ODBC Bridge JDBC Best doc I've

Re: used command isn not allowed

needs an indication on where to find the file (local or otherwise) http://dev.mysql.com/doc/refman/5.1/en/load-data.html For security reasons, when reading text files located on the server, the files must either reside in the database directory or be readable by all. Also, to use LOAD DATA

Re: Q: outer join w/restriction

14, 2004 8:41 AM Subject: Re: Q: outer join w/restriction In article [EMAIL PROTECTED], Martin Gainty [EMAIL PROTECTED] writes: You should generally not have any conditions in the ON part that are used to restrict which rows you want in the result set, but rather specify these conditions

Re: Q: outer join w/restriction

A SQL AND is a restrictive filter In other words Your resultset will yield results based on how you structure your query If you structure your resultset which includes only applicants who have been seen by Reviewer2 then state SELECT ... FROM WHERE (CONDITION1 AND Applicant.Reviewer = 'Reviewer2')

Re: Q: outer join w/restriction

] To: Martin Gainty Cc: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 10:33 AM Subject: Re: Q: outer join w/restriction Martin, you are correct in how you determine when to use AND and when to use OR, but that's not what the original query was trying to find

Re: help with table structure

Also International Numbers Have you seen any address books accomodating 3 digit Country Code?? Martin- - Original Message - From: [EMAIL PROTECTED] To: Chris W. Parker [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 12, 2004 1:20 PM Subject: RE: help with table structure

Re: Enforce value on select

John You will have to soemthing similar to Oracle Decode Martin- - Original Message - From: John Mistler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 10, 2004 9:23 PM Subject: Enforce value on select Is there a way to force SOME value to be returned from a SELECT query

Re: 2003 server problem

Dominic Take a look at the steps necessary to connect to MySQL 1)Server running 2)Setting up GRANTS 3)Setup users and access permissions http://dev.mysql.com/doc/mysql/en/Access_denied.html HTH, Martin- - Original Message - From: Dominic James [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: Error message on windows xp install

Also keep in mind that if you have XP SP2 installed all of your ports are blocked (except Port 80 of course) You will need to reconfig the Firewall available in Control Panel specifically TCP 3306 4759 BTW: It would be helpful to place Port Assignment information in System Requirements I found it

Re: Understanding Joins : Baffled

David- Think of A join consists of one circle of records per table An INNER JOIN only gets the results that are in common between 2 tables or all the rows (where the circles intersect) i.e. In an Inner Join both columns of Both Tables MUST have Non Null identical values and Must be = An OUTER JOIN

contains?

is there way to interrogate what is inside a column specifically a special character? thanks, Martin Gainty _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go

RE: T-SQL SUM() Overflow?

David- try redeclaring your INTEGER columns as BIGINT instead of INTEGER http://dev.mysql.com/doc/mysql/en/Numeric_types.html HTH, Martin Gainty From: David Mohorn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: T-SQL SUM() Overflow? Date: Mon, 16 Aug 2004 11:37:12 -0500 MIME-Version: 1.0

GROUP BY

My original concept to use group by was GROUP BY(MajorColumnGroupIng...MinorColumnGrouping) I am trying to be convinced that GROUP BY(Minor..Major) will work just as well Is there a difference??? thanks, Martin Gainty From: Joe Kislo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Mysql 4.0.20

RE: In Statement Help

://archives.postgresql.org/pgsql-performance/2002-12/msg00185.php HTH, Martin Gainty From: Andrew Dixon [EMAIL PROTECTED] To: 'Stephen E. Bacher' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: In Statement Help Date: Tue, 3 Aug 2004 12:27:25 +0100 MIME-Version: 1.0 Received: from lists.mysql.com

Re: In Statement Help

is Indexed- Martin Gainty From: Michael Stassen [EMAIL PROTECTED] To: Martin Gainty [EMAIL PROTECTED] CC: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: In Statement Help Date: Tue, 03 Aug 2004 10:26:29 -0400 MIME-Version: 1.0 Received: from out011.verizon.net

<    1   2   3   >