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

database-connection

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

set of query   select 'test' as x
x
test

Query can also work with multiple columns, and the order of columns does not matter

set of query   select 1 as n, 'test' as x
x n
test 1

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