On Thu, Nov 15, 2001 at 04:14:58PM -0600, Michael Brunson wrote:
>
> Has anyone ran any benchmarks as to what affect different number of
> RAID_CHUNKS has on speed?
The more chunks, the slower your retrieval speed is likely to be. But
how many chunks do you really need? More than a few?
> mysq
Ken Kinder wrote:
-
The mysql-perl had something called the Perl DBI. Go to this url:
http://www.mysql.com/downloads/api-dbi.html
Get the DBI and the Mysql-Perl tarballs. They are funny to install, but
basicly you untar them:
tar zxvf
then, in the directory crea
On Thu, Nov 15, 2001 at 03:18:58AM -0800, Bennett Haselton wrote:
> >
> >Hmm... I'm sure plenty of people would disagree strongly with your
> >remark of bad OO support in Perl. But, that is beside the
> >point. You could either search CPAN (http://www.cpan.org/) and see
> >if you find what you nee
On Thu, 15 Nov 2001, Shankar Unni wrote:
Thank you for your answers.
> Generally, you don't want to store currencies in floating point, anyway,
> and it's unfortunate that MySQL implements DECIMAL as floating point rather
> than a variable-length BCD (which is exact).
Yes. This is strange,
On Thu, Nov 15, 2001 at 01:49:31AM -0800, Bennett Haselton wrote:
>
> After converting the data in my project from text files to MySQL
> tables, things are certainly working more smoothly than they were
> before,
Good to hear.
> but since I use objects (in Perl, which barely supports objects, bu
On Thu, Nov 15, 2001 at 09:32:56AM +0100, Jure Koren wrote:
> Hello!
>
> I've set up replication with a master and two slaves, all running
> 3.23.43, and it works like a charm. Except for...
>
> When the master goes down, the slave tries to reconnect after 60
> seconds, but just once.
That shou
hello I need some help.
May i know where can i find all the terminologies about the
Database,tables,attributes,tuples,relataion database,primary key,foreign
key, composite primary key all. And their
charactieris,purpose,adavantage and disadvantage?
thnak you
Sincery,
Carmen
On Fri, 16 Nov 2001 10:41:31 +0530, Manish Mehta used a
few recycled electrons to form:
| Hello ,
|
| I have a problem related to not <> or != (not equal to function) .
|
| The SQL Query is
|
| select a.cBook_Name from tbl_bookmaster as a , tbl_empbookrelation as b
| where a.nb
Hello ,
I have a problem related to not <> or != (not equal to function) .
The SQL Query is
select a.cBook_Name from tbl_bookmaster as a , tbl_empbookrelation as b
where a.nbook_id != b.nbook_id
It shows me wrong result. It shows me those rows also which are already
presen
Hi,
I am using jsp-mysal combination in my application.
In my case i need the second user accessing the record to edit to get a
error message "this record is being edited by another user. try later" if
the record is being edited by first user.
In the page i have used
i have set autocommit=0
then
Jennifer Slis wrote:
>
> I am extremely new to mySQL (and the Linux environment all together). I have
> been building/maintaining a mySQL/PHP site. Today, the site began giving me
> errno 145 (cannot open file) errors. I found that meant I had at least one
> corrupt table, so I went into mySQL, f
I am extremely new to mySQL (and the Linux environment all together). I have
been building/maintaining a mySQL/PHP site. Today, the site began giving me
errno 145 (cannot open file) errors. I found that meant I had at least one
corrupt table, so I went into mySQL, found I had two corrupt tables
Sounds like you have a TCP socket problem. Is the database on a local
machine or a hosting provider? What platform is it on wintel or *nix?
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Georgina Fang [mailto:[EMAIL PROTECTED]]
Sent:
Hi:
I telnet to the server. But I can not get into MySql
database. What's the problem?
% mysql
ERROR 2002: Can't connect to local MySQL server
through socket '/tmp/mysql.sock'
(2)
% mysql -p linksdb
Enter password:
Then I type in password, and got the following:
ERROR 2002: C
Hi,
I resubmited again for anyone with solution to assist me.
I had one question. I would like to set permission for remotely backup using
mysqldump. Let's assume I want to use B(10.0.0.2) server to remotely backup
A(10.0.0.1) server.
The command I run at B server are:
mysqldump --opt -h10.0.0
Hi,
I'm building an application which uses Innodb. It is very imperative
that all data is processed as quickly as it possibly can and so the problem
I have is quite a concern. My perl script executes the queries however if if
make an error in the code and the script crashes half way through th
Hi,
- Original Message -
From: "Brent Simpson" <[EMAIL PROTECTED]>
> I've been reading up on this most of the day and still can't get it!
You'll say DOH! later ;-)
> I need to use PHP to make connections to MySQL. When I use my actual
> host name to make the connection I get this:
> W
mysqlHow to install mysql on unix?
ÖÂ
Àñ£¡
Peter.Liu
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
T
mysql£¬ÄúºÃ£¡
fdsa
ÖÂ
Àñ£¡
Peter.Liu
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I've been reading up on this most of the day and still can't get it!
I need to use PHP to make connections to MySQL. When I use my actual
host name to make the connection I get this:
Warning: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES) in /var/www/html/php/db_mysql.inc on l
>Description:
I am using russian values(cp1251 charset) for ENUM items.
Here is an example how to damage ID field by query to change
F_Category Enum.
>How-To-Repeat:
# Create tableA with ID field.
CREATE TABLE tableA (
ID int(11) NOT NULL auto_increment,
F_ReportID b
I'm having a problem sorting records that are used in a left join statement.
Basically what happens is that any record that is not in table1 doesn't get
sorted correctly. It first sorts all the records that have valid 'c2'
records in both table1 and table2, then moves on to all the records that
o
Hrm... so it is going to need to rebuild all the indexes, not just the
table I am adding... doh... oh well, should still be faster, I'd guess.
Probably my best bet in this case is to create a new merged table with the
new table and all the other old ones, then replace the old merged table
with
Hi all,
I'm using a MyISAM table in a high availability environment as a rudimentary
persistent FIFO queue. The table definition is simple - the key is an
auto_increment unsigned bigint and the data is a blob (it holds the contents
of a C structure with a length of 200-400 bytes). I've got a cou
Here is the same data in a little easy format.
Raid Chunks count like %like % %
10.00 sec 0.33 sec 2 min 3.70 sec
30.00 sec 0.39 sec 14 min 59.83 sec
50.00 sec 0.38 sec 6 min 44.92 sec
15 0.00 sec 0.39 sec 6 min 33.72 sec
On Thu, 15 Nov 2001 [EMAIL PROTECTED] wrote:
> I am using 4.0 and switching from MyISAM to InnoDB,
> so quite newbie on this:
I'm still using 3.23.4X (differs depending on which machine I'm on), but
I'm pretty sure that none of the questions have answers that change too
much between those vers
Jason
The forums at http://forums.devshed.com aren't half bad either... Apache, PHP, MySQL,
HTML/Javascript...
# Nathan
- Original Message -
From: "Paul" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 4:28 PM
Subject: Re: Is there any mySQL forums ?
In M
The date addition and subtraction functions in mysql don't seem to quiet do
this. I was wondering if anyone know a way I could do this in the query:
Say you have two fields, start_time, and end_time, representing the start and
end of a period of time. Both are datetime datatypes. What I want is
In Message-ID: <[EMAIL PROTECTED]> Jason
Rowski wrote:
>Hi,
>Is there any mySQL forums ( discussion boards) where I
>can post my mySQL queries ?
>Thanks
>Jason
Jason,
I hope this isn't seen as spam... but http://dbforums.com has a forum for
most mainstream databases, including web access to
Hello all,
Some of you may recognize this post somewhat, I've asked about this
problem before:
I am unable to execute the "shutdown" command with mysqladmin, running
on Darwin 1.4.1 (from Mac OS X 10.1.0).
Originally, I had compiled MySQL 3.23.44 from source code, specifying
the following optio
Thanks Bill,
That works great.
Much appreciative,
Chip
Bill Adams <[EMAIL PROTECTED]>@tqs.com on 11/15/2001 10:31:45 PM
Internet mail from:
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject: Re: getting multiple columns per row from databse query
Try
The mysql-perl had something called the Perl DBI. Go to this url:
http://www.mysql.com/downloads/api-dbi.html
Get the DBI and the Mysql-Perl tarballs. They are funny to install, but
basicly you untar them:
tar zxvf
then, in the directory created by that:
perl Makefile.PL
make
make
"Anthony R. J. Ball" wrote:
> Ok, so to follow... Paul Dubois told me the little
> RENAME TABLE trick to swap out a table... Will that work
> on a table in a MERGE, or are there different hoops to
> jump through?
Your table names need to be unique. Then it should work just fine.
o If you do
Ok, so to follow... Paul Dubois told me the little
RENAME TABLE trick to swap out a table... Will that work
on a table in a MERGE, or are there different hoops to
jump through?
On Thu, Nov 15, 2001 at 02:01:44PM -0800, Bill Adams wrote:
> "Anthony R. J. Ball" wrote:
>
> > I was just readin
I'm sorry but I have tried to solved this on my own, but I'm unable to. I
have a RH system and I installed the (at the time) most current stable mysql
system 3.23.43-1 and have it up and running. The problem that I have is
that I want to start working with Perl and MySQL, but don't know what I
r
There's no way to know that without knowing the schema of the table you're inserting
into. How you index it is going to be the biggest factor there.
--jfarr
- Original Message -
From: "Gabor Penoff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 2:23 PM
S
Hi folks,
can you tell me an estimated speed about filling 100 records with
mysql insert by using the C api?
I know the question sounds silly - all I have now is a suspicion that
I make something wrong (I mean the insert seems to be quite slow here
at home).
cu,
fns
-[ mailto:[EMAIL PROTECTE
Has anyone ran any benchmarks as to what affect
different number of RAID_CHUNKS has on speed?
Also, what affect does the RAID_CHUNKSIZE have?
Here are a few results I've gotten all with the default
CHUCKSIZE.
-
No RAID Tables (yes, fewer rows.. hit the 2G limit)
mys
"Anthony R. J. Ball" wrote:
> I was just reading DOCS for MERGE tables... and they
> look like exactly what I want.
>
> I have a large lookup table that I use to track down
> where I want to find my data, which gets loaded into
> different tables at different times of the day
> (financial dat
the easiest way is using a counter to 4 and then do reset to
so you get
if counter = 4 then
reset counter
write new line
endif
% calculates the modulo between $i and 2 = Remainder of $i divided by 2
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
I was just reading DOCS for MERGE tables... and they
look like exactly what I want.
I have a large lookup table that I use to track down
where I want to find my data, which gets loaded into
different tables at different times of the day
(financial data). Now I am loading all the data into
> On 15 Nov 2001, at 21:59, Carsten H. Pedersen wrote:
>
> > > PRIMARY KEY
> > > (`collection_id`,`document_id`,`tcml_field_id`,`order_number`),
> > > KEY `collection_field_value`
> > > (`collection_id`,`tcml_field_id`,`value`(12)),
> > > KEY `value` (`value`(12)),
> > > KEY `resource_
Try:
$i++;
if( $i % 3 == 0 ){
echo "\n\n";
}
b.
mysql
[EMAIL PROTECTED] wrote:
> I have a database that is names and addresses. I want to make a web page
> that will display those
> names and addresses in a table with 4 columns per row, as many rows as necessary.
>The little
> if statement
I have a database that is names and addresses. I want to make a web page
that will display those
names and addresses in a table with 4 columns per row, as many rows as necessary. The
little
if statement below works to make 2 columns, but when I change the number to 3 or
higher it no longer
works
thanks.
i'll start it with the value i need. it increments after that ;)
Heikki Tuuri wrote:
> Joe,
>
> sorry, I did not know AUTO_INCREMENT=... clause does not work with InnoDB. I
> will look if it is easy to fix.
>
> A workaround is that you insert the first row which the auto-inc column
>
On 15 Nov 2001, at 21:59, Carsten H. Pedersen wrote:
> > PRIMARY KEY
> > (`collection_id`,`document_id`,`tcml_field_id`,`order_number`),
> > KEY `collection_field_value`
> > (`collection_id`,`tcml_field_id`,`value`(12)),
> > KEY `value` (`value`(12)),
> > KEY `resource_id` (`resource_i
> I'm trying to keep a table of summary statistics for another table,
> because I expected that generating the counts would take a while.
> But I never expected the query to take hours, as it does. On
> examination, I see that the query is not using an index, even
> though the table has an index
I am trying to calculate an approximate age from a birth month field
(birthMonthVal TINYINT(3) UNSIGNED NOT NULL) and birth year field
(birthYearVal SMALLINT(4) UNSIGNED NOT NULL). I do not have the day so an
approximate age is OK (the results will be grouped in an aggregate format
anyway).
How d
I'm trying to keep a table of summary statistics for another table,
because I expected that generating the counts would take a while.
But I never expected the query to take hours, as it does. On
examination, I see that the query is not using an index, even
though the table has an index on the th
At 12:57 PM -0700 11/15/01, Mark A Ohrenschall wrote:
>I'm having a problem with Distrib 3.23.42 with the following query:
>
>select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null;
>
>I'm finding that a left join on datetime fields that do not allow nulls is not
>working when I'
> > From: Bennett Haselton
> >
> > My databases textbook from college says that specifying an
> > attribute as an
> > "index" means that the data will be stored in such a way that
> > lookups on
> > that attribute are faster, and specifying an attribute as a
> > "key" means
> > that its values hav
Hi, load your dict file with LOAD DATA INFILE
very easy; pretty quick ;-)
If you don't want to mess with that, I just dumped my dictionary
database. Here is the link to where you can download that dump file:
http://brimstone.fpsn.net/~cfaber/mysql/dict.sql.gz
Michael wrote:
>
> Does anyone
> insert-select on the same table is not allowed in MySQL. If I remember
> right it isn't allowed in ANSI SQL either, supposedly because it
> could lead
> to infinite loops if implemented poorly.
>
> Jon Gardiner.
Core SQL support does not require the DBMS to support it; enhanced
SQL support a
select max(storyID), storyCategoryID
from newsStories where storyCategoryID > 0
group by storyCategoryID
- Original Message -
From: "Christopher Oson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 6:31 AM
Subject: Easy SQL query??
> Good Day, All,
>
>
I'm having a problem with Distrib 3.23.42 with the following query:
select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null;
I'm finding that a left join on datetime fields that do not allow nulls is not
working when I'm trying to emulate a subselect to find non-matching values
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
El Jueves 15 Noviembre 2001 13:15, escribiste:
> Gyulay Gabor wrote:
> > The problem is that I need to store numbers with lot more
> > than 16 decimal digits - e.g. 1234567890123456789012345.12
> > [...]
> >
> > The reason is why we need this that the
Hi,
Is there any mySQL forums ( discussion boards) where I
can post my mySQL queries ?
Thanks
Jason
__
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
Joe,
sorry, I did not know AUTO_INCREMENT=... clause does not work with InnoDB. I
will look if it is easy to fix.
A workaround is that you insert the first row which the auto-inc column
value explicitly specified:
INSERT INTO some_table VALUES (1500, 'joe');
Then InnoDB starts to increment fro
>Description:
Whenever you create a database with an underscore in it and give
a user rights to it, he is able to create other databases with
whatever charater in place of the underscore.
>How-To-Repeat:
create database aa_bb;
grant all privileges on aa_bb.
they will be in mysql 4.1
-Original Message-
From: Rosyna [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 2:11 PM
To: Christopher Book; '[EMAIL PROTECTED]'
Subject: Re: SUB-SELECT
Anyone know if subselects will be available in the future?
Ack, at 11/15/01, Christopher Book
Gyulay Gabor wrote:
> The problem is that I need to store numbers with lot more
> than 16 decimal digits - e.g. 1234567890123456789012345.12
> [...]
> The reason is why we need this that there're several
> currencies (like italian lire) which requires this kind of
> precision.
Excellent answer
HI!
I set the LD_LIBRARY_PATH variable in my safe_mysqld file
but I still get error 1124 ("no paths allowed for shared library")
message while trying add new user function (by CREATE FUNCTION
command).
What do I do wrong? This is a part of my safe_mysqld file:
trap '' 1 2
On Thu, Nov 15, 2001 at 01:49:31AM -0800, Bennett Haselton wrote:
> my $user = user.CreateFromTableRow("bennett");
> $user.sendReminderEmails();
> $user.emailaddress = '[EMAIL PROTECTED]';
You would lose some indexing features, etc., but you could easily use a
language like Python that allows f
You can'd use sub-selects... you have to do it with a join.
Chris
>>>Can I make a query in mySQL like this? DELETE FROM table1 WHERE id NOT
EXIST IN (SELECT id FROM table2)
-
Before posting, please check:
http://www.mysql.
Hi,
I am using 4.0 and switching from MyISAM to InnoDB,
so quite newbie on this:
I have a couple of questions:
1) First, I read in the docs that the minimal thing to
do is to add to /etc/my.cnf
innodb_data_file_path=ibdata/ibdata1:2000M
(although the ibdata file is some 67M in /var/lib/mysql)
On Thu, Nov 15, 2001 at 12:21:19PM -0300, Walter D. Funk wrote:
> does anyone have a clue on how to manage japanese characters in a textfield
> in MySQL & PHP
> it works on varchar type fields , defining it as binary; but no way to make
> it work in a text or blob field
You have to think in
Hi, I have a mysql table I am searching using the FULLTEXT INDEX feature.
However, the legacy database that I am working from had 90 different fields
holding a keyword in each of them. Since the FULLTEXT INDEX only holds 15
different fields, I would much rather have the fields concatenated into o
no
-Original Message-
From: Lyubomir Simich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 12:04 PM
To: [EMAIL PROTECTED]
Subject: SUB-SELECT
Importance: High
Hello
Can I make a query in mySQL like this?
DELETE FROM table1
WHERE id NOT EXIST IN (SELECT id
Hello
Can I make a query in mySQL like this?
DELETE FROM table1
WHERE id NOT EXIST IN (SELECT id FROM table2)
--
WBR
Lyubomir mailto:[EMAIL PROTECTED]
-
Before posting, please check:
I would advice against using temporary tables as views for performance
reasons.
On Thursday 15 November 2001 10:21 am, Alexei V. Alexandrov wrote:
> > There is no support for views -- just hard-code your queries.
>
> It is olso possible to use temporary tables.
> But still the support for views
> There is no support for views -- just hard-code your queries.
It is olso possible to use temporary tables.
But still the support for views in mysql will be great :)
>
> On Thursday 15 November 2001 09:38 am, Alessio Torino wrote:
> > hi all,
> > can anyone explain me if mysql support view???
> >
Hi,
I installed Debian 2.2 to findout that MySQL 3.23 is not available (it's
still in the testing section) so I went and got it from the download section
on www.mysql.com and installed it, but where is the client (not GUI) part.
I need the mysql, mysqladmin files, I can't even set a password righ
insert-select on the same table is not allowed in MySQL. If I remember
right it isn't allowed in ANSI SQL either, supposedly because it could lead
to infinite loops if implemented poorly.
Jon Gardiner.
> -Original Message-
> From: Votteler Marc [mailto:[EMAIL PROTECTED]]
> Sent: Thursda
There is no support for views -- just hard-code your queries.
On Thursday 15 November 2001 09:38 am, Alessio Torino wrote:
> hi all,
> can anyone explain me if mysql support view???
> if yes what is the syntax?
>
> thanks to all
>
> alessio
>
>
hi all,
can anyone explain me if mysql support view???
if yes what is the syntax?
thanks to all
alessio
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Ahhh! Excellent. I didn't think my idea was quite right.
Thanks.
On Thu, Nov 15, 2001 at 09:32:38AM -0600, Paul DuBois wrote:
> At 10:06 AM -0500 11/15/01, Anthony R. J. Ball wrote:
> > MySQL 3.23.41 on Solaris
> >
> >
> > Alright, I have a system where data comes in once... or maybe
> >a f
At 10:06 AM -0500 11/15/01, Anthony R. J. Ball wrote:
> MySQL 3.23.41 on Solaris
>
>
> Alright, I have a system where data comes in once... or maybe
>a few times a day. I use this data to recreate a table, and then
>I need to safely and quickly replace the old table. I was thinking
>lock origin
Thank you, Carl and Chris, for helping me with this problem. Something else must be
happening, as I still can't log in:
www:~ # mysql -u zope -p
Enter password:
ERROR 1045: Access denied for user: 'zope@localhost' (Using password: YES)
www:~ #
Mysqlaccess shows:
www:~ # mysqlaccess -u zope -d
HI,
does anyone have a clue on how to manage japanese characters in a textfield
in MySQL & PHP
it works on varchar type fields , defining it as binary; but no way to make
it work in a text or blob field
thanx
-
Before pos
> From: Bennett Haselton
> My databases textbook from college says that specifying an
When I read my post I saw that I had made at least one obvious error.
Please change:
"An index is conceptually a container of keys arranged in such a way that
each key in the index refers to a unique record.
Hi guys, I get the module Msql-Mysql-modules-1.2217 to install DBD, but
when
is execute this command perl Makefile.PL i have a message that some
library no found.
The message
-
Which drivers do you want to insta
MySQL 3.23.41 on Solaris
Alright, I have a system where data comes in once... or maybe
a few times a day. I use this data to recreate a table, and then
I need to safely and quickly replace the old table. I was thinking
lock original table, drop it, and then rename the new table, but
I wasn't
FYI: im using mysql 3.23.44
auto_increment doesn't seem to work with InnoDB. i've tried to create a
table with:
create table some_table (
uid INT UNSIGNED AUTO_INCREMENT NOT NULL DEFAULT 1500,
user VARCHAR(100) NOT NULL,
PRIMARY KEY (uid),
UNIQUE KEY (uid)
) TYPE=INNODB;
i've also
> From: Bennett Haselton
>
> My databases textbook from college says that specifying an
> attribute as an
> "index" means that the data will be stored in such a way that
> lookups on
> that attribute are faster, and specifying an attribute as a
> "key" means
> that its values have to be unique.
Hi guys, I get the module Msql-Mysql-modules-1.2217 to install DBD, but
when
is execute this command perl Makefile.PL i have a message that some
library no found.
The message
-
Which drivers do you want to instal
Hello, I use BLOB fields to store pictures, it works nice, but problem
arises when trying to backup/restore data, or else export BLOB fields to
another database.
I tried to use MysqlFront to export / import data, but it appears can't
deal with BLOB, so it writes null character on TXT file for BLOB
After investigating my system, MySQL database server and application, i found
that something wrong with my configuration, Thanks a lot for Mr. Heikki
Tuuri for helping me.
Now, i do really believe that innodb is faster that myISAM, and more
reliable, just remember that you have to configu
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Grzegorz Paszka writes:
>> On Mon, Nov 12, 2001 at 07:21:07PM +0200, Sinisa Milivojevic wrote:
>> Another is as I wrote above. New database with content from
>> data source is also broken. I know that is sounds strang
Bennet> MySQL documentation says that CHAR and VARCHAR types are case-insensitive:
Bennet> http://www.mysql.com/doc/C/H/CHAR.html
Bennet> But I have a table with a column of type VARCHAR(255), and if I do a query
Bennet> like
Bennet> select * from user where LOCATE('Bennett', emailadd
Kishor,
>Hi,
>
>We are trying to implement row level locking in our appln.
>we have a table Orderwe are locking the table using
>SELECT * FROM Order FOR UPDATE;
>but still another user is able to update this table. why?
check with
mysql>SHOW TABLE STATUS FROM yourdatabasename;
that you
If you consider JSP, then JSP, Servlets, and MySQL by David Harms is
excellent.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 14, 2001 4:11 PM
To: Webmaster
Cc: [EMAIL PROTECTED]
Subject: Re: Need A book for dynamic website
On Wed, Nov 14,
Paul DuBois wrote:
> >Am I making wrong?, is there some function just to retrieve qty records
> >selected in a query?
>
> mysql_num_rows() is intended for SELECT queries. Its argument should be the
> result set identifier.
Thanks , I checked again, and problem was exporting scripts from Windows
> Hi,
>
> Is it possible to drop an auto_increment column index or primary key to
> boost performance for bulk inserts? It seems mysql requires auto_increment
> columns to be a key at all times.
>
> Here is the error message:
>
> Incorrect table definition; There can only be one auto column and it
| > One more question is how to transfer these values through
| > the MySQL C api ?
try this site...
http://www.mathtools.net/C++/Extra_precision_computation/
ati
-
Before posting, please check:
http://www.mysql.com/manual.
Hi!
I have tested your test case of two SELECT's producing different
outputs depending on the table ordering.
Those two queries were a problem :
-:-
SELECT link.titel,link.id FROM link, ord as o1,ord AS o2 WHERE o1.ord like
'bethanias%' AND o2.ord like 'ung
>Description:
Requests are much longer when using IN instead of =, even
if the list specified after IN has only one element.
>How-To-Repeat:
create table tmp (a integer, b integer, c integer);
create index tmp_id on tmp (a,b,c);
insert into tmp values (1,2,3
On Wed, 14 Nov 2001, Aaron Williams wrote:
> At 3:54 PM + 11/14/01, M. A. Alves wrote:
> >On Wed, 14 Nov 2001, Aaron Williams wrote:
> >> . . .
> >> I am not expert on innodb, or mysql either. I started playing with
> >> those values after reading the performance guide on Innodb.com.
> >
>
Does anyone know where to get a dictionary that would be for sql. I was
attempting to write up a few scripts for password stuff and thought it
would be easy if someone knew where to obtain a dictionary in sql
format. Any ideas would be helpful.
Thanks
--
Alex Kirk writes:
> > What version of MySQL are you using and is it our binary ??
>
> It's 3.23.37. I built it from source on my OpenBSD-2.9 box (i386
> architecture). It didn't appear to have any trouble when I built it.
>
> >
> > Also check the integrity in mysql database with CHECK TABLE.
> What version of MySQL are you using and is it our binary ??
It's 3.23.37. I built it from source on my OpenBSD-2.9 box (i386
architecture). It didn't appear to have any trouble when I built it.
>
> Also check the integrity in mysql database with CHECK TABLE.
mysql> check table user;
+-
1 - 100 of 121 matches
Mail list logo
