DB Create - Execute SQL Command

[eluser]CI_avatar[/eluser]
@progr@mmer thank you. but the sql command that i am referring includes creating the database.
Like this

Code:

SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `_rms_lotto_db`
    CHARACTER SET 'latin1'
    COLLATE 'latin1_swedish_ci';

USE `_rms_lotto_db`;

#
# Structure for the `_users` table :
#

CREATE TABLE `_users` (
  `username` varchar(20) NOT NULL,
  `password` varchar(160) DEFAULT NULL,
  `type` enum('ad','rp') DEFAULT 'rp',
  PRIMARY KEY (`username`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;