That is correct. Many db interfaces off programmatic abstractions of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil
mysql is successfull in login with same user and password but when the same
user and password is given at mysqltuner end it always shows the same error
[!!] Attempted to use login credentials, but they were invalid.
Thanks
Jeetendra Ranjan
SynapseIndia
Michael,
Does MySQL support multi-db transactions?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
Looks to me we should use XA transaction syntax instead. Check this:
http://dev.mysql.com/doc/refman/5.0/en/xa.html
Thanks,
YY
2009/10/28 Martijn Tonies m.ton...@upscene.com
Michael,
Does MySQL support multi-db transactions?
With regards,
Martijn Tonies
Upscene Productions
Upscene Productions releases a new version of
Database Workbench Lite
There are editions available for MySQL, Firebird and InterBase.
What is Database Workbench?
Database Workbench Pro is a cross database development environment
for database administrators
Ah, works for InnoDB I see.
Nice.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
I saw so many open tables in my server, is it dangerous? And if I
execute flush tables what does it impacts to the open tables? Thx.
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Will
Generally this means you need to look at the schema design of your database
system
If you are running a simple contact Database for Mom and Pop store and you have
connections to 100 tables open then you would want to take a more serious look
at the schema you are using to merge
If all the tables are InnoDB, XA isn't needed. It doesn't matter
whether all tables are in the same database.
On Oct 28, 2009, at 5:48 AM, Martijn Tonies wrote:
Ah, works for InnoDB I see.
Nice.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database
There seems to be some confusion about 'multi-db'.Within a single
MySQL instance, assuming that all your tables are a transactional type
(InnoDB isn't the only one), you don't have to do anything special to
cross database boundaries. XA is required if you plan to spread your
transactions out
There seems to be some confusion about 'multi-db'.Within a single
MySQL instance, assuming that all your tables are a transactional type
(InnoDB isn't the only one), you don't have to do anything special to
cross database boundaries. XA is required if you plan to spread your
transactions out
I've written a helpdesk ticket problem and am working on the statistics
module. I'm having problems with group by. For instance, I want to get
the count of the number of different problem types, by how many were
solved by each person. This is my statement:
mysql select distinct
try this:
select accepted_by, problem_type, count(*) from form
where problem_type is not NULL
AND problem_type != 'Test'
AND accepted_by is not null
group by accepted_by, problem_type
On Wed, Oct 28, 2009 at 12:05 PM, Adam Williams
awill...@mdah.state.ms.us wrote:
I've written a helpdesk
works perfectly, i didn't know you could use multiple columns in the
group by. thanks a bunch!
Michael Dykman wrote:
try this:
select accepted_by, problem_type, count(*) from form
where problem_type is not NULL
AND problem_type != 'Test'
AND accepted_by is not null
group by accepted_by,
We had a bit of a scare yesterday when one of our scripts just hung
indefinitely. We nailed it down to a query in the script. When we
executed the query manually, it hung as well. We ended up having
to restart MySQL which for some reason fixed it.
Some background: We're running MySQL 4.0.25.
Hi Everyone,
I am trying to backup a database regularly, without using Administrator
tool in mysql,
Can anyone help to write a scipt regarding backup database.
-Thanks in Advance
Ganeswar
16 matches
Mail list logo