Introduction Since PHP 5.4, the original MySQL extension is obsolete and will generate alerts E_DEPRECATED level when connecting to a database. Instead, we can use the MySQLi extension or PDO_MySQL extension. If like me,...
This is more of personnal notes/code braindump to remember how to do. I will expose you two methods for using javascript calls via DOM and Ajax/Jquery to process mysql queries … Before starting, I...
Renuméroter une table avec auto increment set @i=0; update myvideos set id=(@i:=@i+1); ALTER TABLE myvideos AUTO_INCREMENT = 1; Arrangement de zones : ALTER table Auteurs MODIFY COLUMN AuteurID mediumint(8) AFTER notice_ref ALTER TABLE Auteurs...
MySQL Connector/ODBC (also known as MyODBC) allows you to connect to a MySQL database server using the ODBC database API on all Microsoft Windows and most Unix platforms, including through such applications and programming...
To import CSV unicode file to MySQL table via phpmyadmin (csv fields are delimited with tabulations ) : More advanced options can be used at the shell level : shell> cat /tmp/bit_test.txt 2 127...
You can use mysqldump command to backup database. The mysqldump client is a backup program. It can be used to dump a database or a collection of databases for backup or for transferring the...
