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

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.


Kemahiran: Semua Boleh, Pemasukan Data, MySQL

Lihat lagi: named query, mysql data access, data entry in 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 ip time, random ip, query mysql script, query database, mysql insert date

Tentang Majikan:
( 0 ulasan ) Verona,

ID Projek: #1972894

Dianugerahkan kepada:


See PM for the two options I can offer you.

$25 USD dalam 0 hari
(72 Ulasan)