It would be mad sweet if this language could handle database queries.

<code>HAI
CAN HAS DBASE?
I HAZ A VARIABLE1 IS NOTHING
IM IN YR DATA ;) "test.mdb"
	CAN I PLZ GET column1 column2 column3
	ALL UP IN table1
	OMG column1 IZ BIGGER THAN 5
	ALL UR BASE R BELONG 2 VARIABLE1
IM OUTTA YR DATA
VISIBLE VARIABLE1
KTHXBYE</code>

This is basically broken down as such:

<code>CAN HAS DBASE?</code>
Lets u use databse lol.

<code>IM IN YR DATA ;) "test.mdb"</code>
Opens the database file test.mdb

<code>CAN I PLZ GET column1 column2 column3
ALL UP IN table1
OMG column1 IZ BIGGER THAN 5</code>
Retrieves column1, column2, and column3 from table1 where column1 is larger than 5. You can also retrieve mixed results from several tables - just select the columns from each table seperately before the OMG line and then say
<code>OMG column1 IN table1 IZ column2 IN table2</code>

<code>ALL UR BASE R BELONG 2 VARIABLE1</code>
Places data query results in variable1.

<code>IM OUTTA YR DATA</code>
Ends the database file usage.

Any suggestions for adding data to databases?

 --- //David Millar, 2007/05/29 02:30//

----

I'm not sure we'd want to actually re-do the SQL code itself.

 --- //Eric Stacey, 2007/05/29 03:07//

----

Database stuff could be really fun, but I see it as being something that's very difficult to spec out syntax wise while the rest of the language is still highly fluid.

 --- //Kyle, 2007/05/29 04:24//

----
Very much agreed, but the OP has my vote to develop and spec out a database library. I'm still concentrating on getting something that might handle Mad Libs one day. (You kids and your fancy Web2.0 shenanigans...)
 --- //Adam, 2007/05/29 13:08//

----
Perhaps IM IN UR <database> RETURNIN UR <query> would be a better syntax for quick SQL queries already connected. --- //Dan_Wood, 2007/05/30 12:47//

----
Or maybe IM IN UR <database> DIGIN4 <query>
 --- //Isaac, 2007/05/30 17:48//
----
I used:
<code>CAN HAS SQL?
DBASE IZ GETDB('lolz')
FUNNAHS IZ DBUCKET(&DBASE&,"CAN I PLZ GET joke ALL UP IN funnahs")
IM IN UR FUNNAHS ITZA JOKE
    VISIBLE "<P>".NL2BR(&JOKE#joke&)."</P>"
KTHX</code>
That's opening the DB, fetching array of jokes, using foreach loop and printing each joke.
 --- //Tetraboy, 2007/05/30 17:51//
----
<code>HAI
CAN HAS DBASE?
I HAZ A VARIABLE1 IS NOTHING
IM IN YR DATA ;) "test.mdb"
	CAN I PLZ GET column1 column2 column3
	ALL UP IN table1
	OMG column1 IZ BIGGER THAN 5
	ALL UR BASE R BELONG 2 VARIABLE1
IM OUTTA YR DATA
VISIBLE VARIABLE1
KTHXBYE</code>
Oh! Syntax Error - Undefined l33t function "VISIBLE". Maybe you forgot to include a library?
Searching libraries...Detected 1 match.
Try including STDIO in your uber l33t program!

lol, you forgot to HAS STDIO! In all honesty though, DB access would have to put off until we get more things done ;) but you're right, it would be Mad Sweet :P
 --- //Zenix, 2007/06/06 21:29//
----