| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> lol, sorry guys
<1> lawlz.
<0> i totally thought i was in #php for the longest time
<2> ##php
<2> you mean ;-)
<0> right
<2> oso i have messd up grant tables
<1> whatever
<2> i just tried mysql_install_db
<1> i don't know freenode's weird and wild conventions
<3> Monkey_b, I won't talk about the flaws of PHP in ##php - I might be crazy, but I'm not a madman
<0> haha
<4> virus: you also probably can't type enough words per minute either
<4> I just thought of a better one
<4> virus: you might get kicked for flooding ;)
<3> Jivedue, if I'm in a good condition I write about 7-8 characters per second (including misses) ... getting kicked because of flooding could be possible even if I don't repeat myself. *g*
<4> virus: I'm not literally doubting your wpm abilities, haha, I'm just joking around
<1> aha
<1> there we go
<1> yeah that sounds about right
<4> first of all, I have no idea how using a keyboard works with chinese, but I wonder how many words (which equals chars, I guess) they can type per minute
<1> http://www.straightdope.com/cl***ics/a5_177.html
<4> that was a freakishly fast response..
<1> hahaha
<1> i love the straight dope
<1> and i remembered he'd covered it
<1> so "chinese typewriter straight dope" gave me that as the first hit
<5> I wish Cecil used RSS though :\
<1> indeed
<6> gleam_: i want to do a read lock so that when i am finished loading data from master things still dont write to the master. how can i do this
<1> although i can just pick up the reader
<5> "Hi my website is from 1994!"
<1> load data from master should lock the tables
<1> on the master
<1> oh
<1> things still don't
<1> i dunno.
<4> I like the conclusion .. "thank G-O-D for the A-B-C's." - no kidding
<1> i like all the references in the straight dope archives/faqs/etc ot aol
<1> since until like, 2000 it was an all-aol thing
<1> or maybe even later
<1> ooh
<1> infi
<1> http://www.jwz.org/cheesegrater/RSS/straightdope.rss
<5> ooh, nice
<1> jwz to the rescue
<1> not full text though
<1> just headline+link
<5> bah, the headline is only the date, too. oh well
<1> shame
<7> I have a bit of a design question. I have a table that stores orders for a website. It has rows like, order_id, item1, item2, item3 etc
<7> how do bigger sites allow for N number of items without having N number of rows?
<5> those are columns.
<7> er, columns, right sorry
<5> but they would use a separate items table, and a link table between the ORDERS and ITEMS table, that just contains multiple records with ORDER_ID, ITEM_ID.
<7> but wouldn't they have N number of item_id's for N number of items in the order?
<5> like: ORDERS (id, date, customer_id, status), ORDER_ITEMS (order_id, item_id, quantity), ITEMS (id, name, description, price, etc..)
<5> you use 3 tables.
<7> oh, okay, i get it
<7> wow, i'm dumb
<7> haha
<5> then select all entries from the ORDER_ITEMS table where ORDER_ID = the order you want.
<5> that's normalization. ;)
<5> you probably want to add total, etc. to the ORDERS, that was an example.
<7> i can't believe i never thought of that, considering i do that for everything else
<7> right
<5> spend time in advance planning your table structure, it helps. ;)
<7> i can always calculate that stuff using php
<3> Q: "What is the burning question on the mind of every dyslexic existentialist?" -- A: "Is there a dog?"
<7> yeah, i'm finding that my weakest point is DB schema
<7> i use varchar for just about everything, and use PHP to hack anything i don't know how to do with mysql
<7> which i imagine is typical of novice and intermediate php programmers
<2> so.. since i'm still locked out.. i renamed the mysql table to something temporarily and ran mysql_install_db but mysql wont start that way
<2> any ideas?
<2> nvm, thanks for all the help, i got it ;-)
<8> Hi. Anyone used mysql c api in c++ before?
<1> yes, some people have
<9> A lot of people do.
<8> Yeah, im looking for someone with experience in it because i do have some very weird problems with it.
<8> http://www.gamedev.net/community/forums/topic.asp?topic_id=394411
<8> Could it be one of the header files is missing a safeguard? :p
<1> your best bet will probably be the mysql lists or forums, but someone here might be able to help anyway
<10> im willing to pay sombody $10 USD to make me a simple mysql application Pm me
<9> no
<7> haha
<1> haha
<7> if you lived in LA, i'd take you up on that offer.
<7> i could use some lunch right about now.
<9> I live in LA
<7> neato, what part?
<11> the gay part
<7> west hollywood, or silverlake?
<7> heh
<11> gay holly would
<9> haah
<5> hey now, don't go knocking West Hollywood. It's FABULOUS.
<9> Everyone holds hands in WeHo
<7> oh, cool
<5> actually, there's a pretty cool restaurant there called Barney's Beanery. lots of old Beat authors and peeps like Jim Morrison and Joplin hung out there.
<1> chicago is your daddy.
<5> before choking to death
<5> hmm, maybe that's not such a good restaurant after all..
<7> haha
<7> i actually like a lot of weho
<5> yar, Melrose has some pretty neat shops
<7> it makes my gay friends uncomfortable, though
<5> I dunno if that qualifies as WeHo though
<7> no, not really
<7> i think it's doheney westward
<7> but who the hell knows
<5> or CARES! NUKE LA!
<5> just leave Magic Mountain intact.
<7> everyone in LA that lives west of downtown says they're from "the westside".
<8> gleam?
<1> who me?
<8> I found the problem. I think my_global.h is bugged
<1> fix it :)
<5> mopos: it looked more like you were redefining Bool/_Bool, but I don't really know C++
<8> infi, my_global.h does that
<8> http://dev.mysql.com/doc/refman/5.0/en/windows-client-compiling.html
<5> ah, I get it. straight C doesn't have a boolean type.
<8> correct
<5> maybe you can wrap it in an #ifdef or something.
<8> typedef charmy_bool; /* Small bool */
<8> sorry wrong paste
<8> #if !defined(bool) && !defined(bool_defined) && (!defined(HAVE_BOOL) || !defined(__cplusplus))
<8> typedef charbool;/* Ordinary boolean values 0 1 */
<5> I trust you, we don't need to see. wrap it in an #ifdef C++ // or whatever C++ uses
<5> damn, too slow again.
<12> I have a `time` column in my DB I'm trying to select all events that were in the last 16 minutes
<12> SELECT * FROM `schedule` WHERE TIMEDIFF(`time`,TIME(FROM_UNIXTIME((UNIX_TIMESTAMP(now()) MOD 86400) + 3600))) < '00:15:00' LIMIT 0,30;
<12> that doesn't seem to work
<13> is there any disruption to a database when I do a mysqldump on it?
<9> jsoft, Yes!
<13> like what? they just wont be able to write to it?
<9> I believe so.
<9> I don't remember which kind of lock it puts on
<13> sweet.
<9> Internet too slow at work. Must work from home. Later all
<14> --opt will read lock all tables
<14> (which is the default)
<13> ok. i like the default then.
<13> what about when a database is being restored.. and by restored, I mean.. restored..
<5> you mean restored?
<13> will it just **** out if some php thing is trying to do something in the middle of a restore ( with drop-table options specified in the mysqldump )
<13> no during a mysql < dump_file
<13> infi: yeah restored. I think.
<5> well, theoretically, your snapshot at any point in time would not be complete until the dump was finished loading... so I would hope it would use a read lock in that case. dunno offhand, however.
Return to
#mysql
or
Go to some related
logs:
Reiser+vs.+XFS
block flash in konqueror
gtktreeview row_activated row selected
can't boot with ndiswrapper ubuntu
cmannd prompt $
#osdev
#gentoo
#linux
#web
paste/2838
|
|