Sedang Disiapkan

226656 Advanced MySql Query

Hi, I need a little script that should do this thing:

I have a MySql Database.

In this database there is many cells.

One of this has name "DATE", another one "IP".

The script should do this:

IF you find a cell named IP with NO VALUE inside, you should generate e RANDOM IP and INSERT it in the database.

The random IP generated should be similar of an Italian IP, like 79.136.24.38.

All the ip must be different one from each other.

Then if you find a CELL named "DATE", you should generate a DATE and TIME in this format:

0000-00-00 00:00:00

All the date and time should be plausible and after May 2007.

That's all :)

I will give access to username and password of the database.

Bye

Kemahiran: Semua Boleh, Pemasukan Data, MySQL

Lihat lebih lanjut: named query, mysql data access, data entry access 2007, mysql query, format cell, advanced database, access script data entry, data advanced, script data entry access, insert data database mysql, cells insert, insert mysql, random database script, generate query, mysql entry, data entry mysql database, mysql date, advanced data format, 0000, script insert mysql, random time, random ip, query mysql script, query database, mysql insert date

Tentang Majikan:
( 0 ulasan ) Verona,

ID Projek: #1972894

Dianugerahkan kepada:

symlink7

See PM for the two options I can offer you.

$25 USD dalam 0 hari
(72 Ulasan)
5.1