#mysql
24 October 2007
Total 29 pages. You are browsing page 5/29.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
02:19 <****> do i now connected ?
02:19 <****> what should do now ?
02:20 <****> is there any apt-get way to install mysql-gui-tools?
02:20 <****> apt-cache search mysql |grep gui
02:21 <****> i typed mysql : mysql_install_db
02:21 <****> any repositoryguile-simplesql - SQL library for Guile
02:21 <****> jackofalltrades: mysql-admin - GUI tool for intuitive MySQL administration is that what u want?
02:21 <****>
02:21 <****> what do i have to put ?
02:21 <****> xochilpili: mysql commands?
02:21 <****> :X
02:21 <****> ?
02:21 <****> GuHHH: Yes
02:22 <****> fuck
02:22 <****> i want a GUI for creating tables etc...
02:22 <****> so fucking thanks !!
02:22 <****> jackofalltrades: mysql-navigator - GUI client program for MySQL database server ---------- and ------------- mysql-query-browser - Official GUI tool to query MySQL database
02:23 <****>" after you hit Enter, it thinks you haven't properly finished the line. This may be due to unclosed quotation marks, for instance.
02:23 <****> GuHHH: are there any more?
02:23 <****> jackofalltrades: apt-cache search gui |grep mysql
02:24 <****> GuHHH: :) thanx
02:24 <****> Simetrical : oh. thanks !
02:24 <****> i DID it !
02:25 <****> and how can I restart mysqld?
02:25 <****> why with phpMyAdmin cant connect ? and mysql administrator can connect ?
02:26 <****> mysqld restart ?
02:26 <****> really?! Sorry, i should try before asking
02:27 <****> in phpMyAdmins says : Acces denied for user root@localhost (using password: no)
02:27 <****> and mysql admin i have put my password ?
02:28 <****> 071024 2:31:02 [ERROR] chroot: No such file or directory #071024 2:31:02 [ERROR] Aborting #Segmentation fault (core dumped)
02:32 <****> i got the administrator and the query browser. Cool!
02:32 <****> Simetrical: why cant connect via phpmyAdmin ? and via mysqlAdmin i can
02:32 <****> ?
02:32 <****> xochilpili, presumably phpMyAdmin is not configured correctly. I don't use it, I use a command line, so I don't know much about it.
02:32 <****> is there any gnome epplet or kind of it that shows you the mysql server status on startup
02:32 <****> ?
02:38 <****> mysql-navigator is... how could i say... deprecated? I guess that the query browser is much better
02:39 <****> will this work ?
02:39 <****> WHERE !DATE_SUB(CURDATE(),INTERVAL 3 MONTH) <= date_col;
02:46 <****> try in the query-browser to see if it works
02:46 <****> nope doesnt :) or I wouldnt be here
02:47 <****> I need to select from the table where date < now() - 3 months
02:48 <****> !man interval
02:48 <****> (Comparison Functions and Operators) : http://dev.mysql.com/doc/mysql/en/comparison-operators.html
02:48 <****> go look up interval
02:50 <****> i would get the currentdate - 3 month in php, and use a variable in the sql using 'selcect etc'. $date3month.' <= date_col';
02:57 <****> In that case you might want SQL_NO_CACHE.
02:57 <****> Unless you think you'll be getting a storm of requests in one second.
03:04 <****> how do you assign selects to intermediate results in a query?
03:04 <****> What do you mean?
03:05 <****> I have two selects that I would like to assign to variables and then later join them together
03:06 <****> hmm there are no multi dimensional variables in mysql
03:06 <****> you can use a temporary table
03:06 <****> hrm
03:06 <****> create temporary table result1 SELECT [..]
03:06 <****> and later join the temporary table to another or stuff like that
03:06 <****> let me give it another shot, I might be able to do it with just table aliasing
03:07 <****> you can of course join a statement to a subselect
03:07 <****> in mysql 5 at least
03:07 <****> nils_: JOIN (Subselect) ON ()?
03:08 <****> yeah for example SELECT bla FROM table1 JOIN (select blub from table2) AS s1 ON s1.blub = table1.bla;
03:08 <****> I think I can do it with that
03:08 <****> this example is useless but you can also join to a more complex subselect with group by and stuff (most times that's the only sensible reason to use a subselect in the first place)
03:11 <****> anything wrong with a query like - SELECT msg FROM corkboard WHERE userID = $user OR (userID = $user AND user2ID = $profile)
03:12 <****> Assuming $user and $profile evaluate to strings, including string delimiters, no, although the logic is a bit odd.
03:12 <****> deMorgan's Laws, yo. The condition is equivalent to just userID = $user.
03:12 <****> Simetrical++
03:12 <****> Er, not deMorgan's. Distributive law, here.
03:12 <****> Simetrical++
03:13 <****> for knowing 2 laws I've never heard of ;)
03:13 <****> (that's why I spent so much time in jail)
03:13 <****> Hmm, distributing doesn't seem to work either.
03:13 <****> But obviously the right-hand side of the OR implies the left-hand side.
03:14 <****> So it's redundant.
03:14 <****> user2ID sounds strange
03:14 <****> smells like broken design ;)
03:16 * Simetrical can't see how to formally simplify A || (A && B), dammit
03:16 <****> Oh, oh, of course, factoring.
03:16 <****> whoo! thanks guys. I wound up having a SELECT somecols FROM table JOIN (subquery with a count() on a certain column) with another count and group by in the outer query.
03:17 <****> confusing, but I think it works
03:17 <****> No. Blah.
03:17 <****> can I recurse mysql ? select from foo where not in (select from bar where id < 1000) ?
03:17 <****> Billium, subqueries work, yes.
03:17 <****> not in a sql operator ?
03:17 <****> Yes.
03:18 <****> hmm sql error is why I asked
03:18 <****> Billium, print the exact query you tried to execute, and the error message.
03:18 <****> Billium: your query makes no sense to me
03:18 <****> Billium: but I guess that's an example
03:18 <****> Billium: in which you forgot the left side to the IN operator, of course.
03:19 <****> #1241 - Operand should contain 1 column(s)
03:19 <****> I assumed you were leaving irrelevant stuff like the field names from your example query.
03:19 <****> Billium, and the exact query?
03:19 <****> Billium, oh, I know. Your subquery needs to return one column.
03:19 <****> Billium, it returns multiple ones, so you're trying to check whether a scalar is in a list of tuples.
03:19 <****> SELECT customer_id, lastcheck FROM check_customer WHERE customer_id NOT IN (SELECT customer_id, lastcheck FROM check_customer WHERE DATE_SUB( CURDATE( ) , INTERVAL 1 YEAR ) <= lastcheck )
03:19 * Simetrical feels computer science-y tonight
03:20 <****> Billium, remove ", lastcheck" from the subquery.
03:21 <****> Simetrical: it's interesting how computer science explains simple things in a complicated matter ;)
03:23 <****> nils_, no, the more interesting part is how computer science explains complicated things in a complicated but extremely useful manner. (Although I'm being serious here, which misses the point.)
Total 29 pages. You are browsing page 5/29.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last