Everything from Everywhere - Daily Acquisitions

To change column name in MySQL Table, ALTER TABLE table_name CHANGE old_column_name new_column_name DATA_TYPE; For example,to change misspelled column name 'fist_name', ALTER TABLE users CHANGE fist_name first_name VARCHAR(64); In addition, you can change multiple column names in a query and set languages, default value, etc. ALTER TABLE users CHANGE fist_name first_name VARCHAR( 64 ) NOT NULL,   CHANGE username user_name VARCHAR( 32 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,   CHANGE gend gender TINYINT( 1 ) NOT NULL DEFAULT 0;

Sometimes, it is needed to insert multiple columns at a time. Next MySQL multiple insert queries performs perfect, of course INSERT INTO   table_name (column-1, column-2, ... , column-n)   VALUES (value-1-1, value-1-2, ... , value-1-n); INSERT INTO   table_name (column-1, column-2, ... , column-n)   VALUES (value-2-1, value-2-2, ... , value-2-n);   ... INSERT INTO   table_name (column-1, column-2, ... , column-n)   VALUES (value-m-1, value-m-2, ... , value-m-n); But next single query is easy to use and save memory ant time INSERT INTO   table_name (column-1, column-2, ... , column-n)   VALUES     (value-1-1, value-1-2, ... , value-1-n),     (value-2-1, value-2-2, ... , value-2-n),     ... ,    (value-m-1, value-m-2, ... , value-m-n); But be careful with large data (value). Your server or machine might be stop the execution due to the security or resource issues such as execu...

Sometimes, I want to make another actions using anchor(<a>) tag, for example, design sum menus and showing floating popup. For doing that, I do not define 'href' attribute on the tag and define actions using JavaScript or jQuery like this.

Like other Google services, Google CSE (Custom Search Engine) had a good simple look. I like the new Google Style- It's simple, intuitive, and easy to use. However, sometimes it makes me stupid.

For developing and enhancing your websites or blogs, JavaScript is essential in some sense. Here, I list simple but useful and essential functions of JavaScript. You may want to seek jquery functions or methods for solving the problem, but it may make your pages heavy sometimes, especially in the case of JavaScript is capable to do that simply. (I do not say jquery is a heavy stuff. I love jquery!)

Bloggers using Google Blogger Service are used to design menu by using PageList Widget. In Page menu  on Blogger, you can make your own page or links to URL where your want to put. For example  a web address 'http:// yourblogname .blogspot.com/search/label/ yourlabelname as a page can be a menu item of your blog. (I also made menubar in this blog by linke some address using labels). You can put your the pagelist widget on top tabs or sidebar. The position can be decided in the Page menu page.

There are lots of redirect checking tools to know what type of redirection used in a page. They are all SEO companies or websites and some of them requires additional information and show results with many advertisements. Here are some tools we can use free online and less ads relatively.