| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> dunno
<1> heh
<0> because it shows up while its not supposed to?
<2> jengelh: because if you don't max INT out, you don't need to worry about reusing IDs. This is rather silly.
<3> TomH-, You would determine which one of th eGrant options you need to revoke by reading the grant and revoke page
<3> !m TomH- GRANT and REVOKE Syntax
<4> TomH-: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<0> i browsed those
<0> but with show grants for user i did not see any privileges
<5> dont browse READ
<0> ok i did READ them
<1> archivist: lol
<3> TomH-, and if you grant all for a user you think it will specify exactly what your looking for
<0> what do you mean
<5> hehe all is not all
<0> i only want the user to see his database when he logs in
<0> but he sees information_schema aswell
<0> oh wait im probably retarded
<0> http://www2.tw.freebsd.org/MySQL/doc/refman/5.0/en/information-schema.html ;/
<3> you have an extra chromozone?
<0> no
<1> one less ?
<0> i have no clue
<0> is that schema new in mysql 5?
<1> yes
<0> cause i cant remember having access to that in mysql 4
<0> i see
<0> thats why i was confused probably
<6> I keep getting a weird error about mysql syntax.. but the syntax is correct. the error always mentions some unicode character that doesn't exist in the query..
<6> shall i post an example?
<7> alphablue: This form is not allowed: UPDATE xint x1 SET x1.uint=(select uint+20 from xint where id=10) WHERE x1.id=10;
<1> xgc: thats what i was doing
<8> hi, does mysql has a size limit on tables?
<1> thanks for looking so much into it :)
<7> alphablue: No problem. Just use the multitable form.
<6> can anyone help?
<8> i have a table what is 600MB but today i start to notice that when inserting data in to it, it only stores some values not all of them
<8> the table has a id fiel, from field (varchar 10) and date
<5> probably have a field definition error
<8> the id and the date are stored but the from (varchar10) is not been displayed the strange thing is that when doing a search the field apears but in black
<8> for example if i do a select * from table where `from`=123456 i got the fields but since today the from fields are in blank but they apear in the search quey
<8> any idea on howt to fix this problem? i have allready do an extended repair to the table
<8> but I still having the problem
<9> Question: how can i enable access to mysql server from my lan? I niticed the bind-address in the my.cfg but i can't replace localhost with a subnet nor multiple ips!
<10> hi ppl
<10> is this command rong " usern int(2) DEFAULT '0' NOT NULL auto_increment, "
<5> nbari make sure the app can display the larger sizes
<10> ERROR 1067 (42000): Invalid default value for 'usern'
<6> extrem.. you can't use default with auto_increment
<7> Extreminador: It's not a string.
<8> archivist: the app has been working fine
<5> "been"
<5> but not now
<10> Tadipar ahh ok thanks
<11> )
<8> let me do the query from the shell
<6> 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 ' 'no' as banned, t.owner, t.added, p.peer_id, t.leechers, t.seeders, t.times_co' at line 1] while executing: select left(t.name,30) as torrentname, t.waitime, t.id, 'no' as banned, t.owner, t.added, p.peer_id, t.leechers, t.seeders, t.times_completed, p.ip, p.port
<6> from torrents t, peers p where t.iD = p.torrent and t.info_hash = 'e262b344fb25cdfb9157122de94dafd4b39b7e95' order by RAND() limit 50
Return to
#mysql
or
Go to some related
logs:
#oe
#centos
NO_PUBKEY EA8E8B2116BA136C
#kernel
#web
hzhsun
damn small linux dual display setup
#lisp
azureus messing up wireless ubuntu
courier-auth rpm
|
|