Count of total data with out using Count function
select sum(1) as count from tablename;
Count of total data using Count function
select count(*) from tablename;
Author Archives: Admin
Total count of a table data in mysql without using COUNT
Supported range of DATE,DATETIME,TIMESTAMP in mysql
DATE- Supported range is ‘1000-01-01’ to ‘9999-12-31’
DATETIME-Supported range is ‘1000-01-01’ to ‘9999-12-31’
TIMESTAMP-Supported range is ‘1970-01-01 00:00:01’ UTC to ‘2038-01-19 03:14:07’ UTC
MDF,LDF,NDF in RDBMS
MDF-Primary Data file–holds the data and datafiles
LDF-Log file–holds the transaction completed by database information
NDF-Secondary Data file- holds only data file
Examples of RDBMS
Oracle
Mysql
Microsoft SQL Server
Postgresql
IBM Db2
APS package: Enum field has empty entry in dropdown
Drop down is showing like this. please see the attached screen
If you give default value in the enum it will work without space
use the below scripts in source file
Upgrade firefox in Ubuntu
$ sudo add-apt-repository ppa:ubuntu-mozilla-security/ppa
$ sudo apt-get update
$ sudo apt-get install firefox
Displaying version number-Release version of ubuntu
lsb_release -a
Accessing problem of files in var/www in ubuntu
This is beacuse of permission problem go to terminal and add the following commands
chmod -R 775 /var/www/yourfolder
In service plan ‘Available for sale’ field showing as “IN ccp only” with Yellow color. Some other service plan it is showing “In online store and ccp” why
After Syncronizing the store it will show– as “Online store and CCP” with green color
For this go to Billing Section Product-onlinestore.