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
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
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
>>>
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
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.
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 MySQ
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.
>
>
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 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
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" defaul
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
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 shows that the
disk usage is at 100%. I decided to dr
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 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 stuck. I wonde
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 stuck. I wonder if anyone out there could take a look at this
bit of mysqld log. Any help at all would be greatly appreciated!!!
Pito
110107 15:07:15 m
lto:st...@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:
>
> &
aybe something like this could give you a
> starting point?
>
> Steven Staples
>
>
>> -Original Message-
>> From: Michael Stroh [mailto:st...@astroh.org]
>> Sent: June 3, 2010 11:24 AM
>> To: MySql
>> Subject: Help needed on query on multiple
nt: June 3, 2010 11:24 AM
> To: MySql
> Subject: Help needed on query on multiple tables
>
> Hi everyone. I'm trying to create a certain MySQL query but I'm not sure
> how to do it. Here is a stripped down version of the result I'm aiming
for.
> I'm pretty new
Hi everyone. I'm trying to create a certain MySQL query but I'm not sure how to
do it. Here is a stripped down version of the result I'm aiming for. I'm pretty
new to queries that act on multiple tables, so apologize if this is a very
stupid question.
I have one table (data) that has two column
Step # 1 : Stop mysql service
# /etc/init.d/mysql stop
Step # 2: Start to MySQL server w/o password:
# mysqld_safe --skip-grant-tables &
Step # 3: Connect to mysql server using mysql client:
# mysql -u root
Step # 4: Setup new MySQL root user password
mysql> use mysql;
mysql> update user set pas
I actually get the feeling you are not connecting as root.
Try mysql -uroot -p test instead of just mysql test
Have a nice day,
- Martijn
On Wed, Aug 26, 2009 at 03:02, Joe wrote:
> OK, thanks, that got me in. But upon inspection, the user.host
> values do not look fouled up as I thought they w
When you are in without the flag , issue the following:
Select current_user();
It should return root.
Then do this:
Grant all privileges on *.* 'root'@'%' identified by 'letmein'
It should work If you did not mess too much with grant tables.
Claudio
Il giorno 26 ago, 2009 4:36 m., "Todd Lyons"
>> On Wed, Aug 26, 2009 at 02:12, Joe
> wrote:
>> > We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we
>> > really need some help regaining access to. While attempting
>> > to adjust/add remote user access, we accidentally did the
>> > following:
>> >
>> > use mysql;
>> > update user set hos
OK, thanks, that got me in. But upon inspection, the user.host
values do not look fouled up as I thought they were (it appears
the bogus update may have aborted). But my access problem
remains
If I start with --skip-grant-tables, 'show databases' shows all
DBs. But without that flag, I only
You have to reset the permissions.
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Carlos
On 8/25/2009 7:12 PM, Joe wrote:
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access, we
Hey Joe,
stop the server, start it with --skip-grant-tables, change the root
entry in mysql.user to your liking, and then restart the server
without --skip-grant-tables.
viola!
Walter
On Wed, Aug 26, 2009 at 02:12, Joe wrote:
> We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
> nee
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access, we accidentally did the
following:
use mysql;
update user set host = 'SomeBogusIP' where user = 'root';
Now, we can't get into the DB to fix
: mysql@lists.mysql.com
> From: c...@hosting4days.com
> Subject: Basic SQL Query Help Needed
> Date: Tue, 25 Aug 2009 16:21:45 -0700
>
> I have a basic invoice table with related line items table
>
> Goal :I'd like to get ALL the related line items - for ALL the
> &#x
I have a basic invoice table with related line items table
Goal :I'd like to get ALL the related line items - for ALL the
'open' invoices...
-- this should get a list of open (unpaid) invoices
$query_invoice = "SELECT DISTINCT ID from invoices where status =
'open'"
-
--
I am creating surveys for our website and want store questions and answers
in a database. I found a tutorial that was useful, however it only gave
structure for a single question with one answer. My surveys need to be more
comprehensive than a poll question, and so I need some help with the
structu
Hi Dave,
that's easy. Either install
http://www.phpmyadmin.net/home_page/index.php on the server, the best
tool to manage a mysql server.
Or use XAMPP, a complete package from
http://www.apachefriends.org/en/index.html
Guenther
Dave Stevens wrote:
> Hello all,
>
> I have set up a little serve
Dave,
Log in as the user you intend to set up for them. Issue the following:
show grants;
select @@sql_mode;
If you aren't sure how to interpret the information I will direct you
to the manual: http://dev.mysql.com/doc/refman/5.0/en/
Side note: I would upgrade. 5.0.45 has some pretty serious
Hello all,
I have set up a little server and am pitching to an organization to host their
upcoming new site. The box is Centos 5.2 up to date and mysql 5.0.45. The
requirements below must be met but I don't know how to verify their status.
Can someone point me in the right direction. Will read
: 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,
>
&
>;
Sent: Monday, May 12, 2008 11:43 PM
Subject: RE: Help needed
> Your best bet would be to use a UUID:
>
> SELECT UUID();
> +--+
> | uuid() |
> +
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
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
Garris, Nicole [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
>co
EMAIL 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:
ECTED]
website:
http://www.nusconsulting.com.au
- 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 <[
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 G
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.
It will display an ID, please mail me back the ID.
If you can use it on several computers, it will be even better for me, I need
to have as much results as possi
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 PR
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?
>
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 import
Hi,
I installed Mysql 5.0.45 on Solaris 10 01/08 configured to run
the datadir on a ZFS filesystem on a Raid1 pool.
Both myisam and innodb tables are on the same filesystem.
Innodb is configured to run with a buffer_pool_size=256M,
with doublewrite set to OFF and with file_per_table to Off.
The log
Just use the type varchar.I always use it in my regular life.
On Feb 11, 2008 4:44 PM, Magne Westlie <[EMAIL PROTECTED]> wrote:
>
>
> Jerry Schwartz wrote:
> >>SELECT user_id, user_name FROM user_test WHERE user_id IN (SELECT
> >> uid
> >> FROM temp_uids);
> > [JS] Couldn't you replace the "
Jerry Schwartz wrote:
SELECT user_id, user_name FROM user_test WHERE user_id IN (SELECT
uid
FROM temp_uids);
[JS] Couldn't you replace the " WHERE user_id IN (SELECT uid FROM
temp_uids)"
with a simple JOIN? If "IN" is badly optimized, as I've read here, wouldn't
that be more efficient? Or a
> -Original Message-
> From: Magne Westlie [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 08, 2008 5:37 AM
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: Re: stored procedure, parameter type help needed
>
> Hi again,
>
> I found a way tha
Hi again,
I found a way that works for the query I wanted in my sproc. It uses
your solution to insert into a temporary table, and then uses a SELECT
in the "IN"-part.
I don't know yet if this solution may have side-effects. I need to read
more about how temporary tables is handled by MySQL, a
Hi Magne
>...the query I actually want to use this in, is a 100 line query with
lots of arguments.
>I don't feel to good about creating it into a bunch of strings (16)
that I have to
>concatenate with the variables inbetween.
The only alternative I know for current versions of MySQL is to ass
Hi,
Thanks a lot Peter, that was useful and it worked fine. The only problem
is that the query I actually want to use this in, is a 100 line query
with lots of arguments. I don't feel to good about creating it into a
bunch of strings (16) that I have to concatenate with the variables
inbetwee
Magne,
Sorry, the server is down at the moment, here is the entry ...
To have an sproc accept a variable-length parameter list for an
|IN(...)| clause in a query, code the sproc to |PREPARE| the query
statement:
|
DROP PROCEDURE IF EXISTS passInParam;
DELIMITER |
CREATE PROCEDURE passInParam(
Magne,
>I want to create a stored procedure that runs a query using the "IN"
operator ...
See 'Variable-length argument for query IN() clause' at
http://www.artfulsoftware.com/queries.php
PB
-
Magne Westlie wrote:
Dear List,
I want to create a stored procedure that runs a query usin
Dear List,
I want to create a stored procedure that runs a query using the "IN"
operator (or is "IN" a function???) on values sent as argument. That is,
my procedure should be called with something like:
CALL get_users((1,2));
and I was hoping to implement something like this:
CREATE PROCED
ington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: Sudheer Satyanarayana [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 14, 2007 1:50 AM
> To: mysql@lists.mysql.com
> Su
f security information to follow
You can grow the database as you add module, but as much as you can
foresee and design ahead it would be better
Mikhail Berman
-Original Message-
From: Sudheer Satyanarayana [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 14, 2007 1:50 AM
To: mysql@lists.mysql.
HI Sudheer,
THIS DESIGN IS BASED ON MY MANY->TO->ONE DIRECTION PATTERN
OF DATABASE NORMALIZATION DESIGN... PLEASE MODIFY/CORRECT IT ACCORDING TO YOUR
TASTE. AS A JAVA DEVELOPER I'M USING HIBERNATE FOR MY CREATE-UPDATE-DELETE(CUD)
AND DIRECT JDBC FOR MY QUERIES(R).
YOU MAY VARY.
HERE, HOPE TH
Hi,
I'm creating an application for my web site. I want help in designing
database tables. Currently I'm starting with user management system.
The web site would have these types of users
1. Customer account
1a. Individual account. This user would be an individual with username,
password, bi
hi,
I had already meet this situation: after I unpluggin the power cable, then
start OS(redhat9.0, ext3 fs), start mysql, but innodb recovery was failed!
but, I also test this case on another os(RHEL4,ext3 fs), there is no any
problem.
I think there maybe different to handle filesys
On 3/11/07, Jean-Sebastien Pilon <[EMAIL PROTECTED]> wrote:
I am running a mysql database server and we experienced a power failure.
The mysql server does not want to restart because innodb is corrupted.
Version info:
Mysql version 4.1.11-Debian_4sarge7-log
Debian sarge
Reiserfs filesystem
Wha
Hi All:
As the GUI tools archive doesn't help, I wanted to seek some help
from here. I was migrating the database from oracle to mysql. I was having
an issue migrating a table from oracle to mysql figured out that the table
size on the MySQL has to be set. I'm using the migration kit
Hello,
I am running a mysql database server and we experienced a power failure.
The mysql server does not want to restart because innodb is corrupted.
Version info:
Mysql version 4.1.11-Debian_4sarge7-log
Debian sarge
Reiserfs filesystem
What I have tried:
- Ran reiserfsck to fix corrupted fi
Hi
I'm having a problem compiling store procedure getting errors that don't
make much sense. The problem is that I need to filter any value that is
either NULL or an empty string an set to '0' character. SP is below
CREATE PROCEDURE test ()
BEGIN
DECLARE code VARCHAR(10) DEFAULT '
[ 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 w
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
optimi
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
optimize the query? i've got
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/300
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.
Hi All,
Thank you for u r reply. But i am unable to find my.cnf, is i need to create
this file.
t; <[EMAIL PROTECTED]>
To:
Sent: Saturday, August 19, 2006 12:28 PM
Subject: help needed to mount data from /var/lib/mysql
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 on
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 spac
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 space. Somebody told me that we need to change the data path
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 @lastG
Hi,
How can I get the current value of AUTO_INCREMENT field, as the
AUTO_INCREMENT field is a foreign key in some other table.please do mail
it to my mailed, its very urgent!
Thanks,
bhanu
"The pessimist may be right in the long run, but the optimist has a
better time during the trip."
created 64 bit objects and I had to use right 64-bit flags for DBD::mysql
installation.
Thanks for all who helped
Vinay
- Original Message -
From: "Jake Peavy" <[EMAIL PROTECTED]>
To: "MySQL"
Sent: Friday, March 03, 2006 5:38 PM
Subject: Re: INstalling DBD f
On 3/3/06, Vinay <[EMAIL PROTECTED]> wrote:
>
> Hello,
>I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I
> have installed DBI successfully but having a hard time installing DBD for
> mysql on HP-UX.
> I am getting make errors while installing. I want to use perl to connect
>
Hello,
I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I have
installed DBI successfully but having a hard time installing DBD for mysql on
HP-UX.
I am getting make errors while installing. I want to use perl to connect to
mysql database.
Any help appreciated,
Thank yo
gerald_clark wrote:
Michael Joyner wrote:
(OT) (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED
--
MyODBC does not connect to Sybase.
Correct. Merely trying to use it's debug features to "snatch" the dba
password so
Michael Joyner wrote:
(OT) (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED
--
The Scenario:
~~
We out locked out of our door lock database.
The database is Sybase Sql Anywhere version 7.0
(OT) (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED
--
The Scenario:
~~
We out locked out of our door lock database.
The database is Sybase Sql Anywhere version 7.0
The software uses a hard
I figured out that it wasn't really the special characters that were
the issue, but the
addslashes function in php with the html tags. I just got rid of the
back slashes and all
is good. Sorry for the noise...
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov 8,
Is this the wrong list to ask this on?
If so can someone suggest a better list?
Am I missing something in my analysis of my problem?
Did I not include enough info?
Could it be a problem with perl scripts?
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov 8, 2005,
I tried using
`mysqldump $log -v -Q -c --set-charset --default-character-set=utf8
--add-drop-table --add-locks --create-options --disable-keys
--extended-insert --lock-tables --quick $db_name -r $bk_file 2>&1`
and I still get
-- MySQL dump 10.9
--
-- Host: localhostDatabase: --
I think the problem is mysqldump uses this:
DEFAULT CHARSET=latin1
with --set-charset
How can I get it to use utf8?
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov 7, 2005, at 8:46 PM, Boysenberry Payne wrote:
I'm having difficulty getting certain special ch
I'm having difficulty getting certain special characters to stay the
same when I export databases.
Here are some of the examples:
View of data from phpMyAdmin:
Habitat is a “what you see is what you get� or “WYSIWYG�
View from table dump via phpMyAdmin export:
Habitat is a “what y
Chen" <[EMAIL PROTECTED]>
To:
Sent: Monday, October 24, 2005 11:43 PM
Subject: Help needed for SQL statement
> Hi,
>
> I have such a situation:
>
> There is a table with gene_ids and clone_ids. Each gene only resides on a
> single clone and each clone may contain multipl
Hi,
I have such a situation:
There is a table with gene_ids and clone_ids. Each gene only resides on a
single clone and each clone may contain multiple genes. How do would I
find how many genes are on each and every clone?
Thanks in advance.
X.Chen
--
MySQL General Mailing List
For list arch
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 #include was commented, and main now r
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]> wro
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 Server is working w
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 MySQ
;
<[EMAIL PROTECTED]> wrote:
> Ashok,
>
> Can u do me a favor.
> Am trying to update the mysql server in windows
> using VC++ and C code.
> Am very new to this domain. Can u please send the
> code u are using in
> VC++ to me?
>
> Your help would be greatly ap
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 Server is working w
[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:
> I think you were having two mental problems
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 wid
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
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 "p
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 column "part_id" (int
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
creating an index is necessary for fulltext search.
and when i say
create fulltext index search_index on sometable(column1,column2) i
get an error messg like
Error: The used table type doesn't support FULLTEXT indexes
Why doesn't InnoDb support FullText indexes?
Is there a physical
li
1 - 100 of 340 matches
Mail list logo
