Tags → Example Sql Code

Simple csv to MySQL tool

This code will take a csv file and create or, insert or update, the data into a MySQL database. It assumes the first line contains the field names and uses that to build the SQL query for the following data lines. There''s a download button fo...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Tags
  • csv in mysql,
  • csv mysql,
  • csv to mysql,
  • insert sql query,
  • mysql example,
  • mysql select,
  • mysql to csv,
  • select query,
  • sql if,
  • sql update
• Platforms
  • Linux,
  • Windows
• Licenses
  • Freeware

Fight Against SQL Injection Attacks

Security issues became more damageful if you''re not protecting your web forms. Following example is a good idea to protect our ASP pages against SQL injection attacks. This small ASP code secures and validates all information coming from your ...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Security
• Tags
  • asp code,
  • asp sql,
  • code example sql,
  • code sql,
  • if sql,
  • sql code,
  • sql example,
  • sql if,
  • sql information
• Platforms
  • Windows
• Licenses
  • Freeware

Create Excel from Form Input

ASP form input can be transformed into most any type of format that you''d like to see it in. Typically, most form input either gets delivered to a database, like Access or SQL server or the output is sent to an email address or some other appli...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Excel and ASP
• Tags
  • asp email,
  • asp excel,
  • asp form,
  • create excel form,
  • email script,
  • excel asp,
  • excel form,
  • excel input form,
  • script email,
  • sql like
• Platforms
  • Linux
• Licenses
  • Freeware

Display an Excel DB

The author writes &"For small data bits on a server where the chance for significant simultaneous traffic is not likely excel can perform many of the basic tasks that can be accomplished in Access or SQL Server, but on a much smaller scale.&...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Excel and ASP
• Tags
  • access sql,
  • access sql server,
  • in sql,
  • in sql server,
  • server sql,
  • sql code,
  • sql example,
  • sql server,
  • sql using,
  • sql where
• Platforms
  • Linux
• Licenses
  • Freeware