Adding A Primary Key to an Existing Table
Been trying to add a primary key to a MySQL table using Java for two days with no success. I'm new to Java and JDBC so bear patience with me.
It connects to the database without problem so I know that's not the issue..so I suspect my statment syntax but have been unable to find a good example.
My code sample:
try
{
alterStatement = connection.createStatement();
out.println();
alterStatement.executeUpdate("ALTER TABLE machine ADD PRIMARY KEY (SerialNo)");
out.println("Primary key added");
}
catch (SQLException s)
{
out.println("Error inserting primary key");
}
I get the message: 'error inserting primary key'.
Help, please and thank you.
View Answers
July 29, 2011 at 12:19 PM
Hello Friend,
You code works fine here. Print the SQLException object to check which type of error occurs. Then let me know, we will help you.
Thanks
July 29, 2011 at 6:36 PM
Do you mean use 'printStackTrace()'?
(I'm clueless about SQL excpetion handling to be honest 8-P )
Did that and got this response...
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: ALTER command denied to user 'root'@'localhost' for table 'machine'
Now if that thing is basically telling me "access denied" then I know the computer just doesn't like me because there shouldn't be anything wrong with my account; it was set up properly, performs all the other queries and naturally has full privileges. Meh.
I ended up dropping the table and creating it from scratch with the primary key in the create table statement because I was working under deadline yesterday but I'd still like to know what went wrong.
Ads
Related Tutorials/Questions & Answers:
Adding A Primary Key to an Existing Table
Adding A
Primary Key to an
Existing Table Been trying to add a
primary key to a MySQL
table using Java for two days with no success. I'm new...();
alterStatement.executeUpdate("ALTER
TABLE machine ADD
PRIMARY
Mysql Alter Table Primary Key
Mysql Alter
Table Primary Key
Mysql Alter
Table Primary Key is used to remove the
primary key from the
table and add
primary key to the
existing other column of
table
Advertisements
SQL Alter Table Primary Key
SQL Alter
Table Primary Key
Alter a
Table Primary Key in SQL modifies the
existing table and adds a
primary key.
Create
Table Stu_
Table
SQL statement to create
Mysql add primary key
data type of
Table named employees after
adding primary key... rows in set (0.00 sec)
Query to add
primary key into the
Table...'.
mysql> alter
table employees
-> add
primary key (empid
changing primary key of parent table
changing
primary key of parent table I want to change one
primary key from a
table where
primary key is auto created? How can I do that? I have tried
UPDATE person SET personid=3494 WHERE personid=8483;
and i get the following
SQL Primary Key
in a
database
table. The
Primary Key of the
Table does not include NULL values. In
SQL Each
Table should have
primary key and have only one
primary key... the set of records from
table 'users' with
primary key 'user_id'.
 
Mysql Alter Column Primary Key
;
Mysql Alter Column
Primary Key is used to modify
table and redefine the
Primary Key Column in a
table.
Understand with Example...'. To
understand an example, we create a
table employees whose
primary key is Empid.
 
SQL PRIMARY KEY Constraint
a unique
values. It should contain NULL values. The
Table contain a
primary key and
each
table have only
primary key.
Understand with Example... to create a
table 'Stu_Class_10'.The following SQL creates a
PRIMARY KEY
SQL Alter Table
Primary Key:
The Query Alter given below is used to modify the
existing table 'Stu'
and add id as
primary key in the
table Stu. .... The
modification in
table relates to add columns, rename column and add
primary key
composinte primary key in hibernate
composinte
primary key in hibernate I am facing following problem,
Inside the database(mssql), i have created a
table without
primary key...
primary key with all the columns of the
table and hibernate s/w has created two pojo
Adding JTable into existing Jframe.
Adding JTable into
existing Jframe. i need to add JTable...(100,60,1300,600);
add(pane);
//Action Listener for button
//for
adding new...);
}
}
});
//end action listener
//
table addition
setVisible(true);
setSize
Adding JTable into existing Jframe.
Adding JTable into
existing Jframe. i need to add JTable...(100,60,1300,600);
add(pane);
//Action Listener for button
//for
adding new...);
}
}
});
//end action listener
//
table addition
setVisible(true);
setSize
Adding JTable into existing Jframe.
Adding JTable into
existing Jframe. i need to add JTable...(100,60,1300,600);
add(pane);
//Action Listener for button
//for
adding new...);
}
}
});
//end action listener
//
table addition
setVisible(true);
setSize
SQL Auto increment Primary Key
_id" to be an auto-increment
primary key field in the
table "employee... SQL Auto increment
Primary Key
SQL Auto increment
Primary Key is used to allow a unique
SQL PRIMARY KEY Constraint
values. It should contain NULL values. The
Table contain a
primary key and
each
table have only
primary key.
Understand with Example
The Tutorial...
SQL
PRIMARY KEY Constraint
 
hibernate annotations with composite primary key
to use hibernate annotations in case of composite
primary key in one
table.
I tried like this, I have created a
table without
primary key. By default mssql has created a composite
primary key with all the columns of the
table.
table
Mysql Alter Foreign Key
of
existing table 'books' and
add constraint foreign
key 'publisher_id and publisher...;
A Foreign
Key is a field that marks to the
primary key of another
table. The use of the foreign
key is used to ensure referential
JDBC insert that returns primary key
JDBC insert that returns
primary key How to write code for jdbc insert that returns
primary key?
Help me fast
Thanks
Hi,
Following code can be used:
//Add record into database
String queryInsert = "insert
Mysql Alter Autoincrement
;
existing
table and add autoincrement feature property to the
primary key... of
Table named employees after
adding auto increment feature to
the
primary key... 'employees' definition
and add autoincrement to the
primary key of the
table
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
Mysql Alter Table Identity
FIRST, ADD
PRIMARY KEY (ID);
After alter the
table "userform"...;
Mysql Alter
Table Identity is used to change the
existing structure of
table
and add ID column as identity
key that is used to uniquely define
Foreign key update table
Foreign
key update table How to update
table that has the foreign
key in SQL..?
ALTER
TABLE YourTable
ADD CONSTRAINT FK_YourForeignKey
FOREIGN
KEY (YourForeignKeyColumn)
REFERENCES YourPrimaryTable