youtube Posted July 4, 2013 Group: Members Topic Count: 74 Topics Per Day: 0.02 Content Count: 171 Reputation: 0 Joined: 06/19/13 Last Seen: March 16, 2014 Share Posted July 4, 2013 (edited) how can create table on SQL about email. like this CREATE TABLE IF NOT EXISTS `E-Inquiry` (`ID` bigint(20) unsigned NOT NULL auto_increment,`Sender_ID` int(11) unsigned NOT NULL default '0',`Sender_Name` varchar(30) NOT NULL default '',`Title` text,`Message` text,`Status` tinyint(2) NOT NULL default '0',`Inquiry_Time` datetime NOT NULL default '0000-00-00 00:00:00',`Reply` text,`Reply_Time` datetime NOT NULL default '0000-00-00 00:00:00',`Reply_Name` varchar(30) NOT NULL default '',PRIMARY KEY (`ID`)) ENGINE=MyISAM; i dunno how to create a table for E-Inquiry Edited July 4, 2013 by youtube Quote Link to comment Share on other sites More sharing options...
Archetype Saber Posted July 4, 2013 Group: Members Topic Count: 90 Topics Per Day: 0.02 Content Count: 361 Reputation: 18 Joined: 01/09/13 Last Seen: April 11 Share Posted July 4, 2013 are you familiar with SQL Query ? Quote Link to comment Share on other sites More sharing options...
Patskie Posted July 4, 2013 Group: Members Topic Count: 50 Topics Per Day: 0.01 Content Count: 1702 Reputation: 238 Joined: 09/05/12 Last Seen: April 21 Share Posted July 4, 2013 What framework are you using? Just execute the command Quote Link to comment Share on other sites More sharing options...
youtube Posted July 4, 2013 Group: Members Topic Count: 74 Topics Per Day: 0.02 Content Count: 171 Reputation: 0 Joined: 06/19/13 Last Seen: March 16, 2014 Author Share Posted July 4, 2013 OOP how? @OOP .. can you help me? What framework are you using? Just execute the command Patskie see the control panelare you familiar with SQL Query ? suyothegreat10% familiar master Quote Link to comment Share on other sites More sharing options...
Archetype Saber Posted July 4, 2013 Group: Members Topic Count: 90 Topics Per Day: 0.02 Content Count: 361 Reputation: 18 Joined: 01/09/13 Last Seen: April 11 Share Posted July 4, 2013 it's patskie not OOP Hahaha, anyway, delete the existing table "E-Inquiry" then Paste the SQL to the query then execute it. Quote Link to comment Share on other sites More sharing options...
youtube Posted July 4, 2013 Group: Members Topic Count: 74 Topics Per Day: 0.02 Content Count: 171 Reputation: 0 Joined: 06/19/13 Last Seen: March 16, 2014 Author Share Posted July 4, 2013 can you post the SS of SQL Quote Link to comment Share on other sites More sharing options...
Patskie Posted July 4, 2013 Group: Members Topic Count: 50 Topics Per Day: 0.01 Content Count: 1702 Reputation: 238 Joined: 09/05/12 Last Seen: April 21 Share Posted July 4, 2013 E-inquiry table i guess is made only by Emistry. so if E-inquiry table is already there then i conclude that there should be no problem on emistry script. Quote Link to comment Share on other sites More sharing options...
youtube Posted July 4, 2013 Group: Members Topic Count: 74 Topics Per Day: 0.02 Content Count: 171 Reputation: 0 Joined: 06/19/13 Last Seen: March 16, 2014 Author Share Posted July 4, 2013 suyothegreat i change the"E-Inquiry" to "SQL" there no happen suyothegreat i change the"E-Inquiry" to "SQL" same error my SQL table is correct or have wrong? Quote Link to comment Share on other sites More sharing options...
Archetype Saber Posted July 4, 2013 Group: Members Topic Count: 90 Topics Per Day: 0.02 Content Count: 361 Reputation: 18 Joined: 01/09/13 Last Seen: April 11 Share Posted July 4, 2013 suyothegreat i change the"E-Inquiry" to "SQL" there no happen suyothegreat i change the"E-Inquiry" to "SQL" same error my SQL table is correct or have wrong? No No No No .. delete the Existing "E-Inquiry" table then Execute this SQL Code CREATE TABLE IF NOT EXISTS `E-Inquiry` ( `ID` bigint(20) unsigned NOT NULL auto_increment, `Sender_ID` int(11) unsigned NOT NULL default '0', `Sender_Name` varchar(30) NOT NULL default '', `Title` text, `Message` text, `Status` tinyint(2) NOT NULL default '0', `Inquiry_Time` datetime NOT NULL default '0000-00-00 00:00:00', `Reply` text, `Reply_Time` datetime NOT NULL default '0000-00-00 00:00:00', `Reply_Name` varchar(30) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM; Quote Link to comment Share on other sites More sharing options...
youtube Posted July 4, 2013 Group: Members Topic Count: 74 Topics Per Day: 0.02 Content Count: 171 Reputation: 0 Joined: 06/19/13 Last Seen: March 16, 2014 Author Share Posted July 4, 2013 mmmmm Quote Link to comment Share on other sites More sharing options...
Question
youtube
how can create table on SQL about email.
like this
CREATE TABLE IF NOT EXISTS `E-Inquiry` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`Sender_ID` int(11) unsigned NOT NULL default '0',
`Sender_Name` varchar(30) NOT NULL default '',
`Title` text,
`Message` text,
`Status` tinyint(2) NOT NULL default '0',
`Inquiry_Time` datetime NOT NULL default '0000-00-00 00:00:00',
`Reply` text,
`Reply_Time` datetime NOT NULL default '0000-00-00 00:00:00',
`Reply_Name` varchar(30) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM;
i dunno how to create a table for
E-Inquiry
Edited by youtubeLink to comment
Share on other sites
9 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.