| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> snoyes, aja
<0> here it is the full sentence:
<0> CREATE TABLE menuoptionlang (
<0> id TINYINT(2) NOT NULL,
<0> lang TINYINT(2) NOT NULL,
<0> name VARCHAR(50) NOT NULL,
<0> slug VARCHAR(10) NOT NULL,
<0> CONSTRAINT pk_menuoption_lang PRIMARY KEY (id, lang),
<0> CONSTRAINT fk_menuoption_lang FOREIGN KEY (lang) REFERENCES lang(id)
<0> ) ENGINE=InnoDB
<1> pastebin!
<2> ahhhh pastebin
<3> pastebiiiiiiiiiiiiiiiiiiin!!!
<3> wheee
<0> sorry, i don't understant. it's a joke related to trashbin? :?
<1> go to hashmysql.org/pastebin
<1> sorry, hashmysql.org/paste
<1> if you have more than about 3 lines of code to show, post it there and paste the link back here
<0> snoyes, ok, thanks
<0> here it is: http://hashmysql.org/paste/viewentry.php?id=1840
<1> also pastebin the create table for `lang`
<0> snoyes, ok
<4> is there anyway to export all my commands that I have done inside the mysql shell into a file?
<0> create table lang: http://hashmysql.org/paste/viewentry.php?id=1841
<5> Hello masters, I'm use Ubuntu Dapper and problem with mysql: mysql query failed: FUNCTION provider.CONCAT does not exist
<1> Azuos001: next time, use tee. see help in the shell for details.
<5> SQL: CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
<5> What is the problem?
<6> I'm echoing out a MySQL table via while ($row = mysql_fetch_array($result)) into an HTML table, and I want to know how I could output an incrementing number (1, 2, 3, etc.) for each table row within the first <td> of every <tr>. Any suggestions?
<5> Pliss help...
<1> txopi: what version are you using?
<1> Snoru: That's a question for ##php
<1> caravena: please show the whole query. Use http://www.hashmysql.org/paste if it is long.
<6> OK
<4> snoyes: would tee work inside mysql?
<1> Inside the mysql CLI? Yes.
<5> snoyes: mmm, not whole query. I'm new user and config server of mail with courier, postfix and mysql
<0> snoyes, it could be 4.0.24_Debian-10ubuntu2.3-log ?
<1> txopi: Hm. I dropped your two statements into 5.0.15, and they created no problems.
<0> mmh
<0> the last mysql version is 5.1 as far as i know
<0> perhaps i should upgrade...
<5> help my pliss.
<5> I'm understand the problem
<7> that's a lot of version numbers that aren't mysql's after 4.0.24
<7> wow
<0> gleam-, he he, for completeness :)
<8> #php needs a wiki (don't ask why, I just like wiki's)
<9> snoyes: without the added c1.line=c2.line...the query seems to stall...without returning anything, OR erroring out. Something must be wrong. WITH the added condition, it returns a lot of records (waiting to see how many...but WAY too many), and they are in order by c_id again :(
<10> SELECT * FROM t1 WHERE t_id IN (SELECT t_id FROM t2 WHERE lft>=( SELECT lft FROM t3 WHERE id=3 ) AND rgt<=( SELECT rgt FROM t3 WHERE id=3 ) ) // how can i avoid doing 2 calls to get the lft and rgt values from t3 ?
<8> sorry wrong channel....hehe....#mysql wiki is nice though
<2> does anyone know the IRC channel for visual basic?
<5> concat is funtion of mysql 5.x?
<7> it's in 5.x, it's also in 3.23.x
<7> and versions in between
<7> and presumably before
<1> with that error, I'd guess there's something like a tableName.concat going on
<10> ahh found it SELECT * FROM t1 WHERE (1,2) = (SELECT column1, column2 FROM t2);
<10> hmm
<10> thats not gona work ahh
<11> any recommendations for a tool that will generate ER diagrams from a schema/ddl ?
<10> so no one sees a way i can avoid doing two queries
<12> whis is a unsigned decimal(3,2) only allowing 9.99 when a signed decimal(3,2) allows 99.99 ?
<13> any amazing difference if i use a char of length 48 vs. 50 ?
<12> wouldnt unsigned be theo ne that might be larger since it doesnt have to reserve space for the positive/negative status?
<0> snoyes, thank you for executing that creates on a mysql 5.0.15
<0> snoyes, i checked the syntax on mysql 3.23, 4.0 and 4.1 and it's the same
<0> snoyes, ok, i'll investigate, thank you
<12> albo: if its varchar() not much. but if its char() then its just a fewm ore bytes of storage per tuple
<1> txopi: I did remove the -- style comments before I ran it on mine. Try that; maybe something there is malformed.
<12> varchar only uses as much pace as is needed per tuple
<13> kib: what did u use this knowledge for
<12> albo: I don tunderstnad what you mean
<13> why do u know this very specific fact
<12> its not a very specific fact
<12> its common knowledge of how fields work
<12> you make it sound like this is the only fact I know
<0> snoyes, i get the same error without comments
<13> kib: if it was, then it would be an amazing coincidence that i found you
<12> albo: anyone else could have given this answer
<12> although I was hesitate to answer thinking maybe the question couldnt be that easy and maybe you just expressed the question wrong
<13> kib: is there a way i can run mysql_escape_string from SQL ?
<12> anyhow there is no real difference between varchar48 or 50...other then the max legnth allowed..they will still take up the least amount of space possible. but between char 48 and 50 you get 2 extra bytes per tuple whether you use them or not
<7> no, escape the strings before you send them.
<12> albo: not sure I understand but if youw ant to escape something use \
<13> im curious
<12> php and other languages have built in functions to do this for you as needed
<12> I dont know much about php but addslashes() and stripslashes() I think are close to what you use there
<7> mysql_real_escape_string
<7> in php
<12> you should consult your language reference manual for the language you want to work on though
<14> how do you restore the privilege table to default? Mine is all messed up
<12> my php knowledge goes back to php3 I dont know much of the new stuff
<12> cybertrickle: unable to login as root?
<14> I can, but my root user doesnt have grant privs
<13> gleam-: how does mysql_real_escape_string differ from mysql_escape_string
<12> cybertrickle: can it edit the mysql.user table?
<9> is there a way to put the output of a query into a text file from the CLI? (like the linux yourcommand > file)
<12> yes
<12> use > file
<7> This function is identical to mysql_real_escape_string() except that mysql_real_escape_string() takes a connection handler and escapes the string according to the current character set. mysql_escape_string() does not take a connection argument and does not respect the current charset setting.
<14> Kib: Ill try that
<12> well if your in the shell...if your in the mysql command prompt I don tknow then
<13> gleam-: what does it use the connection for
<12> but Issue all my commands directly from my shell without logging in
<7> the changelog says not to use mysql_escape_string after 4.3.0-
<7> it says right there what it uses the connection for
<13> gleam-: oh i see, the charset of mysql
<12> cybertrickle: if youc an edit the mysql.user table then just fix the root permissions..and flush privs
<14> Kib: Seems to have worked!
<12> if youc ant flush then restart mysql will get the same effect..once its back you should have a working root again..if that doesnt work let me know I have more drastic measures you could try but it will probably involve losing all current logins
<12> cybertrickle: try not to mess up root...its not good if you do that
<12> root should have global permissions in the user table all set to Y
<9> kib: once I'm IN mysql (mysql -uSomething -p), that doesn't seem to work (select * from something; > file)
<12> and not be granted anything specific on any db or tabble or anything else
<12> AaronCampbell: well your logins in
<12> you need to send the query on the command line
<12> then its output will go to the file
<9> kib: That's what I couldn't figure out how to do...
<9> I was looking for a -Qquery type option...
<7> -e "query"
<12> because its the shell thats doing the > redirect not the mysql cli
<15> update test set dob = NOW() where person = 'test'; why doesnt NOW() work?
<9> thanks gleam-
<7> what column type is dob?
<12> but you will also have to include the p***word in the command itself since when its prompted for you wont see it because ihat outpput is being redirected too
<15> date
<7> do you get an error?
<9> I missed that because I did "mysql --help | grep query" and query isn't in the description
<15> no
<7> !tell us about doesn't work
<7> wait
<7> no bot
<12> AaronCampbell: and dont forget to include the db name int he command as well
<7> GODDAMMIT
<7> what do you mean by "doesn't work", tamp4x?
<15> it matches the where query but does not do the change
<7> do you get any warnings?
<15> no
<7> where are you running the query?
<15> client
<7> script? command line?
<15> command line
<7> when you select dob from test where person='test' you get rows back?
<15> no
<15> Query OK, 0 rows affected (0.00 sec)
<15> Rows matched: 1 Changed: 0 Warnings: 0
<12> <12> whis is a unsigned decimal(3,2) only allowing 9.99 when a signed decimal(3,2) allows 99.99 ?
<12> <12> wouldnt unsigned be theo ne that might be larger not having to worry about +/-
<12> oops
<12> didnt mean to paste that here
Return to
#mysql
or
Go to some related
logs:
could not convert undefined or null to object xmlhttprequest
#suse
elly k
kvcd in linux
large anus
#lgp
#linux
Multimonitors SDL
pyshaper ubuntu
how to untar .dfsg linux
|
|