Insert into mysql date_format
Posted: April 26, 2011 Filed under: MySQL, Web developer | Tags: DATE_FORMAT, INSERT, MySQL Leave a commentINSERT INTO tabla (fecha) VALUES (DATE_FORMAT(STR_TO_DATE('$variable_fecha', '%d-%m-%Y'), '%Y-%m-%d'))
Hasta la próxima.
Update Date_Format MySQL
Posted: March 8, 2011 Filed under: MySQL, Web developer | Tags: DATE_FORMAT, MySQL, UPDATE Leave a commentUPDATE table SET field=DATE_FORMAT(STR_TO_DATE('01-01-2011', '%d-%m-%Y'), '%Y-%m-%d') WHERE field_set=id
Hasta la próxima.
Reordenar (Reorder) primary key auto_increment mysql
Posted: February 23, 2011 Filed under: MySQL | Tags: auto_increment, MySQL, primary key 2 Commentsmysql_query("ALTER TABLE tabla DROP id");
mysql_query("ALTER TABLE tabla AUTO_INCREMENT = 1");
mysql_query("ALTER TABLE tabla ADD id bigint UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST");
Hasta la próxima.