Can you say "codefendant"?
--------
David T. Ashley
[EMAIL PROTECTED]
(This e-mail was sent from a
handheld wireless device.)
On Jan 2, 2008, at 5:20 PM, "Daevid Vincent" <[EMAIL PROTECTED]> wrote:
Do it anyways. Release it as Open S
On 12/3/07, Chris Sansom <[EMAIL PROTECTED]> wrote:
>
> My apologies in advance if this is a bit off topic, but...
>
> On a rather old site we have a dreadful old bulletin board system
> based on Matt Wright's WWWBoard - all horrid text files and ancient
> Perl code. We want to replace that with a
Hi Martin,
The easiest way to restore context in this conversation is to go to the
MySQL home page (www.mysql.com), then go to "Community", then "Lists", then
to look at the archives of the main MySQL mailing list (this one).
I believe at this point that Chris and Stut answered my question
decisi
On 11/25/07, Chris W <[EMAIL PROTECTED]> wrote:
>
> Stut wrote:
> >
> > insert into test1 set p = 2, q = (select max(q) + 1 from test1 as tmp
> > where p = 2)
> >
> > Probably not very efficient, but it works.
> >
> > -Stut
> >
> Auto increment is much easier to do. If your primary key is made up
On 11/25/07, Stut <[EMAIL PROTECTED]> wrote:
> David T. Ashley wrote:
> > I have a table with two integer fields (call them p and q).
> >
> > When I insert a record with a known p, I want to choose q to be one
> larger
> > than the largest q with that
I have a table with two integer fields (call them p and q).
When I insert a record with a known p, I want to choose q to be one larger
than the largest q with that p.
What is the best and most efficient way to do this?
For example, let's say the table contains (p,q):
1,1
1,2
1,3
2,1
2,2
2,3
2.4
Hi,
I am developing a large database where the web interface may be shared
among many companies, but the data will generally not be shared. For
the purposes of example, let's call it a bug tracking system such as
Bugzilla. Each company has their own private software bugs.
Many companies may ent
On 11/19/07, Mohammad wrk <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm working on a web 2.0 project that targeting small to medium size
> companies for providing business services. Companies simply register to the
> site and then start their business by loading their data, sharing and
> discussing th
On a *nix box, it is also traditional to configure IPTABLES or similar to
restrict TCP/UDP connections based on IP and/or adapter.
It seems likely based on your description that the box has two network
connections.
Dave.
On 11/13/07, Michael Dykman <[EMAIL PROTECTED]> wrote:
>
> In my.cnf, you c
On 11/6/07, mos <[EMAIL PROTECTED]> wrote:
>
> At 02:18 PM 11/6/2007, Richard Edward Horner wrote:
> >Hi,
> >
> >I'm working on a program that will run in the event that tables are
> >crashed or corrupt. Can anyone recommend a good method for crashing my
> >tables or corrupting them so I have some
On 8/23/07, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
>
> > b)Terminating TCP connections and ensuring that each PHP script
> > runs to
> > completion, anyway, and that the database isn't left in an
> > indeterminate
> > state due to this.
> >
> > Dave.
>
> What do you mean by "b"? If all the connec
On 8/23/07, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
> I am planning on having the database open to customers of mine to
> store their mailing addresses on-line, and be able to manage the
> records.
>
> Is it safe, to have 1 database with lots of tables? Or am I safer
> setting up separate database
On 8/18/07, C K <[EMAIL PROTECTED]> wrote:
> Friends,
> I have one question - How to store passwords in MySQL database table in a
> secure way so that no one can see the password(understand the password
> string)?
It is considered bad security practice to store passwords using reversible
encrypt
On 8/13/07, Jonathan Horne <[EMAIL PROTECTED]> wrote:
>
> i finally have a real need that i need to sit down and learn the basics of
> databases. i need to learn to create a database that i can use to track
> assets at my company, and have it be readable/updatable from a web
> interface
> (and hop
On 8/13/07, Jonathan Horne <[EMAIL PROTECTED]> wrote:
>
> i finally have a real need that i need to sit down and learn the basics of
> databases. i need to learn to create a database that i can use to track
> assets at my company, and have it be readable/updatable from a web
> interface
> (and hop
On 8/7/07, Boyd Hemphill <[EMAIL PROTECTED]> wrote:
>
> Suggestions to use a hash are a problem because once you have a few
> million rows the likelihood of a collision is quite high if you cannot
> afford an error stopping your application. This means that if you write a
> trigger (the obvious wa
You might not need to do this in the way you are suggesting (depending on
your application). I'm not sure why you feel you need to combine the
autoincrement with the hash into the same field. Does it really do harm if
two records have the same hash?
It might work as well to have two separate fie
You are more altruistic than I can ever be.
Every time I go through a nameless fast-food drive-through (too often, based
on my girth), they offer me a chance to win $1,000 if I complete a survey.
I never take those surveys.
Reasons:
a)If, for example, 10,000 people take the survey and the payout
On 7/10/07, Octavian Rasnita <[EMAIL PROTECTED]> wrote:
I have exported a database using mysqldump from MySQL 5.0.27, and I have
tried importing it in a MySQL 5.0.41, but it gives the following error:
ERROR 1071 (42000) at line 483: Specified key was too long; max key length
is 1000 bytes
Hi
On 7/8/07, Steffan A. Cline <[EMAIL PROTECTED]> wrote:
I am trying to set up a forum where there are main posts with replies and
replies to replies. Rather than using nested queries in my middleware I am
thinking there has to be some kind of recursive query where I can output
the
results in a fo
I'm sending this again, because the server seems to have been down for
several hours, and I'm not sure if it went out.
-
I'd like to do full text search on some fields of some tables, but I'm a bit
confused by the documentation. Questions:
a)How do I set that up (i.e. do I need to use
I'd like to do full text search on some fields of some tables, but I'm a bit
confused by the documentation. Questions:
a)How do I set that up?
b)What storage engines are required?
c)Are there any restrictions on "mixing and matching" tables?
d)Do table locking and transactions work the same?
On 7/6/07, John Trammell <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 06, 2007 10:51 AM
> To: David T. Ashley
> Cc: mysql@lists.mysql.com
> Subject: Re: zipcode to timezone
>
> i don
On 7/6/07, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
we have warehouses all over U.S. and i just wonder what is the best way to
find out their timezone base on zipcode. Should i buy a database or is
there any function in mysql or php to get timezone base on a zipcode?
I looked at the zipcode da
On 7/5/07, David T. Ashley <[EMAIL PROTECTED]> wrote:
>
> a)I'm assuming that under MySQL I have to create a third table that maps
> between them? (Let's call it "users2priveleges".)
>
> b)I'm assuming that there is nothing special I need to do to
I'm an old Microsoft Access user, so I just need to double-check on this
with MySQL:
I want to relate two tables (let's call them "users" and "priveleges") in a
many:many way. That is, each user may have multiple priveleges, and each
privelege may have multiple users with that privelege.
Here a
On 7/4/07, Dan Nelson <[EMAIL PROTECTED]> wrote:
In the last episode (Jul 04), David T. Ashley said:
> On 7/4/07, gary <[EMAIL PROTECTED]> wrote:
> > SELECT column FROM table WHERE column LIKE "CAT\_%";
>
> Would it be reasonable to assume that if &q
On 7/4/07, gary <[EMAIL PROTECTED]> wrote:
SELECT column FROM table WHERE column LIKE "CAT\_%";
Would it be reasonable to assume that if "column" is indexed, the query
would execute quickly, i.e. I would assume that the indexing would
facilitate this kind of query?
If I have a table with rows like this, all varchar:
DOG_LUCY
DOG_CHARLIE
DOG_LASSIE
DOG_XRAY
CAT_MR_BIGGLESWORTH
CAT_SCRATCHER
CAT_WHISTLER
what is the form of a query that will return the rows where the first part
of the string matches?
For example, what if I'd like to return the rows that beg
On 6/28/07, M5 <[EMAIL PROTECTED]> wrote:
Not being very strong at math, I have a little problem that I'm not
sure how to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100
meters) (think circle), I need to compute an equivalent square: That
is, t
On 6/28/07, Magnus Borg <[EMAIL PROTECTED]> wrote:
Got strings in the format "integer+(char)^0..1", ex 3456, 2323, 2324A,
2324B, ...
I want to order them as they where integers, like:
order by cast(STING as unsigned) desc
But when using that query resulting in error 1292. And the resul
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
me an opensource soluti
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
me an opensource soluti
On 6/27/07, Dave G <[EMAIL PROTECTED]> wrote:
select payload_time,HEX(processed_data) from data__ProcessedDataFrames
where test_id=18 AND top_level_product_name="DataProduct" AND payload_time
> 11808.74704 AND payload_time < 1180564096.24967;
What I'm concerned about is with how much data I
On 6/27/07, Dave G <[EMAIL PROTECTED]> wrote:
Queries on this table when it gets large is slow as molasses. I'm
thinking about making a new table for anything with a different test_id
any opinions as to whether this is good or bad?
Hi Dave G.,
We need to know how:
a)How large the tabl
I'd like to represent our organization's chain of command (i.e. who is whose
boss) in a database.
The reason is that in some contexts, my database application needs to know
who can view whose time and project records (and the rule is that anyone
above in the chain of command can, anyone at the sa
In reading the syntax of the CREATE TABLE statement, I'm a little confused
by the two keywords KEY and INDEX.
What does one use when one wants MySQL to arrange the column so that it can
find a given record "WHERE column=whatever" in approximately O(log N) time?
This is a "key", right? MySQL use
On 6/11/07, kalin mintchev <[EMAIL PROTECTED]> wrote:
hi all...
from http://dev.mysql.com/doc/refman/5.0/en/features.html:
"Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users who use MySQL Server with 60,000
tables and about 5,000
Just speaking as a newbie who has no idea what he is talking about ...
If nobody suggests anything better ...
I've noticed that there is a clear correspondence between table names and
the files that MySQL keeps, i.e.
[EMAIL PROTECTED] dashley]# ls -al /var/lib/mysql/fboprimedevel/
total 7832
dr
Hi,
I'm implementing a software release database. Users may aribtrarily be
members of groups (a many-to-many mapping), and each software release may
contain multiple files.
I'd like to allow users the maximum flexibility in deciding who may view
what software releases. The most obvious approac
On 6/5/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
David T. Ashley wrote:
> There is no concept that I'm missing. I understand what a transaction
is.
> But I just don't want to bothered. My application is simple enough that
> bogarting the database until all nec
On 6/5/07, Brent Baisley <[EMAIL PROTECTED]> wrote:
I think you're missing the concept of a transaction in the database sense.
The idea behind a transaction is that you can perform multiple steps and if
you don't complete all steps, any changes are reversed. The reversal process
is handled by th
Once you issue a LOCK TABLES command, you may not access any tables not
in the LOCK statement. You must lock *ALL* tables you will use, perform
your updates, and then UNLOCK TABLES.
I didn't know that. I reviewed the documentation. Thanks.
OK, then my only remaining question is how many tabl
On 6/4/07, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
Whatever you do, make sure that every bit of code that locks multiple
resources locks them in the same order. That's the only way to avoid
deadlocks.
Hi Jerry,
I really appreciate the good advice.
However, my original question is still un
On 6/4/07, Gerald L. Clark <[EMAIL PROTECTED]> wrote:
David T. Ashley wrote:
LOCK TABLE thistable, thattable, theothertable,
goshthislistcangetlongtable;
Do whatever is needed;
UNLOCK TABLES;
You could use a string lock for this.
Thanks for the suggestion. It looks logically c
I decided to go with a simple paradigm for my web-based database. Rather
than transactions, each process locks the entire database while it is
changing something, then unlocks it. This just serializes access (all other
processes will block until the one modifying the database has finished).
The
On 5/15/07, Mathieu Bruneau <[EMAIL PROTECTED]> wrote:
Hi, yeah, apparenlty you're running into the 32 bits memory liimt. Note
thta some memory is allocated for the OS so you don't even have the full
4GB of ram you can technically adressesed.
The 64 bits os would increase this limit to 64gb++ (
On 5/15/07, Ratheesh K J <[EMAIL PROTECTED]> wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information should not be visible/accessible to any other
person but the owner of the data.
Whilst I know that encryption/decryption is the soluti
On 5/10/07, James Tu <[EMAIL PROTECTED]> wrote:
David:
I definitely can get the result set using one query, but what I do
with the result set has me thinking about breaking it up into two
queries.
Ah, OK, I misunderstood. You want to (get two results, each of which is
useful individually)
On 5/10/07, James Tu <[EMAIL PROTECTED]> wrote:
I think b/c of the way the tables are designed, I have to perform
multiple queries, unfortunately.
Hi James,
My suggestion to you would be that if you have a situation you don't believe
you can handle in one query, post all the details to the M
On 5/9/07, James Tu <[EMAIL PROTECTED]> wrote:
The database server and the web server are on separate machines.
Table A contains a record for each user.
Let's say Table B contains 'relationship' information. They can be
of type 'friend' or 'family'.
If a user knows another user, this relationsh
On 4/25/07, mos <[EMAIL PROTECTED]> wrote:
At 02:36 PM 4/25/2007, you wrote:
>On 4/25/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
>>
>>A co-worker sent this to me, thought I'd pass it along here. We do tons
of
>>failover/replication and would be eager to see mySQL implment the Google
>>patches
On 4/25/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
A co-worker sent this to me, thought I'd pass it along here. We do tons of
failover/replication and would be eager to see mySQL implment the Google
patches in the stock distribution. If anyone needs mission critical,
scaleable, and failover c
On 4/18/07, Tim Lucia <[EMAIL PROTECTED]> wrote:
-Original Message-
From: John Comerford [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 17, 2007 10:50 PM
To: mysql@lists.mysql.com
Subject: Millisecond time stamp
Hi Folks,
I am putting together a table to hold log entries. I was going
On 4/17/07, John Comerford <[EMAIL PROTECTED]> wrote:
Hi Folks,
A) One character string contain a string I build with the date and
milliseconds tagged onto the end
b) Two separate fields Field1 TimeStamp Field2 Milliseconds
I am leaning towards approach B, but saying that it's more gut insti
I have a box where I'm forced to use PHP before 64-bit integers became
standard ...
If I run a MySQL query where one of the fields returned is 64-bit integer,
how do I get this into PHP as a string? My recollection is that in the
PHP result sets it "auto types" so that it is an integer, and 64-b
I'd like to have a table in MySQL with the key field being a 12-character
text string consisting of digits and upper-case letters (minus the vowels
and Y, to prevent accidental bad words), i.e. something like:
XM39C6B4...
When I do queries and get back result sets sorted on this text string, is
On 2/28/07, Chris McKeever <[EMAIL PROTECTED]> wrote:
Does anyone have any resources, guides, insight into the best practice
for storing date/time information when developing a custom web app?
I am mainly concerned with how the TZ should be stored? Should it go
in as UTC and the code accounts
On 1/4/07, Daniel Kiss <[EMAIL PROTECTED]> wrote:
Hi All,
I'm designing a database where it is required for each row in a table to
have a unique identifier accross a bunch of running MySQL servers on a
network.
I'm considering two options:
1. Have a two-column primary key, where the first co
On 12/18/06, Peter Smith <[EMAIL PROTECTED]> wrote:
Hello MySQLers,
Since I'm mildly technical and I know how to spell orakle,
I've been asked to write up some technical interview questions
for a MySQL position at a startup.
Can any of you help me out?
Your apparent focus on doing what is b
On 12/17/06, Mike Duffy <[EMAIL PROTECTED]> wrote:
I am sure this question has probably been asked in this group before, but
I would like to get an
updated answer.
If you were building your own boxes to run clustered MySQL servers, how
would you configure the
boxes? (This would of course be for
On 11/27/06, Nicholas Vettese <[EMAIL PROTECTED]> wrote:
I am looking for a book that will help me understand PHP/MySQL, and the
way that they work together. My biggest problem is multi-valued
selections, and INSERTING them into the database. A book with great
examples like that would be a hug
What happens if I use the C API of MySQL and the process dies (maybe a
pointer error or something)?
a)Will the connection be killed automatically?
b)What about "LOCK TABLES" and similar statements that were issued ... will
the locks clear automatically?
Thanks.
Has anyone ever written C-language CGI-BIN programs (to be executed from
Apache) and which use the C-language interface of MySQL?
Does it work OK?
Thanks.
ot;2,%" OR mystring LIKE
"%,2" OR mystring = "2")
Performance will be terrible if this grows much but for a trivial
implementation it should work.
Dan
On 11/4/06, David T. Ashley <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm a little bit lost on MyS
Hi,
I'm a little bit lost on MySQL statements.
I am implementing a many:many relationship using a string (wrong way, I
know, but I'm trying to keep the design simple and this is a trivial
application).
In a VARCHAR field, I will store a comma-delimited set of integers
corresponding to the indic
On 8/7/06, James Tu <[EMAIL PROTECTED]> wrote:
If I create a table for each user (I can potentially have hundreds of
thousands of users), will MySQL be able to handle this?
If I just have one table, I could potentially have millions of
records in one table. Will MySQL be able to handle this?
On 8/6/06, Chris W <[EMAIL PROTECTED]> wrote:
David T. Ashley wrote:
> Can I just write something like:
>
> SELECT * FROM mytable WHERE fieldofinterest field2) ASC;
I think this will work..
SELECT *, IF(a-b < 0,a, b) as SortField
FROM table
WHERE whatever
ORDER BY SortFiel
Hi,
I have a table and I'd like to do a SELECT query with the result ordered by
the minimum of two fields. I might also like to query by the minimum (but
that is an easier problem, as I can just rephrase it as an OR).
Can I just write something like:
SELECT * FROM mytable WHERE fieldofinterest
Nigel wrote:
> mod_php will persist the MySQL connection holding open any lock or
> syncronisation token obtained through any of the three methods :
> begin/commit, lock/unlock tables or get_lock/release_lock. PHP does
> ensure that even in the event of timeouts or fatal errors any shutdown
>
Nigel wrote:
> If you can't or won't do this properly by using a transactional table
> and begin/commit at least look at using get_lock() based guard
> conditions which only lock a string leaving the database accessable.
> Whatever you do if you client is php install a shutdown handler to clean
>
Hi,
I'm doing a PHP application, and there are just a few instances where I need
to do atomic operations on more than one table at a time and I can't express
what I want to do as a single SQL statement.
What I'm trying to guard against, naturally, is race conditions when more
than one process is
I'm using PHP, and I sometimes INSERT new records in a table. MySQL assigns
a new autoincrement int field on each INSERT ... nothing surprising there.
It goes 1, 2, 3, etc.
What query can I use to find out what value this int autoincrement assigned
field was? I could of course SELECT based on wh
There is a technique called "unit cancellation" that may serve you well.
The technique is essentially to treat each unit as an orthogonal vector
(orthogonal to all other units), so one unit can't be mixed with any other
unit.
The only way to convert is to multiply by various forms of "1". "1" is
> I am slowly considering leaving GoDaddy, who has a very good bandwidth and
> ok tech support (I have seen better but much much worse) and acceptable
> prices, but unfortunately does not support MySQL 5 and PHP 5 either.
SNIP
> Who think we could make them make the right move and pretty quickly?
Hi,
I'm a beginning MySQL user ...
I have a table of log entries. Over time, the entries could grow to be
numerous. I'm like to trim them to a reasonable number.
Is there a query that will, say, trim a table down to a million rows (with
some sort order, of course, as I'm interested in deleting
to reach length three on each number, i.e.
192.168.0.10 would become "19216810".
b)Store the IP as a 64-bit integer.
I think MySQL will key on strings, right?
Dave.
-------
David T. Ashley ([EMAIL PROTECTED])
Thousand Feet Consulting, LLC
--
MySQL Gene
On Tue, February 7, 2006 10:46 am, [EMAIL PROTECTED] wrote:
> "David T. Ashley" <[EMAIL PROTECTED]> wrote on 07/02/2006 14:03:04:
>
>> a)Will MySQL allow joins that involve more than two tables (in my case,
>> perhaps as many as 5)?
>>
>> b)Can limits
Thanks for your
patience.
-----------
David T. Ashley ([EMAIL PROTECTED])
Thousand Feet Consulting, LLC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n the integer field reaches 2^32-1 or whatever the upper limit is, what
happens then? Will it try to reuse available values from records that
have been deleted? Or is it always an error?
Thanks, Dave.
---
David T. Ashley ([EMAIL PROTECTED])
Thousand Feet Consulting
80 matches
Mail list logo