| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> RDBMS?
<1> A relational database, like MySQL or Oracle.
<0> Random Door Breaking Mean Streak?
<0> again, what I don't understand is why progs even need "databases" to begin with
<1> Because they have data and they want to put it somewhere.
<0> just save all the info in .txt files or folders of some kind
<1> Right, that's one option
<1> But different tools provide different advantages and disadvantages. One of the advantages of using a relational database is that you can express relations between different kinds of data. Another is performance.
<0> like compare?
<0> but does MySQL put everything in a nice graphical chart for me?
<1> But I really can't give you an introduction to databases course on IRC. maybe there's something on the web you could read, or your public library.
<0> i just don't get it...
<2> Unrelated - just use postit notes, stick them on your monitor
<3> lo
<3> l
<3> but
<3> what is the easiest way to import data from .DBF files into MySQL DB?
<2> !google importing DBF files into MySQL
<4> importing DBF files into MySQL: http://www.webmasterworld.com/forum88/136.htm
<3> hmm
<2> that's a paid link :(
<5> Zrin: imho using any desktop client
<5> (that does both :-)
<3> johann__ desktop=GUI?
<5> yep
<5> afaik there was a dbase2mysql somewhere
<5> as well
<0> ....
<0> it makes no sense...
<3> Unrelated imagine you want to keep a list of 2x10^6 customers ... can't use Excel for that
<6> can i use a join in a delete clause?
<3> faber2 yes
<2> Unrelated, how would you store "User 45's favourite colour is red" in your system using 8 bytes in your system, in two lines of code?
<1> unrelated: Right, it makes no sense for the things you have to do. There's nothing wrong with that, but I don't see why you expect us to *fix* that for you.
<7> faber2: This delete syntax page has an example: http://dev.mysql.com/doc/refman/4.1/en/delete.html
<0> I would like a solid reason, or example where SQL is needed?
<0> n/m...
<0> I'll just live with the fact that some people like nascar and some people hate it
<0> all preference I guess....
<8> Unrelated: SQL is needed when you want to retrieve information from a database in a consistant manner
<8> Unrelated: so really you're asking "when is a database needed"
<9> !perror 28
<4> System error: 28 = No space left on device
<7> Unrelated: A database is needed to ensure data integrity, You can reinvent the wheel, but why?
<8> Unrelated: try storing a million orders in text files and being able to search for a specific order either by the person that placed it, the amount, the date or any of a number of criteria
<10> I have a table with rows that look like (foo_id, bar_id, somevalue). For each bar_id in this table, I need to find the somevalue of the row with the highest foo_id.
<10> I could do this with ORDER BY foo_id DESC LIMIT 1, but that requires a subquery.
<10> A dependent subquery, which is really slowing things down.
<10> Is there a way to do this in one shot, to construct a temporary table, keyed to bar_id, with this information?
<11> hello people..
<12> Maybe select somevalue from table having foo_id = max(foo_id) group by bar_id ?
<12> Just guessing
<11> can someone tell me how i delete/drop a database
<13> nuxil: drop database your database;
<11> oh,, nice
<10> cbg: But then I don't get the somevalue.
<14> help ! i lost the root p***word
<14> what to do?
<15> is there an *easy way* to get the number of months between two date fields?
<12> quotemstr: ?
<13> !m blahh lost p***word
<4> blahh: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<14> muchos gracias amigos
<16> !m sk1 period_diff
<4> sk1: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<16> sk1: or... (year(dt1) - year(dt2))*12 + (month(dt1) - month(dt2))
<15> SQL: That's not helpful..I looked at it
<15> if you scroll down the page, you'll see Issac posted this statement: IF((((YEAR(date2) - 1) * 12 + MONTH(date2)) - ((YEAR(date1) - 1) * 12 + MONTH(date1))) > 0, (((YEAR(date2) - 1) * 12 + MONTH(date2)) - ((YEAR(date1) - 1) * 12 + MONTH(date1))) - (MID(date2, 9, 2) < MID(date1, 9, 2)), IF((((YEAR(date2) - 1) * 12 + MONTH(date2)) - ((YEAR(date1) - 1) * 12 + MONTH(date1))) < 0, (((YEAR(date2) - 1) * 12 + MONTH(date2)) - ((YEAR(date1) - 1) * 12 + MONTH(date1))) + (MID(
<15> date1, 9, 2) < MID(date2, 9, 2)), (((YEAR(date2) - 1) * 12 + MONTH(date2)) - ((YEAR(date1) - 1) * 12 + MONTH(date1)))))
<8> quotemstr: select distinct bar_id, foo_id, somevalue from table HAVING foo_id = MAX(foo_id); try that
<16> yup, I saw that
<10> Ahh. I didn't know that HAVING construction existed.
<17> hello, i need to do something that i can't manage to do... i have a select on two tables that *can* return records with the same values on two columns. i want sql to return the records that either have different values OR have the same value on both columns (but in this case i don't want it to return all the other combinations too). i've found that "ORDER BY col1=col2 DESC" puts them first, but i can't seem to be able to trim out al
<17> l the other ones... group by doesn't help much :( any hints?
<10> Thanks!
<15> that's the only way I've found to get the number of months between two dates
<16> sk1: it's really a matter of what you want. What would your answer be for "2005-01-25" and "2005-02-01"? Is that 0 months or 1 month? If it's strictly based on the month number (ignoring the days part), what I posted should work fine
<18> im trying to do a "LOAD DATA LOCAL INFILE" but mysql says ERROR 1148 (42000): The used command is not allowed with this MySQL version
<19> keith: LOCAL INFILE can be disabled at compile time
<18> im using mysql Ver 14.7 Distrib 4.1.10a, for suse-linux (i686)
<19> recompile MySQL or find another way to do it
<18> oh.. im using a mysql package
<19> !man load data
<4> (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<18> so is there a way out? :)
<19> keith: check to see if mysqld is being run with --local-infile=0
<18> Darien, ive tried setting local-infile=1 in my.cnf as well as starting with --local-file=1
<18> but i still get the error "used command is now allowed.."
<19> keith: probably was compiled without it then
<19> but it would be local_infile in my.cnf
<18> sure, same error still
<20> how could i change the encoding of a database?
<21> anyone notice that select (1/((c-x)^2 + 1)) from table1; produces negative numbers?
<21> eject gribnoi_ded please?
<22> for bad taste at the least
<21> for spamming!
<10> What the hell...?
<10> A simple query with one inner join is taking over two minutes.
<1> EXPLAIN the query, see what it's doing
<21> !sysops
<10> It has two lines, both SIMPLE.
<1> quote: Great, put those two lines through an EXPLAIN and see what MySQL is doing with them
<10> One using the primary key, the other (a ref type) using the foreign key referencing the other table.
<1> Er, no, I mean: use the EXPLAIN command. :)
<10> mendel: No, I meant the EXPLAIN output only returns two rows.
<23> SELECT `name`, `image`, `link` FROM `Tadvert` WHILE `general`>0 ORDER BY `general` ASC LIMIT 0,4
<1> Right, that's to be expected, one row per table. Is it using a key in both?
<23> whats wrong with that
<10> mendel: Yep.
<1> xploit: What's wrong is that you've confused "#mysql" and "mysql".
<1> That said, I don't think you mean "while".
<10> mendel: It's finding picking out some dates out of about a million rows.
<10> InnoDB table.
<10> But it's a narrow date range, and the dates are indexed.
<23> hmm ?
<1> quotemstr: Not sure offhand, sorry
<1> xsploit: You've written "while" where you wanted "where".
<23> ah :p
<23> ty
<24> any1 know of a good mysql to oracle primer
<24> i have always done mysql but i am taking an oracle cl*** and want to relate the two
<0> ust rune
<0> .....
<25> God why is the query text area is not resizable in MySQL Query Browser...
<23> can you say isin ?
<23> lke while `1`isin`field` ?
<13> Xspl0it: not while.... where....
<23> hmm like %1%
<23> lol yea :p
<13> Xspl0it: where field in (1,3,6)
<13> Xspl0it: this will return all rows where field value is 1,3 or 6
<23> where field in (1,3,6) <-- will this return a field that has 12 in it ?
<13> Xspl0it: no
<23> that is what i want
<23> where `field` like %1% is what i need i think
<13> Xspl0it: if you need all field that contain string '1' anywhere, that's what you need.
<23> mmkay
<8> like '%1%' though, don't forget the quotes
<23> thank you forthat comment shabbs i had forgotten them and was wondering why it wasnt working :)
Return to
#mysql
or
Go to some related
logs:
#web
NameError: name 'sqlhub' is not defined
#fedora
#perl
#perl
how do i update myh fedora
firefox through ssh
axim x30 qemu
+linux +user space allocation
#web
|
|