| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> hmm?
<1> Seadog: unless you forgot to set mysql_isnt_retarded to 1, in which case the server may explode..
<0> I3ooI3oo: hold on a sec... daughter screaming in next room
<1> Seadog: what happens when you run ANALYZE while someone inserts a few rows?
<1> you'd think everything's okay
<1> I'm going to go with, it might take a little longer, but that's about it
<2> yeah hopefully
<1> I'd be more worried about things like what if MySQL crashes when I'm inserting..
<0> I3ooI3oo: yes?
<3> i was hoping for some more help but now i don't thing i need it unlesss yuou know why selinux is stoping mysqld
<3> with it disabled it works :)
<0> I've no experience with selinux, other than reading a few vague articles
<0> sorry
<3> but i did want to thank you for your help yesterday
<3> i am learning slowy
<3> i love the control you get but .. its like learning a new language while being an interpreter..
<3> ie very slow
<4> so just run selinux in larning mode ..
<5> Hello
<5> Is it possible to change the order of columns?
<6> Hi, Can I use named pipes with MySQL Query Browser?
<7> mm-mysql, $(table2.table3_id not like 'X'" (where X is known)) saves you doing a second outer join
<7> though, i would have expected the two OUTER JOINs approach to work
<8> how can I find empty references between tables? i.e. one table has a "info_id" column and then there's an info table, how do i check that all "info_id"s used in the first table appear in the info table?
<9> use an outer join
<8> k thx
<10> I'm doing SELECT SUM(attendance) and the number should be "10,000" but it's only returning "10"
<11> Full query? Most likely data problem.
<12> Hello
<12> Does mysql have a limitation of username lengths?
<12> in version 4.0.24
<13> yes
<13> 16 chars afaik
<12> Is this limitation held in later versions?
<12> Especailly, the 4.1.x and 5.x trees
<13> yes
<12> Is this limitation going to stay or do they install to increase the length to something sufficient?
<12> install=plan
<13> sufficient for what?
<12> I have a fbsd box with cpanel on it. cpanel folk limit the useraccount name length to 8 characters, which seriously limits names
<14> seekwill: if you responded to anything I didn't get it...sorry...had a connection hiccup
<12> they say it causes errors in mysql.
<12> since they keep a username_dbname for dbs
<15> need you : quakenet #i-savoir
<13> wtf?
<13> verdete1: don't advertise you ****
<15> why ?
<16> :)
<17> Is it better to use integer id's in a user authentication design (with tables for users, groups, permissions and many-to-many relationships between them) rather than using e.g. the login-name as the id?
<16> DeCaf: I would use numerical id's
<16> DeCaf: I'd imagine there would be some sort of performance difference between alpha uniquie keys and integer based
<16> DeCaf: Although I'm not an expert :)
<17> Sembiance: Sort of my thoughts, I'll just go for that approach then. Thanks! =)
<18> what is the convention for mysql table names? or innodb table names...?
<19> for purely asthetic reasons, is there a way to change the order of fields in a table as they are stored in the database? Is there a non-engine specific way to do this?
<20> http://pastebin.com/661845
<20> thats its all right?
<20> the variable config is no seted :S
<1> bitwise: yah, there is
<18> how do i tell mysql that a table has an foreign key?
<1> check the table def?
<18> Jivedue -> i'm monting it with DBDesigner, but if i delete a key that is foreign key, the mysql is allowing this, so, in fact there is no foreign key at all =(
<19> jive: elaborate?
<19> jive: I suspect in the end I will just have to end up adding a temp column to the right position with AFTER and then copying data from old, delete old, rename temp etc..
<1> bitwise: well, I remember reading somewhere that you can tell MySQL to change the order of rows on the disk, but I forget how, haha, seriously.
<1> then again, maybe I just read it wrong
<1> bitwise: http://dev.mysql.com/doc/refman/5.0/en/myisamchk-other-options.html
<19> I think this is closer: http://dev.mysql.com/doc/refman/5.0/en/change-column-order.html
<18> there is a code that you tell mysql, that if i drop some register in a table it will be dropped in the another table because if the foreign key?
<19> or without creating a new table: http://www.faqts.com/knowledge_base/view.phtml/aid/2711/fid/101
<21> anyone with experience from using pack_keys in tables ? http://forums.mysql.com/read.php?24,83324,83324#msg-83324
<18> how much letters the TINYTEXT can have?
<18> 255?
<19> This says 255bytes (1 character): http://www.abbeyworkshop.com/howto/lamp/my_fieldtypes/index.html
<19> ie: 1 letter
<1> wth.
<18> well
<18> is quite the same as varchar(255) but its a blob text so =)
<19> apachez: no experience with pack_keys, but way to go on the reducing your query from 800+ secs to 1.5 :)
<22> substr(fts_path,1,instr(fts_path,'/',-1)-1) how to do this one in mysql
<22> looking for instr to find string last occurrence of the character
<16> :)
<22> Is there any function to look for character last occurence in the string?
<19> sureshz: you want to do this within an SQL query or in the program that receives the data from the query?
<22> yes
<22> I am migrating from oracle to mysql
<22> it is in sql select query
<21> _bitwise_: thanks :)
<23> Hello
<23> can anyone tell me the syntax to remove tables from mysql
<23> anyone there?????
<24> drop table tablename; //removes whole table
<19> sureshz: here's a list of string functions for mysql http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
<23> any way to remove complete database as well?
<19> vj: DROP DATABASE db_name;
<19> sureshz: looks like the Instr and substr functions probably have the same syntax as oracle
<19> *probably* ;)
<25> yes
<22> _bitwise_: thanks
<12> Is it possible, to make db for a specific user under any specific folder specified in /etc/my.cnf?
<12> and have all the global settings apply to the rest.
<26> 'morning
<12> 'Morning
<27> Haris1: may be it is - i would personally use symblinks, I guess.
<12> That's the obvious default choice.
<26> Wow, I actually contributed this morning.
<28> how do you rename a field in mysql?
<28> in the query ;)
<9> select col1 AS some_other_name
<28> i knew it was AS :)
<28> just had to be sure before i did something stupid >.>
<9> then why the hell did you ask?
<27> the AS is even optional
<9> !tell Fushuing about tias
<29> Alrighty.
<16> :)
<28> select * from `forum`, `post`, `thread` WHERE thread.threadid = '1' && post.threadid = threadid post.threadid AS post.threadpostid
<19> fushiong: what do you mean in the query, do you want the field name to actually change its name in the database?
<19> totally mangled your name, sorry :)
<9> !tell us about tab
<28> _bitwise_: no, i need to put it in an array in PHP, but thanks to ambiguation it only shows up the first instead of the second :P
<29> But I don't know a thing about that.
<28> FU<tab>
<19> fush: ok, yeah then AS is where ya wanna be :)
<28> _bitwise_ did i use it correctly there? :S
<9> !tell us about tab
<29> litheum asked me to tell you this: You can probably us the TAB key in your IRC client to avoid having to type nicknames and thus avoid spelling them wrong.
<19> ^^ s/us/use
<28> oh man, i love the mysql query error message -_-: "Query is ****ed"
<9> _bitwise_: fixed ;)
<9> !tell Fushuing about evil
<29> Alrighty.
<28> litheum: you know what's even more evil?
<28> putting 50KB in the script just to select the fields you want
<30> during the install process I get this error - http://pastebin.ca/49439
<9> Fushuing: the names of your fields consume 50KB?
<28> quite, yes
<28> lots of stuff needs to be stored
<28> in different columns
<9> how many fields are you selecting?
<28> 200+
<13> nice
<9> ***uming they each have 20-character names, that means you're selecting 2500 fields
<9> anyway, whatever works for you :)
<28> * is better in this case :P
<28> i'm including the , btw :P
<31> oh that's ok then
<28> and uh...where am i supposed to place the AS?
<9> so far, what you're trying to do makes no sense
<9> you're trying to specify aliases for columns that you aren't naming
<9> unless i am missing something, which isn't out of the question of course
Return to
#mysql
or
Go to some related
logs:
#web
default route disappears boot
#gentoo
linux 82852/855GM allocate memory
#debian
mozilla.preload
#lgp
unknown configuration directive 'SQLLogFile'
tora sql editor ampersand
#sql
|
|