IRC Logs

Network: freenode Channel: #mysql

	Enter your search terms Submit search form
	Web www.irclog.org

[09:21]<crdfnn>oh, you want to select to get the fields that are in the table?
[09:21]<lzysd>yes
[09:21]<crdfnn>kaylee> select field from table
[09:21]<mnnf2f>select field1, field2 from table;
[09:21]<lzysd>one second
[09:22]<mnnf2f>to see what a table looks like: desc table;
[09:22]<mnnf2f>anything more than that and you're going to have to endure some additional abuse ;p
[09:22]<lzysd>mysql> select field from corepages;
[09:22]<lzysd>ERROR 1054 (42S22): Unknown column 'field' in 'field list'
[09:22]<lzysd>good because its wrong.
[09:22]<[zzygmcz]>'SHOW CREATE TABLE <tbl_name>' is better
[09:22]<lzysd>and im not really listening to the abuse anyway
[09:23]<mnnf2f>you're not listening to the advice either
[09:23]<crdfnn>prism: do you even know what fields your table has?
[09:23]<lzysd>kaylee, thats what I bloody want!
[09:23]<lzysd>the names of the fields
[09:23]<mnnf2f>because multiple people have told you how to view the fields in a table, so you can replace the obvious example field names with the real ones
[09:23]<lzysd>the entries in field list
[09:23]<crdfnn>prism: than why didn't you say that?
[09:23]<lzysd>I did
[09:23]<lzysd>3 times
[09:23]<crdfnn>prism: no, you said you wanted one field instead of all of them.
[09:24]<crdfnn>that's not the same
[09:24]<lzysd><prism> see normal select
[09:24]<lzysd><prism> but I dont want that I want `field`;
[09:24]<lzysd><prism> the litral name of `field`
[09:24]<crdfnn>prism: what are you using with mysql? php, java? something else?
[09:24]<lzysd>oh im asking for someone else, if it was me DBI/perl
[09:25]<mnnf2f>hey, i buy it
[09:25]<crdfnn>I know that with PHP and Java you can get the field names, types, etc from the results... I immagine DBI/perl has something similar
[09:26]<mnnf2f>< [RainMkr]> 'SHOW CREATE TABLE <tbl_name>' is better
[09:26]<lzysd>kaylee, what is the query, desribe <table> and just parse the output or is their something nicer
[09:27]<crdfnn>depending on what you're doing with it... I immagine RainMkr and deepbl have better examples
[09:27]<lzysd>deepbl, I imagine hte table is already created
[09:28]<lzysd>Infact I imagine it was created a long time ag
[09:28]<lzysd>o
[09:28]<crdfnn>prism: good grief... stop wasting our time and go read the docs for 5 min
[09:28]<lzysd>kaylee, to early in the morning for that, work time.
[09:28]<mnnf2f>right. that will show you the SQL containing all the field names, etc.
[09:29]<vydrfjv>hi, anyone running mysql-query-browser on ubuntu dapper?
[09:29]<crdfnn>prism: well, it's far to late at night/early in the morning to deal with someone that can't ask a concise question, and is unwilling to read the pretty docs
[09:29]<crdfnn>timalot: nope, sorry
[09:30]<vydrfjv>well i am getting an error when i try to click on the sql syntax list to open up the info
[09:31]<crdfnn>prism: you're quick to criticize deepbl, but have you even tried running that query?
[09:31]<lzysd>yah its sat here in my xterm
[09:31]<crdfnn>timalot: what kind of error
[09:31]<vydrfjv>double free or corruption (out): 0x08a72628 .... looks like a null pointer being freed
[09:32]<crdfnn>timalot: not a clue... have you also tried #ubuntu?
[09:32]<lzysd>I just didnt get time to say 'whoops sorry its the same as 'descrbe <table>' before you started blurbing on and I need to start breakfast
[09:32]<crdfnn>blah blah
[09:33]<rlgdrgq0q0>hi!@
[09:33]<rlgdrgq0q0>can anyone tell me how to reset the mysql password?
[09:34]<crdfnn>apeman2020: do you have root or admin access?
[09:34]<crdfnn>apeman2020: actuall...have you lost your password? or do you just want to change it?
[09:35]<crdfnn>apeman2020: http://dev.mysql.com/doc/refman/5.1/en/set-password.html
[09:35]<rlgdrgq0q0>kaylee
[09:35]<rlgdrgq0q0>well i am at an impass
[09:36]<rlgdrgq0q0>mysql -u root
[09:36]<rlgdrgq0q0>returns denied
[09:36]<rlgdrgq0q0>>>>
[09:36]<mnnf2f>prism: the output of those two commands are not identical. maybe your buddy isn't exactly "playing with a full deck", if you get my drift.. check if his computer is even plugged in
[09:37]<rlgdrgq0q0>lets see if that works!@
[09:37]<rlgdrgq0q0>thanks kaylee
[09:37]<crdfnn>np
[09:37]<rlgdrgq0q0>kaylee_ how do i know what version I am running?
[09:37]<rlgdrgq0q0>dpkg -L myswl?
[09:37]<crdfnn>something like mysql -version iirc
[09:37]<rlgdrgq0q0>mysql?
[09:38]<mnnf2f>mysql --version
[09:38]<crdfnn>mysql's version option would be more reliable... it will tell you what version you have in your path
[09:38]<rlgdrgq0q0>the damn thing wont ever start kaylee..
[09:39]<crdfnn>apeman2020: what os? and do you have OS root access?
[09:39]<rlgdrgq0q0>sure root, no sweat.. ubuntu running gnome
[09:39]<crdfnn>apeman2020: is this a new mysql install? or did you lose the pwd?
[09:39]<rlgdrgq0q0>new
[09:39]<crdfnn>please don't PM me
[09:39]<rlgdrgq0q0>couldnt even set the password
[09:40]<crdfnn>ok, your best bet is to follow the install docs
[09:40]<rlgdrgq0q0>wanted to take it off the channel, but however you would prefer
[09:40]<rlgdrgq0q0>i did.
[09:40]<rlgdrgq0q0>kept returning errors
[09:40]<rlgdrgq0q0>now the mysqld wont start
[09:40]<crdfnn>apeman2020: I'm sure there's plenty of people in here that have gone through an install more recently than I have, and may remember details better than I do
[09:40]<crdfnn>what install docs were you using?
[09:41]<rlgdrgq0q0>https://help.ubuntu.com/community/ApacheMySQLPHP
[09:42]<rlgdrgq0q0>k i fixed the starting issue
[09:42]<crdfnn>apeman2020: you may want to compare those to http://dev.mysql.com/doc/refman/5.1/en/installing.html
[09:42]<mnnf2f>there's a couple must-have fundamentals to be learned while going through the install. if you weren't successful, I would recommend uninstalling and doing it over. you will be better off learning that stuff for later on down the road.
[09:42]<rlgdrgq0q0>how can i ask the mysql install the version?
[09:42]<rlgdrgq0q0>roger
[09:42]<rlgdrgq0q0>thanks guys
[09:42]<rlgdrgq0q0>ill go through it again
[09:42]<rlgdrgq0q0>apt-get remove mysql?
[09:42]<crdfnn>mysql --version
[09:43]<rlgdrgq0q0>ver 14.12 dist. 5.0.22
[09:43]<mnnf2f>apeman2020: I don't know.. I'm a gentoo user. don't use the debian pkg mgmt
[09:43]<rlgdrgq0q0>roger
[09:43]<mnnf2f>sounds close
[09:43]<mnnf2f>though
[09:44]<crdfnn>*ugh* my most recent install was on XP

Back to #mysql
Or go to some related logs:
#suse
#gentoo
#debian
#gentoo
#gentoo