Phpmyadmin prob
Posted: Mon Apr 04, 2011 10:21 am
Hye there I need help to my sql coding.When I try to run on phpmyadmin have error.I copy n paste it.
# phpMyadmin SQL Dump
# version 5.5.8
# http://www.phpmyadmin.net
#
# Host: localhost
#
#
#
#
# Database : 'kes3'
#
# ----------------------------------
#
#Table structure for table 'rakan'
#
DROP TABLE IF EXISTS 'rakan';
CREATE TABLE 'rakan' (
'id' int (11) NOT FULL auto_increment,
'nama' varchar (50) NOT NULL default ",
'alamat' varchar (255) NOT NULL default ",
'no_tel' varchar (15) NOT NULL default ",
PRIMARY KEY ('id')
) TYPE=MyISAM AUTO_INCREMENT=7 ;
#
# Dumping data for table 'rakan'
#
INSERT INTO 'rakan' VALUES (2, 'johnson', 'taman juara, \r\nbatu pahat, \r\njohor', '0196474719');
INSERT INTO 'rakan' VALUES (3, 'aminah basir', 'lorong lurus, \r\ntaman manis 2\r\nkuala lumpur', '0123456727';
INSERT INTO 'rakan' VALUES (6, 'harun selamat', 'no 15 taman gah, \r\nparit timur,\r\npahang', '0132475583');
#-------------------------------------
#
# Table structure for table 'user'
#
DROP TABLE IF EXISTS 'USER';
CREATE TABLE 'USER' (
'id' int(3) NOT NULL auto_increment,
'user' varchar (20) NOT NULL default ",
'password' varchar (20) NOT NULL default ",
PRIMARY KEY ('id')
) TYPE=MyISAM AUTO_INCREMNT=2 ;
#
# Dumping data for table 'user'
#
INSERT INTO 'user' VALUES (1, 'saya', '123');
Can help me?
# phpMyadmin SQL Dump
# version 5.5.8
# http://www.phpmyadmin.net
#
# Host: localhost
#
#
#
#
# Database : 'kes3'
#
# ----------------------------------
#
#Table structure for table 'rakan'
#
DROP TABLE IF EXISTS 'rakan';
CREATE TABLE 'rakan' (
'id' int (11) NOT FULL auto_increment,
'nama' varchar (50) NOT NULL default ",
'alamat' varchar (255) NOT NULL default ",
'no_tel' varchar (15) NOT NULL default ",
PRIMARY KEY ('id')
) TYPE=MyISAM AUTO_INCREMENT=7 ;
#
# Dumping data for table 'rakan'
#
INSERT INTO 'rakan' VALUES (2, 'johnson', 'taman juara, \r\nbatu pahat, \r\njohor', '0196474719');
INSERT INTO 'rakan' VALUES (3, 'aminah basir', 'lorong lurus, \r\ntaman manis 2\r\nkuala lumpur', '0123456727';
INSERT INTO 'rakan' VALUES (6, 'harun selamat', 'no 15 taman gah, \r\nparit timur,\r\npahang', '0132475583');
#-------------------------------------
#
# Table structure for table 'user'
#
DROP TABLE IF EXISTS 'USER';
CREATE TABLE 'USER' (
'id' int(3) NOT NULL auto_increment,
'user' varchar (20) NOT NULL default ",
'password' varchar (20) NOT NULL default ",
PRIMARY KEY ('id')
) TYPE=MyISAM AUTO_INCREMNT=2 ;
#
# Dumping data for table 'user'
#
INSERT INTO 'user' VALUES (1, 'saya', '123');
Can help me?