Em Andamento

Php script to detect mysql table primary keys which are about to reach their limit

We need a php script which

1. Will visit all the tables in a given mysql database.

2. It will check all the primary keys to make sure none of them are close to the limit.

For instance unsigned smallint for mysql can be at most 255. So for a table which has a primary key of type smallint, you'll need to check if the max value used so far is close to the limit, 255.

We can define closeness 20% of the maximum.

The script will need to output the names of the tables which are close to exhausting their primary key limits.

Habilidades: PHP

Ver mais: primary, detect php, check table mysql script, mysql output table, output tables php, mysql script check table, output table, primary key, mysql output, keys, value table, database php script, ruby script updating mysql table text file, ruby script updating field table text file mysql, php script check, php detect, detect database php, check limit mysql database, script edit mysql table, check php script, php script move mysql table, php mysql search table script, instance mysql, bash insert mysql table script, php script update mysql table

Acerca do Empregador:
( 39 comentários ) Istanbul, Turkey

ID do Projeto: #5109102

Premiar a:

PHPDeveloperr

Merhaba php/mysql konusunda iyiyim.çok hızlı bir şekilde bu projeyi tamamlayıp teslim [url removed, login to view]şekkürler...

$83 USD em 1 dia
(8 Avaliações)
4.1

13 freelancers estão ofertando em média $63 para este trabalho

coolguyinus2004

8+ years of exp in programming in PHP/MYSQL. How many tables you have on the database. i can develop a script like this for you.

$54 USD in 4 dias
(283 Comentários)
7.4
leomedina01

Hi sir, My name is Leonardo Medina, and I´m from Brazil. A question: This primary keys are auto-incremented right? Please drop me a line, so we can discuss this project in details and I can make a proper bid. Mais

$43 USD in 2 dias
(75 Comentários)
6.2
acer2004sl

Hello, I can build that for you right now. It will be based into AJAX request. You will enter the Database login information ( host / Username, Password, and the dbase name ) and will show you the resul Mais

$55 USD em 1 dia
(137 Comentários)
5.5
Eliteprog

Hi, First of all thanks for posting this project, I am available to provide you economical services for web development , I have read and understood all of project details. I am expert in software development and c Mais

$115 USD in 5 dias
(22 Comentários)
5.0
eComOS

Hello jumpist2013, I have gone through your outsourced requirement "Php script to detect mysql table primary keys which are about to reach their limit" and have analyzed that I have right credentials (PHP) to execu Mais

$66 USD em 1 dia
(47 Comentários)
4.9
gutibs

Can have it by monday morning, displaying on screen result, ot if your server stands cron jobs i can email you a pdf file per day with the result of the queries and a light indicator (say green, yellow and red color) Mais

$88 USD em 1 dia
(40 Comentários)
4.9
novaemp

Hi Dear. I am really interest for this job, I am expert with php / sql. I hope you contact with me for this job, and I will do my best for you. I can start this job right now and finish in today. Thank you. Bes Mais

$43 USD em 1 dia
(37 Comentários)
4.6
doublebc

Hello, I can create a script that will find all the tables in your database then locate the primary column and get the max value. I am ready to start now. Also the max value for unsigned SMALLINT is 65535. An unsign Mais

$35 USD in 2 dias
(22 Comentários)
4.5
shahid864

let me help you i have four year experience in php will provide you quality work. let start your work. thanks

$77 USD in 3 dias
(32 Comentários)
3.6
alexeyshentyakov

hi, I can help you -----------------------------------------------------------------------------------------------------------------

$55 USD in 3 dias
(8 Comentários)
3.6
Uplidcoder

Hello, I've developed a script previously for a client that fits this description. It's a little more advanced i.e. it runs as a cron job (a script that is executed every X amount of minutes) and if it detects limits h Mais

$55 USD in 3 dias
(4 Comentários)
2.8
maxlumnar

Hello, the task sounds very interesting to do, i would very much like to work on it. I am available right now, or in one day (thats why i posted more days deadline, but i don't think it will take more than a couple of Mais

$80 USD in 2 dias
(4 Comentários)
2.6
allrezo

Hello, I think that it's an easy job ,i know i have no anterior job in [url removed, login to view] but I ensure that I have good experience with PHP and you won't be disappointed , all I need is to build a good portfolio on freela Mais

$36 USD in 3 dias
(1 Comentário)
0.0