Am 30.11.2011 03:13, schrieb Karen Abgarian:
The concept is not difficult to explain. Most people do not expect a gas
tank
to shrink once the gas is consumed...right?
yes, but the hard-disk is the gas tank and the data are the gas
and yes, normally everybody would expect after deleting
2011/11/29 23:19 +0100, Reindl Harald
MY only luck is that i recognized this years ago after PLAYING
with innodb and so i started with innodb_file_per_table=1 from
the begin with the first production database
And are then the table-files in the directories with frm, or in the
directory
Am 30.11.2011 07:02, schrieb Hal?sz S?ndor:
2011/11/29 23:19 +0100, Reindl Harald
MY only luck is that i recognized this years ago after PLAYING
with innodb and so i started with innodb_file_per_table=1 from
the begin with the first production database
And are then the table-files in the
Am 29.11.2011 14:08, schrieb Luis Pugoy:
Hello. I have the following problem.
I was importing a large database to mysql using mysqldump. Unfortunately this
filled up the whole disk, and
mysqldump exited with an error that the table it is currently writing to is
full. Checking df -h it
On 29.11.2011, at 5:21, Reindl Harald wrote:
ibdata1 does NEVER get smaller, this is normal and a hughe problem
in your case, only if you are using innodb_file_per_table which
is NOT default would retire the space after drop tables
why is this dumb innodb_file_per_table=0 default since
This is not to say that MySQL could not have more of the file management
features. For example, the ability to add or remove datafiles on the fly
and the
ability to detach tablespaces as collections of tables.
That's where MySQL(read InnoDB) got stuck actually, it never introduced a
Am 29.11.2011 20:25, schrieb Karen Abgarian:
On 29.11.2011, at 5:21, Reindl Harald wrote:
why is this dumb innodb_file_per_table=0 default since MOST PEOPLE
have only troubles with it because they can not free space with
optimize table with no real benefits?
The logic behind this is
Hi... there is stuff inline there.
The logic behind this is probably that without innodb_file_per_table=1
and with several large ibdata files, the space IS freed up when one does
optimize table or drop table. The space is freed up inside the database
files and can be reused.
well,
On Nov 29, 2011, at 11:50 AM, Claudio Nanni wrote:
This is not to say that MySQL could not have more of the file management
features. For example, the ability to add or remove datafiles on the fly and
the
ability to detach tablespaces as collections of tables.
That's where MySQL(read
Am 30.11.2011 01:11, schrieb Karen Abgarian:
MY only luck is that i recognized this years ago after PLAYING
with innodb and so i started with innodb_file_per_table=1 from
the begin with the first production database
Well, I would not base my database design on luck and playing. There
Hi... and some more stuff inline.
Well, I would not base my database design on luck and playing. There
should be good awareness
of what the features do and what would be the plan to deal with file
allocations should the database
grow, shrink or somerset
if you are working many
Pito,
can u show us the innodb parameters in the my.cnf file.
regards
anandkl
On Sat, Jan 8, 2011 at 10:31 PM, Pito Salas r...@salas.com wrote:
I am very new to trying to solve a problem like this and have searched
and searched the web for a useful troubleshooting guide but I am
honestly
How about this?
SELECT
`first_table`.`names`
, `first_table`.`version`
, (SELECT
COUNT(`other_table`.`names`)
FROM `other_table`
WHERE `other_table`.`this_id` = `first_table`.`id`) AS 'count'
FROM `first_table`
WHERE
Thanks! That did it perfectly!
Michael
On Jun 3, 2010, at 11:45 AM, Steven Staples wrote:
How about this?
SELECT
`first_table`.`names`
, `first_table`.`version`
, (SELECT
COUNT(`other_table`.`names`)
FROM `other_table`
WHERE
...@astroh.org]
Sent: June 3, 2010 11:55 AM
To: Steven Staples
Cc: 'MySql'
Subject: Re: Help needed on query on multiple tables
Thanks! That did it perfectly!
Michael
On Jun 3, 2010, at 11:45 AM, Steven Staples wrote:
How about this?
SELECT
`first_table`.`names
, 2008 11:43 PM
Subject: RE: Help needed
Your best bet would be to use a UUID:
SELECT UUID();
+--+
| uuid() |
+--+
| c712dc72-718d-102b-b3c8-97395a1766b9
: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: Velen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 13, 2008 11:28 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Help needed
Hi Jerry,
Thanks for the tip.
What is UUID
- Original Message -
From: Arthur Fuller
To: Velen
Sent: Saturday, May 10, 2008 10:44 PM
Subject: Re: Help needed
On my main machine the PCID is 135184-45-4-10-1513-1.
Hope it helps.
Arthur
On Sat, May 10, 2008 at 12:59 PM, Velen [EMAIL PROTECTED] wrote:
Hi
PROTECTED]
Sent: Monday, May 12, 2008 8:32 AM
To: Arthur Fuller
Cc: mysql@lists.mysql.com
Subject: Re: Help needed
Hi Arthur,
Could you please tell this guy that it was not a virus and you tested it
without any problem?
Thanks.
Velen
On Sat, 2008-05-10 at 20:59 +0400, Velen wrote:
Hi,
I'm
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 12, 2008 11:59 AM
To: mysql@lists.mysql.com
Subject: RE: Help needed
Sorry, you can't prove uniqueness by running it against a hundred
thousand, million, or even a billion computers. (The billionth-and-first
computer could be the one with the non-unique
I tested the program before running it and it is virus-clean. I ran it
through AVG first and it's clean. I ran it in Windows. I don't know whether
there is a Linux version.
Arthur
On Mon, May 12, 2008 at 11:31 AM, Velen [EMAIL PROTECTED] wrote:
Hi Arthur,
Could you please tell this guy that
On Mon, May 12, 2008 at 8:31 AM, Velen [EMAIL PROTECTED] wrote:
Hi Arthur,
Could you please tell this guy that it was not a virus and you tested it
without any problem?
One guy that is brave/crazy/stupid enough to run a binary on his machine
that didn't have anything bad happen to him does
On Sat, 2008-05-10 at 20:59 +0400, Velen wrote:
Hi,
I'm testing a program and I need you assistance.
Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program.
Please supply a Linux version of your virus so I can test.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Hi all,
You can read this article, written by a SUN benchmarking guru (hi
Dimitri :) ).
Best regards.
Web link : http://dimitrik.free.fr/db_STRESS_BMK_Part2_ZFS.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi [EMAIL PROTECTED] wrote:
The problem I have is that importing the same 7 MB sql dump
takes 9 seconds if engine=Myisam and 98 when engine is Innodb.
Is autocommit turned off?
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
When importing
Il Wednesday 09 April 2008 19:40:32 Rob Wultsch ha scritto:
On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi [EMAIL PROTECTED] wrote:
The problem I have is that importing the same 7 MB sql dump
takes 9 seconds if engine=Myisam and 98 when engine is Innodb.
Is autocommit turned off?
Nicholas Wyatt wrote:
Hello to all!
has anybody got any ideas how i can speed up the following query?
it's so awfully slow (about 1 second).
the test_item table is the main problem. currently, it has
about 108.000 entries.
is it normal that it takes so long? and if it isn't, how can i
[ always cc the list so others can share the fix or make appropriate
comments ]
Nicholas Wyatt wrote:
hi chris,
thanks for answering! however, i do already have indexes on those
columns. all my tables use the myisam storage engine. what are the
differences you mentioned between these engines
On 8/19/06, balaraju mandala [EMAIL PROTECTED] wrote:
Hi Everybody,
I need small help from you. In my Linux box i have limitation of Size in
partition. I have only 5 GB space for /var. MySQL is installed in this
partition only. I want to give another path like /home, where i have 120GB
of
Hello,
You can change the MySQL data path in /etc/my.cnf by editing the
configuration parameter datadir with new data path. Once you done the
changes in my.cnf, reboot the MySQL server.
Thanks,
ViSolve DB Team
- Original Message -
From: balaraju mandala [EMAIL PROTECTED]
To:
Hi All,
Thank you for u r reply. But i am unable to find my.cnf, is i need to create
this file.
I am unable to start server after shifting to new location.
i tried to start 'mysqld' but it was failed. A blank mysql.sock file is
creating. Entries of log files are also not reporting any problem.
if i search for any process running i am getting following thing.
[EMAIL PROTECTED] mysql]# ps -ef | grep mysqld
root 18389 1 0 13:09 pts/300:00:00 /bin/sh /usr/bin/mysqld_safe
--defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid
mysql18422 18389 0 13:09 pts/3
If you do an INSERT and you generate an new number in an AUTO_INCREMENT
field the new value generated can be retrieved using:
*SELECT LAST_INSERT_ID();*
You are not required to retrieve into the application and then use it back
in another SQL statement... you can use user variables:
*SELECT
Is this what you are looking for:
SELECT clone_ids, COUNT(DISTINCT(gene_ids)) as count_genes
FROM table_name
GROUP BY clone_ids
or
SELECT clone_ids, COUNT(gene_ids) as count_genes
FROM table_name
GROUP BY clone_ids
Hope this helps,
Alvaro
- Original Message -
From: Xiaobo Chen [EMAIL
Hello.
This is an output of diff user.c user.cpp. Which successfully compiles on
my FC3 system using the following command:
g++ user.cpp -I/usr/include/mysql -lmysqlclient
I've changed the extension to 'cpp', so g++ could work with this file.
Also #includeconio.h was commented, and
The same source that you compiled under VC++ may not work at all under
linux. Especially since the header files will be different. Make sure
you have the proper header files for linux installed. Also I did not
see any linking flags during compilation.
On 7/3/05, Ashok Kumar [EMAIL PROTECTED]
Hi Prashanth,
I'm happy to help u. i attached one 'C' code in the
previous mail. just use that code for in vc++. Follow
the procedure,
1.Create the new win32 Console App. as a empty
project and add the attached 'C' file to the project.
2.goto Tools-options-Directories(tab) and in that
add the
Ashok Kumar wrote:
Dear Friends,
I'm Ashok here. first i'll tell my sys configuration.
1.Redhat-Linux 9
2.Intel Pentium chipset
3.MySQL 4.1 with Development Libraries
For this i've downloaded the MySQL4.1 under the
specification Linux x86 RPM downloads from the site.
In my system, the MySQL
Philip Lawatsch [EMAIL PROTECTED] wrote on 06/06/2005 01:37:37 PM:
Hi,
I'm trying hard to figure out how to perform a special query in mysql
4.0.
I have one table widgets which has a column widget-id (int) and one
column number_of_parts (int).
And then I have another table part_mapping
Philip Lawatsch wrote:
Hi,
I'm trying hard to figure out how to perform a special query in mysql 4.0.
I have one table widgets which has a column widget-id (int) and one
column number_of_parts (int).
And then I have another table part_mapping which has one column
widget-id (int) and one
Unless you are keeping track of whether a widget in complete or not,
there is no hope but to scan the entire table to determine if a widget
is complete. That's something you don't want to do. You should mark a
widget as complete when it is completed. This would mean checking if a
particular
[EMAIL PROTECTED] wrote:
I pretty much have no idea how I can do this without nested queries (and
to be frank not even how to do it with them) so I'd really appreciate
any help!
kind regards Philip
Try this as a starting point:
snip
I think you were having two mental problems: 1) how
Asha wrote:
Is there a physical
limitation in the InnoDb table structure as to why it can't
support FullText indexes?
http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html
http://dev.mysql.com/doc/mysql/en/innodb-restrictions.html
Peter Normann
--
MySQL General Mailing List
For
Dayakar,
- Original Message -
From: Dayakar [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, November 21, 2004 7:39 AM
Subject: Help needed in creating primary key ,foreign key on a varchar
datatype colum
--=_NextPart_000_000B_01C4CFBA.91C9BA80
Content-Type:
I just checked the definition of CREATE TABLE in the MySQL manual
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html and I didn't see
anything that suggests that primary keys based on VARCHAR columns need to be
treated differently than other column types in MySQL. However, when I tried
to create
have you tried ?
http://www.geocities.com/jahan.geo/mysql_c_by_example.html
Ruben Safir Secretary NYLXS wrote:
On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote:
Hello,
I need to write a simple C client for a project. I am using the MySQL C
API. Attached is the code. It occassionally
On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote:
Hello,
I need to write a simple C client for a project. I am using the MySQL C
API. Attached is the code. It occassionally segfaults with no visible
pattern. Could someone help me figure out why? Or any other comments on the
What you want to do is pivot your data into a crosstab report. This has
been covered several times so you should be able to find more information
if you search on either pivot table, crosstab or cross tab.
Here's how to do it for a week's worth of dates, I will let you extend it
to fit your
Hi,
I need to add a new auto field to my db, but I need to make sure the
records are listed in order of one of the other fields first which is a date
field.
Any ideas how I do this would be greatly appreciated!
listing records is in no particular order, unless you ask for an order.
SELECT
Hi,
(please reply to the list only)
Yes thanks but how do I then add a new auto number field and still keep
the order?
What order? What has an auto-number have to do with what order?
Please explain your problem in detail - it might be completely clear to you,
but we're outsiders :-)
With
Hi Dominic,
I think everyone is misunderstanding my problem as perhaps I didnt phrase
it very well.
I need to add a new autonumber field to my db, but I need to make sure
when the numbers go into the field they are in the order of one of my other
fields that is a date field.
i.e. I have a
* Unnar
I have a problem with this query
Version MySQL 4.0.15-nt
The query gets all articles written by author but excludes those articles
which are related to products
SELECT DISTINCT
post.post_id,
post.title
FROM
c_posts post,
c_post_product prod,
Here is the corrected version:)
Take a look at Paul DuBois book. Don't use gets. Instead use fgets. That's
safe. I didn't change your gets call:)
hth,
Ganbold
#include stdio.h
#include stdlib.h
#include string.h
#if defined(_WIN32) || defined(_WIN64)
#include windows.h
#endif
#ifdef WIN32
On 26-Feb-2003 M Wells wrote:
Hi All,
I'm having problems creating a query to return a recordset from the
following situation:
I have two tables, one which contains member details, and the other
which contains details re: the groups to which the member belongs.
When a member logs into
Read [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 4:05 PM
To: M Wells
Cc: [EMAIL PROTECTED]
Subject: RE: Help needed with SQL...
On 26-Feb-2003 M Wells wrote:
Hi All,
I'm having problems creating a query to return a recordset from the
following situation:
I have two tables
On 26-Feb-2003 [EMAIL PROTECTED] wrote:
Yes , I had use this query statement in my MySQL server,
But I have a query about it.
Why are you use WHERE a.groupname=b.groupname AND members.id=b.memberid
AND a.memberid=1?
Can you give me a explain or give me a advise!
Sure.
mysql SELECT
: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 5:11 AM
Subject: RE: Help needed with SQL...
On 26-Feb-2003 [EMAIL PROTECTED] wrote:
Yes , I had use this query statement in my MySQL server,
But I have a query about it.
Why are you use WHERE a.groupname=b.groupname
]
Sent: Wednesday, February 26, 2003 10:56 AM
Subject: Re: Help needed with SQL...
I've never seen opening a table twice and then doing a join back with
itself. Am I wording this correctly? Is that how to describe what you're
doing?
Thanks for posting this to the full list.
- Sheryl
Hello Inamullah,
Thursday, October 24, 2002, 12:50:27 PM, you wrote:
First of all don't send me your questions, send them to the mailing
list. I don't privide private support.
IKWell, I have just installed mysql on both wndows n
IK Linux on the same machine and i wanted to ask how i
IK can
Hi Sheela,
At 01:49 2002.10.11. -0700, you wrote:
hi,
I am using mysql
while creating a table I want to give column
descriptioneither by using a query or GUI
ex
create table t1(
a bigint not null ' here i wamt to tell what for the a
is
)
pl help me
thanks
sheela
You can add comments to your
Pushpinder,
Looks like a file permission problem. Which user do
you have that runs the MySQL daemon (server)? Does
this user have the ability to write to the directory
you've specified as the data directory for MySQL?
Kelly
--- Pushpinder Garcha [EMAIL PROTECTED]
wrote:
Hi
I have set up the
One mistake that I see happen a lot in database design is that people
get stuck in visualizing the data in physical terms along with the
labels we attach to them. You should try to think more generically.
Freezer, box, building, tube, etc. are all just labels assigned to
locations. In your
Hi,
On Fri, 2002-09-20 at 08:30, Csaba Kiss wrote:
this is my first mail to the mailing last, since I am new to the mysql
world. I would like to create a cell-bank mysql database. We freeze
down cells in small tubes. These tubes are stored in boxes and the
boxes are in big freezers.
Hiho hiho!
bob wrote:
Hi,
I'm very new to mysql and I'm having a problem getting my joins to work. I
have 3 tables:
builder
category
builder_category_link
The builder table has a an id field and then several other fields (name,
address etc)
The category table has an id field and then one
.
-Original Message-
From: Ralf Narozny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 12:28 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Help needed with JOIN on 3 tables
Hiho hiho!
bob wrote:
Hi,
I'm very new to mysql and I'm having a problem getting my joins to work
Hi
SELECT b.* //all fields from builder
FROM
builder b //define tables and aliases
, builder_category_link l
, category c
WHERE
(b.builderID = l.builderID) //linking builder to link table
AND (l.categoryID = c.categoryID)
Subject: RE: Help needed with JOIN on 3 tables
This is what I found I will stop using Microsoft for development of
mysql. I was running the queries locally on my Win2k machine using the
win32
version of mysql. After screwing with it for several days I finally gave
up
and posted to the list
Hi,
Now I need a query which will take the values from column
'query', treat them as patterns for matching and return
row(s) which match the given string 'blahblah'. In this
example, the matched data is obviously in second row.
(bla% matches blahblah)
Do I make any sense? Is
You should be able to just use something like this:
Select uid, username From tablename Where '$externalstringvar' like query;
That's PHP syntax. You'll have to use whatever makes sense for your
scripting or programming language in place of the $externalstringvar
variable. The single-quotes
Hi.
The char* to the field value will be NULL (in the C meaning), if the
value is NULL (in the SQL meaning). The reason for your core dump is
probably a missing check before you treat the NULL pointer as string.
Bye,
Benjamin.
On Thu, Feb 28, 2002 at 03:23:01PM -0300, [EMAIL
PROTECTED]
Subject: Re: Help needed !!!
On Fri, Jan 25, 2002 at 01:05:12PM +0530, Chetan Lavti wrote:
I am going to use the MySQL version 3.23.47 for as our database.
The issue is which table type to use.
I want that the database should be (memory-resident). I have tried
with the MyISAM tables
On Fri, Jan 25, 2002 at 01:05:12PM +0530, Chetan Lavti wrote:
I am going to use the MySQL version 3.23.47 for as our database.
The issue is which table type to use.
I want that the database should be (memory-resident). I have tried
with the MyISAM tables which doesn't solves my purpose as
On Wednesday 05 December 2001 16:40, you wrote:
hi everybody
i want to take diff of datetime format columns.
Is it possible using direct '-' arithmatic..
It gives result as:
2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126
2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350
First row is
the formatting ok,
but it just needs the table headings.
Ideally we want to use one or more queries to do this, rather than using
mysqldump.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 10 September 2001 11:38 am
To: Andrew Murphy
Subject: Re: Help needed getting table
Hi,
use "mysqladmin variables" command to see current settings. I guess
your mysqld does not read the config file you have edited. ;-) It
happened to me me also few days ago. Remember mysqld looks for
/etc/my.cnf and $DATADIR/var/my.cnf if I remember well. Maybe put the
path to config file just
On 26-Aug-2001 [EMAIL PROTECTED] wrote:
Hi
I need to set the max_allowed_packet to 16M. below is my
01mysql-server.sh file. I use DBI and I know that I have to start this
before the DBI program and I did but if I use ./mysqld --help it shows
that my max_allowed_packet is still 1M. Any
Already tried ... Not successfully.
Another idea ?
-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 7:51 PM
To: BALU Frédéric; [EMAIL PROTECTED]
Subject: Re: help needed for replication
Dear Frederic,
localhost | jkasas
: help needed for replication
Already tried ... Not successfully.
Another idea ?
-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 7:51 PM
To: BALU Frédéric; [EMAIL PROTECTED]
Subject: Re: help needed for replication
Dear
Dear Frederic,
localhost | jkasas | 1896f443280395b3
And what I do and get :
mysql GRANT SELECT ON MEMBERS.users TO jkasas@'localhost';
ERROR 1133: Can't find any matching row in the user table
Try GRANT SELECT ON MEMBERS.users TO jkasas@localhost (w/out quotes)! :)
You need to GRANT PRIVILEGES to the host and user that PHP connects from.
Kim White wrote:
Hi
Could anybody tell me how to get rid of the following error on a php3
request. Warning: MySQL Connection Failed: Host 'hostname.co.za' is not
allowed to connect to this MySQL server in
Kim White wrote:
Could anybody tell me how to get rid of the following error on a php3
request. Warning: MySQL Connection Failed: Host 'hostname.co.za' is not
allowed to connect to this MySQL server in /var/local/irm/irm.inc on line
83.
PROTECTED]]
Sent: 26. juni 2001 17:42
To: [EMAIL PROTECTED]
Subject: Re: HELP NEEDED: Problems with SELECT in combination with
HAVING
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime = '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY robotId
This should return
:[EMAIL PROTECTED]]
Sent: 26. juni 2001 17:42
To: [EMAIL PROTECTED]
Subject: Re: HELP NEEDED: Problems with SELECT in combination with
HAVING
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime = '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY robotId
This should return
: Re: HELP NEEDED: Problems with SELECT in combination with
HAVING
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime = '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY robotId
This should return the robotId and the most recent startTime labeled 'crit
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime = '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY robotId
This should return the robotId and the most recent startTime labeled 'crit'
for all records specified in the where clause. And have a look in the manual
for
Please do a SHOW FIELDS FROM and SHOW KEYS FROM on all tables involved
so we can see what's going on here. Also, a warning, if desacription is
indexed, by doing LIKE '%GABA%' with wildcard at beginning, it won't use
index's.
Would also help if you did an EXPLAIN on that query and sent that.
Okay, here is the full monty from the database regarding the query in
question, any suggestions on how to improve any of it are greatly
appreciated!
Also, if any more info is needed, just let me know.
Thanks!
Bryan
QUERY:
mysql select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as
cause some VERY weird join results, and may be your problem. Try adding in
the join clause in the where clause.
- Original Message -
From: Bryan Coon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 2:52 PM
Subject: RE: Help needed with Query UPDATE INFO
Okay, here
What do you mean by "better" ?
Next time it hangs, check your disk freespace.
When MySQL runs out of tmp workspace, it waits until some becomes
available.
[EMAIL PROTECTED] wrote:
Help!
I have set up a web server with PHP4, RH7 and MySQL 3.23.32.
After surfing for sometime, the browser
Hello Pat
Well, I really feel stupid! Under the gun with this any I really don't
have a clue. I also need to install some type of DBI foe windows2000
advanced server too and I'm now downloading a perl file off of
mysql.com. I really have no idea working with windows. My main OS that I
have been
Don't you think this has nothing specific to MySQL? Maybe you
should read some books on SQL and the manual for MySQL?
SELECT * FROM
tablename
WHERE
datefield'2001-01-11' AND
datefied'2001-02-12'
Don;t ask how to correctly call the query in perl, read
perldoc DBI
perldoc DBD::mysql
Slight correction, for some reason the query below does NOT work on my
sample DB unless I quote the date values.
This should work now:
SELECT IP, Size, Date FROM your_table
WHERE Date BETWEEN '2001-02-01' AND '2001-05-01';
so and i have Mysql table with
IP | Size |
93 matches
Mail list logo