Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » General » Downloads
 
Add your own
alternative version

DarkSide SQL Mini Version 1, The embedded database

, 23 Mar 2006 BSD
An embedded database library in C++.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/Templates/main.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Data Types</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" --> 
<link href="ss.css" rel="stylesheet" type="text/css">
<!-- InstanceEndEditable --> 
</head>

<body bgcolor="#FFFFFF" text="#666666">
<table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
  <tr> 
    <td bgcolor="#CCCCCC"><h3><font color="#999999">DarkSide SQL Mini Help</font></h3></td>
  </tr>
</table>
<table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
  <!--DWLayoutTable-->
  <tr> 
    <td width="164" height="305" valign="top"><table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
        <tr> 
          <td><a href="index.htm">Home</a></td>
        </tr>
        <tr> 
          <td><a href="intro.htm">Introduction</a></td>
        </tr>
        <tr> 
          <td><a href="using.htm">Using The Library</a></td>
        </tr>
        <tr> 
          <td><a href="api_ref.htm">API Reference</a></td>
        </tr>
        <tr> 
          <td><strong>SQL Commands</strong></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_ct.htm">CREATE TABLE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_dd.htm">DROP DATABASE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_dt.htm">DROP TABLE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_use.htm">USE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_i.htm">INSERT</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_u.htm">UPDATE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_d.htm">DELETE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_s.htm">SELECT</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_o.htm">OPTIMIZE</a></div></td>
        </tr>
        <tr> 
          <td><a href="types.htm">Data Types</a></td>
        </tr>
        <tr> 
          <td><a href="oprs.htm">Operators</a></td>
        </tr>
        <tr>
          <td><a href="bugs.htm">Bugs</a></td>
        </tr>
        <tr> 
          <td><a href="lic.htm">License</a></td>
        </tr>
        <tr> 
          <td><a href="tps.htm">Third-party software</a></td>
        </tr>
        <tr> 
          <td><a href="abt.htm">About</a></td>
        </tr>
      </table></td>
    <!-- InstanceBeginEditable name="txt" -->
    <td width="398" valign="top"><p>DataTypes</p>
      <table border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
        <tr> 
          <td>SMALLINT</td>
          <td>Integer values in the range -32768 and 32767</td>
        </tr>
        <tr> 
          <td>INT</td>
          <td>Integer values in the range (-2147483647 - 1) and 2147483647</td>
        </tr>
        <tr> 
          <td>BIGINT</td>
          <td>As of now, same as INT</td>
        </tr>
        <tr> 
          <td>FLOAT</td>
          <td>Decimal values, 19 digits in length including 7 digit floating point 
            precision. </td>
        </tr>
        <tr> 
          <td>DOUBLE</td>
          <td>Decimal values, 25 digits in length including 14 digit floating 
            point precision. </td>
        </tr>
        <tr> 
          <td>CHAR</td>
          <td>Character strings with a maximum length of 255</td>
        </tr>
        <tr> 
          <td>VARCHAR</td>
          <td>Character strings of unlimited size. <a href="text.htm">more...</a></td>
        </tr>
        <tr> 
          <td>DATE</td>
          <td>Date values in the format YYYY-MM-DD. Use the constant 'sysdate' 
            to insert the system date. <a href="date.htm">more...</a></td>
        </tr>
        <tr> 
          <td>TIME</td>
          <td>Time values in the format HH:MM:SS.Use the constant 'systime' to 
            insert the system time.</td>
        </tr>
        <tr> 
          <td valign="top">TIMESTAMP</td>
          <td>A string representing the current date and time. Automatically inserted 
            by the database ignoring any value specified by the user.Better to 
            give 0 as a TIMESTAMP value in an insert</td>
        </tr>
        <tr> 
          <td>BOOL</td>
          <td>TRUE,FALSE values</td>
        </tr>
        <tr> 
          <td>AUTOID</td>
          <td>A BIGINT field that is automatically incremeneted by the database. 
            Specify 0 as its value in an INSERT</td>
        </tr>
        <tr> 
          <td>UID</td>
          <td> A unique ID same as AUTOID, but a random value created from the 
            system time.</td>
        </tr>
      </table>
      <p>&nbsp;</p></td>
    <!-- InstanceEndEditable --></tr>
  <tr> 
    <td height="58" colspan="2" valign="top"><div align="center">&copy; 2003 <a href="mailto:vijaymathewp@yahoo.co.in">LogicMatrix</a></div></td>
  </tr>
</table>
</body>
<!-- InstanceEnd --></html>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The BSD License

Share

About the Author

No Biography provided

| Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.150123.1 | Last Updated 23 Mar 2006
Article Copyright 2003 by AnOldGreenHorn
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid