SEARCH KEYWORD -- DATABASE SUPPORT


  How does MySQL handle DROP TABLE

A few days ago, when executing DROP TABLE in MySQL, all processes including DDL and DML were hung until DROP TABLE was completed. I am confused about this phenomenon. I have reviewed the source codes of MySQL to check how MySQL internally handle DROP TABLE. When user trigger DROP TABLE command: ########################MySQL SERVER drop table######################## /* Sql_table.cc  delete (drop) tables. */bool mysql_rm_table( )   /*   Execute the drop of a normal or temporary...

   MySQL,DROP TABLE     2012-09-24 11:34:05

  The Ultimate Guide to Implement Function Overloading in Python

Introduction When it comes to function overloading, those who have learned Java should be familiar with it. One of the most common uses is logging, where different overloaded functions are called for different parameters. So, how can we implement function overloading in Python? Concept of Overloading Function overloading allows multiple functions with the same name to exist within the same scope, but with different parameter lists. Although many programming languages (like Java and C++) support ...

   GUIDE,JAVA,OVERLOADING,PYTHON     2024-11-14 22:29:17

  Samsung announces Galaxy S III mini

Samsung announces Galaxy S III mini today, compared to Galaxy S III, the mini version has some changes in screen size and configurations. Below are the detail configurations of Galaxy S III mini: 4-inch screen 800 × 480 resolution 5-megapixel primary camera, VGA front camera 1GHz dual-core processor Android 4.1 operating system Support the Samsung S Voice Personal Assistant, NFC and S Beam transmission function 1GB RAM, two versions with 8GB and 16GB memory, expandable to 32GB with microS...

   Galaxy S III mini,Configuration     2012-10-11 19:27:53

  PHP Apache MySQL Set-up Note

With the emergence of WAMP, LAMP, PHP developers are liberated from the tedious work of setting up PHP environment. Since PHP, Apache and MySQL are so tightly bundled, WAMP and LAMP provide a setp solution for setting up a PHP environment which includes the programming programming environment, server and database. But for a PHP who wants to learn more, you have to try to set the PHP environment yourself by installing PHP, Apache and MySQL manually and configuring them. Below is a simple note on ...

   PHP,Apache,MySQL     2014-04-07 01:56:43

  Which Type of IT Career is Best For You?

Considering the growth of the information technology job market, a career in IT is an incredibly smart career move.  A career in IT can mean many things – you can become a network administration, website developer, database specialist, programmer or engineer. The job range is vast and can suit various personalities and levels of technical skill. Having a good insight into those job profiles is key to make the right decision about your career path. Here's a selection of some of the mos...

   career,IT,tips     2014-07-30 09:21:40

  Simple PHP paging class

Frequently in our web applications, we may have many records in the database to display. In order to imrpove loading speed and efficiency, we may need to display some records at a time, so we need to paginate the records. For example, if we have 1 million book records and when users want to view the book list, it's inefficient to display all the records on the same page, we may need to have some pagination to allow displaying a portion of the records such as 20 records per page. This is a simple...

   PHP,Paging,Class     2012-09-10 20:23:33

  Chrome overtakes IE as the No.1 browser

According to data from market research company StartCounter, by May 2012, Chrome has overtakes IE as the No. 1 web browser globally. Firefox and Safari is following IE to be 3rd and 4th most popular web browser.In May, market share of Chrome is 33%, while IE only gets 32%. Firefox is slowly dropping, which has a share of 25%.  However, with release date of Windows 8 approaching, IE 10 will also be shipped with Win8, at that time, the number of users who use IE may increase because according...

   Chrome,No.1,IE,StatCounter     2012-05-21 06:03:04

  JSON in JavaScript

When sending an AJAX request to the server, the response can have two formats : XMLHttpRequest.responseXML to access data with XML format and XMLHttpRequest.responseText to access data with string format. XML is the standard data transfer format, but one weakness is it's troublesome to parse and retrieve the data. JSON(JavaScript Object Notation) is a light weight data interchange format, we call it the JavaScript object representation. The advantage of using JSON as the data format is itself is...

   JSON,JavaScript     2013-05-04 23:25:57

  China to expand 4G network across the country

According to Xinhua news, China Mobile, the country's largest telecommunication company is expanding its commercial trials of 4G network across the country including Tibet. On Tuesday, the Tibet branch of China Mobile held a ceremony to mark the beginning of its 4G network trial in Tibet. This plan includes building new 4G base stations there and also provide support for connecting to the 4G network. In this new plan, China Mobile's high speed network services will soon benefit people living in ...

   4G,China Mobile,Tibet     2013-06-13 05:06:41

  Microsoft is to release Office for iPad and Android

Microsoft plans to release Office series software on iPad and Android based tablets this November. This application's loading screen shows "Office for iOS" on iPad, this may indicate that it may also be compatible with iPhone and iPod Touch. The Office series software will also be available on Android at the same time. Some details about this application are still unknown, such as price and features. Last November there was news showed that Microsoft was developing Office for iOS. Micr...

   Microsoft,iPad,Office,Android,iOS     2012-05-24 03:33:28

RECENT