Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL how to declare a auto increment in sql
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


harini
how to declare a auto increment in sql
1 Answer(s)      4 years and 7 months ago
Posted in : SQL


Dear sir,
How to declare a auto increment insql? i used a identity but it is nt working in sql,so please helpme sir..
Thanks and Regards
Harini Veerapur

Advertisement
View Answers

June 8, 2010 at 1:13 PM


Hi Friend,

If you are using MySQL database, then go to your database table and click the right button of your mouse. There is Alter Table option.Click that. The create table form will get open. Click the checkbox option of Auto_Incrt for the field 'id'.

Thanks


Related Tutorials/Questions & Answers:
how to declare a auto increment in sql - SQL
how to declare a auto increment in sql  Dear sir, How to declare a auto increment insql? i used a identity but it is nt working in sql,so... table form will get open. Click the checkbox option of Auto_Incrt for the field 'id
How to auto increment primary key in mysql...
How to auto increment primary key in mysql...  How to auto increment primary key in mysql... and one more thing i need to get auto increment value in front end each time for inserting the value[JSP
Advertisements
SQL Auto increment Primary Key
SQL Auto increment Primary Key       SQL Auto increment Primary Key is used to allow a unique.... Understand with Example The Tutorial illustrate an elaborative example from 'SQL Auto
MySQL Auto_Increment
MySQL Auto_Increment This example illustrates how to define AUTO_INCREMENT of a field. The AUTO_INCREMENT attribute can be used to generate a unique... AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id
Stumped with NOT NULL AUTO_INCREMENT
to create a new table with the ID column being NOT NULL AUTO_INCREMENT. The table will create if I do not have NOT NULL AUTO_INCREMENT, but it WILL NOT create...Stumped with NOT NULL AUTO_INCREMENT  I've almost made it through my
query regarding auto increment primary key
query regarding auto increment primary key  i want to use s1,s2.... as my auto increment primary key.cant i do this in mysql
MySQL Auto_Increment
MySQL Auto_Increment       MySQL Auto_Increment is used to generate a unique number when a new... with Example The Tutorial illustrate an example from 'MySQL Auto_Increment
auto sql script - SQL
auto sql script  Is there a way of generating inserts scripts using the table structure for oracle database
Declare Cursors in SQL
Declare Cursors in SQL       Declare Cursors in SQL is used to define cursor and its... 'Declare Cursors in SQL'. To grasp the example, we create a table 'Stu_Table
How to declare NSMatrix
How to declare NSMatrix  How to declare NSMatrix in XCode can anyone explain it with example
Declare Cursors in SQL
Declare Cursors in SQL       Declare Cursors in SQL is used to define cursor and its... 'Declare Cursors in SQL'. To grasp the example, we create a table 'Stu_Table
Auto Increment and Decrement
Auto Increment and Decrement   ... of a variable that how both are different with each other.  Description... of this variable. Now we are applying the prefix increment operator and display the value
JDBC: MYSQL Auto_Increment key Example
JDBC: MYSQL Auto_Increment key Example In this tutorial we are setting one field of table auto_incremented using JDBC API. Auto_Increment key : Auto... of table creation just specify AUTO_INCREMENT key for your willing field
how to generate auto code ?
how to generate auto code ?  i wanna genrate auto code for id in core java. pls tell me code of auto genrate
Auto generated column in sql 5.0 - SQL
Auto generated column in sql 5.0  hi, in my data base i have declared one column has auto generating but currently am not able to insert the data unless i need to pass some integer value to that column.. regards pramod.k.r
How to Declare Abstract Class in PHP ?
How to Declare Abstract Class in PHP ?  hi, I am a PHP Beginners. As i am trying to make an application where i trying to declare the abstract class of PHP. Please any one explain me how to declare abstract class in PHP program
How to Declare fflush() Function in PHP
How to Declare fflush() Function in PHP  Hi, Can someone give my any online example for write all the buffered data of an open file. Is it appropriate to use the PHP fflush() Function to develop this application? Please suggest
Auto grow Text Area using jQuery plug-in
Auto grow Text Area using jQuery plug-in In this section, you will learn how to create a text area which auto grow on increment of the content using jQuery... as you want. The height can increment without limit by changing the below code'
How to declare String array in Java?
Following example will show you how to declare string array in java. There are many ways to declare an array and initialize them. We can use 'new' keyword to declare an array. However, an array can also be declared without
auto
auto  write a java code design an auto with as many feature as possible
How to make auto number? - JSP-Servlet
How to make auto number?  Dear, my friend... I really need your help.... I want to ask you, how to make auto number in mysql database? The format that I want is: ======> 00010809, 00020809, 00030809, etc 0001 = auto
How create auto number? - JSP-Servlet
How create auto number?  Dear, my friend... I really need your help.... I want to ask you, how to make auto number in mysql database? The format that I want is: ======> 00010809, 00020809, 00030809, etc 0001 = auto
How to declare a Combobox without using a string in its declaration?
How to declare a Combobox without using a string in its declaration?  What i mean to ask is how can i declare a combobox first and initialise... the examples and tutorials so far i haven't found any which tells me how to do
How can I call a Servlet that is declare on web.xml with spring framework
How can I call a Servlet that is declare on web.xml with spring framework ... is declare on web.xml, but the spring dispacher don't find it so how I can make spring dispacher to call a servlet that is declare on my Web.xml here is my
string increment
string increment  Sir, I want to auto icrement cust_id which is string whenevr i add customer, i cannot use integer Plz Help
How to Auto Delete Bids after certail time expire.?
How to Auto Delete Bids after certail time expire.?  I am developing alibaba.com like website where after time expires ,buying request need to be deleted. So is there any idea experts have for this type of problem
How to Auto Delete Bids after certail time expire.?
How to Auto Delete Bids after certail time expire.?  I am developing alibaba.com like website where after time expires ,buying request need to be deleted. So is there any idea experts have for this type of problem
how to auto generate number in jsp with the database connection mysql for employee number?
how to auto generate number in jsp with the database connection mysql for employee number?  how to auto generate number in jsp with the database connection mysql for employee number?   <%@page import="java.sql.
how to auto generate number in jsp with the database connection mysql for employee number?
how to auto generate number in jsp with the database connection mysql for employee number?  how to auto generate number in jsp with the database connection mysql for employee number?   <%@page import="java.sql.
Declare the Navigation Rules
Declare the Navigation Rules  How to declare the Navigation Rules for JSF
Declare construct
Declare construct  hii, Define about declare construct?   hello, Declare construct allows you to define execution directives for a block.... These declare construct can be set in such a manner that all the code is affected
 

 

 

DMCA.com