|
|
pete_bisby
Logging database transactions is relatively easy within PostgeSQL and MySQL. Options can be set within the configuration files (postgresql.conf for PostgreSQL and my.ini for MySQL) to enable and record database INSERTs, UPDATEs and DELETEs. But if a client requires to view this information on a...
|
|
17 |
14,797 |
|
|
|
decodec
Introduction
A very interesting and useful capability of MySQL is to incorporate Regular Expressions (regex) in SQL queries. The regular expression support in MySQL is extensive. Let's take a look at using Regular Expressions in queries and the supported metacharacters.
Using Regular...
|
|
12 |
43,313 |
|
|
 |
Mary
Introduction
If you're using MySQL, there are some easy things you can do to secure your systems and significantly reduce the risk of unauthorised access to your sensitive data.
The most valuable asset for technology-based organisations is usually the customer or product information in their...
|
|
3 |
4,180 |
|
|
 |
hurricanesoftwares
Relational Database Design is one of the most powerful ways to ensure data integrity and a great way to kick-off any project. Very often the first thing developers do when starting a new project, or stub-project, is to design the database. This way the structure of the application is already in...
|
|
7 |
5,356 |
|
|
 |
pradeep
Many times we need to update a record but we might not know whether such a record exists or not. In traditional programming we usually check whether the record exists or not, then perfrom the appropriate query according to the result of the previous query. A very good example of such situatuion is...
|
|
2 |
7,278 |
|
|
 |
pradeep
Many of the more mature databases like MySQL, Oracle, PostgreSQL, etc. support the concept of prepared statements. Many languages or their database abstraction classes/modules support or sometimes need you to prepare the queries before they are executed, also some modules require that you prepare...
|
|
2 |
5,977 |
|
|
 |
shabbir
I just happen to make my life worse when I forgot my MySQL password on my Vista PC. I tried Googling out for forgot password for Windows Vista but happen to find everything from XP to Linux but not Vista and after going through each of them including the Linux one's as well I happen to reset the...
|
10-21-2007 11:07 AM
by verci 
|
5 |
8,839 |
|
|
 |
shabbir
MySQL
-?, --help, -IDisplay help.
--auto-rehashEnable automatic rehashing. Disable with --disable-auto-rehash.
-A, --no-auto-rehashNo automatic rehashing.
WARNING: options deprecated; use --disable-auto-rehash instead.
-B, --batch Don't use history file. Disable interactive behavior.
...
|
|
5 |
27,322 |
|
|
|
pradeep
Recent versions of MySQL have implemented support for foreign keys through the InnoDB table engine. Let's see how it works.
Referential integrity is an important concept in database design. The term refers to a state when all the references in a database are valid and no invalid links exist...
|
|
1 |
10,530 |
|
|
 |
Janu
Introduction
Data in MySQL is stored in files (or memory) using a variety of different techniques. Each of these techniques employs different storage mechanisms, indexing facilities, locking levels and ultimately provides a range of different functions and capabilities. By choosing a different...
|
|
1 |
5,650 |
|
|
|
pradeep
Sometimes we require to copy an existing MySQL table to another table, usually we get the SQL dump and execute it to create the new table, but we have a shortcut to do that.
For instance if we need to make a copy of go4expert_users to a table named go4expert_users_new we need to execute the...
|
|
0 |
4,682 |
|
|
|
Andrew
Introduction
A MySQL database abstraction class, which makes database handling easier and object-oriented.
The class:
class DBI
{
var $server;
var $user;
|
|
1 |
6,574 |
|
|
|
pradeep
Introduction
Sometimes we need to get a formatted date while getting the date from a MySQL database using a SQL query. Fortunately, MySQL has an in-built function called DATE_FORMAT which will help us to acheive the same.
DATE_FORMAT(date,format) What is what??
Here are the format...
|
|
0 |
4,836 |
|
|
|
pradeep
TEXT TYPES
CHAR( ) A fixed section from 0 to 255 characters long.
VARCHAR( ) A variable section from 0 to 255 characters long.
TINYTEXT A string with a maximum length of 255 characters.
TEXT A string with a maximum length of 65535 characters.
BLOB A string with a maximum length of...
|
|
0 |
6,965 |
