| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> zeitoun, what time was it for you? midnight here
<1> its 5:54 pm
<0> 8:54 here
<0> Must be Friday there too
<1> nope, still thursday :)
<0> doh, PM, why did i read AM
<0> mmm, +8 hours, some place near the atlantic ocean?
<1> Eggplant: well closer to the Mediterranean sea actually :)
<1> http://www1.mappy.com/mappymoi/map?data_id=90DD253F-738E-43BA-906F-99CCC9B0B6BB&hint=2636
<0> mmm, ya i guess its 6 for atlantic, I shouldnt try and think before lunch, it doenst work
<1> well anyway... glad you solved your problem :)
<0> never heard of that site before, wonder if it has the usa, ifso, another many thanks
<2> how do i relate tables in phpmyadmin?
<2> what good is mysql if foreign key constraints aren't even available? how is it a relational DBMS?
<3> mogbit they are use innodb tables
<2> mehhhh innodb isnt supported in phpmyadmin
<4> Is there any reason why mysqldump would not dump all the rows in a table, and seem to abruptly stop in the middle of the dump? (the last line of the file is abruptly terminated). I am dumping a couple rather large tables (<4 gb though..)
<4> (I am using --opt -Qq as my options)
<5> sql: i have a table with selled items with number and date. is there a way to get a result grouped by month?
<3> mogbit have you set up phpmyadmin correctly
<6> xirjs: select date_format(yourdatefield, '%Y-%m'), group by that field
<7> guys, mysql 5 vs 4 question
<7> right now we have a nice, beefy 4.blah box
<7> some clients need 5.blah
<7> would it be safe to run 4 and 5 on same machine, but on different ports?
<7> thanks!
<8> guys I have a table definition, a query and a strange error message, can someone help me how this can be solved? http://pastebin.com/546913
<3> vasiliyb yes there is documentation on dev.mysql.com
<9> tokyo_away - your FULLTEXT index needs to have all the columns in the match
<9> you have two indexes instead of one
<9> !m sjrussel string functions
<10> sjrussel: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<8> sjrussel: but I have the index on those two collumns where I match against...
<9> no, you have two separate indexes on each column
<9> you need one index with both columns
<8> ah there can be one on both?
<9> yeah
<8> ah I did not know that existed :-)
<8> sjrussel: thanks!
<11> hey guys
<11> i wanted to ask if anyone has seen a commenting system that is done in mysql? I have a photoblog that I would like to allow people to leave comments on my photography.
<12> what's hard about that?
<12> photoID, email, username, comment_text
<11> well
<11> photoid would be linked to the url of the photo?
<12> select email,username,comment_text from comments where photoID = foo;
<11> sorry i am a photographer not a database guy lol
<12> no, there should be a unique ID, and then a photo URL in a PHOTOS table
<3> you may find a ready made application on sourceforge
<12> then in the COMMENTS table, it would have photoID, username, email, comment_text
<11> yea
<11> ok
<11> if i can find one already made that would be great
<12> but archivist is right, too. if you don't want/have the expertise to roll your own, Gallery will likely work fine for your needs.
<11> because i do not know sql
<12> freshmeat.net, search for gallery
<11> well
<12> or just use flickr fer crissake :b
<11> don't want gallery
<11> see my site www.digitaleyesandears.com/testing/One
<13> http://pastebin.com/546918 howcome the mysqld returns this error when i add the FK? the perms in data dir is fine (mysql:mysql) and so is permissions
<11> i want it to fit with my site
<13> is the innodb foreign keys beta still or?
<14> Still?
<14> It was non-beta for... 3-4 years?
<14> Paste the error here.
<13> ah, i got it now
<13> 150 = 150 = Foreign key constraint is incorrectly formed
<13> i forgot an index :P
<15> is there a way of analyzing a sql query?
<16> explain
<17> look at it
<3> !man explain
<10> (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<17> and blink occasionaly while looking at it
<17> else your eye dries out and ya can't see anything
<17> which would be.. end of anaylsis
<18> hi
<18> i got lots of *.bin files in /var/lib/mysql, can i savely delete them or what are they for?
<18> like localhost-bin.000308 and such
<19> ronino: binlogs, if you're not either using them for backups or using replication then you don't need them (and might want to remove 'log-bin' from your my.cnf), you can clean them up with "PURGE MASTER LOGS"
<18> mendel: thank you!
<18> mendel: where do i have to type "PURGE MASTER LOGS"? the command line client yields an error message
<19> Which error message?
<18> 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 '' at line 1
<18> mysql> PURGE MASTER LOGS;
<20> Hi. I'm kinda newbie in sql, and i'm having some trouble. Could someone help me? I have a database with about 30k entries. However I know there are some entries missing, since I have a list of ids (31104 ids) and the table should have 1 line for each id number, and the tables has less than 31104 rows. How can I get a list of which IDs are missing in my mysql table? I've created another table with all the IDs and I tried to do "sel
<20> ect id from ids where id not in (select in from people)", however it takes forever
<18> i'm running 4.1
<20> i mean, (select id from people) in the subquery
<20> ?
<3> dont worry about missing id's
<21> anyone familiar with INSERT... ON DUPLICATE KEY UPDATE
<20> archivist, I think i haven't said it correctly
<20> I have a table which should have 31104 names and some data ***ociated with it, including a number, which is unique to each one (and is not an arbitrary number that I can give at my will)
<20> however the table has less than 31104 names
<21> thats alot of names
<21> maybe you should kill some of them
<20> and I have a list with all the id numbers of all the people
<20> lol
<3> often names are deleted there will be gaps
<20> what I would like to know is what are the id's in this full list that are not in the other list
<3> so max id should not equal no of names
<20> well, do you know a fast way to get a list of which numbers are not in the list but should be there?
<20> i don't think you understood what I want
<20> like
<20> 31104 people and one phone number for each, unique, and all have one and only one
<20> I know all the phone numbers these person should have
<20> (i have a list with all the phone numbers)
<20> however in my list with phone numbers AND names, i have less than 31104 rows
<9> i'm presuming id is an autoincrementID?
<20> and I which to know which phone numbers are not present in the list with the names
<3> so you have a list with gaps
<20> no, it's not
<20> it's not autoincrement
<9> why do you care?
<20> i don't know how you call it in your country (i'm from brazil) but we have a number which is ***ociated to each person
<22> How can I create a subselect that returns one column with two rows, the first containing 1, and the second 2?
<20> I care because I need all the names
<9> so, left join on people where people.id is null
<22> I'm trying to duplicate the rows returned from a join so I can perform an operation on the duplicate and group both sets of results together
<23> hey guys
<23> i'm trying to get mysql working with php under iis. they're all installed.
<23> however, php isn't loading the mysql extension
<24> is there a way to do a "double" link? i.e. i've got a table of names (i.e. 2 columns, `id` and `name`) and then a table of pairs (`id1`, `id2`), how can i look those IDs up and return the 2 names for each row of the second table, in 1 query?
<25> Is there an easy way to export all of the data in a mysql database in such a way that it can be (easily) imported into another mysql database?
<23> i'm attempting to load it in php.ini, specifying the path to c:\php\dlls\libMySql.dll however php is complaining that its not a valid extension
<3> dmar-_-_, have you edited php.ini
<23> yeah
<26> Therx, a join with table aliases
<23> it complains saying that "
<23> PHP Warning: PHP Startup: Invalid library (maybe not a PHP library) 'libmySQL.dll' in Unknown on line 0 "
<27> dmar-_-_: You have to load the extension from the extension directory in your php.ini file... that dll is required by the mysql extension to work, which means it needs to be in your $PATH somewhere.
<23> cool... imma get that path added
<24> ctooley: table aliases/
<24> ?
<20> Therx, select t1.name, t2.name from names t1, names t2, pairs where (t1.id = pairs.id1) AND (t2.id = pairs.id2)
<27> dmar-_-_: You migth check http://php.net/install.windows.extensions for more information.
<24> ah, yeh i see, thx
<28> Hey all. I'm having config troubles and hoping somebody could nudge me in the right direction. The same database replicated from production to staging... on staging my apostrophe's and bullets are showing up as question marks (?)
<28> Same charset on both servers.
<26> select first.name as id1_name, second.name as id2_name from (table1 first join table2 ids on first.id = ids.id1) left join table1 second on second.id = ids.id2;
<2> why would my tables still be myisam after ALTER TABLE X TYPE=INNODB ?
<9> Tvienti - where are they showing up?
<9> it's probably a different charset somewhere else - like in apache
<28> sjrussel: I should've thought of that... let me investigate further =/ Thanks for the pointer
<3> mogbit what is the error message from the alter table
<13> Can anyone recommend some readings on innodb FK?
<28> Yep, easy fix.. thanks again sjrussel
<29> is it bad practice to have 2 tables and then a 3rd table which bridges the 2 tables
Return to
#mysql
or
Go to some related
logs:
#gaim
ubuntu bcm4306 native driver
kfreebsd recompile kernel
ralink 2500 .deb
noegnud ubuntu
undefined symbol XAACreateInfoRec
phpopenchat firefox script busy
python touple
namevirtuahost apache2
#ubuntu
|
|