MySQL – Inserting data in MySQL tables

The INSERT SQL statement impregnates our table with data. Here is a general form of INSERT.

INSERT into table_name (column1, column2....)
values (value1, value2...);

where table_name is the name of the table into which we want to insert data; column1, column2 etc. are column names and value1, value2 etc. are values for the respective columns. This is quite simple, isn’t it?

Mysql – Deleting entries from tables

The SQL delete statement requires the table name and optional conditions.

DELETE from table_name [WHERE conditions];

NOTE: If you don’t specify any conditions ALL THE DATA IN THE TABLE WILL BE DELETED!!!

change windows 2008 active directory database location

ntdsutil
activate instance ntds
files
info ( to check where the DB files are located )

create directory’s for the DB and log files
mkdir d:\NTDS-Dbase
mkdir d:\NTDS-Logs

ntdsutil
activate instance ntds
files
move db to d:\NTDS-Dbase
movelogs to d:\NTDS-Logs

MySQL – Inserting data in MySQL tables

MySQL – Inserting data in MySQL tables

Mysql – Deleting entries from tables

change windows 2008 active directory database location

Categories