str[bits]

May 25, 2005

Types of SQL Statements Supported by MySQL

Filed under: MySQL

SELECTING, CREATING, DROPPING, AND ALTERING DATABASES

USE
CREATE DATABASE
DROP DATABASE
ALTER DATABASE

CREATING, ALTERING, AND DROPPING TABLES AND INDEXES

CREATE TABLE
DROP TABLE
CREATE INDEX
DROP INDEX
ALTER TABLE

GETTING INFORMATION ABOUT DATABASES AND TABLES

DESCRIBE
SHOW

RETRIEVING INFORMATION FROM TABLES

SELECT
UNION

PERFORMING TRANSACTIONS

SET AUTOCOMMIT
START TRANSACTION
COMMIT
ROLLBACK

MODIFYING INFORMATION IN TABLES

DELETE
INSERT
LOAD DATA
REPLACE
UPDATE

ADMINISTRATIVE STATEMENTS

FLUSH
GRANT
REVOKE

May 17, 2005

CD and Expansion

Filed under: Laugh-Out-Loud, Work-a-Work

We got one “smart-talking” computer user here and she said, “Sandro, I have some doubt! My manager gave me a document in CD to edit, but when I’m saving it, it gives me error - Read Only! Why?”

And here’s another one: This morning I was also in one user and he complained, “My computer really very slow, you need to expand it!”

May 8, 2005

Running with Alternate Credentials

Filed under: Windows Server

Similarly with Linux’s sudo or su commands; you can also elevate privilege in Windows Server by using runas command.

runas /user:administrator@company.com /netonly "mmc.exe"






















Get free blog up and running in minutes with Blogsome | Theme designs available here