SQL

Alter table to remove Foreign Key or add DELETE CASCADE (MySQL)

SQL

Alter table to remove Foreign Key or add DELETE CASCADE (MySQL)

Step 1 : Get the Foreign Key Name. SHOW CREATE TABLE tableName; Note the name of Foreign key (which is mostly auto generated) output will look something like CONSTRAINT `FK4C5B93445F11A0B7` F...

Dec 20, 2016 · Tushar

Import mysql dump to RDS Db Instance

SQL

Import mysql dump to RDS Db Instance

mysql -h host.address.for.rds.server -u rdsusername -p rdsdatabase < backupfile.sql host.address.for.rds.server = this will be what is referred to as the "end point" in your RDS descripti...

Mar 11, 2016 · Tushar