Mathieu,
The old_passwords option only changes how mysqld generates new
passwords. If old_passwords=0 when you create a new user mysql will
generate a long password that will only accept clients using the newer
protocol (and client lib). When old_passwords=1 mysql will generate
the older shorter
Hi
MySQL uses the product of the MAX_ROWS and AVG_ROW_LENGTH values for MyISAM
tables, to decide how big the resulting table should. If you don't specify
either option, the maximum size for a table is 65,536TB of data (4GB before
MySQL 5.0.6).
Ref: http://www.mysql.org/doc/refman/5.0/en/crea
I may not be totally right but :
1) Well it all depends of which client library they are using if they
are using the old library yes
2) Well if that client use the old libraby yes ... (btw you can check
the password field in the mysql.user table to view the difference =>
they have a different for
Hi,
The thing is, if the Outermost quote is single( ' ) , and if you try to use
the same inside the string, in that case you need to go for \'. The same
applies for Double quotes also. Double quotes within the single or single
quote within the double dosen't reqire blackslash.
For instanc
Thanks for all your help Mike.
Problem solved. I divided to process in two parts: one write the
insert/update/delete and then write the changes in the audit trail. All this
inside one transaction. If the first part fails, ROLLBACK. If the second
part fails, ROLLBACK, otherwise, if both were done o
Andre Matos wrote:
Thanks Mike.
I understand the possible "gaps" that I might have if I use the ROLLBACK.
This is acceptable in my case.
What I really want to avoid is what I am doing now: open one transaction to
insert, or update, or delete certain information and close with the commit.
Then,
Thanks Mike.
I understand the possible "gaps" that I might have if I use the ROLLBACK.
This is acceptable in my case.
What I really want to avoid is what I am doing now: open one transaction to
insert, or update, or delete certain information and close with the commit.
Then, I get the LAST_INSER
Anil Doppalapudi wrote:
Hi List,
Any update on this
Thanks
Anil
Hi List,
Below is the output of mysqldumpslow. In the output query execution time is
showing -ve value how to interpret the below output i.e how to interpret
-ve value for query execution time please advice
Nobody has
Andre Matos wrote:
SET AUTOCOMMIT=0;
START TRANSACTION;
INSERT INTO staff (`Name`) VALUES ('ABC');
INSERT INTO changes (`Key`, `Table`, `Value`) VALUES (LAST_INSERT_ID(),
'staff', 'ABC');
COMMIT;
SET AUTOCOMMIT=1;
This works fine in my test environment, however what about many users doing
at the
Andre Matos wrote:
The idea is to have a audit trail to record the changes made. So, I want to
insert a new record in the "staff" table and right after this, insert a
record in the "changes" table.
SET AUTOCOMMIT=0;
START TRANSACTION;
INSERT INTO staff (`Name`) VALUES ('ABC');
INSERT INTO change
Hi List,
Let's suppose I have these two tables:
CREATE TABLE `changes` (
`ID` int(12) unsigned NOT NULL auto_increment,
`Key` varchar(25) collate latin1_general_cs NOT NULL default '',
`Table` varchar(25) collate latin1_general_cs NOT NULL default '',
`Value` text collate latin1_general_c
The second edition of MySQL Cookbook (O'Reilly, 2006) is now available.
The second edition brings the recipes up to date for MySQL 5.0/5.1. For
example, it covers views, stored routines, triggers, and events. The
second edition also adds coverage for Ruby (using the Ruby DBI module).
More inform
Hello everyone,
I have a few questions on the use of the BDB engine with MySQL.
If I use the BDB storage engine for a table, is it safe for me to
access the BerkeleyDB file while MySQL may possibly writing to it?
The database commits are nothing more than simple inserts, updates,
and deletes. Th
Nicholas Vettese wrote:
> I am looking for a book that will help me understand PHP/MySQL, and the
> way that they work together. My biggest problem is multi-valued
> selections, and INSERTING them into the database. A book with great
> examples like that would be a huge help. Also, any websites
Hello,
I'm hitting a performance wall on my MySQL primarily I believe because
the bin log and the InnoDB logs are on the same volume group as
another MySQL server. In reality, I have four MySQL servers, two per
server (in Solaris Containers). All four are sharing the same volume
group to maximize
Thanks for the tip.
I have just entered the SQL statement and it isn't giving me the totals I
want but you have given me something to look up to see if I can use uit to
get what I want. I suppose in programming terms what I am after is:
totsurname=0,totstreet=0,tottown=0,totdistrict=0,tot=0
for
I'm not sure that this is exactly what you want, but I think you can use
the WITH ROLLUP modifier:
select district, town, street, surname, count(surname)
from test5
group by district asc, town asc, street asc, surname asc WITH ROLLUP
Here's a link to the MySQL documentation on WITH ROLLUP
http:
Hi,
OCFS is a cluster filesystem so running two mysqld over the same OCFS
directory is exactly the same
as running two mysqlds over the same directory in a local filesystem on
the same machine which is
strictly prohibited.
If you decide to consider mysql clustering over ocfs please keep in
mi
Hope I have the right group.
I am working out how to get groups within groups. e.g.
I have a table with 4 columns C1,C2,C3 & C4
I am looking to select data so that I can get
C1 group item
C2 Group item
C3 Group Item
C4 detail
End of C3 Group Item
count/totals of
>> You seem to be mimicking the prepared query feature of mysqli in PHP5.
Do you
>> have the mysqli extension available? If so, you can use things like:
>>
>> http://www.php.net/manual/en/function.mysqli-stmt-bind-param.php
>>
>> which has an example as to how to utilize a prepared query.
>>
>>
I am using Full-Text searching with In Boolean Mode. I am generating
my query by using binding parameters. If a user types in a quoted
string on the search form (in order to match that string as-is), the
binding mechanism escape it with a backslash. The query runs fine and
it appears to return the
Chris White wrote:
On Monday 27 November 2006 09:12, Filipe Freitas wrote:
CREATE PROCEDURE `getListaDeNewsflashes`(in quantidade smallint)
COMMENT 'Devolve uma tabela com um número limite de newsflashes'
begin
PREPARE statement FROM "SELECT * FROM newsflashes ORDER BY RAND() LIMIT ?";
SE
Ysgrifennodd ViSolve DB Team:
Hi Renish,
If you want to capture the entries which are entered more than once.
Here's the answer for it.
mysql> select * from a;
++
| b |
++
| pen|
| pencil |
| rubber |
| pen|
| paper |
| paper |
++
6 rows in set (0.00 sec
David T. Ashley wrote:
On 11/27/06, Nicholas Vettese <[EMAIL PROTECTED]> wrote:
I am looking for a book that will help me understand PHP/MySQL, and the
way that they work together. My biggest problem is multi-valued
selections, and INSERTING them into the database. A book with great
examples
On Tue, 2006-11-28 at 17:58 +0100, Stefan Onken wrote:
> Can you explain this a little bit more ? I am not the guy who set it
> up, so I would like to go back them and say "Well, You cannot do
> this, because... " :)
http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html describes
the pit
OCFS probably provides protection at the file level, but mysqld undoubtedly
keeps some critical information in its own internal memory. The two MySQL
daemons are oblivious to each other, so that memory-resident information
will not be synchronized.
Regards,
Jerry Schwartz
Global Information Incor
Am Dienstag, 28. November 2006 15:21 schrieb Gerald L. Clark:
> [EMAIL PROTECTED] wrote:
> > Hello,
> >
> > We recently moved to a new "cluster" plattform, setup by one
> > external IT company
> >
> > at present (early stage):
> > 2 XEON computers with a fibre channel link to a Network
> > Storage.
Sounds more like it's setup on a SAN.. a NAS is a different type of unit
like a NetApp filer.
I'd have to agree with the other poster, I'm not sure your current config
is valid.
A more typical setup would be that both boxes should have their own
unique SAN partitions, and a high speed network c
At 8:57 -0500 11/28/06, Ronald Vincent Vazquez wrote:
Hello Nishant:
I was able to code a simple client which inserts/deletes data into the
database after reading this:
http://www.kitebird.com/mysql-book/ch06-3ed.pdf
Sample chapter (Chapter 6: The MySQL C API) from MySQL by Paul DuBois
Good lu
On Monday 27 November 2006 09:12, Filipe Freitas wrote:
> CREATE PROCEDURE `getListaDeNewsflashes`(in quantidade smallint)
>COMMENT 'Devolve uma tabela com um número limite de newsflashes'
> begin
> PREPARE statement FROM "SELECT * FROM newsflashes ORDER BY RAND() LIMIT ?";
> SET @limit=quanti
Yes, it's true that the query won't work if you have duplicate aid,bid
rows. I probably shouldn't have assumed that there would be a PK or
unique constraint on aid,bid. So if that isn't the case, you can add a
distinct:
SELECT AID
FROM AhasB
WHERE BID in (1,2)
GROUP BY AID
HAVING count(disti
>From what I know, an index on a field that can only have two values will
never be used, except to make INSERTs slower.
By the way, I think I remember that you have a VARCHAR in those records.
Doesn't that force the CHAR to become a VARCHAR under the hood? That might
be less efficient that using s
James Northcott / Chief Systems wrote:
>SELECT AID
>FROM AhasB WHERE BID in (1,2)
>GROUP BY AID
>HAVING count(BID) =2
Not quite, since that will catch aid's with two bid=1 rows or bid=2 rows:
SELECT * FROM t;
+--+--+
| i| j|
+--+--+
|1 |4 |
|1 |5 |
|3
SELECT DISTINCT a,b,c,d,e FROM tbl;
Renish wrote:
How abt to return the distinct rows?
- Original Message - From: "Peter Brawley"
<[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>;
Sent: Tuesday, November 28, 2006 11:48 AM
Subject: Re: Simple doubt
>But if I do like this..
>sele
Daniel, you might look into the use of MERGE tables, which are
essentially multipule identical MyISAM tables that look like one
table.
Dan
On 11/27/06, Chris White <[EMAIL PROTECTED]> wrote:
On Monday 27 November 2006 13:50, Daniel Smith wrote:
> Assuming a decent spec server, would a simple s
Peter Brawley wrote:
>I want to find all A's such that
>they have exactly B's 1 and 2
>SELECT A.ID, group_concat(BID ORDER BY BID) as Bs
>FROM A INNER JOIN AhasB ON A.ID=AID
>GROUP BY A.ID
>HAVING Bs='1,2'
Why the join? Doesn't your ahasb bridge table already incorporate the
join logic? If your
Hi.
I've created the following table, with default value for MAX_ROWS. As
the following shows, it has a max. size of 4G.
I'm wondering: Is the expected max number of rows in this table =
Max_data_length \ Avg_row_length?
If not, what might it be?
How do I calculate it?
mysql> show table status fro
[EMAIL PROTECTED] wrote:
Hello,
We recently moved to a new "cluster" plattform, setup by one external IT
company
at present (early stage):
2 XEON computers with a fibre channel link to a Network Storage. The mysql
directories are located on the Network storage and mounted into
/var/lib/mysql on
Hello,
We recently moved to a new "cluster" plattform, setup by one external IT
company
at present (early stage):
2 XEON computers with a fibre channel link to a Network Storage. The mysql
directories are located on the Network storage and mounted into
/var/lib/mysql on each machine. So, every ma
Hello Nishant:
I was able to code a simple client which inserts/deletes data into the
database after reading this:
http://www.kitebird.com/mysql-book/ch06-3ed.pdf
Sample chapter (Chapter 6: The MySQL C API) from MySQL by Paul DuBois
Good luck,
RV
On Tue, November 28, 2006 02:08, Nishant Gupta w
I need some clarification on the old password issue as I am having problems
logging in.
Here is what I am running into now.
Original Server config:
my.cnf is NOT using the old_passwords=1 under MySQL-server-4.1.14-0
I am able to login via phpmyadmin without problem, remotely with mysqladmin
a
I think this will work:
SELECT AID
FROM AhasB
WHERE BID in (1,2)
GROUP BY AID
HAVING count(BID) =2
Donna
James Northcott / Chief Systems <[EMAIL PROTECTED]>
11/27/2006 04:35 PM
To
mysql@lists.mysql.com
cc
Subject
Many-Many relation, matching all
Hello,
I'm having a conceptual iss
Joey wrote:
I wanted to confirm something as I am having a problem logging into mysql
from the network.
I have a server configured with a user showing host as % and the user with
it's appropriate privalages. It allows me to login from phpmyadmin as well
as via port 3306 to connect to the DB wi
Hi,
I'm not a wizard on the MySQL optimizer, but here's my go...
> > Two questions for you:
> > 1) Why store so many repeatable data in the same table?
> > I mean you needn't to store "purchases"/"previews" for all records.
> > You can choose MySql SET datatype, or you can choose another table to
[EMAIL PROTECTED] wrote:
>
> Hi Andy,
>
> Two questions for you:
> 1) Why store so many repeatable data in the same table?
> I mean you needn't to store "purchases"/"previews" for all records.
> You can choose MySql SET datatype, or you can choose another table to
> store the action types and let t
I wanted to confirm something as I am having a problem logging into mysql
from the network.
I have a server configured with a user showing host as % and the user with
it's appropriate privalages. It allows me to login from phpmyadmin as well
as via port 3306 to connect to the DB with MySQL gui to
Filipe Freitas wrote:
Hi,
This is not a mysql thing but maybe you can help me.
I want to call a stored procedure from PHP, so I tried it like normal
querys: mysql_query("CALL mySP();"); with no success.
thx
I'm not PHP expert but I've managed to do this in perl using DBI (in
spite of all d
47 matches
Mail list logo
