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
• 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
• 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
• 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
• Platforms
  • Linux
• Licenses
  • Freeware