Re: Finding gaps

if the system is completely manual. That's just the way the universe is made. And yes, if you re-number, you introduce the possibility of duplicates. -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape, there's hope. Cross Time Cafe Perl is the duct tape

Re: Finding gaps

if you re-number everything. They have a choice: uniqueness and gaps, or no gaps and non-uniqueness. -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape, there's hope. Cross Time Cafe Perl is the duct tape of the Internet. Hassan Schroeder, Sun's first

Re: valid chars mysql db username

0.0002 million dollars worth, Shawn Where there's duct tape, there's hope. Cross Time Cafe Perl is the duct tape of the Internet. Hassan Schroeder, Sun's first webmaster There is more than one way to do things. A Perl axiom -- MySQL General Mailing List For list archives

Re: Blocking HTML code in inserts?

to filter basically any HTML tags at all. Thanks, Skip You have to pre-process your data to remove them. -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape, there's hope. Perl is the duct tape of the Internet. Hassan Schroeder, Sun's first webmaster

RE: Re-arranging fields

breach. Users should only have access thru pre-defined SQL statements. -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape, there's hope. Perl is the duct tape of the Internet. Hassan Schroeder, Sun's first webmaster -- MySQL General Mailing List For list

RE: Re-arranging fields

or malicious intent. -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape, there's hope. Perl is the duct tape of the Internet. Hassan Schroeder, Sun's first webmaster -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: SET vs. ENUM

be; with ENUM the DB has to set aside enough bytes for the longest identifier. The only advantage of ENUM is that the data is in the same table; you don't have to do an extra join. It can save you some processing time. -- Just my 0.0002 million dollars worth, Shawn Where there's duct

Re: SET vs. ENUM

they're doing. They're the ones who would know how to sabotage it. Access should only be granted to those who need it to do their jobs. Everyone else should be restricted to using a user interface with predefined pathways. -- Just my 0.0002 million dollars worth, Shawn Where there's

Re: Re-arranging fields

. According to RDB theory, the order of the columns is immaterially, just as is the order of the rows. You should always explicitly name the columns in the order you want. Relying on their default order can lead to problems down the road. -- Just my 0.0002 million dollars worth, Shawn

Re: order of items in a WHERE...IN clause

see the optimizer treating these any differently. Thanks, Gary M. Josack Any difference will come up in an EXPLAIN. To run one, put the word EXPLAIN in front of the SQL statement: EXPLAIN sql_statement; -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape

Re: FW: How do I (can I) use aggregate functions inside a select

| *** | +---+--+---+---+---++ 14 rows in set, 2 warnings (0.01 sec) mysql -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape, there's hope. Perl is the duct tape of the Internet. Hassan Schroeder

Re: WHERE .... IN

dollars worth, Shawn Where there's duct tape, there's hope. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do I get the file names from a certain directory in SQL?

a good interface to SQL. -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape, there's hope. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to optimize: max(timetstamp) where a.foo=b.foo ?

and examine the results. -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape, there's hope. Perl is the duct tape of the Internet. Hassan Schroeder, Sun's first webmaster -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: WHERE .... IN

: WHERE ( field1 LIKE '123,%' OR field1 LIKE '*,123,%' OR field1 LIKE '%,123' OR field1 = '123' ) Note that this could that a long time on large tables. You'd be better off to normalize your tables ;) -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape, there's hope

Re: a question...

'83.117.196.206' with the column name. -- Just my 0.0002 million dollars worth, Shawn Where there's duct tape, there's hope. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Best Way?

If I have (2) tables. Like GROUP , CODE GRP1, AA GRP1, AB GRP1, AC GRP2, BA GRP2, BB GRP2, BC And; USER , UCODE ME, AA ME, AC YOU, AA What's the best way to query to find out if ME has all codes in either of the groups? In other words, I want to know if I have all

Re: view irregularities

clause will evaluate as FALSE and those rows will not be returned. By putting both terms into the ON clause of your LEFT JOIN, you make it possible to have non-matched rows in your final result. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: If I downgrade MySQL from ver-5 to ver-4.

or handle properly. For the most recent changes to the Community server, please read: http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0-51a.html -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: MySql at 100% CPU

. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN __ ___ ___ __ / |/ /_ __/ __/ __ \/ / / /|_/ / // /\ \/ /_/ / /__ /_/ /_/\_, /___/\___\_\___/ ___/ Join the Quality Contribution Program Today! http://dev.mysql.com

Re: table join trouble

there were a few additional elements to this query you also left out. Please let me know if this streamlined format improves your query speed and result quality. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: Embedding MySQL

://www.mysql.com/oem/licensing.html and http://www.mysql.com/company/legal/licensing/ . If you have any additional questions, you may contact MySQL directly for additional information. Please see the contact links on those pages for various options. -- Shawn Green, Support Engineer MySQL Inc., USA

Re: Inter-version client/server compatibility

client-server protocol has not changed much, if at all, in a long while. You should be quite safe using a 5.x-based client library to talk to a 4.1 and even a 3.x server. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: Using DROP USER in a stored procedure

the daemon or issue a FLUSH PRIVILEGES command. http://dev.mysql.com/doc/refman/5.0/en/flush.html Does this give you enough information for you to automate your table maintenance? -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: Fast relevance sorting of full text search results

want to use the temporary table method to somehow weight (sum or average comes to mind) the match values across all responses before returning the results. I hope these ideas help your performance and search accuracy. Best wishes, -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com

Re: help on creating missing ids

'), (1,'name2'), (2,'name1'), (1,'name1'); I repeated a 'name1' value for company 1 so that you can see how both INSERT IGNORE works and the sub-assignment for the auto_increment value. Best wishes, -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: query kills mysqld

* location1 This way you won't need to do any dependent subqueries for your final answer. Yes, they are a powerful tool but your original query is an example of how that they can be used in ways that make them less than effective. Please let me know if you need additional guidance. -- Shawn Green

Re: help on creating missing ids

Dimitar Vasilev wrote: Hi Shawn, Thanks for your response. I'm trying to assign uniquely a user id per share holder within the whole list, not within each company. Suppose we have a person John Smith that holds shares both in MonkeyBusiness and NoSuchThing. I'd like to give him an id

Re: Conflicting server IDs on slaves

/releasenotes-cs-5-0.html For a list of all other bugs (active and inactive) you are invited to research the bugs database (it is a public forum) at: http://bugs.mysql.com -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: Use of slave server for read only queries

way is to use the --read-only startup parameter on the slave. The only updates it will allow must come through replication or from a SUPER user. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_read_only -- Shawn Green, Support Engineer MySQL Inc., USA

Re: excessive time spent in statistics status

be a major difference in how you currently use your data and I would not suggest this for a near-term solution. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: excessive time spent in statistics status

for completeness. Please try out SELECT STRAIGHT_JOIN and let me know if your situation improves. BTW - we encourage everyone to reply to the full list on all responses (unless they are confidential) so that all members can gain from the knowledge transfer. -- Shawn Green, Support Engineer MySQL

Re: excessive time spent in statistics status

to solve in some more detail as I may be able to help you to design a less cumbersome method of achieving the same goals. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: JOIN migration from Oracle to MySQL

you are trying to write, we could try to help you to rewrite it in a way that will perform much better than the translation you just attempted. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: Reset a auto increment field?

the auto_increment= option to an ALTER TABLE statement like this ALTER TABLE mydata AUTO_INCREMENT=936; (alter table) http://dev.mysql.com/doc/refman/5.0/en/alter-table.html (for the definition of table option) http://dev.mysql.com/doc/refman/5.0/en/create-table.html -- Shawn Green, Support Engineer

Re: Reset a auto increment field?

then number them as you output them with your client application. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN __ ___ ___ __ / |/ /_ __/ __/ __ \/ / / /|_/ / // /\ \/ /_/ / /__ /_/ /_/\_, /___/\___\_\___/ ___/ Join

Re: where column

an actual equation to provide the true or false condition SELECT... FROM ... WHERE 0 will always return no data as the WHERE condition will never be true. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: date query

tmp_source, tmp_datepairs; If you have any questions about the logic, please feel free to ask. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN

Re: Functions and NULL with standard install

Try it as he wrote it just without the pipes (|): SELECT RPAD(IFNULL(column_name, ''),5,'1'); Another option to the IFNULL and CASE is the COALESCE function: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office

Re: Table doesn't exist from stored function

lower case and see what happens. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN Join us at the 2007 MySQL Conference and Exposition April 23 to 26 - Santa Clara, California, USA http://www.mysqlconf.com/ -- MySQL General Mailing List For list archives

Re: Selecting records based on max and value

INNER JOIN supplyorder AS s, WHERE h.supplyorderuid = s.uid; This is just one way to implement a group-wize maximum query pattern. Search the list and the rest of the web for this term and you will see many other variations. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com

Re: Does Update allow for aliases?

:) An alternative form is: UPDATE maindb.orders o INNER JOIN altdb.orders ao ON o.ID=ao.ID SET o.price=ao.price; The table reference portion of the mulitple-table UPDATE command will accept any valid JOIN syntax, not just the implied INNER JOIN of a comma separated table list. Yours, -- Shawn

Re: Data types and space needs

they are stored. Even if you declare a field to be INT(1) then whatever value you put into it will take up just as much room on disk and in memory as any other INT. The only difference is how the number is rendered as part of a result. -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com

Re: db/query question...

subquery evaluation of the EXISTS() clause used in subquery solution (1) . Does this demonstration help you see some additional patterns you can use to solve this and perhaps a few other similar query problems? -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office

Encryption

Is there a simple way to encrypted data as it's being stored in a table? And then easily decrypted when it's queried? Sample syntaxs if available - thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

UPDATE question

If I have 4 Fields (FIELD1, FIELD2, FIELD3 FIELD4) I can do this easily; UPDATE TABLE_NAME SET FIELD4 = FIELD1; But -- how do I do it so that FIELD4 = FIELD1 FIELD2 ??? I can't seem to find any examples online. Maybe it's just too early in the morning - I'm drawing a blank! ;)

EXPORTING results to CSV

Is there a way to export the results to a text file (comma-delimited preferred)... ie, SELECT * FROM TABLE test.txt ; (obviously this doesn't work) :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: constraining unique values across columns

--- Scott Purcell [EMAIL PROTECTED] wrote: I occasionally run into issues where I would like to ensure that the values across two or three columns are not duplicated. At work we use Oracle, and I see that they add constraints when creating the columns. I am running mysql 5.0 and was hoping

Re: constraining unique values across columns

sorry :( I clicked send too early --- Shawn Green [EMAIL PROTECTED] wrote: --- Scott Purcell [EMAIL PROTECTED] wrote: I occasionally run into issues where I would like to ensure that the values across two or three columns are not duplicated. At work we use Oracle, and I see

Re: download link to file

browser's request for information (which can be initiated by the user clicking on a link). And you wanted to know how to format that link so that it becomes clickable. Am I close? Shawn Green Database Administrator __ Do You Yahoo!? Tired of spam

RE: Help with subqueries... MAX() and GROUP BY [sovled]

should review the techniques discussed not just in the article you quoted but also in the articles around it. Shawn Green Database Administrator __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: How to select the last entry per item

to the groupwize maximum (in this case the record with the latest date from a group of records sharing the same ID) is by using one of the techniques listed here (temp table, subquery, concat hack): http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html Shawn Green Database

Re: need help for my jointure

else on the list) will be able to respond with an appropriate query. Shawn Green __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http

Re: need help for my jointure

have the target IP and save that list into a temporary table. Then we run a query that finds every conf EXCEPT those we just located in the first step. Last we clean up after ourselves by getting rid of the temp table. Make sense? Shawn Green Database Administrator

Re: Top N selections + rest row

considered using the WITH ROLLUP modifier? Select Country , Sum(Sales) AS Sales From myTable Where Year=2005 Group By Country WITH ROLLUP Order By Sales DESC LIMIT 25; http://dev.mysql.com/doc/refman/5.0/en/select.html Shawn Green __ Do You Yahoo

Re: help with SELECT BETWEEN

to numbers again. Please read for more details: http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html http://dev.mysql.com/doc/refman/5.0/en/number-syntax.html Shawn Green __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam

RE: Return virtual records

--- Ed Reed [EMAIL PROTECTED] wrote: Thanks for the response Shawn but there's nothing covert here. I really need a list of partnumbers based on the Sum of that part in the table. My users will be marking off the parts in the list and if there a more than one of a partnumber then it needs

Re: If exists query.

enough. Shawn Green __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Cannot create functions from a workstation

/refman/5.0/en/show-grants.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list

Re: adding a field and settign the value

was not very clear Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http

Re: Show Grants problem

. When you do SELECT * from user where user = 'user1'; a) how many entries are there b) what is in the host column for those entries. For example if the host column shows fizzle.shizzle.com then you have to use SHOW GRANTS FOR 'user1'@'fizzle.shizzle.com'; HTH! Shawn Green Database

RE: MySql Error Number 1130

but I do know it's only for local connections. shellmysql -u -p -h. -P3307 HTH! Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http

RE: FW: New to TRIGGER and CALL. Example gives errors. (repost)

syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.skey = 1; ELSEIF NEW.skey 9 THEN EW.skey = 9; END IF; END' at line 5 mysql delimiter ; mysql snip! Shawn Green Database Administrator Unimin Corporation - Spruce Pine

RE: Return virtual records

find a faster, more robust solution than the one you are proposing. Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: Best practices

in advance for any kind of advice in this matter. Regards, Bruno B B Magalhaes Best Wishes! Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http

Re: Looking for advice on how to store and query some data

-row.html In this case, what you are trying to maximize is the date per person_id. It should be fairly easy for you to convert the examples to match your situation. Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo

Re: question

ON o.pkid = b.pkid SET o.Col_1 = b.Col_1, o.Col_2 = b.Col_2, o.Col_3 = b.Col_3, o.updatetime = CURDATE(); Details are here: http://dev.mysql.com/doc/refman/4.1/en/update.html I hope that helps, Shawn Green Database Administrator Unimin Corporation - Spruce Pine

Re: [NEWBIE] How To Trim Database To N Records

want to limit the database to exactly 10 rows (see previous query), then this should work for you: DELETE FROM yourtablename WHERE datecolumn @lastDate or (datecolum = @lastDate AND id @lastID); Let us know how it works... Shawn Green Database Administrator Unimin Corporation

Re: FW: New to TRIGGER and CALL. Example gives errors. (repost)

suspiciously like an interface issue, not a coding issue. How are you delivering these commands to your MySQL server and is it v5.0 or newer? Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo

RE: Social Network, linking members

are numeric, then every row of data will be the exact same length (as stored on disk). This fixed-width type of table is EXTREMELY fast for searching and retrievals. I honestly encourage you to attempt to use a second table in your design. Shawn Green Database Administrator Unimin Corporation

Re: Problem running multi master replication

direct-read to FEDERATED. Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives

Re: Insert speed on table with 7M rows but small row size.

. Those are the two ideas off the top of my head. Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing

Re: Effective-dating

: http://www.google.com/search?num=100hl=enlr=q=chronological+effective+date+%2BdatabasebtnG=Search Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around

Re: MUL when describe table

It's there: http://dev.mysql.com/doc/refman/4.1/en/describe.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL

Re: what is this? -- errno=2006 errmsg=Server gone

Bruehe, Senior Production Engineer MySQL AB, www.mysql.com IIRC, this message can also occur whenever you transmit a packet larger than the server's max_allowed_packet setting. What were you doing when you got the message? Shawn Green Database Administrator Unimin Corporation - Spruce Pine

Re: Social Network, linking members

.id = f1.to_person_id; There are many ways to make that faster but this is the general form of the query. Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam

Re: select all events from (today-N) days

-functions.html I think the one you need is called UNIX_TIMESTAMP() Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL

Re: How to pass parameters in MYSQL

of a conversion or function if you ever hope to use an index during the lookup phase. http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam

newbee error (1044)

I get the following error while trying to create the following database mysql mysql zm_cre­ate.sql.in ERROR 1044 (42000): Access denied for user ''@'­loc­al­host' to database 'mysql' I tried to run the following script /usr/bin/mysql_in­stall_db --user­=mysql It does not create mysql database

Re: newbee error (1044)

--datadir=/mysql/data --user=mysql This might help ypu to solve the problem. Shawn Sharp wrote: I get the following error while trying to create the following database mysql mysql zm_cre­ate.sql.in ERROR 1044 (42000): Access denied for user ''@'­loc­al­host' to database 'mysql' I tried

Estimated Drive Space Requirements

If I have about 2Gb of raw text data to import everyday -- can I expect that to take up about 2Gb in a mySQL database ... slightly more.. double? Pretend there's no indexes for now. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

sqlloader question

I've been given some Oracle table dumps that are NOT plain text delimited. I've been asked to look at using sqlloader to get the file into my mysql database. Does this exist for mysql? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Oracle DMP to mySQL -- Possible???

I have some data that has been dumped from Oracle into what appears to be a proprietary text file... It is not delimited into a format that I can just import into mysql (easily). The IT guy has provided me an outline of the dump.. ie; SQL describe isup051024; Name

Re: No Longer Receiving Emails

It's possible that Gabe's mail spool is full, and he is not receiving mail - including our responses. Gabriel - if you are receiving any messages directly sent to you - please respond to the list to rule that out. If no responses are made to any of either directly or through the list,

ORDERing/GROUPing or both??

If I have a table with fields ID, NAME, VALUE and they may be populated like 1, SHAWN, APPLE 2, TOM, BANANA 3, SHAWN, BANANA 4, JACK, GRAPES 5, TOM, APPLE 6, SHAWN, GRAPES and I want to query all records showing only the most recent records for each person Any thoughts? -- MySQL General

Re: Many to Many: Does this make sense ?

TO ENSURE EVERYTHING IS CLOSED } } catch (SQLException sqle) { // } -- Shawn Karma is immutable, so act accordingly! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Brainstorming' time! (export to excel via java)

in the database (see the dbform's usersguide chapter on Query Support) Have a good one, -- Shawn Karma is immutable, so act accordingly! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECT and DELETE

I'd like to kill 2 birds with one stone... I'd like to SELECT a set of records (for viewing) and in the same motion DELETE any that show up. Can it be done? Shawn Cummings Engineering Project Manager Global NAPs 10 Merrymount Rd Quincy, MA 02169 Desk 617-507-5150 VoIP 617-507-3550 [EMAIL

Re: Free software to design forms and report

). It also hooks up with other open source projects like jasperReports should you want to export your data into pdf form in an invoice or some such thing. -- Shawn Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ -- MySQL General Mailing List For list archives: http

grouping

select max(comments.commentid) as tagger, comments.commentref, article.articlesubject, article.articlename, comments.commentfrom from comments LEFT JOIN article ON comments.commentref=article.articleid GROUP BY commentref ORDER by tagger DESC; I have this query above. I lists comments in

LIMITS

when I do a query is there a way to IGNORE the first X number of returned records??? For instance I want to see 15 records after the first 50. Shawn Cummings Engineering Project Manager Global NAPs 10 Merrymount Rd Quincy, MA 02169 Desk 617-507-5150 VoIP 617-507-3550 [EMAIL PROTECTED

sorting/grouping

I have a very simple table. commentid, commentref (each field is an INT) Each record is a comment... commentid is the ID (each new record is a higher #).. and the commentref field if the story the comment refers to. I want to be able to list the stories in order from most recent comment

RE: sorting/grouping

This doesn't seem to be making sure that the newest commentid is the result... Seems to be random. At 09:11 AM 10/6/2003 -0400, you wrote: try select commentid, commentref from comments ORDER by commentref ,commentid DESC; -Original Message- From: Cummings, Shawn (GNAPs) [mailto

RE: sorting/grouping

ORDER by commentref ,commentid DESC; -Original Message- From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 2:37 PM To: [EMAIL PROTECTED] Subject: sorting/grouping I have a very simple table. commentid, commentref (each field is an INT) Each

reserved words and column titles

to edit the code. Shawn McGinn Web Media Services University of New Brunswick email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqlhotcopy fails under linux RH9

/mysql/mysql.so does exist as does /usr/lib/perl5/5.8.0/i386- linux-thread-multi/DynaLoader.pm Is this a known issue? Anything I can do other than use dump? -- Shawn Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ -- MySQL General Mailing List For list archives

mysqlhotcopy fails under linux RH9

/mysql/mysql.so does exist as does /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm Is this a known issue? Anything I can do other than use dump? -- Shawn Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ -- MySQL General Mailing List For list archives

derived tables

. the query as a whole returns 'tbl_name', not it's contents). Where am I going wrong? I am using version 4.1.0-alpha-standard Shawn -- Shawn McGinn [EMAIL PROTECTED] UNB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

derived tables

. the query as a whole returns 'tbl_name', not it's contents) Where am I going wrong? I am using version 4.1.0-alpha-standard. Shawn -- Shawn McGinn [EMAIL PROTECTED] UNB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

derived tables

). Where am I going wrong? I am using version 4.1.0-alpha-standard Shawn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

<    1   2   3   4   5   6   >