How to get next AUTO_INCREMENT value in mysql

there are two possibilities to access next auto_increment variable associated with a particular table in MySql

1) Using information schema

select auto_increment
from information_schema.tables
where table_schema = 'db_name'
 and table_name = 'table_name'

2) accessing status of database

SHOW TABLE STATUS  where name="table_name"

1st give only next auto increment value but second gives some additional information other than that.

hope this helps....cheers......

Nexabion Solutions Corporate blog: Finnex: Debt Collection Agency Software Launched.

Nexabion Solutions Corporate blog: Finnex: Debt Collection Agency Software Launched.: Yes, We have done it again!. When we launched the Beta version, in February, many said FinNex looked like a mainframe app, thanks to its p...

How to find end date of a given month in php

The following php function does the trick.
This function accepts argument as integer month and integer year

eg.findEndDate(2,2000);
eg.findEndDate(12,2011);

function findEndDate($month,$year)
{
return date('m-d-Y',mktime(0,0,0,$month+1,0,$year));
}

Zion Grile 1.0 Beta - Live cricket scorecard for your desktop.

Zion Grile 1.0 Beta

Live cricket scorecard for your desktop...Download

This is a very good application. Please download and try.

This is from the codeglober Joji George.

You need to install Java Runtime Environment for working this. Click here to download Java Runtime Environment

Cheap reliable Web hosting Offers

   Your Professional web hosting Partner

 

Yuva web hosting, a hosting service from Nexabion Solutions, is always dedicated in providing their customers the most reliable, fast and secure web hosting service. We provide hosting plans that are affordable for all types of customer coupled with 24x7 customer support which makes us your best choice. 

Use coupon code NXBVS2  for Offers. CALL US NOW:  0890 7113 827

http://www.yuvawebhosting.com

Google Apps is changing

You've probably heard that Google is about to make more of its services available to organizations with Google Apps accounts. We're ready for early adopters who accept the current feature limitations to transition to our new infrastructure for Google Apps accounts. Here is what this means for you:
• In addition to the core suite of messaging and collaboration applications, your users may now access many more Google services with their Google Apps accounts. Learn more
• Currently you will not have the ability to disable additional services as you can today with the core Google Apps suite, but this capability will be added soon. If you need the ability to disable any of the additional services please do not transition at this time.
• Important materials and notices for your users are currently only available in the English versions of Google products. If you have users who may be using non-English versions of Google products, do not transition at this time.
This update is free, and Google will automatically make the transition for you this Fall. In most cases, though, we think you'll want to step through the transition wizard yourself and actively communicate the forthcoming changes to your users. You can move everyone to the new infrastructure today, or you can try out the new account services with selected pilot users. Learn more

Java Me from Childhood to Robinhood - Online Book by CodeGlober Joji George(xpedition)

We are happy to inform you that our CodeGlober Joji George, published his first book on Java ME as online. The first part of the book is now released.


This book is mainly written to those who are interested in Java Me programming. I think it will help you to begin Java ME from scratch.
This book contains 9 chapters .

Author : Joji George

Go to Java Me from Childhood to Robinhood




cochin IT solutions-web hosting application development cellphone applications web site designs