| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> right?
<1> yeah
<1> in() can handle millions of values
<0> i know, but isn't there like an exclusively_in() ? :)
<0> it's much easier if was i able to say SELECT * FROM table WHERE field2 IS ONLY IN ('v1', 'v2')
<1> I think you're confused about how all of this really works
<0> i am
<0> i'm sorry
<0> i looked everywhere on google, couldn't find anything that helps
<2> where did you get the nick cubex from?
<0> kestaswork i can't remember really
<0> kestaswork i've been using it for years now. why?
<2> I know someone else called qubex, wondered if you got it off him
<0> kestaswork oh. nope
<0> kestaswork but i can pretend i did :)
<3> I'm about to look into installing Mysql on a 2003 SBS server - is it true that the dbase max size is 2TB?
<0> firewire i think != won't work either. SELECT * FROM table WHERE field2 != V3 will still get me T3
<0> firewire i need to get only those records that have the same field1 and have both V1 and V2
<0> you see, T1 has both V1 and V2, T2 also has V1 and V2, T3 has V1 and V3. how can i say that i want the records that have only T1 and T2?
<0> SELECT * FROM table WHERE field2=V1 and field2=V2 is an impossible query
<0> is it really impossible to do what i'm trying to do?
<4> i don't get what you're trying to do cubex
<0> lotus_anima i'm not sure how to explain it.
<4> select * from table where field1=t2 or field1=t2;
<0> lotus_anima but i need that by value, that's field2
<0> lotus_anima ok, think of it this way. each T is an article and each V is a tag
<0> lotus_anima article T1 is tagged with V1, V2 and V3, T2 is tagged with V1 and V2, T3 is tagged with V1 and V3
<0> lotus_anima let's say a user wants all the articles that have both tags V1 and V2, but not V3. this should get him T1 and T2, but not T3
<0> lotus_anima now, although T3 is tagged with V1, it's not tagged with V2 so it should be excluded from the results
<5> Hey - does a NULL in an int field take up any space? A friend is trying to conserve DB space by adding a flag that means "use yesterday's value" and leaving the value field blank. We don't know if that woud save any space or take more space, however....
<0> lotus_anima see where i'm getting?
<0> arrrrgh. i'm going crazy over this
<6> how do I query the schema for a table?
<7> can you do datetime operations in mysql ?
<8> chino[lap]: of course
<7> what can it do ?
<8> !m chino[lap] datetime operations
<9> chino[lap]: Nothing found
<8> !m chino[lap] datetime
<9> chino[lap]: (The DATETIME, DATE, and TIMESTAMP Types) : http://dev.mysql.com/doc/mysql/en/DATETIME.html
<7> and you can figure out how long its been from one date to another ?
<8> !m chino[lap] datediff
<9> chino[lap]: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<8> there
<10> does mysql do reverse DNS lookups?
<10> on inbound connections?
<11> Syn-: yes, unless you disable it
<11> or use IPs in your privilege tables
<10> diable via config or is done by command line?
<10> yeah i only use ips in the priv tables
<11> anything done by config can be done by command line, anything that can be done by command line can be done by config...
<11> for the most part, at any rate
<12> hello
<12> Does mySQL have a solution for OLAP cubes??
<11> !m Syn- dns
<9> Syn-: (How MySQL Uses DNS) : http://dev.mysql.com/doc/mysql/en/DNS.html
<12> !m Syn- olap
<9> Syn-: (GROUP BY Modifiers) : http://dev.mysql.com/doc/mysql/en/GROUP-BY-Modifiers.html
<11> Varanger: i bet Syn- doesn't care about your questions :)
<10> thanks
<12> litheum: I don't know... I just need an OLAP solution for mySQK
<12> L
<11> maybe you could be more specific about waht it is you're talking about?
<12> I am moving from SQL Server to mySQL and I need to change from MS Analysis Server to a solution with mySQL
<11> you ***ume i know what the hell MS Analysis Server is
<12> litheum: Do you know MS Analysis Services?
<11> no
<12> What is the difference between: "Windows Essentials" and Windows (x86) installers?
<13> Hi everyone !! :) Or i am stupid or..... well ! i get a syntax error message for insert into UserPrefs("UID") value("1"); Any idea ? yes, UID exists...
<2> Estes: values
<2> Estes: learn SQL better
<13> ah, yes, this was a desperate try
<13> i also have done it with values
<2> Varanger: I doubt there's an alternative to analysis services for mysql
<2> Estes: maybe it doesn't like the speech marks around 1
<11> !m Estes insert
<9> Estes: (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<13> tryied without them too
<11> !tell Estes about tutorials
<9> Alrighty.
<13> hum
<13> i develop with mysql since more than 3 years now, i know how to do a simple select
<13> or a simple insert
<14> hi, is there a "reverse" join or a way to use join that acts like gnu diff?
<11> that doesn't say much for your experience over the last 3 years, man
<11> jesus
<13> my syntax is right, i'm 99.99999% sure of it
<11> what is the syntax you're using now?
<15> JOINS are either INNER or OUTER
<13> insert into UserPrefs("UID") values(1);
<15> get a book!
<13> Sneaky_Bastard, to learn how to do a subselect mysql finaly supports when others did it a while ago ?
<14> i know what types of joins there are i'm asking how to get a certain desired effect
<13> this query is right unless i'm on drugs
<15> I was answering Stalyn
<14> the difference between two tables sharing the same column
<15> no such concept as
<15> "reverse JOIN" to the best of my knowledge
<15> Estes: pastebin ?
<15> why the double quotes around UID ?
<13> Sneaky_Bastard, already pasted only thing i have
<13> when
<13> i'll paste it with the coluns as well
<11> !m Estes quoting identifiers
<9> Estes: (Database, Table, Index, Column, and Alias Names) : http://dev.mysql.com/doc/mysql/en/Legal_names.html
<15> no
<15> what was the error message?
<15> you said "I got an error", but I don't see what.
<13> damn, stop this documentation stuff, i tryied ALSO with simple quotes
<13> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"ID", "UID") values("", 1)' at line 1
<11> Estes: READ THE PAGE
<11> you don't use double quotes [*], you don't use single quotes, you use BACKTICKS
<15> oops
<11> lol
<15> he's right
<15> field names are quoted with backtick character
<13> yes
<13> i just seen it too
<13> damn i'm too tired
<11> not only that, but the query you're pasting is different than the query that's generating the error message!!
<13> doing something stupid like this
<13> ....
<13> bah
<15> Estes: for best channel support
<13> apologises
<13> :P
<13> i should go to bed
<15> *always* paste exact code and error messages on pastebin
<15> k?
<13> too bad
<15> then link us
<13> yup
<13> just overtryied being overtired
<13> hehe
<13> thanks guys
<13> nite nite
<15> bye bye
<11> jesus
<16> rioter!
<17> will: did you see him?
<18> Hi sirs, When launching 'top' on my server, it shows mysqld is almost always 99%, is this normal? or should I do something? ;)
<15> that doesn't sound right
<15> munzir
<15> what is your network activity like ?
<18> Sneaky_Bastard: status command gives:
<18> Threads: 35 Questions: 4363106 Slow queries: 1321 Opens: 138106 Flush tables: 1 Open tables: 64 Queriesper second avg: 29.757
<18> what test you want me to run?
<19> hey, if one was to setup database replication to a staging server, would writes to the slave get overwritten?
<18> Sneaky_Bastard: ??
<20> how can I do a "SELECT * FROM * WHERE `msg`='sup';"
Return to
#mysql
or
Go to some related
logs:
printer detector
03909 0390239 19092 19092 949182 929812 9388310 109921093 9019994 1999301993 099
samba cups ml-2010
net.ipv4.netfilter.ip_conntrack_tcp_timeout_established
scanftime
Desktop1 xorg
surf _mindspin
#math
pemission denied debian
lego rip-off
|
|