|
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/Templates/main.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Delete</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>DELETE</strong></p>
<p>The DELETE command is used to delete records from a table. When youu
execute a delete, the records are marked as deleted. They are actually
removed from the table only when you issue the <a href="sql_o.htm">OPTIMIZE</a>
command. It is important to optimize your table if your application deletes
too many rows. </p>
<p>Syntax:<br>
<font color="#990000">DELETE FROM table WHERE condition</font></p>
<p>eg:<br>
<code>DELETE FROM books WHERE date_of_pub < '1980-2-2'</code></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