| |
|
|
| |
|
|
|
Added by Webmaster on Tuesday October 27, 2009
|
Discuss it| Favorite it |
| |
|
MySQL provides statistical data for users to get more knowledge about the tables in databases. The command to get this useful information is "mysql table status"... (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Webmaster on Tuesday October 27, 2009
|
Discuss it| Favorite it |
| |
|
MySQL Query browser is a freely available client tool to run queries and commands on MySQL servers. It comes as part of the MySQL GUI tools package, which can be installed on several platforms... (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Webmaster on Friday September 25, 2009
|
Discuss it| Favorite it |
| |
|
Use mysqladmin utility to find MySQL server's uptime. Run the following command from command line... (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Webmaster on Friday September 25, 2009
|
Discuss it| Favorite it |
| |
|
If you have an empty data folder or you want to initialize/reinitialize MySQL server from scratch (possibly after dropping all existing databases) then use these instructions... (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Webmaster on Friday September 25, 2009
|
Discuss it| Favorite it |
| |
|
To show indexes on a MySQL table execute any of the commands mentioned in the tutorial in a MySQL client... (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Webmaster on Friday September 25, 2009
|
Discuss it| Favorite it |
| |
|
You can speed up index scans if you periodically perform a void ALTER TABLE operation, which causes MySQL to rebuild the table... (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Webmaster on Friday September 25, 2009
|
Discuss it| Favorite it |
| |
|
If you have deleted a large no. of records from a table or if you have made many changes to a table with variables length rows, you should run OPTIMIZE TABLE command... (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Webmaster on Friday September 25, 2009
|
Discuss it| Favorite it |
| |
|
UNION is used to combine the result from multiple SELECT statements into a single result set. By default, when it is applied to more than one queries, returns unique result sets only. UNION ALL on the other hand returns all rows in the result sets... (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Sarbjit Singh Gill on Friday February 06, 2009
|
Discuss it| Favorite it |
| |
|
Objective: To create a customized login with access to some of the folders in a site.
In the previous two parts we learned how to leverage virtual directories and physical folders to offer a lot of control from IIS FTP. Now, what about when we want to have one site administrator have access to more than one, but not all, of the directories in a site? How is this accomplished from within IIS FT.. (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Sarbjit Singh Gill on Friday February 06, 2009
|
Discuss it| Favorite it |
| |
|
In previous section, we discussed the ways to use the hidden power of Microsoft's FTP server product. We talked about ways to leverage virtual directories along with Windows user accounts... (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Shahryar Ghazi on Thursday January 29, 2009
|
Discuss it| Favorite it |
| |
|
The Linux kernel uses this macro to find the current process. The current macro is defined in include/asm-i386/current.h (line 13) in both 2.6.0 and 2.4.18 kernels. This macro calls another function get_current()... (more)
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Added by Shahryar Ghazi on Thursday January 29, 2009
|
Discuss it| Favorite it |
| |
|
Linux kernel uses a number of advanced keywords, macros, and extensions to C language. Here is a description of some of these keywords, macros and extensions that I found troublesome to understand and had to investigate a little bit in order to understand them.
I have used kernel versions 2.4.18 or 2.6.0 for this tutorial... (more)
|
| |
|
|
|
|
|
|
|
| |
|
Click here for more tutorials. |
| |
|
|
|