This is incompatible with sql_mode=only_full_group_by – MySQL
Your MySQL is enabled ONLY_FULL_GROUP_BY mode, don’t worry you can disable it simply There are two solutions to disable it:
Read moreMySQL
SELECT list is not in GROUP BY clause and contains nonaggregated column
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘returntr_prod.tbl_customer_pod_uploads.id’ which is not functionally
Read moreERROR 1698 (28000): Access denied for user ‘root’@’localhost’
When you try to login to the MySQL database with the root user, you get the “ERROR 1698 (28000): Access denied
Read moreImport/Export database from server using command
Connect to server using PUTTY or other server connecting tools. After connection connected to server successfully run following Import Database:
Read moreMySql Error – field doesn’t have a default value
You getting this error STRICT_TRANS_TABLES mode. You updated the MySQL version or using MySQL 5.7.5 version. The STRICT_TRANS_TABLES mode was added to the
Read moreAll Countries SQL file with Country Codes, Phone codes
Updated Sql dump of all the Countries, Country Codes, Phone codes.
|
1 2 3 4 5 6 7 8 9 10 |
CREATE TABLE IF NOT EXISTS `country` ( `id` int(11) NOT NULL AUTO_INCREMENT, `iso` char(2) NOT NULL, `name` varchar(80) NOT NULL, `nicename` varchar(80) NOT NULL, `iso3` char(3) DEFAULT NULL, `numcode` smallint(6) DEFAULT NULL, `phonecode` int(5) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
Click below button to download all file with
Read moreHow to Make Primary Key start from user defined number – MySQL
While your are creating the structure for table just add the AUTO_INCREMENT = YOUR_DEFINED_NUMBER. Doing this your Primary Key will set
Read moreCreate .SQL File of MySQL table using Query in PHP
Want to get backup of your table without login on PHPMyAdmin? Yes you can do this in PHP just write
Read moreCreate/Copy Table from Old Table using MySQL Query
You can make a copy of old table as create new MySQL table from same database using query. No need
Read moreMySQL date_format convert date/datetime into string
DATE_FORMAT function converts a DATE or DATETIME value to string. DATE_FORMAT have two parameter, In first parameter you need to
Read more