This tutorial will help you to change the default page in the .htaccess file. To do this first make sure you are using Apache web server and you have enabled .htaccess for the virtual host. Let’s edit the .htaccess file on your website document root and add a DirectoryIndex entry followed by file name. Now Apache will use this file as your default file.

#Default index page

DirectoryIndex home.html

You can also define more than one file like below. In this Apache will serve one of below file default file.

#Multiple default index page 

DirectoryIndex home.html index.html index.php index.htm

The post How to Change Apache Default Page with htaccess appeared first on TecAdmin.

CREATE INDEX:-

This will creates index on mysql table. This will allow duplicate values also.

CREATE INDEX index_name ON table_name (COLUMN_NAME1, COLUMN_NAME2, ...)

CREATE UNIQUE INDEX:-

This will creates index on mysql table. With uses of UNIQUE keyword this will not allow duplicate values.

CREATE UNIQUE INDEX index_name ON table_name (COLUMN_NAME1, COLUMN_NAME2, ...)

1. CREATE INDEX Examples:-

For this example I have a table named Users with thousands of records in mysql database. The table structure is as following in screenshot.

Now use following command to create index named Users_Idx1 on table Users based on column username.

mysql> CREATE INDEX Users_Idx1 ON Users (username);

Use UNIQUE keyword with the query to create index with unique records.

mysql> CREATE UNIQUE INDEX Users_Idx1 ON Users (username);

2. SHOW INDEX Examples:-

Use following sql command to list all indexes for a mysql table. The below query will delete Users_Idx1 index from Users table in current database.

mysql> SHOW INDEX FROM Users;

3. DELETE INDEX Examples:-

Use following sql command to delete index on mysql table.

mysql>  ALTER TABLE Users DROP INDEX Users_Idx1;

The post How to Create, List or Drop Indexes on MySQL Table appeared first on TecAdmin.

This article will help you to set default document in IIS for any website configured. To do it follow the below step by step instruction’s:

1. Start IIS

Go to run window and type “inetmgr” and hit enter to open IIS web server in your windows system.

2. Select Default Document Option

Now go under sites option in left side bar and select your site. Now click on “Default Document” option as per showing in below screenshot.

3. Enter Default Page Name

• Now you will show a list of pages which is globally set as default document for your website.
• Now click on Add button in right sidebar.
• It will show a pop-up. Enter your filename to set as default document and click OK.

4. Set Top in Priority Order

No Select your new filename entered and put it at top of priority order by using “Move Up” button in actions side bar.

Now your default document has been correctly configured for your website in IIS web server.

The post How to Set Default Document in IIS appeared first on TecAdmin.