Re: noob question

2005-06-06 Thread mfatene
Hi, look at this : mysql> SET AUTOCOMMIT=0; mysql> start transaction; mysql> insert into inno values(2); mysql> select * from inno; +--+ | t| +--+ |1 | |2 | +--+ 2 rows in set (0.00 sec) mysql> rollback; mysql> select * from inno; +--+ | t| +--+ |1 | +--

Re: noob question

2005-06-06 Thread Digvijoy Chatterjee
Thank You for the quick reply , now i wanted to create INNoDb table such that i could rollback my changes ,but here i am as I issue a rollback command ; nothing happens...is there some thing like autocommit on...or rather how do i alter standard settings of mysql client... MY MAIN QUESTION is :

Re: noob question

2005-06-06 Thread SGreen
Digvijoy Chatterjee <[EMAIL PROTECTED]> wrote on 06/06/2005 10:09:15 AM: > How do i explicilty create an innodb table ? > I tried searching thro Manual...but did not get anything important > in the create t > table section. > Thanks > DIgz > > *** CAUTION - Disclaimer **

Re: noob question

2005-06-06 Thread Martijn Tonies
> How do i explicilty create an innodb table ? > > I tried searching thro Manual...but did not get anything important in the create t > > table section. CREATE TABLE ... ENGINE=InnoDB With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server

Re: Noob Question: Error 1046

2003-09-26 Thread Director General: NEFACOMP
Do you have a database you want to create that table in? You can use the test database if you are just testing. In that case you do: mysql> USE test If you want to create your own database: mysql> CREATE DATABASE database_name mysql> USE database_name And then continue your queries.

Re: Noob Question: Error 1046

2003-09-25 Thread Charlie Brewer
t;[EMAIL PROTECTED]> To: "Charlie Brewer" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 3:09 PM Subject: Re: Noob Question: Error 1046 > On Thursday, Sep 25, 2003, at 15:12 US/Eastern, Charlie Brewer wrote: > > and basic commands. Anyways, they gave an exam

Re: Noob Question: Error 1046

2003-09-25 Thread Hassan Schroeder
Charlie Brewer wrote: > http://hostultra.org/brewer/mysql.jpg 'Error 1046: No Database Selected' means just that :-) So you have to select one -- see HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-93