Generate useful test data and random dates in MySql. All code and tables are provided.
Community journal
Follow the feed
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Showing entries 1 to 6 of 6
« Previous |
Next »
This MySql function will generate a link to your glossary when you are fetching text for a web page. All code is provided in a zip file.
Jul
07
2012
A short MySql function to generate a Lorum Ipsum text. You can download the code in the zip file below.
You can use this MySQL function to generate names, (e-mail)addresses, phone numbers, urls, bit values, colors, IP address, etc.. As usual, the code is provided in a zip and the code is fully documented.
This article describes a single MySql function to sanitize strings. The provided options are:
- replace multiple spaces to a single space
- remove Unix and Windows linebreaks and replace them with a space
- remove tabs and replace them for a single space
- remove multiple backslashes
- completely remove htmlentities (&)
- replace htmlentities with the corresponding character
- remove all HTML tags
Below you will find all code to create the table and the stored procedures to manage hierarchical trees in MySQL. All code is documented and can be downloaded in a zip file.