Top "Alter" questions

HibernateJpaVendorAdapter's generateDdl doesn't alter tables

I am developing a website using Spring+JPA+Hibernate. In the persistence configuration (JPA+Hibernate) I'm setting the HibernateJpaVendorAdapter's generateDdl …

hibernate alter

how to drop a column if exists in mysql?

ALTER TABLE user DROP COLUMN registered_date We can drop a column using the above command. But how can i …

mysql sql alter

Is it possible to alter a CSS stylesheet using JavaScript? (NOT the style of an object, but the stylesheet itself)

Is it possible to alter a CSS stylesheet using JavaScript? I am NOT talking about: document.getElementById('id').style._____='.....…

javascript html css stylesheet alter

What happens if you kill a long-running alter query?

What happens if you kill a long-running alter query? Will the alter query simply revert? How long could that take (…

mysql kill alter

How do I rename column in w3schools sql?

I am trying to rename a column name in w3schools website ALTER TABLE customers RENAME COLUMN contactname to new_…

sql alter

Removing NOT NULL restriction from column in MySQL

How can I alter a column whose restricted to NOT NULL to accept NULL values?

mysql null alter

SQL Server script: ALTER PROCEDURE - Executing multiple ALTER PROCEDURE into one script without having to select each of the ALTER one after another

I know this is not a big issue, but it tickles me anyway. I have a SQL Server 2005 script to …

sql-server-2005 alter-table alter sql-scripts

mysql: how to truncate the length of a field

Alter table merry_parents change mobile mobile char(10). When I do the above I'm getting error: #1265 - Data truncated for …

mysql field truncate alter

Add index to table if it does not exist

I want to add an index to a table by using the ALTER syntax, but first check if it already …

mysql indexing alter

Can I use ALTER DATABASE to rename a mysql database?

I am using PDO with PHP to create a new database and then a new user with privileges on that …

php mysql database pdo alter