| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> redduck676, INSERT INTO fights (...) SELECT 44, 1, hp FROM monsters WHERE id = 1
<0> SimAtWork, yeah sure.
<1> will: yay, thanks.
<2> redduck676: areyou making some kinda d20 calculator/program ??
<1> SimAtWork: nope, a php game.
<3> mendel, I'm just going to keep on a reading this stuff til I get it firmly implanted exactly what stakes place on the startup
<3> I sure thx you for your help
<4> np
<4> rado1: Also...
<4> You might find this book useful: http://www.oreilly.com/catalog/hpmysql/
<5> rado1 - best to just install a couple of machines and play around, then come bak when you're stuck
<4> You might find the free chapter provided there even more useful.
<3> free chapter?
<3> you mean in the docs? Chapter 6?
<5> yeah, that book is good to help get started
<3> lol of course...I just needed pointing in the right direction
<3> thx y'all
<3> bye
<5> he meant chapter 7 of the book, 'replication', which is available free
<6> can anyone point one to a manual which discusses repair of berkeleydb tables ?
<7> Why does "INSERT INTO Startreg (Stevne_id,Bil_nr,Kl***e_nr,Forer1,Forer2,Klubb,Merke,Brutt) VALUES ('1',20,2,Jan,Vidar,HiST,Subaru,'false');" result in "Unknown column 'Jan' in 'field list'" - Jan is a value not in the field list?
<8> weedar: you need to quote strings, but not integers.
<9> try 'Jan'
<7> Ah, of course - what a silly mistak
<7> Thanks infi & dd =)
<9> np and same goes for ... Vidar,HiST,Subaru
<9> you need to quote em ;)
<7> I thought so, so I did :)
<10> is there a way to temporarily give a MySQL connection a restricted privilages level?
<0> Why?
<8> SUDO GRANT ALL PRIVILEGES ON *.* TO %@%;
<0> hehe
<11> i am trying to get the datetime of the monday (of that week) given an arbitrary datetime... right now I have this clunky hack... http://pastebin.com/627511 -- anyone know of a more elegant way to do it?
<11> (that one converts it to unix time too)
<12> I am trying to get a large XML file into a mysql4.01 database. Can anyone suggest a not too complex tool or method for a not too deep php type person?
<5> "use the filesystem" ?
<5> there's not much point in puting an xml file into the db
<5> put it on the filesystem, and store the path to it instead
<13> or decode the xml and put in db
<12> can you point me towards filesystem techniques for xml?
<14> hi
<12> I am not too technical... :<
<12> or how to decode xml...
<15> xml xml xml! XML for everything!
<5> filesystem techniques?
<5> just save the file somewhere, and store the path
<5> bah to xml
<15> everyone loves the xml...
<16> what was the trick to drop and recreate referenced tables?
<16> set check_constraints?
<17> and how does one backup privileges in 4.1?
<5> backup the 'mysql' database
<18> can someone tell me which of these is a restricted key: name,alias,author,description,group,weight,enabled,hook_to,appears_on
<17> sjrussel: only option? doh.
<17> I was hoping there was a way to get GRANT statements back out
<5> there might be, I don't know.
<17> hrm, mysqldump doesn't seem to
<19> A while back I read something about a hack to make MySQL 4 behave like it would if it had triggers
<18> anyone?
<18> can someone tell me which of these is a restricted key: name,alias,author,description,group,weight,enabled,hook_to,appears_on
<0> Restricted key?
<0> OneFix_Work, Upgrade to 5.0?
<19> will: I can't
<18> keys that you can't use without quoting them
<17> switch to postgres then.
<17> It's actually mature >;)
<18> ie: you can't use the name 'varchar' for a table, unless you query it as `varchar`
<0> !m Shadowhand reserved words
<18> because 'varchar' is a restricted name
<20> Shadowhand: (Treatment of Reserved Words in MySQL) : http://dev.mysql.com/doc/mysql/en/Reserved_words.html
<18> will, w00t
<18> ah ha
<18> group
<18> i thought so
<18> thanks
<0> MyQuiL, What's wrong with using mysqldump for the user info?
Return to
#mysql
or
Go to some related
logs:
turboprint.key dapper
#sdl
#linux
#kde
xinemera twinview
ubuntu php_pdo sqlite3
#ubuntu
cups problem +ubuntu +password
aszlig php.net
#perl
|
|