Practical

Quote

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`sno` int(6) NOT NULL auto_increment, `sname` varchar(40) NOT NULL default '', `' at line 2

Language: SQL
GRANT privileges   
ON databasename.tablename
TO username
IDENTIFIED BY ';password';;

Language: SQL
GRANT ALL   
ON registration.*
TO root
IDENTIFIED BY ';';;

Language: SQL
-- phpMyAdmin SQL Dump
-- version 3.2.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 09, 2010 at 03:21 PM
-- Server version: 5.1.44
-- PHP Version: 5.3.2
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
--
-- Database: `registration`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `student`
--
 
CREATE TABLE `student` (
  `sno` INT(6) NOT NULL AUTO_INCREMENT,
  `sname` VARCHAR(40) NOT NULL DEFAULT ';';,
  `init` VARCHAR(5) NOT NULL DEFAULT ';';,
  `fname` VARCHAR(40) NOT NULL DEFAULT ';';,
  `title` VARCHAR(4) NOT NULL DEFAULT ';';,
  `msname` VARCHAR(40) NOT NULL DEFAULT ';';,
  `dob` VARCHAR(8) NOT NULL DEFAULT ';';,
  `sex` CHAR(2) NOT NULL DEFAULT ';';,
  `lang` VARCHAR(10) NOT NULL DEFAULT ';';,
  `idno` VARCHAR(13) NOT NULL DEFAULT ';';,
  `telh` VARCHAR(12) NOT NULL DEFAULT ';';,
  `telw` VARCHAR(12) NOT NULL DEFAULT ';';,
  `cel` VARCHAR(12) NOT NULL DEFAULT ';';,
  `fax` VARCHAR(12) NOT NULL DEFAULT ';';,
  `email` VARCHAR(40) NOT NULL DEFAULT ';';,
  `address` tinytext NOT NULL,
  PRIMARY KEY (`sno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Dumping data for table `student`
--