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
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
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
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
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
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
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
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
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
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
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
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
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
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
l
- steve
--
+----+
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp://www.edberg-online.com/ |
++
--
MySQL General Mailin
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
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
--
+-
ID = r.Child inner join categoriesProducts as p on r.Parent = p.ID
where p.Category = 'prodCat2';
- s
--
+--------+
| Steve Edberg edb...@edberg-online.com |
|
x27;t used federated tables yet...
- steve
--
+----+
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp://www.edberg-
, 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
---++
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
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, ---+
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
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
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
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-
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, -
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
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
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/ |
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
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
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
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
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.
--
+--
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
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]
--
+----
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
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
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] |
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
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
+----
info.
-steve
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgf
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
?
Michael
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.u
| 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
--
+-----
| Type | Row_format | Rows | Avg_row_length |
Data_length |
+---+++--++-
+
| mynotnullisam | MyISAM | Fixed |3 | 11 |
33 |
+---+++--++-
+
--
+------
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
--
+----
le unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/
cribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
+--------+
| 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
+----
#x27;t figure it out. Can someone
provide some insight for me?
Thanks-
> Anna
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis
You explicitly set the TIMESTAMP column to NULL
...so that means it's a feature.
-steve
--
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis
nfo
-> (
-> name varchar(50)
You need a comma:
name varchar(50),
-> message varchar(255)
-> )
-> ;
thanks,
-wiley
--
+--------+
| Steve Edberg [EMAIL PROTECTED]
; > 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?
> > >
> > >
> > >
> > >
--
+---
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
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
--
+---
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
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
>
--
+-
>data-set.
>
>Anyone help?
>
>Best wishes,
>
>Peter.
>
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-91
>);
>
>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..
>
-
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
--
+----+
|
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
, Limerick
>
>http://www.piercom.ie http://nm.csn.ul.ie
>Phone: +353-61-201917 Fax: +353-61-355051
>
--
++
| Steve Edberg [EMAIL PROTECTED] |
| Un
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
++
| Steve Edberg [EMAIL PROTECTED] |
| University
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
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
>
--
+----
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
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
>> >
>
rching text in big table?
>
>Thanks in advance.
>
--
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| P
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
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/ |
+---
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
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]
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
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
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,
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
satisfied.
>
>thank you for any help
>mike
>
--
+---- Open source questions? +
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/
ld be used)
>
>thanx in advance
>peter
>
--
+ Open source questions? +
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| ht
;for rest of the depart records.
>
>--
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>| Ilya Martynov (http://martynov.org/)|
>| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB
rent database
>the user is using ?
>
>Thanks !
>
--
+--------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
|
DueField = 0,
>( StatusField = "C" WHEN StatusField = "O")
>WHERE PrimaryKeyField = "XYZXYZ";
>
>
>
>Can something like that be done?
>
>Chris
>
--
++
| Steve Edber
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
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
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
abase? Is anybody using it? How is it? Better than MySQL?
>
>Looking forward to hearing from you.
>
>Regards,
>DT
--
+----+
| Steve Edberg [EMAIL PROTECTED] |
| Univers
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
;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
; > >> ++--+
> > >> | record | num1 |
> > >> ++------+
> > >> | 1 | 12.3 |
> > >> | 2 | 17.785 |
> > >> | 3 | 138.981 |
> > >> | 4 | -34.12 |
> > >> |
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
--
+---
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
>>
--
+--
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
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
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
= '$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]
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 |
|
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
lear the buffer
>
>mysql> use gon;
>Database changed
>mysql> insert into mymp3 (myclass)values('class_four');
>ERROR 1062: Duplicate entry '127' for key 1
>mysql>
>
>..........
>Could you please tell me what&#x
Fax: +47 77 69 66 89
>NO-9261 Tromsø, NORWAY Mob: +47 98 06 61 38
>
>Try FAST Search: http://www.alltheweb.com
>
- steve edberg
--
+--- "They've got a cherry pie there, that'll kill ya" --+
| Steve Edberg
1 - 100 of 105 matches
Mail list logo
