Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
Search
or browse popular tags
Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Privacy Policy

RSS Twitter

All pages tagged SQL

PHP: How to connect to MSSQL database

This tutorial describes how to connect to MSSQL database with a DSN and without a DSN. More...

Tags: PHP CONNECTION DATABASE MSSQL DSN ADODB DRIVER RETRIEVE PRINT Hits: 447860 Comments: 21

Back Up and Restore a MySQL Database

If you're storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups of your data to protect it from loss. This tutorial will show you two easy ways to backup and restore the data in your MySQL database. You can also use this process to move your data to a new web server. More...

Tags: MYSQL BACKUP RESTORE ZIP SHELL PHPMYADMIN HOW-TO Hits: 365212 Comments: 3

PHP: How to Encrypt Passwords in the Database

If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. This article will show you how to encrypt user passwords with md5 algorithm and how to start using encrypted passwords if you already have users' database ready. More...

PHP: How to connect to MySQL database using PHP

Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running. More...

Tags: PHP CONNECTION DATABASE MYSQL FUNCTIONS RETRIEVE PRINT SQL QUERY Hits: 184267 Comments: 25

ASP: How to connect to MS SQL Server database

In this tutorial we will show you how to connect to a MS SQL Server database using a DSN and without a DSN. More...

Tags: ASP CONNECTION DATABASE MSSQL DSN DRIVER RECORDSET SQL Hits: 90903 Comments: 5

How to create a dump of MySQL database in one click

Your users probably asked you to add an option to export the whole database to SQL file. This can be done in phpMyAdmin or Navicat of course but your users want something simpler than that. More...

Tags: PHP MYSQL BACKUP DUMP EXPORT Hits: 83237 Comments: 0

PHP: Export Database Schema as XML

Sometimes it can be useful to have a dump of the current database schema. This script reads the schema from a MySQL database and outputs XML that describes the schema. More...

Tags: PHP MYSQL XML SCHEMA Hits: 80150 Comments: 7

PHP: Blocking access to the login page after three unsuccessful login attempts

Sometimes you need to add an extra protection to password-protected website. This article explains how access to the login page can be restricted after three unsuccessful login attempts. This schema uses visitors IP address to store log attempts in the database and block access to login feature for 30 minutes after third unsuccessful attempt. More...

ASP: How to connect to MySQL database

In this tutorial we will show you how to connect to MySQL database using a DSN and without a DSN. More...

ASP: How to connect to database using a connection string

The power of Active Server Pages comes through when we tie databases to our web sites. To connect to a database, ASP uses what is called ActiveX Data Objects, or ADO for short. ADO comes with ASP, and can be used easily from your ASP pages. In this tutorial we will show you how to connect to our Access database and retrieve all the records from the table. More...

Tags: ASP CONNECTION DATABASE ADO ACCESS OLEDB ODBC SQL RETRIEVE PRINT Hits: 62275 Comments: 2

MS SQL Server Connection Strings

MS SQL Server ODBC and OLEDB connection strings More...

Tags: MSSQL ODBC OLEDB CONNECTION STRINGS Hits: 56862 Comments: 0

SQL: IN Operator

In SQL, there are two uses of the IN keyword, and this section introduces the one that is related to the Where clause. When used in this context, we know exactly the value of the returned values we want to see for at least one of the columns. More...

Tags: SQL IN WHERE QUERY RANGE INCLUSION EXCLUSION Hits: 47340 Comments: 2

Bike - drop in phpMyAdmin replacement

Pretty often you need to run a couple of queries against your MySQL database on the client's web server. Usually phpMyAdmin does the job well but there are situations when you just need to upload something to the server and open in the borwser, without any configuration steps.

Welcome Bike, lightweight phpMyAdmin replacement. If you already have a CMS installed on the web server (WordPress, Drupal, Joomla), simply upload Bike to CMS's subfolder and open it in the browser.

More...

Tags: PHP MYSQL PHPMYADMIN Hits: 47274 Comments: 0

SQL: ORDER BY

The Order By clause imposes an order on the query results. More...

SQL: DISTINCT Clause

The Distinct keyword eliminates duplicate rows from the query results. More...

Tags: SQL DISTINCT DUPLICATE ELIMINATION QUERY Hits: 42237 Comments: 3

SQL: HAVING Clause

The Having clause is optional and used in combination with the Group By clause. It is similar to the Where clause, but the Having clause establishes restrictions that determine which records are displayed after they have been grouped. More...

Tags: SQL HAVING QUERY GROUPBY RESTRICT DETERMINE DISPLAY Hits: 41948 Comments: 0

ADO and ADO.NET Connection Strings

Connection strings are string variables which contain database connection information and then passed to ADO which will interpret them and act accordingly. Since there are going to be passed to ADO, they need to be in a comprehensible for ADO format. This tutorial was created as an easy reference of various ADO and ADO.NET connection strings for the most popular database types. More...

MySQL Connection Strings

MySQL ODBC and OLEDB connection strings More...

Tags: MYSQL ODBC OLEDB CONNECTION STRINGS DATABASE Hits: 34412 Comments: 0

SQL: Join

Single table queries are useful but they do not exploit the full power of the SQL language. SQL is relational database query language and as such, one of its most important features is its ability to retrieve information from several different related tables. In relational database terms, this process is called a join. More...

Tags: SQL JOIN QUERY RETRIEVE RELATIONSHIPS MATCHING Hits: 28703 Comments: 1

SQL: INSERT Statement

The Insert Into statement can be used to append a record to a table or to append multiple records from one table to another. More...

Tags: SQL INSERT QUERY SINGLE MULTIPLE RECORDS TABLE Hits: 28116 Comments: 2

SQL: Union Clause

The Union clause allows you to combine the result sets of 2 or more individual queries. More...

Tags: SQL UNION QUERY COMBINE RESULTS SELECT Hits: 23788 Comments: 1

SQL: LIKE Condition

The Like condition allows you to use wildcard characters to specify one or more string character values. More...

Tags: SQL LIKE CONDITION WHERE QUERY WILDCARD PATTERN Hits: 23443 Comments: 0

SQL: SELECT statement

The Select statement allows you to retrieve records from one or more tables in your database. More...

Tags: SQL SELECT RETRIEVE RECORDS DATABASE TABLE Hits: 22240 Comments: 0

SQL: UPDATE Statement

The Update statement allows you to update a single record or multiple records in a table. More...

Tags: SQL UPDATE QUERY SINGLE MULTIPLE RECORDS Hits: 21359 Comments: 0

SQL: GROUP BY

The Group By clause of the Select statement lets you split up the values in a column as a whole. More...

Tags: SQL GROUPBY QUERY COMBINE RECORDS AGGREGATE SUM COUNT MIN MAX Hits: 19175 Comments: 0

SQL: BETWEEN ... AND...

The Between keyword allows you to define a predicate in the form of a range. More...

Tags: SQL BETWEEN QUERY PREDICATE RANGE UBOUND LBOUND Hits: 18451 Comments: 0

SQL Data Types

The following is a list of general SQL datatypes that may not be supported by all relational databases. More...

Tags: SQL DATA TYPES SUPPORTED RELATIONAL DATABASE Hits: 14681 Comments: 3

SQL: DELETE Statement

The Delete statement allows you to delete a single record or multiple records from a table. More...

Tags: SQL DE;ETE QUERY SINGLE MULTIPLE RECORDS TABLE Hits: 12727 Comments: 0

SQL: ALTER TABLE

Many times your design may have not accounted for everything it should have. Also, requirements for applications and databases in particular are always subject to change. The ALTER TABLE statement allows to change the structure of a table after it has been created. More...

Tags: SQL ALTER TABLE STRUCTURE ADD DELETE MODIFY Hits: 12395 Comments: 0

SQL: WHERE Clause

The Where clause is used to specify that only certain rows of the table are displayed, based on the criteria described in that Where clause. More...

Tags: SQL WHERE QUERY CRITERIA SELECTIVELY RETRIEVE Hits: 12203 Comments: 1

SQL: AND/OR conditions

The scope of the Where clause and the operators used with it can be extended by using the logical operators AND and OR. More...

Tags: SQL AND OR CONDITION LOGICAL OPERATORS SEARCH QUERY Hits: 11113 Comments: 0

How to determine MySQL version from the command line

How to determine MySQL version from the command line or from MySQL prompt. Quick and useful trick. More...

Tags: MYSQL Hits: 344 Comments: 0

How to transfer SQL Server logins between instances

Learn how to transfer logins and passwords between instances and between different versions of SQL Server. More...

Tags: SQL SERVER, MANAGEMENT STUDIO Hits: 171 Comments: 0

Fix: Insufficient access rights error when doing backup

All of sudden SQL Server Management studio gives me the following error message when I'm trying to browse for the backup file location: "Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)" More...

Tags: SQL-SERVER,SQL,BACKUP,PLESK Hits: 156 Comments: 0

Cannot load from mysql.proc. The table is probably corrupted

After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in Navicat: "Cannot load from mysql.proc. The table is probably corrupted". Luckily there is an easy fix. More...

Tags: SQL,MYSQL,UPGRADE Hits: 136 Comments: 0



Tags:

Add To: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments





Copyright © 2005-2014             www.WebCheatSheet.com All Rights Reserved.