Generate Slug URL in MySQL
A slug is a short name using human-readable keywords to identify a web page. For example, in the following URL. example.com/schools/new-york-art-school the slug is new-york-art-school.… Leer más »Generate Slug URL in MySQL
A slug is a short name using human-readable keywords to identify a web page. For example, in the following URL. example.com/schools/new-york-art-school the slug is new-york-art-school.… Leer más »Generate Slug URL in MySQL
//DB = 2013-03-14 //Setear en la base de datos $birthday = $this->request->post(‘birthday_y’) . «-» . $this->request->post(‘birthday_m’). «-«. $this->request->post(‘birthday_d’); $rs_user->birthday = date(«Y-m-d», strtotime($birthday)); $rs_user->save(); //Getter de… Leer más »Date Converter Date Format yyyy-mm-dd PHP to MYSQL
Error frecuente en bases de datos MYSQL, se puede solucionar este problema de dos maneras, solo ingresa al phpmyadmin y ejecuta una de estas dos… Leer más »Table is marked as crashed and should be repaired
UPDATE cmg_campaign SET start_date= adddate(start_date,60); UPDATE cmg_campaign SET finish_date= adddate(start_date,60);
Actualizar campo decimal con un valor determinado en los casos que sea NULL UPDATE `pro_table` SET `weight`=’1000.00′ WHERE weight IS NULL UPDATE `pro_table` SET `width`=’50.00’… Leer más »Mysql set decimal value if null
UPDATE product SET summary=REPLACE(summary,’\n’,»)
ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (mytest.instance, CONSTRAINT instance_ibfk_1 FOREIGN KEY (GroupID) REFERENCES mytest.mygroup (ID)) SET FOREIGN_KEY_CHECKS=0; TRUNCATE… Leer más »mysql : Cannot truncate a table referenced in a foreign key constraint