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 MoreSQL
update all row in codeigniter
update all row in codeigniter $this->db->update_batch() Generates an update string based on the data you supply, and runs the query. You can either pass …
Read MoreHow To Remove html tags from validation_errors() in Codeigniter
How To Remove html tags from validation_errors() in Codeigniter Remove html tags from validation_errors() in Codeigniter Set the Opening tag and Closing Tags for …
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. For …
Read MoreFinding Duplicates with SQL
Finding Duplicates with SQL:: SELECT `email`, COUNT(`email`) AS NumOccurrences FROM `user` GROUP BY `email` HAVING ( COUNT(`email`) > 1 )
Read MoreHow to split a single column values to multiple column values
How to split a single column values to multiple column values:: For Example: #Current table Field is like:: Name ———— abcd efgh ijk lmn opq …
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 MoreSQL update from one Table to another based on a ID match
SQL update from one Table to another based on a ID match MS SQL UPDATE Sales_Import SET Sales_Import.AccountNumber = RAN.AccountNumber FROM Sales_Import SI INNER JOIN …
Read MoreSQL – How to split a single column values to multiple column values
How to split a single column values to multiple column values.. For Example: #Current table Field is like:: Name ———— abcd efgh ijk lmn opq …
Read More