Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 6

Displaying posts with tag: download code (reset)

Create random test data using real data from your MySql database.
+0 Vote Up -0Vote Down

Generate useful test data and random dates in MySql. All code and tables are provided.

Mysql: creating a link to your glossary while fetching text for a webpage
+1 Vote Up -0Vote Down

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.

MySql Lorum Ipsum generator
+0 Vote Up -0Vote Down

A short MySql function to generate a Lorum Ipsum text. You can download the code in the zip file below.

Howto generate meaningful test data using a MySQL function
+2 Vote Up -0Vote Down

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.

MySql: cleaning user input before storing the data
+1 Vote Up -0Vote Down

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
Manage hierarchical data with MySQL stored procedures
+1 Vote Up -0Vote Down

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.

Showing entries 1 to 6

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.