Re: last_insert_id

2009-12-27 Thread Steve Edberg
. I'd recommend spending some time reading the documentation for autoincrement fields and the last_insert_id() function. - sbe - -- ++ | Steve Edberg edb...@edberg-online.com

Re: Mysql version of database link?

2009-12-07 Thread Steve Edberg
federated tables yet... - steve -- ++ | Steve Edberg edb...@edberg-online.com | | Programming/Database/SysAdminhttp://www.edberg-online.com

Re: Select Problem

2009-12-06 Thread Steve Edberg
where p.Category = 'prodCat2'; - s -- ++ | Steve Edberg edb...@edberg-online.com | | Programming/Database/SysAdminhttp://www.edberg-online.com

Re: Alphabetical search to and from

2009-11-04 Thread Steve Edberg
be handy if you were dealing with something more complex than a simple range. - steve -- ++ | Steve Edberg edb...@edberg-online.com | | Programming/Database/SysAdminhttp

Re: results of the query as a table

2009-10-27 Thread Steve Edberg
-- ++ | Steve Edberg edb...@edberg-online.com | | Programming/Database/SysAdminhttp://www.edberg-online.com/ | ++ -- MySQL General Mailing List

Re: results of the query as a table

2009-10-27 Thread Steve Edberg
At 3:29 PM + 10/27/09, Olga Lyashevska wrote: On 27.10.2009, at 15:11, Steve Edberg wrote: At 2:59 PM + 10/27/09, Olga Lyashevska wrote: Dear all, I run a query and I try to save results as a table. On the results of this first query I want to run yet another query (perhaps a few

Re: Creation date

2009-05-05 Thread Steve Edberg
of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Centersbedb...@ucdavis.edu | | Bioinformatics programming/database/sysadmin (530)754-9127 | + said t e lawrence, picking up his

Re: Auto increment?

2009-04-02 Thread Steve Edberg
time a record is inserted or updated. Then the other applications can simply select records with timestamp last_poll_time. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC

Re: Possible to get better error handling for invalid enum parameter to stored program?

2009-03-08 Thread Steve Edberg
an error and did not insert. I don't know what version you're running, perhaps this does not apply to you. For more info: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html http://dev.mysql.com/doc/refman/5.0/en/enum.html - steve edberg At 2:00 PM -0800 3/6

Re: How to disable some of the mysql query?

2008-11-28 Thread Steve Edberg
) that might reduce the load sufficiently. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics

Re: Table encryption

2008-11-22 Thread Steve Edberg
/?l=mysql-internals) [2] http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html [3] http://www.truecrypt.org/ [4] http://opensolaris.org/os/project/zfs-crypto/ -- +--- my people are the people of the dessert, ---+ | Steve Edberg

Re: Comma's in data?

2008-03-08 Thread Steve Edberg
-- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics programming/database/sysadmin (530)754-9127

Re: trouble selecting DB

2007-09-14 Thread Steve Edberg
if nothing else. It could well be your problem if you are referring to the database 'FooBar' as 'FOOBAR' and MySQL is running on a *nix platform. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp

Re: Seeing Table Structure

2007-07-23 Thread Steve Edberg
. Please advise. TIA, Tony AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. -- +--- my people are the people of the dessert, ---+ | Steve Edberg

Re: i know your name

2007-07-12 Thread Steve Edberg
of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics programming/database/sysadmin (530)754-9127 | + said t e lawrence, picking up his fork

Re: Problem about fulltext search.

2007-06-30 Thread Steve Edberg
words to compute valid relevances. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics

Re: duplicate key question

2007-06-23 Thread Steve Edberg
/what_is_drm; Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- +--- my people are the people of the dessert, ---+ | Steve Edberg

Re: Blob data

2007-06-22 Thread Steve Edberg
of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics programming/database/sysadmin (530)754-9127 | + said t e lawrence, picking

Re: corrupted tables

2007-03-16 Thread Steve Edberg
system crashes I haven't lost any data; a repair table and index rebuild fixed things. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center

Re: getting a Duplicate entry error when inserting a new record - but there is no duplicate record

2007-03-13 Thread Steve Edberg
unique index01 (videourl,userid); Indexes/keys do not have to be unique unless they are primary or defined as unique. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC

Re: getting a Duplicate entry error when inserting a new record - but there is no duplicate record

2007-03-13 Thread Steve Edberg
to do...i need it to be unique. You can disregard this; again, didn't read the original message closely enough. This would indeed create a non-unique index. steve thanks, jerad On Mar 13, 2007, at 4:55 PM, Steve Edberg wrote: At 4:36 PM -0700 3/13/07, jerad sloan wrote: thanks. i

Re: Default Value to a DateTime Column

2007-03-13 Thread Steve Edberg
current_timestamp See http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html - steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center

Re: row count inconsistency

2007-02-21 Thread Steve Edberg
are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics programming/database/sysadmin (530)754-9127 | + said t e lawrence

Re: row count inconsistency

2007-02-20 Thread Steve Edberg
an alter table tablename auto_increment=1 statement. See http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html for more info. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp

Getting OT re San Jose (was RE: General MySQL Question: Ed Reed (CA, United States of America) Medium)

2007-01-30 Thread Steve Edberg
and where to go? Or perhaps some of the locals could volunteer to be ambassadors and take people with similar interests to local activities, restaurants or points of interest. -- +--- my people are the people of the dessert, ---+ | Steve Edberg

Re: insert into some table show status like 'foo'

2006-12-15 Thread Steve Edberg
://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html - steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED

Re: Cloning or duplicating a record

2006-09-14 Thread Steve Edberg
, which is unique. Check mysql manual for more info on syntax of insert command. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center

Re: Data dictionary for MySQL

2006-09-07 Thread Steve Edberg
at the information_schema database; it might have everything you need already: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu

Re: Managing big mysqldump files

2006-08-19 Thread Steve Edberg
performance/speed penalty (that is, do mysqldump | bzip2 outputfile.bz2). Try 'man gzip' and 'man bzip2' for more info. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC

RE: counting keywords

2006-04-12 Thread Steve Edberg
with relatively high efficiency. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics programming

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

2006-04-12 Thread Steve Edberg
-variables.html http://dev.mysql.com/doc/refman/4.1/en/example-user-variables.html http://dev.mysql.com/doc/refman/4.1/en/delete.html steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu

RE: counting keywords

2006-04-11 Thread Steve Edberg
with regex/rlike; those only give a boolean result (pattern matched/not matched), but can't as far as I know be used for counting/replacing strings. This doesn't appear to have changed even in MySQL 5.1. steve -Original Message- From: Steve Edberg [mailto:[EMAIL PROTECTED] Sent

Re: counting keywords

2006-04-10 Thread Steve Edberg
* Domain Registration, .COM for as low as fifteen dollars a year, .COM.AU for fifty dollars two years! -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center

Re: Visual database design system

2006-02-03 Thread Steve Edberg
recall clearly, it is similar in scope to Datanamic's DeZign - http://www.datanamic.com/ - which is (or was) Windows only. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu

Re: dump to more than 1 file

2005-11-22 Thread Steve Edberg
, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics programming/database/sysadmin (530)754-9127 | + said t e lawrence, picking up his fork

Re: INSERT record IF NOT EXISTS?

2005-08-17 Thread Steve Edberg
://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED

Re: List for newbie

2005-01-03 Thread Steve Edberg
, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics programming/database/sysadmin (530)754-9127 | + said t e lawrence, picking up his fork

Re: Heap Help

2004-11-29 Thread Steve Edberg
://www.gunmuse.com/http://www.gunmuse.com 469 228 2183 -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics

Re: html in a text field - good practice?

2004-08-18 Thread Steve Edberg
database, though. I suppose that you could twiddle with MySQL's fulltext search parameters (min. word length, stop words, etc) to get it to ignore embedded HTML/XML/SGML, though. steve ++ | Steve Edberg

Re: Does Dropping a table affect it's indexes?

2004-02-19 Thread Steve Edberg
and then re-populating it as opposed to droping and re-creating it? Thanks, Jeff ++ | Steve Edberg [EMAIL PROTECTED] | | Database/Programming/SysAdmin(530)754-9127

Re: char count

2004-01-21 Thread Steve Edberg
University Phone (630)252-0629 FAX (630)252-0625 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- ++ | Steve Edberg

Re: specific records

2003-07-02 Thread Steve Edberg
'. I want to select rows from6 to 11. How can I do this? SELECT * FROM tablename where column5 AND column12; Best regards, Maciej Bobrowski -- ++ | Steve Edberg [EMAIL PROTECTED

RE: Row numbers

2003-02-13 Thread Steve Edberg
: Thursday, February 13, 2003 5:48 PM Subject: Row numbers Is there a way to get a row number returned with any select query? -- ++ | Steve Edberg [EMAIL

RE: Row numbers

2003-02-13 Thread Steve Edberg
, well - eye of the beholder, and all that stuff ;) -steve ++ | Steve Edberg [EMAIL PROTECTED] | | Database/Programming/SysAdmin(530)754-9127 | | University

Re: NEWBIE to mysql

2003-02-10 Thread Steve Edberg
- ( - name varchar(50) You need a comma: name varchar(50), - message varchar(255) - ) - ; thanks, -wiley -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California

Re: TIMESTAMP field is updated unintentionally

2003-02-01 Thread Steve Edberg
the TIMESTAMP column to NULL ...so that means it's a feature. -steve -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127

Re: MySQL Truncated returns

2003-01-31 Thread Steve Edberg
changing the column type to text to no avail. I searched the documentation and couldn't figure it out. Can someone provide some insight for me? Thanks- Anna -- ++ | Steve Edberg [EMAIL

Re: group multiple queries.. if one fails all fail

2003-01-23 Thread Steve Edberg
) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ++ | Steve Edberg [EMAIL

Re: What is the best known practice for insertion...?

2003-01-20 Thread Steve Edberg
/php/unsubscribe.php -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http

Re: Indexing

2003-01-20 Thread Steve Edberg
: http://lists.mysql.com/php/unsubscribe.php -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database

Re: index problem

2003-01-16 Thread Steve Edberg
...it doesn't need to look at the actual data record at all. Which is good. how to make mysql use the index on col1 for the first query? Give it a reason to do so ;) -steve -- ++ | Steve Edberg

Re: Avg_row_length

2003-01-15 Thread Steve Edberg
| +---+++--++- + | mynotnullisam | MyISAM | Fixed |3 | 11 | 33 | +---+++--++- + -- ++ | Steve Edberg

Re: Populating one table with data from another

2003-01-14 Thread Steve Edberg
-- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu

Re: Avg_row_length

2003-01-14 Thread Steve Edberg
Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 -- ++ | Steve Edberg

Re: Limit and Order by

2002-12-05 Thread Steve Edberg
you DO intend? Because the statement above does indeed limit the results to the highest 100 totals - the limit is done after the order by. -steve Sql! Query! -- ++ | Steve Edberg [EMAIL

Re: LIMIT in MySQL

2002-11-26 Thread Steve Edberg
-- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu

Re: Bug with limit clause

2002-11-05 Thread Steve Edberg
://www.chitec.de -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http

Re: padding field with zeros

2002-10-12 Thread Steve Edberg
the data into the database, but I just wanted to know. Or maybe there is a way to pad it while doing the query select? Thanks, Bryan -- ++ | Steve Edberg [EMAIL PROTECTED

Re: where clause question

2002-10-07 Thread Steve Edberg
-- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu

Re: Help with WHERE string searching

2002-09-07 Thread Steve Edberg
-- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu

Re: Searching text in a big table

2002-08-28 Thread Steve Edberg
. -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu

Re: changing coulmn

2002-07-02 Thread Steve Edberg
my_file_4 my_file_5 -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin

Re: timestamp problem ..

2002-06-14 Thread Steve Edberg
an error in your SQL syntax near 'NOW()' at line 1). Thanks ! Wouter (ps. beer for the helper .. if you'd come up with some idea to give it to you) -- ++ | Steve Edberg [EMAIL PROTECTED

RE: Is the order same?

2002-06-14 Thread Steve Edberg
databases, results should always be considered an unordered set unless you EXPLICITLY specify an ORDER BY. - steve HAGW! Jay sql, mysql, query -- ++ | Steve Edberg [EMAIL

RE: Reconstructing SQL create table statements

2002-06-14 Thread Steve Edberg
] -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu

Re: System Table

2002-06-05 Thread Steve Edberg
-355051 -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http

Re: doc archive?

2002-06-05 Thread Steve Edberg
/unsubscribe.php -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http

Re: I need 50.000 inserts / second

2002-05-31 Thread Steve Edberg
-- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu

Re: mysql-3.23.50

2002-05-30 Thread Steve Edberg
At 12:44 PM +0200 5/30/02, Inbal Ovadia wrote: Hi all i have mysql-3.23.41 should i install 3.23.50? what are the differences between this versions? http://www.mysql.com/doc/N/e/News-3.23.x.html -- ++ | Steve Edberg

Re: Problem with DDL

2002-05-13 Thread Steve Edberg
text, who smallint(5) unsigned DEFAULT '0' NOT NULL' at line 4 -- Any help is appreciated.. Please email me directly.. -- ++ | Steve Edberg [EMAIL PROTECTED] | | University

Re: change displayed text results?

2002-05-09 Thread Steve Edberg
i need to change this 0 and display a character like '-' . Is possible to do this? and how? thanks in advance, regards fabrizio -- ++ | Steve Edberg [EMAIL PROTECTED] | | University

Re: Rounding times

2002-05-09 Thread Steve Edberg
:50:00. I have racked my brains over this, and I can't work out how to do this. I'm attempting to write a query which will create ten-minute summaries from a data-set. Anyone help? Best wishes, Peter. -- ++ | Steve Edberg

Re: problem

2002-04-19 Thread Steve Edberg
-- -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu

Suggestion re: floating point comparison (was Re: Problem with where clause)

2002-02-01 Thread Steve Edberg
as to what the problem might be? Thanks, ++ | Steve Edberg [EMAIL PROTECTED] | | Database/Programming/SysAdmin(530)754-9127 | | University of California

Re: pb with integrity constraint

2002-01-15 Thread Steve Edberg
? -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu

Re: Inserting Object property in MySQL

2002-01-11 Thread Steve Edberg
? ++ | Steve Edberg [EMAIL PROTECTED] | | Database/Programming/SysAdmin(530)754-9127 | | University of California, Davis http://pgfsun.ucdavis.edu

Re: RedHat DB?!

2001-12-18 Thread Steve Edberg
? Is anybody using it? How is it? Better than MySQL? Looking forward to hearing from you. Regards, DT -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis

Re: Order By number of rows returned ?

2001-12-15 Thread Steve Edberg
) I'd like to order these so that J009 would be grouped at the top of the set because it was found in 3 rows, A007 would be placed after J009 with B001 last. Any ideas :) ? Thanks for your time. Girish -- ++ | Steve Edberg

Re: Inches and Degrees

2001-12-12 Thread Steve Edberg
++ | Steve Edberg [EMAIL PROTECTED] | | Database/Programming/SysAdmin(530)754-9127 | | University of California, Davis http://pgfsun.ucdavis.edu/ | +-- Gort

Re: specific command or mySQL++ command

2001-12-08 Thread Steve Edberg
is using ? Thanks ! -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http

Re: Can this be done?

2001-12-08 Thread Steve Edberg
-- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu

Re: Advanced ORDER BY

2001-09-21 Thread Steve Edberg
Software Company (http://www.agava.com/) | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- + Open source questions? + | Steve Edberg University of California, Davis

Re: mySQL on unix vs ODBC

2001-09-12 Thread Steve Edberg
? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http://pgfsun.ucdavis.edu/open-source-tools.html

Re: fieltypes

2001-09-11 Thread Steve Edberg
questions? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http://pgfsun.ucdavis.edu

Re: BDB Tables, InnoDB tables ??

2001-09-10 Thread Steve Edberg
) Type innodb or bdb into the search box OR (1) Go to http://www.mysql.com/doc/ (2) Use your browser's search function to search the page for innodb or bdb -steve -- + Open source questions? + | Steve Edberg University

Re: Stored Procedures and Triggers

2001-09-03 Thread Steve Edberg
? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http://pgfsun.ucdavis.edu/open-source-tools.html

Re: Installation on Solaris questions

2001-08-30 Thread Steve Edberg
) -- + Open source questions? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http

Re: Downsides of MySQL?

2001-08-16 Thread Steve Edberg
all, I don't think any of the recent and not-so-recent credit-card number thefts have been on MySQL systems. OK, back to work for me. But first, some Mountain Dew... -steve -- + Open source questions? + | Steve Edberg

Re: Assigning New Users

2001-07-08 Thread Steve Edberg
economies in the world, 51 are --+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- corporations -- http

Re: PHP and MySQL result set navigation

2001-06-05 Thread Steve Edberg
) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! -- +--- So long, and thanks for all the fish - -+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu

Re: Database Index Question

2001-04-26 Thread Steve Edberg
...LIKE 'tom%' instead, I believe MySQL WOULD use an index on 'name.' -steve -- +-- KDVS 90.3fm Annual Fundraiser : 16 - 22 April 2001 --+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer

Re: delete in mysql

2001-04-24 Thread Steve Edberg
--+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +- www.kdvs.org

Re: building site search

2001-04-19 Thread Steve Edberg
--+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +- www.kdvs.org

Re: Mysql Table via php

2001-02-23 Thread Steve Edberg
RICE, $row-QTY); } mysql_free_result ($result); Thanks, I am running very short on time Joe. -- +--- "They've got a cherry pie there, that'll kill ya" --+ | Steve Edberg University of Cal

Re: From Windows access to MySQL on Linux

2001-02-03 Thread Steve Edberg
ey've got a cherry pie there, that'll kill ya" --+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--

Re: Querying database from another unix box......

2001-01-26 Thread Steve Edberg
://www.is.co.za -- +--- "They've got a cherry pie there, that'll kill ya" --+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/

Re: question

2001-01-23 Thread Steve Edberg
Huntsville,AL 35816 Alabama high tech directory ph.no-256.837.3394. A-11 ,Research Institute Huntsville,AL-35899. U.A.H PH.NO-256.824.2698 -- +--- "They've got a cherry pie there, that'll kill ya" --+ | St

Re: What proportion of sites use MySQL.

2001-01-23 Thread Steve Edberg
org/~vivek/ - -- +--- "They've got a cherry pie there, that'll kill ya" ------+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED]