Re: noob question

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

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

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

> 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

noob question

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 ** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely

Re: Noob Question: Error 1046

r queries. This means, you need to tell MySQL the database your queris should run on. Hope this helps Thanks Emery - Original Message - From: "Charlie Brewer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 21:12 Subject: Noob Questio

Re: Noob Question: Error 1046

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

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

Noob Question: Error 1046

Evenin', Sorry to send noob questions, I know how annoying they can be, but we need help too ;) Anyways, Im using a self teach book to teach myself PHP, MySQL and Apache. The book is getting into MySQL and basic commands. Anyways, they gave an example, and I typed it in as shown in the book,