MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).
I am using Pentaho Data Integration and I am trying to connect to my database via MySQL but when I …
mysql pentahoHow would I round down to the nearest integer in MySQL? Example: 12345.7344 rounds to 12345 mysql's round() function rounds up. I …
mysql sql roundingDo I use varchar(36) or are there any better ways to do it?
mysql guid uuidWhat would be a piece of PHP code for exporting a MySQL database to a .sql file? I don't have …
php mysql backupIs there a way to remove all whitespaces from a specific column for all values?
mysqlHere is a table in MySQL 5.3.X+ db: CREATE TABLE members` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `memberid` VARCHAR( 30 ) …
mysql primary-key auto-increment mysql-error-1075I've been asked if I can keep track of the changes to the records in a MySQL database. So when …
mysql databaseUPDATE AggregatedData SET datenum="734152.979166667", Timestamp="2010-01-14 23:30:00.000" WHERE datenum="734152.979166667"; It works if the datenum exists, but I want to insert …
mysql insertI am trying to dump the contents of a table to a csv file using a MySQL SELECT INTO OUTFILE …
mysql sql into-outfileI am trying to write a stored procedure in MySQL which will perform a somewhat simple select query, and then …
mysql loops stored-procedures cursor