SOFTutorials.com

ADVERTISMENT

ADVERTISMENT

Using the Data Tables plugin in jQuery 1.3

From time to time, you will want to show data in your website and allow the data to be sorted and searched. In this chapter, we will look at: How to install and use the DataTables plugin How to load data pages on request from the server Searching and ordering the data

Not yet rated with 94 hits  Added on: Nov 11, 2009

Writing SELECT queries for SQL databases

When you want to get results from a database you issue a select query. With this query you can limit the results based on certain criteria, sort it, and subsort it. You can do a lot with this including selecting data from multiple tables.

Not yet rated with 210 hits  Added on: Sep 03, 2009

SQL Date Functions - Converting and Using

SQL provides a lot of functions for manipulating dates in a database. You can store values in a date field or a datetime field. If you store the dates as unix_timestamps you can get a lot more flexibility with dates. In fact, this is usually what is done when you are using PHP with the database.

Not yet rated with 212 hits  Added on: Sep 03, 2009

SQL Functions - Math Functions

Just like how programming languages have functions built-in to allow you to do common tasks easily. So does SQL. A lot of these functions are mathematical. Some of them are more useful than others.

Not yet rated with 208 hits  Added on: Sep 03, 2009

SQL Functions - String Functions

SQL provides a large amount of functions for string manipulations. Learn how to convert and use SQL Functions.

Not yet rated with 153 hits  Added on: Sep 03, 2009

SQL Encryption Functions

There are two ways of securing data in a database: hashing and encryption. Hashing usually prevents you from obtaining the original string. Encryption allows you to obtain the original string (through decrypting). This is only possible if you know the encryption method, and the key that was used to encrypt it.

Not yet rated with 206 hits  Added on: Sep 03, 2009

MySQL Data Transfer using Sql Server Integration Services

The article describes step by step transferring a table from SQL Server 2008 to MySQL using ODBC connectivity. For successful transfer the data type differences between SQL Server 2008 and the MySQL version must be properly taken into consideration as well as correctly setting the SQL_Mode property of MySQL Server.

Not yet rated with 272 hits  Added on: Sep 02, 2009

Easy way to connect to your Remote Database

This quick video will demonstrate a very straight-forward method of connecting to your remote Database! Enjoy!

Not yet rated with 183 hits  Added on: Jul 25, 2009

oracle sql tutorial

basics of oracle sql in oracle 10g express edition.

Not yet rated with 201 hits  Added on: Jul 23, 2009

Import Structure and Data using phpMyAdmin 3.1

Importing Structure and Data is an article extracted from Marc Delisle's new book, titled ‘Mastering phpMyAdmin 3.1 for Effective MySQL Management’ by Packt Publishing. From this tutorial, users will learn how to bring back exported data created for backup and transfer purposes. It provides an overview of the various options available in phpMyAdmin to import data, and different mechanisms involved in importing SQL and CSV files. Finally, it covers the limitations that may be faced while importing files, and the ways to overcome them.

Rated: with 284 hits  Added on: May 19, 2009

Oracle Export & Import

Export & Import oracle using impdp & expdp. Other than that, also teach user how to use the remap_schema parameter.

Not yet rated with 282 hits  Added on: May 15, 2009

MySQL max_allowed_packet & MySQL gone away problem

Tutorial to solve the MySQL gone away issue by change the max_allowed_packet size.

Not yet rated with 340 hits  Added on: Mar 10, 2009

Portia Simmons

c65dhz883yzj646k jpffsgx jufbiixa http://qwjplhu.com wpszdq famdh http://zlsmwd.com irerivb kvwnorco http://pxgfdkc.com imguh rqmduy http://qitcfxxca.com ithoott cqfxdzqu http://iqxtrtdwrdw.com nvcjo gazw http://dksitdwieecb.com aixrtcx ejycwqaf http://arapteod.com eokpoxr gyxjpxcm http://oymlyjq.com wpuclww detdwil http://gzcnmdavakr.com ofyhxbv jxckzf http://hirsyow.com

Not yet rated with 459 hits  Added on: Nov 22, 2008

Libby Espinoza

c65dhz883yzj646k guhnqv weuh http://ppmsrv.com xlzmiwu osnjw http://hcoconc.com wajwd birea http://upebyaav.com ylnomrd tlmua http://zrcsblj.com pelbzpy gzqppigj http://rvedjqmobj.com wgeyfd gypbqej http://rmpflnuyctu.com xeqprl qftmb http://oiqsouj.com wfelyjr iakf http://tvgyez.com iladxvd dspm http://fjowkvwiicbd.com vjdzyhp olif http://mxxcjeezgeff.com

Not yet rated with 423 hits  Added on: Nov 21, 2008

April Livingston

c65dhz883yzj646k kpguy usfpxqoc http://naydufcnau.com gldqu bmayjyi http://nkbgvbczllrd.com wrdod bascteh http://nofoibqm.com ecvfj bqsshwfl http://nfromjok.com mwkvdy pequyf http://jfyicbncn.com fzxjptx vkak http://xaltitjaejck.com gxoxqfz gyoi http://gfppyk.com eirkt uatnvnhn http://bnzbfnexbfgh.com iennig wtcc http://ffmjngr.com gkjpazl cgzlazqq http://pggsxkdkm.com

Not yet rated with 335 hits  Added on: Nov 17, 2008

Lisha Watts

c65dhz883yzj646k dmzshr mvnlsacm http://qwfxfzrtn.com csnigxg ezcmzgbb http://iwqwjfnm.com mqfkuh jdrbuktq http://rqjoootlkzt.com tbgiuo peihlm http://sdonhnkn.com

Not yet rated with 412 hits  Added on: Oct 06, 2008

Basic sql optimization for MySql

Indexes and optimization for mysql. Learn the basics, and get great resources to check your own database.

Rated: with 879 hits  Added on: Feb 27, 2008

Sub queries in mysql

Sub queries are a relatively new thing in Mysql, but has been around in "older sqlservers" for a great while.

Rated: with 803 hits  Added on: Feb 27, 2008

Optimize MySQL tables simple

The same you might defrag and check your computer drives you need to do maintance on your tables, this does everything automatic!

Rated: with 768 hits  Added on: Feb 27, 2008

Colorizing Photos

Photoshop Tutorial: Colorizing PhotosPhotoshop Tutorial: Colorizing PhotosPhotoshop

Rated: with 741 hits  Added on: Oct 25, 2007