#mysql
20 October 2007
Total 24 pages. You are browsing page 4/24.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
02:35 <****> processlist shows 'copy to tmp table'
02:36 <****> hi, what are "MySQL replication log"
02:36 <****> ?
02:36 <****> alefff: to alter a table, mysql copies the table to a temp table, performs the alteration and then drops the old table and swaps in the new one
02:37 <****> malomalo, you should be able to adapt all versions. what user_id is this?
02:37 <****> ToeBee: I know that, because I already created indexes for other columns. The problem is that fulltext is taking toooooo long to finish.
02:38 <****> ToeBee: When I created the other indexes, it took like 25~35 minutes each
02:38 <****> ah
02:38 <****> for fields with data like phone number, and zip code
02:38 <****> the boring_polls have a poll_id and a user_id in each column. So to filter out the boring_polls for a certain user I need to get all the boring_polls that belong to a user, then use those in the JOIN
02:39 <****> haven't done anything with fulltext... so I'm not sure how much that impacts the process
02:39 <****> it looks like fulltext works fine with small amount of data
02:39 <****> is there a way todo a query so it sorts Rep asc then priority asc ?
02:40 <****> but with that 63 million records, it's too slow
02:41 <****> amy_: look at the "user" table in the mysql database
02:41 <****> gnari: k, think I got it with this "SELECT * FROM polls LEFT JOIN boring_polls ON (polls.id = boring_polls.poll_id AND boring_polls.user_id =9) WHERE boring_polls.poll_id IS NULL"
02:42 <****> gnari: thanks for the help man
02:42 <****> ToeBee, what's the command to do that? Im a total mysql newb
02:43 <****> hi, what are "MySQL replication logs"?
02:43 <****> im making a php form todo queries i need to variables rep and status how would I be able to make it so if nothing would select Status='wild card or all' ?
02:43 <****> malomalo, you are welcome
02:44 <****> amy_: log in to the mysql database as mysql root and run a select query
02:44 <****> select user, host from user;
02:44 <****> magyar, those are logs that mysql uses for replication
02:44 <****> cause Status='%' doesnt work
02:45 <****> raden_work: just eliminate that part of the WHERE clause
02:45 <****> hmm have to play with php a lil then
02:46 <****> raden_work: also, if you're using wildcards in a string comparison in SQL you have to use LIKE instead of =
02:46 <****> raden_work, do you mean Status LIKE '%' ?
02:47 <****> im trying to make a search for a database but it looks like it going to take alot of forms and scripts was trying to use variables in stead
02:48 <****> Anyone help with a MATCH(column) AGAINST ('episode 8') issue?
02:48 <****> if I search for 'episode' i get the same results as when I search for 'episode 8'
02:50 <****> gnari_zzz: thanks, I assume they can be dissabled if no slaves are present
03:03 <****> hi guys i have a problema
03:04 <****> i have a integer coluimn, but when i want order, i want orrder as character, but no as int
03:04 <****> some solution?
03:06 <****> Order as character?
03:06 <****> aja
03:07 <****> yes
03:07 <****> as a text
03:08 <****> Example? I don't know how an integer can become a text
03:09 <****> example :
03:09 <****> 50 30 25
03:09 <****> order numeric : 25,50,30
03:16 <****> DanyWalker: I don't see it
03:17 <****> select varchar(numeric_field) from table ... some like it?
03:17 <****> No
03:17 <****> I don't see how you're trying to convert to a character...
03:18 <****> I don't see 25, 50, 30... I don't understand that order
03:20 <****> select CONCAT(' ',n_mer_codarancel) as xxx from mercaderia order by xxx asc
03:20 <****> ready ;)
03:21 <****> for a column that has a 0 for not enabled and 1 for enabled, would I use tinyint(1) for that?
03:21 <****> Sure
03:21 <****> You'd use TINYINT, not necessarily TINYINT(1)
03:22 <****> ok, is there BIT in mysql?
03:22 <****> I don't believe a real one
03:22 <****> im used to SQL Server so this is why im unsure about mysql's equivalent.
03:22 <****> ok
03:23 <****> isn't BIT just a synonym for TINYINT(1) in some versions of MySQL ?
03:23 <****> I seem to remember reading something like that..
03:27 <****> There is a fine manual just begging to be read... :)
03:35 <****> mysql.com down? I want to know if the conventions are plural tablenames or not
03:50 <****> supergreg: http://www.peachpit.com/articles/article.aspx?p=30885&seqNum=10&rl=1
04:07 <****> is there a way to change code that comes in a database table as HTML into XHTML?
04:35 <****> How to compile embedded server of mysql-5.0 on windows
04:39 <****> ShawnRisk: That's really a job for application lan
04:39 <****> d
04:39 <****> pardon?
04:40 <****> is there a way to change code that comes in a database table as HTML into XHTML?
04:40 <****> That's generally not somehting you'd use a database for
04:40 <****> okay
04:40 <****> That's something you do in your application
04:41 <****> "XHTML" ?
04:41 <****> don't you mean "XML" ?
04:41 <****> okay
04:42 <****> XHTML is XML.
04:44 <****> you could write an absolutely fucking outrageous stored procedure to convert HTML to XHTML, maybe :)
04:44 <****> if this is somehow absolutely crucial for you, you could just have some UDF that did it
04:46 <****> :P
04:46 <****> It's unlikely he wants to do that in the context of SQL.
04:47 <****> wha the hell is "the context of SQL"! :-P
04:49 <****> litheum: It's like asking if I have a C program stored in field1, can I SELECT compile(fieldc) FROM tbl; to compile each C program found?
04:50 <****> Probably not something you would really want to do.
04:50 <****> the answer, of course, is the same, really ;)
04:50 <****> not something you would *normally* want to do, no
04:50 <****> no sensible person would want this
04:50 <****> seems like a frickin cool thing to have though, implemented somewhere
04:51 <****> Is MySQL version 5.x the version to use these days?
04:51 <****> My system has v4.1.20
04:51 <****> pkrumins: 4.1.x is a bit old.
04:51 <****> pkrumins: if your system works fine, and you don't need 5.0, upgrade to the latest 4.1 until you have a problem ;)
04:52 <****> Well, I just got a dedicated server and it was pre-installed there.
04:52 <****> whether that problem is "i need features in 5.0" or "4.1 is not working for me"
04:52 <****> aha
04:52 <****> litheum: Hm, rather, upgrade BEFORE it's a problem ;)
04:52 <****> if you have no applications on 4.1 and you're doing something new, yes, you absolutely should be using 5.0
04:52 <****> That's my philosophy
04:52 <****> litheum, can you name the key features in 5.0?
04:53 <****> litheum, i have no applications on 4.1
04:53 <****> pkrumins: views, stored routines, information schema
Total 24 pages. You are browsing page 4/24.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last