Tags → Inserting Into Sql

Insert Date into Access Database

When inserting a date into an Access database you should use the format YYYY-MM-DD. Our function AccessDate returns a date in YYYY-MM-DD format. When working with a date in Access always use the # delimiters in your SQL statement.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Date and Time
• Tags
  • access sql,
  • date format function sql,
  • date format in sql,
  • date format sql,
  • date format sql access,
  • format date sql,
  • function in sql,
  • function sql,
  • sql date,
  • sql date format
• Platforms
  • Windows
• Licenses
  • Freeware

RW MySQL Dump

Use RW My SQL Dump to backup your MySQL databases, both structure and data. The script can be run from command prompt only. So, you can use crontab or other system scheduler to fully automate your data backup process. The script browse all databses t...

• Categories
  • CGI and Perl →
  • Scripts and Programs →
  • Database Tools
• Tags
  • directory script,
  • mysql backup,
  • mysql backup script,
  • mysql script,
  • mysql select,
  • mysql select script,
  • script directory,
  • sql command,
  • sql structure,
  • statements
• Platforms
  • Linux
• Licenses
  • Freeware

phpSQLGen

This project provides functions for generating SQL queries, HTML tables, and XML documents. It consists of two classes and a set of utility functions. SQLGen provides PHP functions for generating SQL query strings from arrays. TableMaker generates an...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Tags
  • adodb,
  • adodb php,
  • html layer,
  • php adodb,
  • php array,
  • php database abstraction,
  • php xml,
  • php xml output,
  • xml output php,
  • xml php
• Platforms
  • Linux
• Licenses
  • Freeware

Inserting Records into the Database using Java Servlets.

An article on inserting records into the database with Java Servlets. Every step from establishing a Connection to executing the INSERT SQL query is explained in detail. Online demo available.

• Categories
  • Java →
  • Tips and Tutorials →
  • JSP and Servlets →
  • Database-Related
• Tags
  • connection database java,
  • connection java,
  • database in java,
  • in java,
  • insert query,
  • insert sql query,
  • java database,
  • java database connection,
  • sql insert,
  • sql insert java
• Platforms
  • Linux
• Licenses
  • Freeware