Import large csv file using phpMyAdmin

by
phpmyadmin error

Getting Error while upload large file from phpMyAdmin: Soution: change the memory limit in php.ini file both upload_max_filesize and post_max_size also. Then restart the httpd service (web service)    

MySQL Skip Duplicate Replication Errors : skip replication error

by
mysql master - slave replication

Normally MySQL replication will stop whenever there is an error running a query on the slave. This happens in order for us to be able to identify the problem and fix it, and keep the data consistent with the mater that has sent the query. You can skip such errors, even if this is not recommended, as … Read more

CSS Selectors – manipulate HTML element : Chapter 3

by
html-css-website

CSS Selectors CSS selectors allow you to select and manipulate HTML element(s). CSS selectors are used to “find” (or select) HTML elements based on their id, classes, types, attributes, values of attributes and much more. 1. The element Selector The element selector selects elements based on the element name.You can select all <p> elements on … Read more

CSS Syntax : Chapter 2

by
html-css-website

A CSS declaration always ends with a semicolon, and declaration groups are surrounded by curly braces: p {color:red;text-align:center;} To make the CSS code more readable, you can put one declaration on each line, like this: Example p { color: red; text-align: center; } CSS Comments Comments are used to explain your code, and may help you when you … Read more

Convert seconds to hh:mm:ss format IN EXCEL

by

Use =A1/86400 Where A1 holds the time. Format as hh:mm:ss or whatever you need.   You can also try A1=9084 B1==TEXT(A1/(24*60*60),”hh:mm:ss”)   [xyz-ihs snippet=”Discuss”]

How to show or hide file name extensions in windows

by
windows

For Windows Vista, Windows 7, and Windows Server 2008 Start Windows Explorer, you can do this by opening up any folder. Click Organize. Click Folder and search options. Click the View tab. Scroll down until you notice Hide extensions for known file types, un-check this line by clicking the check box. Note To hide file name extensions, check this line. Click OK … Read more

Start learning CSS : Chapter 1

by
html-css-website

What is CSS? CSS stands for Cascading Style Sheets Styles define how to display HTML elements Styles were added to HTML 4.0 to solve a problem External Style Sheets can save a lot of work External Style Sheets are stored in CSS files CSS Saves a Lot of Work! CSS defines HOW HTML elements are to be displayed. Styles are normally saved in external … Read more