addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1linklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Re: [webdesign-396] two questions MySQL

From: Aoirthoir An B.
Sent on: Monday, December 7, 2009 2:00 PM
AHA! Danke!

--- On Mon, 12/7/09, Ronald Finnerty <[address removed]> wrote:

> From: Ronald Finnerty <[address removed]>
> Subject: Re: [webdesign-396] two questions MySQL
> To: [address removed]
> Date: Monday, December 7, 2009, 12:35 PM
> ustream for streaming
> 
> --- On Sun, 12/6/09, Aoirthoir An Broc
> <[address removed]> wrote:
> 
> 
> From: Aoirthoir An Broc
> <[address removed]>
> Subject: Re: [webdesign-396] two questions MySQL
> To: [address removed]
> Date: Sunday, December 6, 2009, 10:21 PM
> 
> 
> FTP wont get you into the database.
> FTP will let you create a file, transfer it to the site and
> then ssh in to have the data go into the database. When I am
> better I will go over that or I will create a video and that
> way you can have it for the future.
> 
> Also one cat in our meeting whas telling me about a site to
> do streaming but I forgat the name of it so if anyone has
> suggestions that would be cool. It needs to stream from
> GNU/Linux.
> 
> Many Kind Regards.
> Aoirthoir the Fat Bellied.
> 
> --- On Sun, 12/6/09, Ronald Finnerty <[address removed]>
> wrote:
> 
> > From: Ronald Finnerty <[address removed]>
> > Subject: Re: [webdesign-396] two questions MySQL
> > To: [address removed]
> > Date: Sunday, December 6, 2009, 9:33 PM
> > Anyone that has good notes from
> > the russo meeting i would appreciate a copy.
> > ?i cant get ftp to work to get into the
> > database.
> > thanks in advance
> > ron finnerty
> > 
> > --- On Sun, 12/6/09, Aoirthoir An Broc
> > <[address removed]>
> wrote:
> > 
> > 
> > From: Aoirthoir An Broc
> > <[address removed]>
> > Subject: Re: [webdesign-396] two questions MySQL
> >
>  To: [address removed]
> > Date: Sunday, December 6, 2009, 12:04 PM
> > 
> > 
> > 
> > 
> > 
> > 
> > Stuart,
> > 
> > Christopher's right on the button here. 
> > --- On Sun, 12/6/09, Christopher William Leggett
> > <[address removed]>
> wrote:
> > 
> > 
> > From: Christopher William Leggett
> > <[address removed]>
> > Subject: Re: [webdesign-396] two questions MySQL
> > To: [address removed]
> > Date: 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?gif­tregistry.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_recipient­s):
> > 
> > 
> > 
> > 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.WebS­igCleveland.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]
> 
> > 
> > 
> > 
> > --
> > Please Note: If you hit "REPLY",
> > your message will be sent to everyone on
> > this mailing list ([address removed])
> > This message was sent by Christopher William Leggett
> > ([address removed])
> from Cleveland
> > Web Design and Development Meetup.
> > To learn more about Christopher William Leggett,
> 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]
> > 
> > 
> > 
> > 
> > --
> > Please Note: If you hit "REPLY",
> > your message will be sent to everyone on
> > this mailing list ([address removed])
> > This message was
>  sent by Aoirthoir An Broc
> > ([address removed])
> from Cleveland
> > Web Design and Development Meetup.
> > To learn more about Aoirthoir An Broc, 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]
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > --
> > 
> > Please Note: If you hit "REPLY",
> > your message will be sent to everyone on
> > this mailing list ([address removed])
> > 
> > This message was sent by Ronald Finnerty ([address removed])
> > from Cleveland
> > Web Design and Development Meetup.
> > 
> > To learn more about Ronald Finnerty, 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]
> > 
> > 
> >
> 
> 
> 
> --
> Please Note: If you hit "REPLY", your message
> will be sent to everyone on this mailing list ([address removed])
> http://www.meetup...­
> This message was sent by Aoirthoir An Broc ([address removed])
> from Cleveland Web Design and Development Meetup.
> To learn more about Aoirthoir An Broc, visit his/her member
> profile: http://www.meetup...­
> To unsubscribe or to update your mailing list settings,
> click here: http://www.meetup...­
> Meetup Inc. PO Box 4668 #37895 New York, New York
>[masked] | [address removed]
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> --
> 
> Please Note: If you hit "REPLY",
> your message will be sent to everyone on
> this mailing list ([address removed])
> 
> This message was sent by Ronald Finnerty ([address removed])
> from Cleveland
> Web Design and Development Meetup.
> 
> To learn more about Ronald Finnerty, 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