|
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/Templates/main.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Operators</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><strong>Operators</strong></p>
<p> </p>
<table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
<tr>
<td width="60%"><div align="center"><font color="#990000">Comparison
Operators</font></div></td>
<td width="40%"> </td>
</tr>
<tr>
<td><div align="center">=</div></td>
<td>Equal To</td>
</tr>
<tr>
<td><div align="center"><></div></td>
<td>Not equal to</td>
</tr>
<tr>
<td><div align="center">></div></td>
<td>Greater than</td>
</tr>
<tr>
<td><div align="center">>=</div></td>
<td>Greater than-equal to</td>
</tr>
<tr>
<td><div align="center"><</div></td>
<td>Less than</td>
</tr>
<tr>
<td><div align="center"><= </div></td>
<td>Less than- equal to</td>
</tr>
<tr>
<td valign="top"><div align="center">LIKE</div></td>
<td>Match strings that starts with given characters</td>
</tr>
</table>
<p>All string comparisons in DarkSide SQL Mini are case sensitive. You don't
have to use a '%' operator in LIKE comparisons</p>
<p>eg:<br>
<code> SELECT * FROM emp WHERE name LIKE 'Jo'</code></p>
<table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
<tr>
<td><div align="center"><font color="#990000">Logical operators</font></div></td>
</tr>
<tr>
<td><div align="center">AND</div></td>
</tr>
<tr>
<td><div align="center">OR</div></td>
</tr>
</table>
<p>As of version 1, DarkSide SQL Mini do not support any arithmetic operations.</p></td>
<!-- InstanceEndEditable --></tr>
<tr>
<td height="58" colspan="2" valign="top"><div align="center">© 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.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Submit an article or tip