.
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
federated tables yet...
- steve
--
++
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp://www.edberg-online.com
where p.Category = 'prodCat2';
- s
--
++
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp://www.edberg-online.com
be handy if you were
dealing with something more complex than a simple range.
- steve
--
++
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp
--
++
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp://www.edberg-online.com/ |
++
--
MySQL General Mailing List
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
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
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
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
) 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
/?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
--
+--- 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
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
. 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
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
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
/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
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
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
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
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
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
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
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
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
://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
, 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
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
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
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
-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
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
*
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
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
, ---+
| 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
://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
, ---+
| 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
://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
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
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
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
'. 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
: 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
, well - eye of the beholder, and all that stuff ;)
-steve
++
| Steve Edberg [EMAIL PROTECTED] |
| Database/Programming/SysAdmin(530)754-9127 |
| University
- (
- name varchar(50)
You need a comma:
name varchar(50),
- message varchar(255)
- )
- ;
thanks,
-wiley
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California
the TIMESTAMP column to NULL
...so that means it's a feature.
-steve
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127
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
)
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
/php/unsubscribe.php
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http
: http://lists.mysql.com/php/unsubscribe.php
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database
...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
|
+---+++--++-
+
| mynotnullisam | MyISAM | Fixed |3 | 11 |
33 |
+---+++--++-
+
--
++
| Steve Edberg
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu
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
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
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu
://www.chitec.de
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http
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
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu
.
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu
my_file_4
my_file_5
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin
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
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
]
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu
-355051
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http
/unsubscribe.php
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu
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
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
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
: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
--
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu
as to what the problem might be?
Thanks,
++
| Steve Edberg [EMAIL PROTECTED] |
| Database/Programming/SysAdmin(530)754-9127 |
| University of California
?
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu
?
++
| Steve Edberg [EMAIL PROTECTED] |
| Database/Programming/SysAdmin(530)754-9127 |
| University of California, Davis http://pgfsun.ucdavis.edu
? 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
)
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
++
| Steve Edberg [EMAIL PROTECTED] |
| Database/Programming/SysAdmin(530)754-9127 |
| University of California, Davis http://pgfsun.ucdavis.edu/ |
+-- Gort
is using ?
Thanks !
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu
Software Company (http://www.agava.com/) |
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
+ Open source questions? +
| Steve Edberg University of California, Davis
? +
| 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
questions? +
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+--- http://pgfsun.ucdavis.edu
) 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
? +
| 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
)
--
+ Open source questions? +
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+--- http
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
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
)
| __@
| _`\,_
|__(*)/ (*)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
...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
--+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+- www.kdvs.org
--+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+- www.kdvs.org
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
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/ |
+--
://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/
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
org/~vivek/
-
--
+--- "They've got a cherry pie there, that'll kill ya" ------+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED]
98 matches
Mail list logo