#mysql
13 October 2007
Total 15 pages. You are browsing page 15/15.
First :: Prev :: [...] [11] [12] [13] [14] [15] :: Next :: Last
22:21 <****> MtlTime: you can either SELECT (number1 + number2 + number3) AS Total ..... order by Total which puts total in the result set -OR- you can SELECT ...... ORDER BY number1+number2+number3 ... which doesn't put the total in the result set
22:22 <****> ok cool
22:22 <****> however I tried ORDER BY number1+number2+number3 and it didn't work
22:23 <****> MtlTime, define "didn't work"
22:28 <****> well. I trust that gnari will give you excellent guidance is you ever respond.
22:28 * chadmaynard is out of here.
22:33 <****> hi
22:33 <****> hi
22:33 <****> when should i use a fulltext index vs an index
22:36 <****> pclip, use fulltext when searching for words within larger string values. use plain index if you mainly want tests like WHERE col='foo' or WHERE col LIKE 'foo%'
22:37 <****> pclip, in particular a regular index will not help much with queries like: WHERE cil LIKE '%foo'
22:41 <****> what if i have a column with maybe 3 woords in it i want to search?
22:41 <****> ahh, yes, i will want like '%foo%'
22:41 <****> so fulltext then, thanks
22:46 <****> and, is it faster to insert data for a largeset, then build all the indexes for a table?
22:46 <****> large data set being ~40mil
22:49 <****> pclip, i do not know for sure in the case of mysql, but it makes sense that index building is faster after data has been inserted, and it is indeed faster that way with some other DBMS i know (postgres)
22:56 <****> it appears that at first, it could add about 1000 rows a second, now it seems to be taking five times that
22:56 <****> was wondering if it's due to the index
22:57 <****> pclip, quite possible
22:58 <****> ok, heh - trying to delete the index now, and it's taking a fair while!
22:58 <****> not sure if i've crashed mysql
23:00 <****> Hi I have a server running as a lamp config and I need to hook up another server that will use the mysql on the same server the servers are 2 proliant DL380's with twin giga ethernet ports and im familiar with binding the server to ip. im gonna head into the datacenter to put the two servers eth1's onto a lan
23:01 <****> I have a 100mb DB that I need to import into a webhost mySQL DB.
23:01 <****> so i need a switch, the question is what should I consider when choosing a switch for the job
23:02 <****> looking at a budget of around $400 so a cisco is out of the question :P
23:03 <****> Hi
23:03 <****> phpMyAdmin has a 50mb import limit. Can I split the DB on export. Or soje other way ?
23:03 <****> I'm trying to properly indexing tables in my database
23:03 <****> soje = some
23:03 <****> Hello.
23:03 <****> have read that a primary key is used for store data related to other tables??
23:04 <****> it wan't a key wich didn't allow duplicates??
23:05 <****> Ramattack, for tableA to be able to refer to a row in tableB, there must be something in the tableB row that uniquely identifies it. a primary key does that, or any UNIQUE NOT NULL index
23:06 <****> I see...
23:07 * siliconsurge wonder is a el-cheapo netgear will do the job
23:07 <****> how could I make this relationships...
23:07 <****> one moment
23:07 <****> http://www.howtoforge.com/proftpd_mysql_virtual_hosting_debian_etch
23:07 <****> I'm trying to use that tables
23:08 <****> and I have ftpuser where I store the users data
23:08 <****> ftpquotalimit in wich I store it's quotas and limitations
23:08 <****> ftpquotatallies status at the moment of how much quota have used
23:08 <****> and ftp group for making a user to own to a group
23:09 <****> how could I set keys properly in this tables? of course user will be always used...
23:09 * gnari has to go. will be back in 25 minutes ...
23:10 <****> would a crossover cable be a no ?
23:11 * siliconsurge watches a ball of hay float across the room
23:15 <****> on the next page, i get this Query was empty -
23:27 <****> hey I install mysql 5 with debian
23:27 <****> installed
23:27 <****> why cant i log in with root?!
23:31 <****> I use a keyboard.
23:33 <****> n_np_: Is there a root password and do you know it. For what host does it apply?
23:33 <****> pardon me i didnt know its passwordless
23:33 <****> i set it now though :)
23:33 <****> thanks Xgc for answering though
23:34 <****> n_np_: You're welcome.
23:36 <****> hi, can i do binary operations in mysql4?
23:37 <****> Does MySQL acquire an exclusive lock when doing an ALTER TABLE operation that would copy the table?
23:37 <****> i hope so :)
23:37 <****> E.g., are readers denied while an ALTER is in progress?
23:40 <****> i have a status code, where status is e.g. 1+2+4=7, can i do a comparison in mysql then? e.g. select id from table where status ! '4' etc ?
23:41 <****> where status & 4
23:41 <****> But it will always resort to a full table scan, you have to use boolean-ish enums if you want to use indexes.
23:42 <****> Or WHERE !(status & 4)
23:46 <****> intgr, ah, ok , thats great, just want to test, i have status an integer from 1-8 now, but i want to make it a binary field to set more than one status for each row, ee.g. status=2+4 , which e.g. means sent+read or similar
23:47 <****> but if its possible somehow i will use it, thats more flexible
23:48 <****> Actually you can use a single tinyint column for each flag and set it to 1 or 0.
23:48 <****> yes, but this would end up in 8 new fields for each row, not elegant :)
23:49 <****> maybe later on i want to define new status codes, or make it dynamically etc
23:49 <****> e.g. let the user define a new status
23:49 <****> its for a newsletter software where i want to take care of the status, and save more than one flag at once in a single value
23:50 <****> Well whatever suits you best.
23:53 <****> intgr, you know how is this called in mysql ?
23:53 <****> i mean the magic word i have to look for in dthe docu :)
23:53 <****> Bitwise operators, they're present in nearly every programming language.
23:54 <****> ah bitwise :) i was searching for binary operator
23:55 <****> Note that to combine flags you should use "|" instead of "+"
23:56 <****> 7 + 4 = 11 but 7 | 4 = 7
23:58 <****> intgr, thank you
--- Log closed Sun Oct 14 00:00:16 2007
Total 15 pages. You are browsing page 15/15.
First :: Prev :: [...] [11] [12] [13] [14] [15] :: Next :: Last