correction:
D> Data integrity logic should be ensured by client application
should be read as:
Data integrity logic should be defined by client application
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
>>[MySQL]
>>1: START TRANSACTION
>>2: WITHDRAW $50 from account 32146.
>>3: DEPOSIT $50 into account 12345.
>>4: LOG transfer (date/time/teller/etc...) for auditing.
>>5: COMMIT TRANSACTION
DK> It depends why step 3 failed.
DK> If you want to rollback the transaction to the beginning on any error,
is there any difference between:
a)
>>select lname, fname
>>from person_tb, details_tb
>>where mem_id = det_id
>>and fin = "y";
and
b)
select lname, fname
from person_tb
where mem_id in (select det_id from details_tb where fin = "y")
which one will execute faster ?
--
MySQL General Mailing
mysql>> select projects.name from projects
JB> -> where projects.closeddate between :fd and :td;
JB> ERROR 1064: You have an error in your SQL syntax near ':fd and :td' at
JB> line
JB> 2
JB> What are those colons?
He probably uses Delphi or C++Builder to connect to mysql via TQuery
component.
select ID from YourTable
group by ID
having count(ID) > 1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>>>- Someone copies the DB files to another box, starts a mysql
>>>instance, loads the DB and presto - views the 'private' data !!!
>>>
PD> Sure. That's why you establish filesystem level access privileges so that
PD> only the mysql user can copy them in the first place.
Some DBMSs allow to setu
>> How does one restore a mysql database if it crashes in
>> the middle of a large operation?
RB> Not sure what you mean...
What if i on purpose turn off the computer when mysql is in the middle of
transaction execution ? Will the server on restart automatically
rollback the crashed transaction ?
>> 1.) If you want to have an "easy way tool" for creating your reports -
>> use MS Access
Yep if you know Access
WF> -- Tools are for dummy users, Clever users create tools. --
Clever users select the best way they can do things for themselves
What is best depends on user knowledge and objective
