| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> OldVolks: many other aspects can also be normalised to be an (optional) attribute of the main details. this also prevents NULLs in case they are indeed optional.
<0> and it makes searches easier. the above looks like a spreadsheet.
<0> !tell us about spreadsheet
<1> arjenAU asked me to tell you this: Arjen's rule#1: A relational database is NOT a spreadsheet.
<2> i just copied the php bit of code to give a quick list of what i have
<3> arjenAU: hey, how have you been arjenAU?
<0> TodoInTX: I'm generally around. taught MySQL course in Sydney last week... LCA in Dunedin 3 weeks ago... now busy with MySQL UC program matters. I think it's called work.
<3> I said How not where? ;)
<0> TodoInTX: busy? ;-)
<3> OldVolks: does my answer solve your imediate question?
<2> i added it
<2> right now nothing matchs because the database is empty
<4> TodoInTX / OldVolks: If you really want LEFT JOIN behavior, you don't want profile.hair_color in the WHERE clause. Move that to the ON clause or you'll lose your rows where the right table is null.
<3> arjenAU: quick question... it's advised to increase read_buffer when you do lots of table_scans, what status variable tells that ?
<3> Select_scan ?
<4> OldVolks: If you don't need LEFT JOIN behavior, just use a simple INNER JOIN.
<0> TodoInTX: see manual for descriptions of status vars.
<3> bah.
<0> TodoInTX: if you think I memorised all hundreds of 'em, you're delusional ;-)
<0> TodoInTX: oh if you use MySQL Administrator, you get a useful oneliner next to each status and setting var.
<0> I just don't have it handy right now.
<3> I'm usuially one to RTM before asking questions.
<3> the explanations seem a bit sparse in some of the entries.
<5> TodoInTX: provide the exact entry which is not described sufficiently and request mysql doc team to work on it
<6> hey guys, need a mysql 5 book... need to learn the very standard and correct way of using mysql
<6> please do recommend good ones!
<0> Renich: Pro MySQL by Pipes & Kruckenberg (APress), MySQL (3rd edition) by Paul DuBois.
<0> Renich: check out Apress, they have a lot of good stuff. also in combo with PHP.
<7> none by mysql press?
<6> thank you arjenAU
<7> the shame!
<0> there's of course the MysQL 5.0 Certification Guide by MySQL Press.
<6> arjenAU: Yeah, is it free?
<0> jpm_: sure. but Apress has a very short release cycle, so they're often ahead ;-) and it's good
<0> Renich: is what free?
<6> the guide from mysql press
<7> there's no free lunch
<0> Renich: yuo asked for book. a dead tree. as you may be aware, one BUYS a book from a bookstore.
<7> get a job!
<6> lol, you're right
<0> feel free to go to Borders to just sit and read it.
<0> oh, if you sign up for a MysQL training week, the cert guide is indeed free.
<0> it's used as the student guide for the MySQL 5.0 for Developers and MySQL 5.0 for DBAs courses.
<0> very good.
<6> thank you for the tips, arjenAU
<6> the problem with fast dev is that we, beginners, can't catch up with the new stuff
<6> I'm trying to learn php5.1, MySQL 5, C++, CSS 2.1, XHML1.1 and some other stuff... too little time!
<0> Renich: which is why training courses are good.
<6> arjenAU: had a bad experience with zend's beginners course... don't wanna repeat that
<6> I know zend is not mysql ab
<7> it could be though!
<0> Renich: indeed. MysQL has a very good track record on courses. and you probably know the trainers, as they hang out here also
<6> but still... I hate it when I learn stuff you find on tutorials on the net
<7> if marten would just sell out to oracle
<7> then everything would just be oracle.com
<7> but nooooooooooo
<6> arjenAU: Well, thank you for your advice, I will take it in count
<0> Renich: all the info is out there anyway. the point of a course is that the training is clearly structured with fundamentals, exercises, etc so that you gain skills effectively and quickly.
<6> that sounds great
<0> some of the mysql trainers: flupps (Tobias Asplund), Harrison Fisk, me...
<0> in the US you're likely to see Harry, or Sarah Sproehnle. all good.
<7> sarah kicks ***
<0> jpm_: that'd be too easy ;-)
<6> cool, yeah, your name sounds familiar... any books?
<6> advanced mysql perhaps?
<0> Renich: I reviewed some, and I edited the Mysql manual for O'Reilly COmmunity Press. but no I didn't author a book. I do some other stuff that gets my name around some time ;-)
<6> cool, well, thank you arjenAU for your advice, I will take it in count (and start raising some money)
<6> arjenAU: By the way, you guys should port your work to Mxico. Nobody gives certification here... and almost nobody understands english! Only newbies give courses... and they're ridiculous
<3> Harrison did my training... I p***ed the Core and Pro exams so I think it was pretty good.
<3> 1st go arround too.
<8> Does anyone know if there is any big difference between MySQL 4.0 and 4.1?
<3> spazzz: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-x.html
<3> spazzz: stronger p***word function and subqueries are probably the most notable differences.
<4> spazzz: 0.1 doesn't sound like a big difference, but it is.
<3> and prepared statements.
<8> TodoInTX: I'm trying to backup the database on my Fedora box so I can change the server over to Ubuntu. But the dumb thing won't reimport the tables. It complanes about syntax errors
<3> spazzz: from 4.0 to 4.1 ?
<6> well guys, have a nice night... and a great week!
<5> spazzz: default charset=? must be from 4.1 to 4.0
<6> and thanks for the advice! bye
<8> Its there
<5> spazzz: dump again with mysqldump using the compatible option if 4.1 to 4.0
<8> lokus: Can you tell me how to invoke the compatability option?
<3> mysqldump --compatibe=mysql40
<5> spazzz: --help option is always there :)
<8> Ok... The thing is
<8> Ohh wait..
<8> Sorry i got confused a minute
<8> The Ubuntu SQL server is older than the Fedora one
<8> Alright let me give that a shot and i'll get back with you
<9> hello. I'm a beginner and i was wondering if someone could point me to some information on the different lengths of datatypes that you can use
<9> such as when it's appropriate to have a certain length of an integer and exactly how long is it
<9> if that makes sense
<10> i wanna ask about ODBC
<0> !m drocko data types
<1> drocko: (Column Types) : http://dev.mysql.com/doc/mysql/en/Column_types.html
<10> i have a mysql database server
<0> drocko: goodnes,s it's the manual!
<9> thanks
<11> larcenhaido, oh?
<10> if my user want to acsessing my mysql database than should he get it with ODBC?
<3> native client libs are prefered.
<11> depends - there are JDBC and .NET (and others)
<10> so ODBC is client side...am i right?
<10> i dont have to install MyODBC in my database server
<10> am i right?
<11> larcenhaido, ODBC is a driver to access the mysql server
<12> how many instances of union can I use in one query?
<11> larcenhaido, so you do not need to install it on the server unless it also happens to be the client
<12> or, how do I found out. the union topic on mysql.com doesn't say
<10> okay
<3> Supaplex: I didn't know there was a limit. It's like saying how many OR's can you use in a query.
<10> tahnks guys for the information
<0> Supaplex: no limit afaik.
<11> larcenhaido, MyODBC (also called C/ODBC) uses the mysql *client* library. The mysql client library talks 'directly' to the server
<11> larcenhaido, So....
<0> Supaplex: you just have your own sanity to consider, and decent db design. if you're pondering limits, I fear for both ;-)
<11> MyODBC -> MySQL Client Library -> MySQL Server
<11> nothing special needed on the server - just mysql server
<11> larcenhaido, On the client you just need to install C/ODBC (MyODBC) because it is statically linked to mysql client library. No need to install the MySQL client library :)
<11> larcenhaido, is that the answer you were looking for?
<12> ok, cool. I just tried with 32, seems to work. I'm trying manual table partitioning, and I only occasionally need this query. :)
<10> ok
<0> pharvey|InCode: sup?
<10> thank you guys
<13> err 'shout out' being a good thing ;)
<13> just saying hi
<0> Supaplex: at the very least, use a VIEW in 5.0. or just go for 5.1 and use proper parittioning
<0> pharvey|InCode: g'day, eh!
<13> :)
<0> pharvey|InCode: whereabouts in canada are you now?
<13> Just north of Vancouver... outside of a town called Sechelt
<14> canada, eh?
<15> How do I specify my images table must have a child record in the track table? http://trac.natalian.org/browser/projects/imagetrack/create.sql
<13> ya - eh :)
<13> http://www.bigpacific.com/sechelt/index.html
<16> is there an easy way to do like
<16> WHERE var = [ 'this', 'or', 'that' ] ?
<16> where it's like this | or | that ?
<16> instead of var = 'this' || var = 'or' || var = 'that'
<17> IN
<17> WHERE var IN ('this', 'or', 'that')
<16> Julian|Work, what if you wanted AND?
<17> WHERE var = 'this' AND var = 'that'?
Return to
#mysql
or
Go to some related
logs:
cpanel php_escape_html_entities
art-manager fluxbox
lpq is not ready
setting permissions for /dev/nvram
#math
#gentoo
#linux
hanging perl script
#perl
servlet CURDATE()
|
|