;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 ref
> -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 h
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
tion e)
{
e.printStackTrace();
System.out.println("Error "+e.getMessage());
}
-
-note: i added the connector/j.jar to the classpath environment variable
-Is the connector/J version must be consistent with the jdk version?
-i consume more time to solv
On Nov 12, 2007 9:22 AM, Afan Pasalic <[EMAIL PROTECTED]> wrote:
> If you have to deal with it again consider using a bunch of unions
> instead of the 'IN'. Not prettiest thing, but it should fix your
> performance issue.
> Could you please give me more details about your statement that mysql dea
at uses a MySQL database. The following query
> >> is extremely slow and I've been battling for a couple of days on an off
> >> to try and get a combination of indexes to optimise it. Any help would
> >> be greatly appreciated.
> >>
> >>
> >&g
a combination of indexes to optimise it. Any help would
be greatly appreciated.
select household_d.id, household_d.ad_type, household_d.ad_catid,
household_d.ad_renewed, household_d.ad_userid,
household_d.ad_trade, household_d.price,
SUBSTRING(household_d.description, 1, 301
On Nov 8, 2007 4:08 PM, Stut <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I've inherited a PHP app that uses a MySQL database. The following query
> is extremely slow and I've been battling for a couple of days on an off
> to try and get a combination of indexes to o
Hi all,
I've inherited a PHP app that uses a MySQL database. The following query
is extremely slow and I've been battling for a couple of days on an off
to try and get a combination of indexes to optimise it. Any help would
be greatly appreciated.
select household_d.id, household
Guys, just wanted to thank you again for helping me with
the sql statement that I needed. I was able to sorted using
php and I was able to display the correct result.
Thanks again!!1
Nestor :-)
On Nov 6, 2007 7:37 AM, Néstor <[EMAIL PROTECTED]> wrote:
> You guys are correct, that is exactly wh
- Original Message -
From: "Russell E Glaue" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, November 06, 2007 8:55 PM
Subject: Re: Please help to solve a serios problem
>
> The mysql.sock location '/var/lib/mysql/mysql.sock' att
>>> From: Ali Nebi <[EMAIL PROTECTED]>
>>> Sent: Nov 6, 2007 9:24 AM
>>> To: mysql@lists.mysql.com
>>> Subject: Please help to solve a serios problem
>>>
>>> Hi, i need of help for a serios problem.
>>>
>>> We have ins
t runs mysql.
>
>
>
>
> -Original Message-
> >From: Ali Nebi <[EMAIL PROTECTED]>
> >Sent: Nov 6, 2007 9:24 AM
> >To: mysql@lists.mysql.com
> >Subject: Please help to solve a serios problem
> >
> >Hi, i need of help for a serios problem.
> >
> >
You guys are correct, that is exactly what happened.
I must thing of this in the future.
At this moment I have a lot of other projects to take care, that it is
eaiser for me to read the information into an associative array with
the columns and the values and sort the array and then print the
top
6, 2007 9:24 AM
>To: mysql@lists.mysql.com
>Subject: Please help to solve a serios problem
>
>Hi, i need of help for a serios problem.
>
>We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
>5, x86.
>
>Our problem is this.
>We get this message
Hi, i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5, x86.
Our problem is this.
We get this message in the log:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (
--- [EMAIL PROTECTED] wrote:
> Néstor wrote:
>
> I think you'd best begin by normalising your
> database. Something along
> these lines:
>
very true indeed, that would save you major headaches
when right after finishing the demo, someone would
say, "can we add a 18 gallon pledge? what about
Néstor wrote:
I can do simple select statements but I need your brains to create query
statment.
I am using mysql 4.0 in my 1and1 site.
I have a table that has 8 fields, one is the "agency" field and the other 7
are
*tip* values on saving water and the value of this field is either 0 or an
amoun
Enrique that is pretty good and close to what I need.
On top of what you have generously provide, I guess I can just put
each gallon field into an array an then sort the array to display the
first 5 gallon fields per agency. Is there an easier way?
Thanks,
Nestor :-)
On 11/5/07, Enrique Sanche
--- Enrique Sanchez Vela <[EMAIL PROTECTED]>
wrote:
> Date: Mon, 5 Nov 2007 15:01:59 -0800 (PST)
> From: Enrique Sanchez Vela <[EMAIL PROTECTED]>
> Subject: Re: Need help creating query statement
> To: Néstor <[EMAIL PROTECTED]>
>
>
> --- Néstor <
I have a table with about 9 fields, and record ID field an
agency name field and the # of gallons that a erson pledges to save:
--
|ID| agency| 5g | 8g | 10g | 12g | 15g | 18g | 20g |
---
I can do simple select statements but I need your brains to create query
statment.
I am using mysql 4.0 in my 1and1 site.
I have a table that has 8 fields, one is the "agency" field and the other 7
are
*tip* values on saving water and the value of this field is either 0 or an
amount.
-
Imran wrote:
Hello all:
> ...
I would like to get all of the records in MenuOptions and any record in
MenuAccess with a specific fkGroupid. For example:
...
>
IIf I run a query for fkgroupid = 1 I should get
AccessId fkMenuID fkgroupid view execute
Me
Customer Maintenence
Null Null Null Null
Null 3 Reports
Any help will be appreciated.
Thanks
NULL)
Thanks for the hints, you who gave them.. ;)
Anders.
> - Original Message -
> From: "Anders Norrbring" <[EMAIL PROTECTED]>
> To:
> Sent: Sunday, October 14, 2007 7:13 AM
> Subject: Help with query...
>
>
> > I'm trying to set up a
Anders Norrbring wrote:
I'm trying to set up a query, but I don't really get the result I
expected, so can someone please help me out here?
The query I've built is this:
SELECT a1.username FROM accountuser AS a1
LEFT JOIN (freeaccounts AS f1, payments AS p1)
ON (a1.username =
I'm trying to set up a query, but I don't really get the result I
expected, so can someone please help me out here?
The query I've built is this:
SELECT a1.username FROM accountuser AS a1
LEFT JOIN (freeaccounts AS f1, payments AS p1)
ON (a1.username = p1.username
AND p1.usernam
Oh, and here's the output (Sorry):
+---+-+
| releaseid | name|
+---+-+
| 1 | Unspecified |
| 2 | Next Patch |
| 3 | LOCset |
| 4 | Abashiri|
|
Here's my full test solution:
use test;
drop table if exists releases;
create temporary table releases
(
releaseid int(10) unsigned not null auto_increment primary key,
name varchar(255)
)engine=myisam;
insert into releases ( name ) values
( 'Unspecified' ),
( 'Next Patch' ),
(
> -Original Message-
> From: Jay Pipes [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 12, 2007 2:07 PM
> To: Daevid Vincent
> Cc: mysql@lists.mysql.com
> Subject: Re: Need help with a "natural sort order" for
> version numbers and release code
Daevid Vincent wrote:
I'm trying to get some 'release/version numbers' to sort properly.
mysql> SELECT ReleaseID, Name FROM releases ORDER BY Name DESC;
+---+-+
| ReleaseID | Name|
+---+-+
|18 | Unspecifie
I'm trying to get some 'release/version numbers' to sort properly.
mysql> SELECT ReleaseID, Name FROM releases ORDER BY Name DESC;
+---+-+
| ReleaseID | Name|
+---+-+
|18 | Unspecified |
|20
syntax to use near 'CONSTRAINT
FK_WorksOn_Users FOREIGN KEY
(
UserID
) REFERENCES TimeTracke' at line 8
what to do if this error comes plz anyone help me
--
View this message in context:
http://www.nabble.com/small-help-tf4532644.html#a12935164
Sent from
MySQL's regex library doesn't have all those Perl features. You can use
the pcre-compatible extension from http://www.xcdsql.org/MySQL/UDF/, or
just use two clauses in the WHERE: one should be
col NOT RLIKE "linux$"
Baron
Tang, Jasmine wrote:
Hi,
I need to match anything that start with "
I have the following horrible sql. I need one result that has all the
data in one row. I am currently using 3 sub queries and figure it must
be a better way...
SELECT 'FS_DEV',
ifnull(a.severity, 0) AS aseverity,
ifnull(a.
Hi,
I need to match anything that start with "foo" then followed by a string
containing letter/number/underscore/dot but NOT end with the string
"linux". When I use the pattern 'foo[(a-z|0-9|_|.)]+(?!linux)' , I got
"ERROR 1139 (42000): Got error 'repetition-operator operand invalid'
from regexp
Dimitar Vasilev wrote:
Hi Shawn,
Thanks for your response.
I'm trying to assign uniquely a user id per share holder within the whole
list, not within each company.
Suppose we have a person John Smith that holds shares both in MonkeyBusiness
and NoSuchThing.
I'd like to give him an id that is the
2007/9/22, Shawn Green <[EMAIL PROTECTED]>:
>
> Hello Dimitar,
>
> Dimitar Vasilev wrote:
> > Hi all,
> > I have a table shares that consists of
> > company id, shareholder id, shareholder name.
> > Company id and shareholder id are decimal digits; shareholder name is
> text.
> > Due to some missin
Hello Dimitar,
Dimitar Vasilev wrote:
Hi all,
I have a table shares that consists of
company id, shareholder id, shareholder name.
Company id and shareholder id are decimal digits; shareholder name is text.
Due to some missings of my initial data, I'd like to create a unique id for
the sharehold
Hi all,
I have a table shares that consists of
company id, shareholder id, shareholder name.
Company id and shareholder id are decimal digits; shareholder name is text.
Due to some missings of my initial data, I'd like to create a unique id for
the shareholder ids
which are blank/null in the import
Thing 1: your auto_increment key MUST be your primary key.
Thing 2: the timestamp field will be updated with the current epochal
timestamp which only increments every second.. as you have a
timestamp field as you primary (and therefore unique) key, you will
never be able to perform more than on
Hi ,
I think i might have hit a bug, posted on forums.mysql.com but
apparently nobody really reads that i think.
my table:
CREATE TABLE `clog` ( `cID` int(20) NOT NULL auto_increment, `lID`
int(10) default NULL, `ip` int(10) default NULL, `timestamp` int(11) NOT
NULL, PRIMARY KEY (`clickID`
Hi all!
I need some help with ORDER BY in the following example. I want to order by
selected category, then by subcategories of the selected category, then by
categories with the same parent_id of the selected category, then by random
if possible, or random within the categories if possible, but
Thanks for the help i have got it correct.
--
View this message in context:
http://www.nabble.com/seoparator-help-tf4316769.html#a12568601
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
,000.00 |
> +---+
> 1 row in set (0.00 sec)
>
> Cheers,
>
> Andrew
>
> -Original Message-
> From: coolcoder [mailto:[EMAIL PROTECTED]
> Sent: Thu, 23 August 2007 11:55
> To: mysql@lists.mysql.com
> Subject: seoparator help
>
>
000.00 |
+---+
1 row in set (0.00 sec)
Cheers,
Andrew
-Original Message-
From: coolcoder [mailto:[EMAIL PROTECTED]
Sent: Thu, 23 August 2007 11:55
To: mysql@lists.mysql.com
Subject: seoparator help
Was wondering if anyone could help me with this little problem I'm
having.
decimal places
number_format($fieldvalue, 2)
Regards
Terry
http://booksihaveread.awardspace.co.uk
- Original Message -
> *From:* coolcoder <[EMAIL PROTECTED]>
> *To:* mysql@lists.mysql.com
> *Date:* Thu, 23 Aug 2007 03:55:27 -0700 (PDT)
>
> Was wondering if anyo
Was wondering if anyone could help me with this little problem I'm having.
I'd like to have a comma separator after every 3 digits. E.g "3,000,000".
How would i go about this?
www.coderewind.com
Best Place to hunt for Code
--
View this message in context:
http://www.n
Martijn Tonies schrieb:
> Hi,
>
>> I have a rather basic problem I would be glad to get some help:
>> What I intend to do is:
>> - create a person-list
>> - create a buddy-list
>> each entry in the person-list can have 0 to many buddies
>> - when
Hi,
> I have a rather basic problem I would be glad to get some help:
> What I intend to do is:
> - create a person-list
> - create a buddy-list
> each entry in the person-list can have 0 to many buddies
> - when an entry in the person-list is deleted, I would like to
>
hi there,
I have a rather basic problem I would be glad to get some help:
What I intend to do is:
- create a person-list
- create a buddy-list
each entry in the person-list can have 0 to many buddies
- when an entry in the person-list is deleted, I would like to
have correspnding entries in
I am unable to connect to mysql 5.1 with phpmyadmin 2.10.2 on win2k running
php 5.2.3.
I get the following errors:-
Event viewer:-
Event Type: Information
Event Source: Application Popup
Event Category: None
Application popup: httpd.exe - Entry Point Not Found : The procedure entry
point mysql_
character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
> +--++
> 8 rows in set (0.00 sec)
>
> Operating system is FreeBSD 6.2.
> MySQL 5.0
>
>
> Another question: Is there any way to optimize the L
6.2.
MySQL 5.0
Another question: Is there any way to optimize the LIKE or is there any fast
method to select a column based on starting with a given character?
Thanks for your kind help!
--
Thanks!
BR / vj
On 8/13/07, Dan Buettner <[EMAIL PROTECTED]> wrote:
>
> Michael, it looks to me like your root partition is absolutely 100% chock
> full. Am I misunderstanding your request for help? Sounds like you are
> saying you think you have nothing in that partition - but your 'df -
Michael, it looks to me like your root partition is absolutely 100% chock
full. Am I misunderstanding your request for help? Sounds like you are
saying you think you have nothing in that partition - but your 'df -h'
command is showing 0 bytes available in /.
Dan
On 8/13/07, Micha
need assistance..i think the package is
failing because it is not reading lvm properly.
I have removed the mysql package and now i can not re-install it on the
partition...i would appriciate any help offered.
thanks
mjh
-+
8 rows in set (0.00 sec)
Operating system is FreeBSD 6.2.
MySQL 5.0
Another question: Is there any way to optimize the LIKE or is there any fast
method to select a column based on starting with a given character?
Thanks for your kind help!
--
Thanks!
BR / vj
---
+
8 rows in set (0.00 sec)
Operating system is FreeBSD 6.2.
MySQL 5.0
Another question: Is there any way to optimize the LIKE or is there any fast
method to select a column based on starting with a given character?
Thanks for your kind help!
--
MySQL General Mailing List
Fo
ny way to optimize the LIKE or is there any fast
method to select a column based on starting with a given character?
Thanks for your kind help!
--
Thanks!
BR / vj
On Mon, 2007-07-30 at 10:06 -0500, Brian E Boothe wrote:
> hi all
> i have a pretty extensive Project Going on and it would be nice to get
> some input on my tables and joins schema, i'd like to send someone my
> SQL as for them to help me
> thru the rough spots if th
hi all
i have a pretty extensive Project Going on and it would be nice to get
some input on my tables and joins schema, i'd like to send someone my
SQL as for them to help me
thru the rough spots if they could, or i could post the enitre SQL here
for u to use, please someone respond
Hello,
I need some advice for setting up a mysql database (debian etch) to
store many blobs (about 1 GB) . I run a HP DL 360 (?), 1 GB RAM,
RAID 5, 10K disks, 30 GB and the standard installation of mysql
coming with debian etch (5.0.32, readline 5.2)
I need only one database (innodb) with 1 t
> On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote:
> >mysql>
> >
> >mysql> \R shell>
> >PROMPT set to 'shell>'
> >
> >shell>
It doesn't matter what the prompt says, it's still mysql you're
running here. When people say "the shell prompt" they don't mean
"make your prompt say the word shell", they
server. I discovered my web
server only takes .sql files for the database in the
PHPadmin thing. So I'm hoping it'll work out.
Thank you all for the help. I'd never figured out if
everybody didn't provide the steps to get there! :)
Lillian
--- Gary Josack <[EMAIL PROTECTED]&g
alf way
down the page)
Ben Wiechman
-Original Message-
From: Gary Josack [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 24, 2007 6:50 AM
To: Red Hope
Cc: mysql@lists.mysql.com
Subject: Re: mysql dump help!
Red Hope wrote:
> I'm curious about one thing. When I go into MySQL
>
ds end with ;
or \g.
Your MySQL connection id is 9
Server version: 5.0.41-community-nt-log MySQL
Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear
the buffer.
mysql>
mysql> quit
Bye
D:\lillian>mysqldump -u root -ppassword test >
test.sql;
is an application (.exe
> file) not a sql
> command, ie
>
> Welcome to the MySQL monitor. Commands end with ;
> or \g.
> Your MySQL connection id is 9
> Server version: 5.0.41-community-nt-log MySQL
> Community Edition (GPL)
>
> Type 'help
mmands end with ;
> or \g.
> Your MySQL connection id is 9
> Server version: 5.0.41-community-nt-log MySQL
> Community Edition (GPL)
>
> Type 'help;' or '\h' for help. Type '\c' to clear
&g
I cut and pasted what you typed and just altered the
password. It didn't like it all. Same error again. If
I put any command in without the ";" at the end then
I'll get locked into this "->" thingy unless I clear
out. I can't guess why it won't take it.
Lillian
--- Ananda Kumar <[EMAIL PROTECTED
the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.41-community-nt-log MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
mysql> quit
Bye
D:\lillia
try this
mysqldump -u root -ppassword --database test > test.sql
On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote:
Hey y'all,
I use charming Windows XP on here. I've taken database
classes but lucky for me we never used *real* MySQL.
Below I typed up exactly what I put into the MySQL
prompt and
Hey y'all,
I use charming Windows XP on here. I've taken database
classes but lucky for me we never used *real* MySQL.
Below I typed up exactly what I put into the MySQL
prompt and this is what it kicks back to me.
Lillian
mysql>
mysql> \R shell>
PROMPT set to 'shell>'
shell>
shell>mysqldu
I think we are daling with a windows user, who are not
that familiar with a command prompt. Correct me if
i'm wrong. How to get to a point where you would be
able to execute a mysqldump, will depend on what OS
you are running, and how you installed MySQL.
On Tue, July 24, 2007 04:41, Carlos Proal
n't use the
> semicolons.
Hmmm, try \q before typing mysqldump ;^)
>
> Any help would be awesome!
> Thank you,
> Lillian
>
> Tried & Wrong
> mysqldump -u root -ppassword test > test.sql
> mys
Can you email us the complete command and the error ?
Carlos
Red Hope wrote:
Well, that went over my head. :) I understand what
you're telling me, how to get there, but not how to do
it. bleh.
When I start up MySQL Command Line Client, I'm always
prompted at "mysql>". So I told it to swi
nsole, KDE
> Konsole or Windows
> CommandPrompt from the different menus on your
> operating system
>
> If the mysql directory is on your PATH you can use
> mysqldump anywhere,
> if not, move to the mysql/bin directory and then you
> can run it without
> any problem.
>
e,
if not, move to the mysql/bin directory and then you can run it without
any problem.
Hope that help.
Carlos
Red Hope wrote:
Oh boy, and here's the big stupid question. How do I
get to the shell prompt? Sorry! Yea, I'm that newbie.
:)
Thank you,
Lillian
--- Carlos Proal <[
gt; tried
> > so hard to get it to dump my files into .sql
> format
> > but my syntax is wrong, wrong, wrong. lol
> >
> > I put below examples what I've been entering to
> get my
> > databases backed up. I always get an error or I
> get
> > loc
ySQL 5.0.41 and I have tried
so hard to get it to dump my files into .sql format
but my syntax is wrong, wrong, wrong. lol
I put below examples what I've been entering to get my
databases backed up. I always get an error or I get
locked into the "->" thing if I don't us
backed up. I always get an error or I get
locked into the "->" thing if I don't use the
semicolons.
Any help would be awesome!
Thank you,
Lillian
Tried & Wrong
mysqldump -u root -ppassword test > test.sql
mysqldump -u root -ppassword test > test.sql;
mysqldu
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
ItemTag.ItemID = Item.ProductID;
but I'm not sure how to go about it. Can anyone help?
Thanks
Mark
--
Yoge,
AdventNet, Inc.
925-965-6528
[EMAIL PROTECTED]
site24x7.com
--
MySQL General Mailing List
For list archives: http://l
The following query should work if I understand what you're attempting
correctly. Use at your own risk though ;)
DELETE FROM Item USING Item, ItemTag WHERE ItemTag.ItemID =
Item.ProductID AND ItemTag.TagID = '168';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi.
On Thursday 05 July 2007 17:35, you wrote:
> > I want to delete from the 'Item' table
> > all the items identified by the folowing query:
>
> If you have MySQL 5+, you can do it using a sub-query:
>
> DELETE FROM
> Item
> WHERE
> ProductID IN (
> SELECT
> Item.ProductID
> FROM
> It
> I want to delete from the 'Item' table
> all the items identified by the folowing query:
If you have MySQL 5+, you can do it using a sub-query:
DELETE FROM
Item
WHERE
ProductID IN (
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
ItemTag.Ite
Hi
I want to delete from the 'Item' table all the items identified by the
folowing query:
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
ItemTag.ItemID = Item.ProductID;
but I'm not sure how to go about it. Can a
Rich Brant schrieb:
> Is there anyway to prevent the temporary and filesort?
>
> SELECT
> t1.sourceID as sourceID,
> count(t1.sourceID) as clicks,
> [...]
> ORDER BY clicks desc, conversions desc;
>
> When using EXPLAIN:
>
> [...] Using where; Using temporary; Using filesort
On 6/29/07, Rich Brant <[EMAIL PROTECTED]> wrote:
Hello all. I'm looking for help with the query below. Is there anyway
to prevent the temporary and filesort?
The filesort is caused by either the ORDER BY or the GROUP BY. There
are sections in the manual about how to get it to
tp://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html about
mysqleers comments.
Thanks
ViSolve DB Team.
- Original Message -
From: "Nilnandan" <[EMAIL PROTECTED]>
To:
Sent: Monday, July 02, 2007 3:58 PM
Subject: Re: Frequently MyISAM TABLE corruption.
Found block with too small length at
967177484; Skipped |
| DB1.tables1 | repair | warning | Number of rows changed from 186252 to
186251|
| DB1.tables1 | repair | status | OK
|
+--++--+-
Rich Brant wrote:
Hello all. I'm looking for help with the query below. Is there anyway
to prevent the temporary and filesort? I've tried about as many
combinations as I could think of, but can't seem to prevent it. I'm
sure that's the reason, when run on a table o
Hello all. I'm looking for help with the query below. Is there anyway
to prevent the temporary and filesort? I've tried about as many
combinations as I could think of, but can't seem to prevent it. I'm
sure that's the reason, when run on a table of around 750k records,
or data conversions. the config__
tables are
used to interpret the blob in the data__ProcessedDataFrames table
Thanks again for the help.
Relevant data might include the actual schema for your tables, (DESC
does not inform us about what indexes you have or what table types
you
are using) and
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
I do, but I don't see any way around that with the data I have.
Dave G.
> Good Afternoon David
>
> sounds as if you have a number of non-unique indices (even possibly FTS!)
> slowing down queries..this should help you concentrate on the slower
> indices
> mysql>
>
t_name)
ON E.product_id = D.product_id
WHERE E.element_id=id
GROUP BY product_id;
toString is a UDF I wrote for data conversions. the config__ tables are
used to interpret the blob in the data__ProcessedDataFrames table
Thanks again for the help.
> Relevant data
Good Afternoon David
sounds as if you have a number of non-unique indices (even possibly FTS!)
slowing down queries..this should help you concentrate on the slower indices
mysql>
select TABLE_NAME,COLUMN_NAME,INDEX_NAME from INFORMATION_SCHEMA.STATISTICS
where NON_UNIQUE=1;
Anyone e
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
ultiple tables, for
specific top_level_product_name, with in some time range (using p_time).
Any help would be appreciated. I will happily give more information if
you need to offer an educated opinion.
Thanks
David Godsey
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Login to mysql
Perform this on the table
ALTER TABLE tbl-name MODIFY COLUMN Rating varchar(10);
Then recreate the ODBC link in OpenOffice
Give it a try.
Colleen Beamer <[EMAIL PROTECTED]> wrote:
Hi,
I apologize for posting here, because I only use MySQL at a very basic
level
901 - 1000 of 7359 matches
Mail list logo