XML FeedsCategory: MySQL
Server to go, apache, php, perl and mysql running from cd rom (server2go)
By admin on Nov 15, 2009 | In MySQL, Utilities, PHP | Send feedback »
what a great little project. You can now run apache, php, mysql from a cd rom to create your own web application which you can then distribute on non writeable media.You can get this herehttp://www.server2go-web.de/index.htmlThe software is f… more »
How to reset vtiger crm 5 password
By admin on Jul 28, 2009 | In MySQL, vtiger crm | Send feedback »
you need to execute the following mysql statement to reset it to admin or adpexzg3FUZAk(sorry cant remember)update vtiger_users SET user_password = 'adpexzg3FUZAk', crypt_type='' WHERE id=1; more »
Mysql get information on all tables of a database
By admin on Jun 16, 2009 | In MySQL | Send feedback »
The following mysql query allows you to get all table info for a specific db including number of rows, row format, avg_row_length, data length etc.
SHOW TABLE STATUS FROM databasename; more »
Mysql field in asp generates error: Variable uses an Automation type not supported in VBScript
By admin on May 27, 2009 | In MySQL, ASP (classic), IIS web server | Send feedback »
Recently whilst migrating an old site from mysql 4 and Windows 2000 server to MYSQL 5 and IIS7/Windows 2008 an old script that worked fine stopped working giving error type mismatch and when trying to determine the type name it returned error Variable u… more »
Mysql returns no results in ASP page for a valid query after upgrade to 5.xx from 3.xx
By admin on Sep 22, 2008 | In MySQL, ASP (classic) | Send feedback »
I came across something very bizarre recently. After Mysql was upgraded from version 3.xx to 5.xx the asp pages that worked fine for years stop working as some basic queries (nothing clever just doing select) stopped returning resuts.
The reason? The… more »
Error in my_thread_global_end():1 threads didn't exit
By admin on Aug 1, 2008 | In MySQL, IIS web server, PHP, PLESK | Send feedback »
I recently got this strange error message trying to migrate a site from a dedicated server to a shared host server using php 5.2.5, mysql 5, plesk and windows 2003 server:
Error in my_thread_global_end():1 threads didn't exit
Although a lot of the post… more »
Mysql how to convert varchar column to float or integer to order results
By admin on Jul 22, 2008 | In MySQL | 1 feedback »
I recently needed to order results of a varchar column in the same manner a float column would. I found this interesting way of doing it:
Select col1 from tbl1 order by 0+col1 asc;
col1 is a varchar column but if you use the digit zero and the plus… more »
Find duplicate records in mysql using multiple fields combination
By admin on Sep 4, 2007 | In MySQL | Send feedback »
If you need to find duplicates using a multiple field combination in mysql you can use:
SELECT col1, col2, count(col2) FROM orders where datecreated > '2006-09-91 00:00:00' GROUP BY col1, col2 HAVING COUNT(col2) >1
You can add more columns to it… more »
