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

Veja 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

Concedido a:


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 Comentários)

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


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)

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)

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)

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)

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)

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)

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)

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)

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)

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

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

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)

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)

Hello, I think that it's an easy job ,i know i have no anterior job in 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)