Sql

By using CONCAT function in mysql, we can concat fields or string. SELECT CONCAT(‘field1’, ‘-‘, ‘field2’, ‘-‘, ‘field3’); // Output: // ‘field1-field2-field3’

SELECT DATEDIFF(“2007-03-07”, “2007-03-01”); // For static dates SELECT DATEDIFF(ColumnA, ColumnB); // For Table column based dates

To get the records count of table in mysql: SELECT COUNT(‘fieldname’) AS RecordsCount FROM TableName; (OR) SELECT COUNT(*) FROM TableName;