Altering column size in SQL Server ALTER TABLE table_name ALTER COLUMN column_name datatype; LIKE:: ALTER TABLE `product` MODIFY COLUMN `updatedon` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP …
Read MoreTag: SQL
Codeigniter – How to Join City Country State by concatenate two fields in Sql
Codeigniter – How to Join City Country State by concatenate two fields in Sql $this->db->select(” CONCAT(c.name,’-‘,co.code) as id,CONCAT(c.name,’ ,’,s.name,’ ,’,co.name) as text”,FALSE); $this->db->from(“city c”); $this->db->join(‘state …
Read MoreUpdate Two Column Field By Splitting The VAlue from One Column in SQL.
Update Two Column Field By Splitting The VAlue from One Column in SQL. Here the split will be done depending on space in name. Here …
Read MoreUpdate two column field by Splitting the value from one column in SQL
Update two column field by Splitting the value from one column in SQL QUERY:QUERY: UPDATE user u2 set u2.first_name = SUBSTRING_INDEX(u2.name, ‘ ‘, 1), u2.last_name …
Read More