addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Re: [webdesign-396] two questions MySQL

From: Christopher L.
Sent on: Sunday, December 6, 2009 10:26 AM
Stuart,

I'm not entirely sure if this is the problem, but look closer at the event field. It looks like it has a single quote instead of the back tick. Hope that will fix the issue.

Christopher Leggett

Sent from my iPhone

On Dec 5, 2009, at 2:05 PM, Stuart Smith <[address removed]> wrote:

Aoirthoir:
I hope you are feeling better today.  

Trying to create the additional tables, but not working yet.  I have two questions:

1) I am able to get FTP access to tastala.com and see the /students/stuart folder, but not sure where should uploading the .sql file (named: giftregistry.sql) so that can run "mysql>source giftregistry.sql" 

2) Since I was not able to upload the .sql file, I tried creating the new table at the command prompt.  After entering the following sql statement a table was not created.  Where is my error?

mysql> CREATE TABLE `stuart_recipients` (

-> `id` INT(11) NOT NULL AUTO_INCREMENT,

-> `id_recipient` INT(11) NOT NULL,

-> `first_name` VARCHAR(30) NOT NULL,

-> `last_name` VARCHAR(30) NOT NULL,

-> 'event` VARCHAR(50) NOT NULL,

'> `eventDateTime` DATETIME NOT NULL,

'> PRIMARY KEY (`id`),

'> KEY `name` (`last_name`,`first_name`)

'> ) ENGINE=myisam DEFAULT CHARSET=utf8;



I also tried to do it a second time, and still not work:

mysql> CREATE TABLE `stuart_recipients` (
    -> `id` INT(11) NOT NULL AUTO_INCREMENT,
    -> `id_recipient` INT(11) NOT NULL,
    -> `first_name` VARCHAR(30) NOT NULL,
    -> `last_name` VARCHAR(30) NOT NULL,
    -> 'event` VARCHAR(50) NOT NULL,
    '> `eventDateTime` DATETIME NOT NULL,
    '> PRIMARY KEY (`id`))
    '> ENGINE=myisam;

Here is the "Show tables" after tried to create table (no stuart_recipients):

mysql> show tables;
+----------------------+
| Tables_in_learnadd1  |
+----------------------+
| aoirthoir_giftextras | 
| aoirthoir_gifts      | 
| aoirthoir_recipients | 
| bob_student          | 
| bryan_students       | 
| carmen_students      | 
| chris_giftextras     | 
| chris_gifts          | 
| chris_recipients     | 
| chris_students       | 
| fakebryan_students   | 
| marlin_students      | 
| remington_students   | 
| ron_students         | 
| stone_giftextras     | 
| stone_gifts          | 
| stone_recipients     | 
| stone_students       | 
| stuart_students      | 
| sweechin_students    | 
| will_students        | 
+----------------------+
21 rows in set (0.00 sec)

Looks like Chris (chris_recipients) and Stone (stone_recipients) were successful.

I might play around some more later. Thanks for your assistance. 

Stuart
Web Development SIG Co-Leader www.WebSigCleveland.org 
Follow me on: twitter.com/sos_jr
=========================== 
Stuart O. Smith, Jr., MNO, MCP+I 
Certified Internet Webmaster - Master Designer

home email: [address removed]
home phone:[masked]

Please consider the environment before printing this e-mail.



=



--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Stuart Smith ([address removed]) from Cleveland Web Design and Development Meetup.
To learn more about Stuart Smith, visit his/her member profile
To unsubscribe or to update your mailing list settings, click here

Meetup Inc. PO Box 4668 #37895 New York, New York[masked] | [address removed]

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy