#mysql
08 October 2007
Total 24 pages. You are browsing page 24/24.
First :: Prev :: [...] [20] [21] [22] [23] [24] :: Next :: Last
23:46 <****> seekwill, mine doesn't.
23:46 <****> At least not in the HTTP request.
23:46 <****> an Ajax.Request that sends the current time() or whatnot
23:46 <****> Lame
23:47 <****> It gives accepted languages, encodings, and charsets, but not timezones.
23:47 <****> It also doesn't mention that it supports, say, JPEG.
23:47 <****> SpComb: Hmm.. that's a good idea!
23:47 <****> not implemented it though
23:47 <****> Can't JS set cookies? Why don't you just set the time zone in a cookie instead of using Ajax?
23:48 <****> Simetrical: I like server-based things.
23:48 <****> Hmm..that works too
23:48 <****> Simetrical: not sure if a single-use cookie would be better to using an asynch request in any way
23:48 <****> What would the server do, then, upon receiving this request? Add it as a datum in the session table, I suppose.
23:49 <****> although I guess it might be simpler on the JS side
23:49 <****> thanks for
23:49 <****> um
23:49 <****> well the link i guesse
23:49 <****> bbl
23:49 <****> Either way it's basically going to have to be stored in cookies.
23:49 <****> hi
23:49 <****> Directly or indirectly.
23:50 <****> if someone is referring to "SQL" the same way they would to "MySQL", does this mean they are referring to MSSQL?
23:50 <****> Why don't you ask them?
23:50 <****> cant right now just want to know if im offbase
23:50 <****> they can refer any SQL
23:50 <****> there is no standard SQL database system
23:50 <****> is there
23:50 <****> Oracle, DB2, Postgres, anything
23:50 <****> its either MSSQL, MySQL, oracle or others
23:50 <****> yeah
23:50 <****> stupid people ;)
23:51 <****> thanks a lot
23:51 <****> FreeGlobe, there's an SQL standard.
23:51 <****> what is it
23:51 <****> you mean the language itself
23:51 <****> FreeGlobe, it's generally not followed very accurately.
23:51 <****> not the actual database system
23:51 <****> ... and no one fully support it
23:51 <****> :)
23:51 <****> FreeGlobe, yes, the language.
23:51 <****> i meant SQL standard database management system
23:51 <****> as in MYSQL, MSSQL etc
23:51 <****> how do I use 'if exists' with a select statement?
23:52 <****> FreeGlobe, there is no one piece of *software* that can be termed SQL, no. SQL is a language, as the name implies.
23:52 <****> in what order...
23:52 <****> there is ANSI SQL standart, but no such thing as standart database implementation
23:53 <****> hmmm
23:53 <****> is the delete operation rollback -able in mysql?
23:54 <****> SDr, if you're using InnoDB and are in a transaction, yes.
23:55 <****> i have a table with an integer id column to have that column be unique, such that if i delete row 47, then i can never again add row 47 back to the table.
23:56 <****> rephrase
23:56 <****> How do I ensure that a row with a particular id only ever exists once. Even If the row with that id is deleted, I want to ensure it cannot be added again.
23:57 <****> well, you can use auto-increment, it wont be re-used
23:57 <****> but that probably won't stop you from inserting it explicity
23:57 <****> right
23:57 <****> but i don't want someone to be able to explicitly add it
23:57 <****> right
23:58 <****> there's no built-in easy way to enforce that
23:58 <****> an enabled column and then access the table through a view?
23:58 <****> heyadayo, then don't allow rows to be deleted.
23:58 <****> I guess you could use a trigger.
23:58 <****> Or maybe inserts into a view, I don't know how those works.
23:58 <****> work.
23:58 <****> and do what in the trigger? :)
23:58 <****> I have no idea how triggers work or what they can do, so beats me.
23:59 <****> can you use 'exists' with a select statement?????
23:59 <****> what about a GUID? is there such a thing in mysql, and would it help here?
23:59 <****> roler: yes
23:59 <****> heyadayo, someone could still insert it explicitly if the original was deleted.
23:59 <****> hello guys. A short question: how do I run mysql with like 1024 threads on a single machine?
--- Log closed Tue Oct 09 00:00:02 2007
Total 24 pages. You are browsing page 24/24.
First :: Prev :: [...] [20] [21] [22] [23] [24] :: Next :: Last