How to generate random chars and insert with MySQL?

Duplicate:
Inserting random characters to MYSQL Database

How can I generate 100 records with 5 random characters and insert into the database with a query.

I want to insert into this table:

codes
  id (auto-increment)
  codes

mysql sql

Edit Report

0 Answers