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

With the DbFit system under test, Insert Into interpreter can be used to insert records into a table (similar to the SetUp interpreter).

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)
insert into Table   Test_DBFit
name luckyNumber
pera 1
nuja 2
nnn 3
set of query   Select * from Test_DBFit
Name Lucky Number
pera 1
nuja 2
nnn 3
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