Dashboard > GreenPepperOpen > ... > Database > Executing statements
  GreenPepperOpen Log In View a printable version of the current page.  
  Executing statements
Added by Francois Denommee, last edited by Francois Denommee on Jan 27, 2010  (view change)
Labels: 
(None)

With the DbFit system under test, Execute interpreter can be used to execute arbitrary database statements.

database-connection

connect to MySql database on localhost with username dbgreenpepper and password dbgreenpepper and database dbgreenpepper

execute statement   Create table Test_DBFit(name varchar(50), luckyNumber int)
execute statement   Insert into Test_DBFit values ('Obi Wan',80)
execute statement   Insert into Test_DBFit values ('Darth Maul',10)
set of query   Select * from Test_DBFit
Name Lucky Number
Darth Maul 10
Obi Wan 80
execute statement   drop table Test_DBFit

DEMONSTRATION LICENSE - This Confluence site is for demonstration purposes only. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.4.3 Build:#705 Mar 21, 2007) - Bug/feature request - Contact Administrators