From: Sergey Seroukhov Date: April 26 1999 2:41pm Subject: Fill tables with a random data List-Archive: http://lists.mysql.com/mysql/2404 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Hello, All! Sorry, if I can't write here. I made a simple program to do subj. If anybody need it, you can get the program from ftp://cm.dongu.donetsk.ua/pub/mysql/mpr.zip Program is freeware. ================================================================== README "MySQL Packet Runner" can help you to do: - define total and averange execute time of a random query; - fill your table with a random data and random field values from another tables. This program is freeware. It is made for Windows and isn't use ODBC or BDE. Program execute a query with defined times. Using several simple templates you can insert into standart MySQL query a random data. Formats is: %d - insert a random integer in range [0..n] Example: %10d -> 5 %f - insert a random float value in range [0..n] Example: %100f -> 33.78 %s - insert a random string with length n Example: %5s -> "sOj^8L" %t - insert a random date which [0..n] later by now Example: %10d -> "1999-04-12" (now is "1999-04-22") %q - insert a first field from random record from subquery number n. Subqueries are marked by '1:','2:'.. in a form. You can use only 5 subqueries. Subquery can include described templates except %q. Example: 1: SELECT LoginNo FROM Logins WHERE Login LIKE %1s 2: SHOW TABLES ..... General Query: INSERT INTO AccessLogs VALUES (NULL,%1q,%30t,%2q,%12s) Results may be folowing: INSERT INTO AccessLogs VALUES (NULL,"10","1999-01-03", "ActiveUsers","kj:*&Hk%jG$#") INSERT INTO AccessLogs VALUES (NULL,"3","1999-02-01", "IncomeOrders","2Kns1a*hKHfc") ...etc. NOTE: SubQueries will execute once per process! ================================================================= With best wishes, Sergey Seroukhov --- Networks Lab. ASU DSTU