| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> you probably want to do SELECT DISTINCT field1, field2, field3 FROM test;
<1> ERROR 1005 (HY000): Can't create table './mypodcast/table1.frm' (errno: 150)
<1> now I got that error
<0> paste create table
<2> imagine you have a table with coordinates x,y,z and you want every point in space shown only once... it doesnt matter how many objects are in that spot. if theres one object in that table on x,y and z coordinate then show it if there are 10 on that spot also show only one row
<3> !perror 150
<4> MySQL error: 150 = Foreign key constraint is incorrectly formed
<0> schmirgo: select distinct x,y,z from ...;
<1> ah. .I found out why
<2> i'll try again...
<0> schmirgo: you can also get fancy with group by and having (see the docs for those)
<2> doh... i put brackets around it like distinct(x,y,z)... i left the brackets out and its working... :)
<2> thansk a lot ;)
<2> thanks even ^^
<0> np
<0> if you really like brackets (parentheses) you can do "select distinct(x),(y),(z)"
<0> but i digress :>
<5> hello, can I distribute mysql with apache 2.0 and php 5.0 all together under gpl ?
<0> blz554: go to their websites and figure out what the licenses are.
<6> anyone have any exprecence with mysql query browser?
<2> ^^
<0> e.g. http://en.wikipedia.org/wiki/MySQL#Licensing
<1> cool.. now it works.
<1> FOREIGN KEY (ref) REFERENCES ref(ref) ON UPDATE CASCADE ON DELETE RESTRICT <-- works
<7> blz554, you cannot re-license apache/php, but you can license the bundle as GPL and make sure to state the other licenses of the items inside it
<5> yup
<1> ref INT REFERENCES ref(ref) ON UPDATE CASCADE ON DELETE RESTRICT <-- dosnt work
<5> thats what i mean davy
<1> seems like I have to spesify foreign key.. even that the standar says that you can add references... directly on one datatype.
<0> welcome to the world of "standards"
<1> goodamn.. this is annoying.
<1> in postgresql both versions works perfect.
<1> strange mysql didnt give some syntax error
<8> Help! Having problems with myODBC on Redhat AS 3 and desperately need help! Is there a better IRC room for ODBC configuration questions than this?
<1> http://pastebin.com/642369 <-- check it out
<1> whats the reason its like that?
<1> maybe its a bug in mysql?
<0> Snadder: probably because its not a key in the second example. ;)
<1> whats the point in having a referance thingie.. without a key?..
<0> apparently none
<0> design oversight? yes. bug? not sure...
<1> when you spesify a reference directly on a datatype.. you cant say its a key
<9> Hi guys, what do I have to do to be able to store Korean + English characters in mysql
<9> ?
<0> specify a CHARSET during CREATE TABLE? i am not sure
<3> babo: and use SET NAMES some_charset; as your first statement upon connection. there doesn't appear to be a standard encoding for Hangul, so you'll probably want to use utf8 there and in your table spec.
<9> infi: so I have to open a connection specifically for hangul characters ?
<3> well, encoding is connection-specific, usually defaulting to latin1; just run SET NAMES utf8; as your first statement, and you can use it like normal from there.
<3> when you disconnect and reconnect, it will resume the default character set, so you will have to reset it each time you connect.
<10> philverb_w, hi
<11> ooooooooooooooh
<11> That would awesome!!!!
<11> Call it ORACLE
<12> 1 disk per db
<11> Or call it 'fs'
<13> and you could store all the actual columns as filesystem metadata
<13> the files could be zero-byte files
<14> I double dare you to actually do it
<11> Ooooh, a double dar...
<11> Ooooh, a double dare...
<12> indexing would make it a lot easier to retrieve all that pr0n
<15> Hi, Im using MySQL 4.0. How can I select all rows in table A which Id isn't in table B ?
<11> I swear I have a factoid that has an example..
<11> SELECT a.id FROM a LEFT JOIN b ON a.id = b.aid WHERE b.aid IS NULL
<15> will: is that for me ?
<11> It's for everyone!!!!
<11> We share knowledge in this channel.
<15> will: hehe .. ok but that would solve my problem?
<11> I have no idea what your problem is.
<11> Do you have a problem with me?
<14> (yes) :P
<11> Eh, who doesn't.
<14> I sure do <3
<11> I love working from home.
<11> I'm still in my PJs... :)
<14> h8
<11> You hate?
<11> Don't be h8er
<15> will: thanks :D
<11> For what?
<11> Does anyone know how to edit our wiki?
<11> Oh I guess I can't...
<16> I can't work from home, I'd never get anything done
<16> I'm too easily distracted
<16> oh look, shiney...
<13> will: depends on what part
<13> I think only Therion can edit the main page
<11> The main page :)
<17> Hello, I've got a problem (well, lack of knowledge on my part). I want to include entries where COUNT(*) = 0 in this query: http://hashmysql.org/1663 - not sure how to accomplish it. I've been reading the MySQL 5.0 manual, but have not come across a solution yet
<3> will, will you will your will to me?
<11> Someone will have to remind me that I put a note about how to do a "all in a that is not in b" query in my section of the wiki.
<11> infi, will do
<3> lol
<3> touche'
<18> Hello, how can I create a query with subqueries to insert in a table data from another table? Something like INSERT INTO table1 VALUES('table2.field1','table2.field2','table2.field3') for each row...
<11> !m fromvega insert select
<4> fromvega: (INSERT ... SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
<13> use a JOIN in your INSERT ... SELECT and you're golden
<11> dgsss, Not sure if you want species in your HAVING. THat might be better as a WHERE. But you will want HAVING number_of_birds = 0 in your HAVING.
<17> will: thanks, lemme toy with that
<11> While you toy with that, I'll toy with infi
<11> dgsss, OOOOOOOOOOOOOOOOOOOOOOOH
<19> hello, quick query question
<19> does NULL equal NULL, normally?
<11> Don't group by species
<13> no
<3> will: toy with me not, my wife will complain.
<19> i would like it to, is there any easy way for it to
<13> NULL IS NULL
<13> but not NULL == NULL
<19> okay cause i want to go select id_field from table, other_table where table.field = other_table.field
<19> (simplfied)
<19> and i want that to match when they're both null, too
<18> tks
<11> dgsss, Do you have an owners table?
<17> will: SELECT owner, COUNT(*) AS number_of_birds FROM pet WHERE species='bird' GROUP BY owner HAVING number_of_birds >= 0; produced the same results
<11> Yeah I read it wrong.
<11> dgsss, Do you have an owners table?
<17> will: unfortunately, no, this is an unnormalized table from an ***ignment. want me to post the structure?
<11> haha
<11> We don't do homework!
<17> i do :-P
<11> Do it yourself :P
<19> am i going to have to modify my query to have every single match be (where table.field = other_table.field or table.field is null and other_table.field is null) ?
<11> If you can't do that, you should retake the cl*** and pay attention to self joining.
<19> because that's going to be ridiculous and there are too many queries for me to edit to do that
<20> anyone know what would cause such a fluctuation of query runtime? (users_tmp has 100000 rows) http://pastebin.com/642459 ?
<13> polvi: busy system
<13> contention for resources
<20> Darien: it is not doing anything else
<11> dgsss, If I give you this, you better tell me if it works.... SELECT owners.owner, COUNT(pets.owner) AS number_of_birds FROM pet AS owners LEFT JOIN pet AS pets ON owners.owner = pets.owner AND pets.species = 'bird' GROUP BY owners.owner;
<21> polvi, query caching can also affect it
<11> shabbs, Stop distracting me...
<19> Darien, if i use <=> instead of =, will it do what i want
<13> mike_sol: no
<13> hmm
<13> !man is not
<4> (Comparison Functions and Operators) : http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
<17> there is no owners table, as stated earlier
<13> ah, it will
<13> my bad
<19> really?
<19> **** yeah
<13> yes
<11> dgsss, Try my query.
<19> imna give it a go and see
Return to
#mysql
or
Go to some related
logs:
#css
gentoo syntax error near unexpected token dhcp
speaking duestch
#centos
wpa_gui livecd
fglx debian
portage rsync error Unknown module
irc from console
#css
PHP 4.4.2 Cannot find rfc822.h
|
|