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
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
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
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
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
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 to queries that act on multiple tables, so apologize
-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 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
...@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
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, Joemysql@bluepolka.net wrote:
OK, thanks, that got me in. But upon inspection, the user.host
values do not look fouled
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
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'
-
--
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
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, Joemysql@bluepolka.net wrote:
We have an inaccessible MySQL v5.0.45 DB
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,
...@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
'open' invoices...
-- this should get a list of open (unpaid) invoices
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
On Wed, Aug 26, 2009 at 02:12, Joemysql@bluepolka.net
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
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
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
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
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
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 server
, 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,
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
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
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
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?
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 WHERE user_id IN
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 am I
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, as
-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 that works for the query I wanted in my sproc
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 PROCEDURE
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
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 using
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
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
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
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.com
Subject: Design Help Needed
Hi,
I'm creating
.
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
Subject: Design Help Needed
Hi
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,
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
What
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
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
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
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
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
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
]
To: mysql@lists.mysql.com
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 only. I want
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
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.
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
--Help needed
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
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
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
to
(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
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
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 that I can get
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,
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
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
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
PROTECTED]
To: mysql@lists.mysql.com
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 multiple genes. How do would I
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
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
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
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]
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
the
code u are using in
VC++ to me?
Your help would be greatly appreciate.
Thanks
prashanth
-Original Message-
From: Ashok Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 3:34 PM
To: mysql mysql
Subject: Help needed regarding MySQL-C Libraries on
Linux
Dear
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
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).
part_id
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
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
I was able to set up a table no problem.
On one of the blobs, it is coming up on the web page like a mess
and not like an interpreted object
as one would expect.
Using Mysql 3.23.58 with php 4.3.9
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I asked for help with a version of this query a few months
ago, and subsequently made some improvements to it, and also
fooled around with other parts of my app that were in need of
tuning. I've since done some more extensive benchmarking and
realized that this query really is somewhat slow. Even
1 - 100 of 329 matches
Mail list logo