Description:
I am using MySQL server as backend database supporting a telecomm platform
providing voice over ip services.
tables involved: acc, cdr, account, location2
Partial processing flow:
1. When a phone call is started. A record will be inserted into table acc
(method=INVITE). This will
Hi!
I have a SQL query construction question that I hope someone can help
me with. After comparing a bunch of DNA fragments (see name below) with
a larger reference sequence I get a ordered list ranked according to
similarities, and with start/stop co-ordinates where the fragments map
to the
-Original Message-
From: Marcus Claesson [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 7:49 AM
To: mysql@lists.mysql.com
Subject: Help with SQL query construction
Hi!
I have a SQL query construction question that I hope someone can help
me with. After comparing a
Marcus,
I've managed to do this with a Perl-DBI script, but
would much prefer to do it completely with MySQL instead.
You could port it to a recursive stored procedure. It would probably be
slower, and what would you have gained?
PB
Marcus Claesson wrote:
Hi!
I have a SQL query
Hi,
this Thursday, Sergey Petrunia will give a MySQL University session on:
Interaction Between Optimizer and Storage Engine
Please register for this session by filling in your name on the session
Wiki page that you can find here:
On Nov 29, 2007 4:34 AM, Adam Lipscombe [EMAIL PROTECTED] wrote:
Folks
How can one conditionally drop an index in MySQL?
Googling shows that the drop index does not support an if exists
qualifier - apparently a bug
has been raised but as far as I know its not fixed yet.
Does anyone know
You may want to check to see if the index exists first.
Just query the table INFORMATION_SCHEMA.STATISTICS:
SELECT COUNT(1) FROM INFORMATION_SCHEMA.STATISTICS
WHERE table_schema = 'given schema'
AND table_name = 'given table name'
AND index_name = 'given index name';
This returns the number of
I actually suggested that last night, and thought better of it because
the alter ignore was so much simpler...
On Dec 3, 2007 11:18 AM, Rolando Edwards [EMAIL PROTECTED] wrote:
You may want to check to see if the index exists first.
Just query the table INFORMATION_SCHEMA.STATISTICS:
SELECT
I started to take this but gave up, here's a few suggestions:
1. you have questions that need a none option
2. NEVER make the questions mandatory. like #32. I don't give a shit about
most of those things, but you force me to check '1' for all of them. that's
wasting my time.
3. how many damn
It occurs to me that this sounds very much like my experience the last
couple of times I tried to take the survey... As a long-time user of
MySQL, I want to make my contribution, but this survey is a dog's
breakfast every time. Perhaps someone at AB might take notice this
round and try to fix
hi friends,
i searched on google but not file a solution.
is there a way that i can store special characters (return, new line, tab,
etc) into mysql (ver. 4.1.12) table with text type?
i use textarea tag for user to enter the text.
my goal is to store/display EXACTLY what user entered in
Hi,
And, what's up with the vertical white lines on dark blue background as
a section divider?
My eyes actually hurt looking at the survey page. It makes it *very*
difficult to read the questions.
Regards,
Jeremy
Daevid Vincent wrote:
I started to take this but gave up, here's a few
I just finished it. There were 56 questions, not counting the final
give us your name stuff for the prize. Most of the questions were
mandatory.
This seems to be a fill out the form type of survey system rather than
a self-adjusting system based on the answers to your previous questions.
You need to escape the data read from the form. I'm sure that whatever
programming language you are using has some function to do this.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
At 13:19 -0800 3/12/07, Jeremy Cole wrote:
I just finished it. There were 56 questions, not counting the final
give us your name stuff for the prize. Most of the questions were
mandatory.
This seems to be a fill out the form type of survey system rather
than a self-adjusting system based
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 decent forum system based
on MySQL and PHP, but there's no
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 decent
Well, there was some other parameters with a special XDHFSKL324234234
style code at the end, which I figured was tied to me directly somehow, so I
didn't want to post that -- for exactly this reason below. *wink*
The survey was emailed to us.
-Original Message-
From: Chris Sansom
18 matches
Mail list logo