, may not
be what *you* need.
I'd recommend spending some time reading the documentation for
autoincrement fields and the last_insert_id() function.
- sbe -
--
+--------+
| Steve Edberg
x27;t used federated tables yet...
- steve
--
+----+
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp://www.edberg-
ID = r.Child inner join categoriesProducts as p on r.Parent = p.ID
where p.Category = 'prodCat2';
- s
--
+--------+
| Steve Edberg edb...@edberg-online.com |
|
7;,'j','k','l','m','n','o','p')
I wouldn't recommend the latter, but might be handy if you were
dealing with something more complex than a simple range.
- steve
--
+-
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
l
- steve
--
+----+
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp://www.edberg-online.com/ |
++
--
MySQL General Mailin
e 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, pickin
hich, by default, will be updated
every 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 Edberg
running v5.0.51a; as you can see, the first invalid value was
truncated to '' with a warning, the second caused 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/re
uery_log = "| some_program_that_monitors_activity") that might
reduce the load sufficiently.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davi
ttp://marc.info/?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, ---+
---++
6 rows in set (0.00 sec)
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center[EMAIL PROTECTED] |
| Bioinfor
for portability 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 Edberg
e structures. I can´t find in the
documentation how to do either of those. Please advise.
TIA,
Tony
AOL now offers free email to everyone. Find out more about
what's free from
>> AOL at AOL.com.
--
+--
le 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 lawre
will not
match. You need to insert more test data before MySQL has enough
words to compute valid relevances.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Ce
ivacy, eliminate DRM, learn more
at http://www.defectivebydesign.org/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 peop
eople 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
ams out
there. Even after 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/ |
ate
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 Cen
and create a non-unique index?
that isn't what i'm trying 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, St
eness across a set of columns, define
a unique composite key, for instance: create 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, -
ries?
--
+--- 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-
rement field or explicitly
reset it using an
alter table 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, ---+
| Ste
enter.
>
> Perhaps what is needed is either a nice cheatsheet of what
to do 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
I
haven't played with this much, I might be doing something wrong.
For more info, see:
http://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html
- steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghtt
s
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
t 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.ucdavi
eed 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.ucdavi
http://dev.mysql.com/doc/refman/4.1/en/user-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 Edberg
ost or all of the above using user-defined functions,
presumably with relatively high efficiency.
steve
--
+------- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center
done 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:[E
u/> http://www.pacificfox.com.au an
industry leader with commercial IT experience since 1994
*
Web Design and Development
*
SMS Solutions, including developer API
*
Domain Registration, .COM for as low as fifteen dollars a year,
.COM.AU for fifty dollars two yea
yet. If I
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://pgf
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 |
+ sa
TYPE=MyISAM;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
+------- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucd
e 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 lawren
ident
<http://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] |
ou might be better off using an XML
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
+----
y deleting all data from
the table and then re-populating it as opposed to droping and
re-creating it?
Thanks,
Jeff
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| Database/Programming/SysAdmin
T
Dept of Mol. Pharm. and Biol. Chem.
Feinberg School of Medicine
Northwestern 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]
--
+----
a 'table'. I want to select rows from6
to 11. How can I do this?
SELECT * FROM tablename where column>5 AND column<12;
Best regards,
Maciej Bobrowski
--
+--------+
| Steve Edberg
if you want to run
this query again in the same session...
And as far as ugly, well - eye of the beholder, and all that stuff ;)
-steve
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| Dat
; > Sent: Thursday, February 13, 2003 5:48 PM
> > Subject: Row numbers
> >
> >
> > >
> > > Is there a way to get a row number returned with any
select query?
> > >
> > >
> > >
> > >
--
+---
nfo
-> (
-> name varchar(50)
You need a comma:
name varchar(50),
-> message varchar(255)
-> )
-> ;
thanks,
-wiley
--
+--------+
| Steve Edberg [EMAIL PROTECTED]
You explicitly set the TIMESTAMP column to NULL
...so that means it's a feature.
-steve
--
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis
#x27;t figure it out. Can someone
provide some insight for me?
Thanks-
> Anna
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis
the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
+----
cribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis
le unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/
index file...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
--
+----
| Type | Row_format | Rows | Avg_row_length |
Data_length |
+---+++--++-
+
| mynotnullisam | MyISAM | Fixed |3 | 11 |
33 |
+---+++--++-
+
--
+------
| 68 | 11 | <---
TIA,
--
Stefan 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
--
+-----
?
Michael
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.u
ld tell us what 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!
--
+----+
| St
info.
-steve
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgf
renwalder Str. 7/TCH, 30165 Hannover
- Tel.: +49/511/9357-840, Fax: +49/511/9357-849
- eMail: [EMAIL PROTECTED], Web: http://www.chitec.de
--
++
| Steve Edberg [EMAIL P
a script to fix that before entering 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 E
if A.Afn=1, then check Bfn1,
>> if A.Afn=2, then check Bfn2,
>> if A.Afn=3, then check Bfn3.
>>
>> So how I compose a where clause to do this? Thanks in advance!
>>
> > Alex Shi
>>
--
+--
ng the _
>instead of % but the word may or may not be at the end
>or beginning of the line.
>
>Can someone point me in the right direction (or tell
>me how to do it)
>
>Thanks. Sorry for the newbie question.
>
>Robert
--
+---
rching text in big table?
>
>Thanks in advance.
>
--
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| P
ES | | NULL| |
>> +---++--+-+-+---+
>>
>> On Tuesday, July 2, 2002, at 09:36 , Anil Garg wrote:
>>
>> > in my table a column has enties
>> > my_1
>> > my_4
>> > my_5
>> >
>
op off the contents if you
>only want the CREATE TABLE statements.
>
>
>Erik
>
>
>
>
>
>
>Erik Price
>Web Developer Temp
>Media Lab, H.H. Brown
>[EMAIL PROTECTED]
>
--
++
| Steve
ordering, or...
As a general rule in relational databases, results should always be
considered an unordered set unless you EXPLICITLY specify an ORDER BY.
- steve
>HAGW!
>
>Jay
>sql, mysql, query
>
--
+----
as default value, but that just results in a very well known
>error 1064 (You have 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 t
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University
, Limerick
>
>http://www.piercom.ie http://nm.csn.ul.ie
>Phone: +353-61-201917 Fax: +353-61-355051
>
--
++
| Steve Edberg [EMAIL PROTECTED] |
| Un
n MySQL and around 6 seconds in the
>current system. So if I can decrease the insert time I'll definetly use
>MySQL!
>
>Thank you for the attention.
>
>Best regards,
>Cesar
>
--
++
| Steve Edbe
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
--
+----+
|
>);
>
>ERROR 1064 at line 3: You have an error in your SQL syntax near 'when
>timestamp(14),
> body text,
> who smallint(5) unsigned DEFAULT '0' NOT NULL' at line 4
>
>
>--
>
>Any help is appreciated.. Please email me directly..
>
-
>data-set.
>
>Anyone help?
>
>Best wishes,
>
>Peter.
>
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-91
rder, SUM(cat1+cat2) from tbl
>when the result of the SUM is =0 i need to change this 0 and display a
>character like '-' .
>
>Is possible to do this? and how?
>
>thanks in advance,
>
>regards
>fabrizio
>
--
+-
e to put a
hostname in an INSERT.
-steve
>648, 15872, 1, '', 10);
>ERROR 2005: Unknown MySQL Server Host ''tess.DOC',' (2)
>mysql>
>--
--
++
| Steve Edberg
m/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
+---
; > >> ++--+
> > >> | record | num1 |
> > >> ++------+
> > >> | 1 | 12.3 |
> > >> | 2 | 17.785 |
> > >> | 3 | 138.981 |
> > >> | 4 | -34.12 |
> > >> |
;without any data in USERS it works but normally it wouldn't.
>
>Something bad in may script ?
>
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis
query executes fine, but when I look at the ses column in inserted row it
>says Object->ses instead of a value.
>
>Any ideas why?
++
| Steve Edberg [EMAIL PROTECTED] |
| Databas
abase? Is anybody using it? How is it? Better than MySQL?
>
>Looking forward to hearing from you.
>
>Regards,
>DT
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| Univers
cause it was found in 3 rows, "A007" would be placed after "J009" with
>"B001" last.
>
>Any ideas :) ?
>
>Thanks for your time.
>
>Girish
>
--
++
| Steve Edberg
ibiscus Coast
>NEW ZEALAND
>
>Ph + 64 9 414 6172
>Fax + 64 9 414 6182
>Mobile 025 832 682
>
>http://www.starf.net
>
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| Universit
ave any idea what would be the best way to enter these number
>and as what type?
>
>Thanks in advance,
>Jonathan Duncan
++
| Steve Edberg [EMAIL PROTECTED] |
| Database/Prog
DueField = 0,
>( StatusField = "C" WHEN StatusField = "O")
>WHERE PrimaryKeyField = "XYZXYZ";
>
>
>
>Can something like that be done?
>
>Chris
>
--
++
| Steve Edber
rent database
>the user is using ?
>
>Thanks !
>
--
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
|
;for rest of the depart records.
>
>--
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>| Ilya Martynov (http://martynov.org/)|
>| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB
ld be used)
>
>thanx in advance
>peter
>
--
+ Open source questions? +
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| ht
satisfied.
>
>thank you for any help
>mike
>
--
+---- Open source questions? +
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/
in advance
>Nilesh
(1) Go to http://www.mysql.com/doc/
(2) 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 question
t;> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>>
> > MySQL 3.23.41-max: up 3 days, processed 33,335,761 queries (111/sec. avg)
>>
--
+ Open source questions? +
| Steve Edberg University of California,
ve me pointers on installing MySql on
>a Sun Solaris machine
>
>Thank you
>
>( tables )
>
--
+ Open source questions? +
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED]
nk 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 University of Califor
Factoid: Of the 100 largest economies in the world, 51 are --+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+---
Factoid: Of the 100 largest economies in the world, 51 are --+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+--- c
ker/
>> |
>> | Attachments only after prior notice please.
>> | Don't put me on any kind of mailing list.
>> |
>> | I am now receiving the Snowhite virus 4x a day
>> | - some of you must be infected, please check !
>> | (No, you did not
e
beginning of your pattern. If you used ...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 |
|
= '$userto' ");
if (!$ResultId) {
your_database_error_function();
}
...
-steve
--
+-- KDVS 90.3fm Annual Fundraiser : 16 - 22 April 2001 --+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED]
VS 90.3fm Annual Fundraiser : 16 - 22 April 2001 --+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.ed
E=3 order
by id desc";
# 'desc' means to sort in descending order - ie, from z -> a
$result = mysql_query ($query) or die ("Query failed");
while ($d = mysql_fetch_object($result))
{
printf ("%s %s %s
ilable
>
>This is the code that is returning the above error message.
>
>mysql_connect("localhost","root","")
> or die ("Server Currently Unavailable");
>
>Debra Samsom
>Bristol Aerospace Ltd.
>(204) 775-8331 3402
>[EMAIL PR
eed of the
network(s) between the two machines.
- steve
>Thank you,
>Helen
>
--
+--- "They've got a cherry pie there, that'll kill ya" --+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED]
use it extensively on MacOS 8.6; it runs also on 9 & X:
http://www.rtlabs.com/macsql/
-steve
>--
>-Spinlock
>EmpireQuest Creator
>http://www.empirequest.com
--
+--- "They've got a cherry pie there, that'll kill ya" --+
| Steve Edberg
1 - 100 of 105 matches
Mail list logo
