#mysql
27 October 2007
Total 16 pages. You are browsing page 4/16.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
03:44 <****> ;)
03:45 <****> I need to figure out how togive length to dates
03:45 <****> I am having trouble setting up my load balanced array of 25 Palm Pilots as web servers with MySQL and Apache.
03:45 <****> Crazy lol :|
03:45 <****> ...
03:46 <****> Didn't even know that was possible
03:46 <****> Yes, I have Linux.
03:46 <****> <3 Palm Pilots
03:46 <****> Yes, I have Linux also.
03:46 <****> I am using http://palmtelinux.sourceforge.net/
03:46 <****> Thats irrelevant however
03:46 <****> Ah nice
03:46 <****> I bought 25 of these.
03:47 <****> Surley it would have been cheaper to buy a cheap server rather than 25 pilots?
03:47 <****> The plan: 25 Palm pilots will provide the best Apache MySQL web server ever.
03:47 <****> Hmm, perhaps
03:47 <****> And smallest. :)
03:47 <****> How much RAM do your pilots have?
03:47 <****> 64 MB each
03:48 <****> Hmm, how are they networked?
03:48 <****> Ethernet.
03:48 <****> Ooooh...how'd you do that?
03:48 <****> Pilots don't have ethernet?
03:48 <****> when you create a date field do you have to declare its length
03:48 <****> or do you just do "dob date,"
03:49 <****> huh?
03:49 <****> tators: no
03:49 <****> dates don't have lenghs :|
03:49 <****> if the date is mmddyyyy
03:49 <****> can you declare that
03:49 <****> or should I make it varchar(8)
03:49 <****> you have it back to front
03:49 <****> MySQL does year-month-date
03:49 <****> so you could do yyyymmdd
03:50 <****> or yyyy-mm-dd
03:50 <****> seperate however you want
03:50 <****> yea
03:50 <****> mysql takes many formats
03:50 <****> ok
03:50 <****> well the data comes in yyyymmdd
03:50 <****> do I declare that
03:50 <****> or just say "dob date"
03:50 <****> or "dob date(yyyymmdd)
03:50 <****> Just say dob date..
03:50 <****> k
03:50 <****> then on the insert just put your date in
03:51 <****> Yeah, I have ethernet.
03:51 <****> sweet
03:51 <****> Name theif
03:51 <****> !man date and time
03:51 <****> *thief
03:51 <****> (Date and Time Types) : http://dev.mysql.com/doc/mysql/en/date-and-time-types.html
03:51 <****> no, silly bot
03:52 <****> !man date and time functions
03:52 <****> (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
03:52 <****> there. tators: there are various format functions that let you convert a string to a date or a date to a given format
03:52 <****> do you guys usually declare what type of table ie myisame, innodb....
03:52 <****> or do you just create the table
03:53 <****> if you don't specify, it will use the default engine. If that is ok with you then you don't need to specify... otherwise you do
03:54 <****> is there a lot of difference between them all
03:54 <****> yes
03:54 <****> or as a beginner should I study that later as opposed to nwo
03:56 <****> tators: foreign keys require innodb. fulltext indexing requires myisam. you can alter the table and change the engine at any time.
03:56 <****> ah ok thanks
03:56 <****> as a beginner I would go with myisam. innodb has a whole nother level of config options that could be confusing
03:56 <****> innodb also has more granular locking
03:56 <****> its weird
03:56 <****> and transactions
03:56 <****> this book tells me how to insert one record at a time
03:57 <****> but not a 3gig text file
03:57 <****> respect to whoever can !man that link
03:58 <****> tators: search the manual for 'load data infile'
03:59 <****> k
03:59 <****> well... whats in the text file?
03:59 <****> if it is a mysqldump it is different than if it is a comma separated values file
03:59 <****> tators: If you have access to a command line/shell just do mysql -u insert username here -p insert database here < filename
03:59 <****> I think its a comma delimited file
04:00 <****> k ok
04:00 <****> that won't work for a csv file. you need load data
04:00 <****> !man load data
04:00 <****> (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/load-data.html
04:00 <****> Yes, if its command seperated use LOAD DATA
04:00 <****> You didn't say which it is?
04:01 <****> if its a mysql dump the method I showed would work fine
04:01 <****> comma delimited csv :)
04:02 <****> comma delimited comma separated values!
04:05 <****> can't get state of '/home/andrew/desktop/xxxxx.txt'
04:05 <****> stat*
04:09 <****> thumbs!
04:10 <****> tators: you don't really think mysql has permissions to that directory do you?
04:11 <****> chmod -R 777 /
04:11 <****> :)
04:11 <****> rm -fr / while you're at it.
04:12 * chadmaynard leaves
04:14 <****> seekwill: hi
04:14 <****> thumbs: Are you playing?
04:14 * ToeBee twiddles his thumbs
04:14 * thumbs queries seekwill
04:14 <****> look!
04:16 <****> today, by the power of SQL I discovered that our cell phone provider had shorted us call records in the monthly data file to the tune of 70,000 records for about 200,000 minutes
Total 16 pages. You are browsing page 4/16.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last