Archive
Archive for the ‘My SQL’ Category
CURTIME() Vs NOW()
CURTIME() returns the TIME part of the current time.
NOW() returns the date and time portions as a timestamp in various formats, depending on how it was requested
Example
mysql> SELECT NOW(),CURDATE(),CURTIME();
+———————+————+———–+
| NOW() | CURDATE() | CURTIME() |
+———————+————+———–+
| 2012-06-18 14:14:01 | 2012-06-18 | 14:14:01 |
+———————+————+———–+
1 row in set (0.03 sec)
The difference between MySQL CURTIME() and NOW()
CURTIME() returns the TIME part of the current time.
NOW() returns the date and time portions as a timestamp in various formats, depending on how it was requested
Example
mysql> SELECT NOW(),CURDATE(),CURTIME();
+———————+————+———–+
| NOW() | CURDATE() | CURTIME() |
+———————+————+———–+
| 2012-06-18 14:14:01 | 2012-06-18 | 14:14:01 |
+———————+————+———–+
1 row in set (0.03 sec)
MySQL CURDATE() Vs NOW()
CURDATE() returns the DATE part of the current time.
NOW() returns the date and time portions as a timestamp in various formats, depending on how it was requested
Example
mysql> SELECT NOW(),CURDATE(),CURTIME();
+———————+————+———–+
| NOW() | CURDATE() | CURTIME() |
+———————+————+———–+
| 2012-06-18 14:14:01 | 2012-06-18 | 14:14:01 |
+———————+————+———–+
1 row in set (0.03 sec)
The difference between MySQL CURDATE() and NOW()
CURDATE() returns the DATE part of the current time.
NOW() returns the date and time portions as a timestamp in various formats, depending on how it was requested
Example
mysql> SELECT NOW(),CURDATE(),CURTIME();
+———————+————+———–+
| NOW() | CURDATE() | CURTIME() |
+———————+————+———–+
| 2012-06-18 14:14:01 | 2012-06-18 | 14:14:01 |
+———————+————+———–+
1 row in set (0.03 sec)
BLACKHOLE storage engine
The BLACKHOLE storage engine accepts data but does not store anything . So on retrieval it will return nothing .
When we create BLACKHOLE table the server will create file with name starts with table name with extension .frm . No other tables will be generated as it stores nothing .
It supports all types of indexes .
Though nothing is stored , the query statements get stored if binary logs are enabled .
It does not support AUTO INCREMENT
CSV Storage Engine
The ARCHIVE storage engine is used for storing large amounts of data without indexes in a very small footprint.
When you create an ARCHIVE table, the server creates a table format file in the database directory. The file begins with the table name and has an .frm extension. The storage engine creates other files, all having names beginning with the table name. The data and metadata files have extensions of .ARZ and .ARM, respectively. An .ARN file may appear during optimization operations.
The ARCHIVE engine supports INSERT and SELECT, but not DELETE, REPLACE, or UPDATE. It does support ORDER BY operations, BLOB columns
Random Posts
- How to add cross-sell to a product - Magento
- Find out process id of a process - Linux
- extract
- strstr()
- Namespaces
- Requirements for running a Solr server
- filter_id()
- SQL BETWEEN
- strlen()
- Create an array containing a range of elements - PHP
- popen
- number_format()
- join()
- Remove menu reward points from my account page magento
- SQL AUTO INCREMENT
- Change sent email address on contact form magento
- idate
- How to change editor font - WordPress
- date_format
- DateTime::setDate()
- Customize unity launcher Ubuntu 11.10
- date_sunset
- getFormAction() return null value contact form magento
- Success or failure messages are not being displayed contact page magento
- php replace html tags
Categories
- .htaccess (32)
- Ajax (3)
- Apache (17)
- Cookie (4)
- Database Model (9)
- Design Pattern (9)
- Filter (27)
- general (45)
- HTML (1)
- IP.Board (1)
- Javascript (17)
- Jetty (3)
- Joomla (17)
- jQuery (15)
- JSON (3)
- Linux (77)
- Magento (195)
- My SQL (35)
- Open sources (0)
- Payment Gateway (1)
- PHP (817)
- Plugins (11)
- Prototype (1)
- session (5)
- Socialengine (1)
- Sports (0)
- SQL (69)
- SVN (17)
- Vbulletin (11)
- Wordpress (87)