Daily Archives: September 21, 2007

ALTER TABLE ORDERS FOREIGN KEY

Posted on September 21, 2007 by carlosap

MySQL: CREATE TABLE ORDERS (Order_ID integer, Order_Date date, Customer_SID integer, Amount double, Primary Key (Order_ID), Foreign Key (Customer_SID) references CUSTOMER(SID)); Oracle: CREATE TABLE ORDERS (Order_ID integer primary key, Order_Date date, Customer_SID integer references CUSTOMER(SID), Amount double); SQL Server: CREATE TABLE … Continue reading →

Posted in PHP mySQL | Leave a comment

MySQL migration: MyISAM to InnoDB

Posted on September 21, 2007 by carlosap

MySQL migration: MyISAM to InnoDB   By Keith Winston on July 18, 2005 (8:00:00 AM) The MySQL database is unique in that it offers multiple storage engines. The SQL parser and front end interfaces are separate from the storage engines, … Continue reading →

Posted in PHP mySQL | Leave a comment

What is referential integrity?

Posted on September 21, 2007 by carlosap

  Simply put, referential integrity means that when a record in a table refers to a corresponding record in another table, that corresponding record will exist. Look at the following:

Posted in PHP mySQL | Leave a comment

terminal services

Posted on September 21, 2007 by carlosap

http://i-admin.blogspot.com/2005/06/how-to-crack-windows-terminal-services.html

Posted in Windows | Leave a comment

Backup – Restore SQL 2005

Posted on September 21, 2007 by carlosap

T-SQL code BACKUP: USE myDatabaseName GO BACKUP DATABASE myDatabaseNameTO DISK = ‘C:\filePath\myDatabaseName.bak’NAME = ‘The name of the back up.’   RESTORE: RESTORE databaseName FROM DISK = ‘C:\filePath\backupFilename’ Tags: backup, restore

Posted in SQL Server | Leave a comment