#mysql
04 November 2007
Total 16 pages. You are browsing page 16/16.
First :: Prev :: [...] [12] [13] [14] [15] [16] :: Next :: Last
23:11 <****> MS SQL undoubtedly has advantages over MySQL, this isn't one.
23:11 <****> that's your opinion, duh
23:11 <****> The opinion of anyone who was exposed first to backticks instead of brackets, probably.
23:11 <****> instead of brackets?
23:11 <****> Actually my opinion is all this nonsense should be thrown out and everyone should follow the standard, even though it's a bit stupid in this regard.
23:12 <****> same goes for vice versa, obviously
23:12 <****> Needless to say.
23:12 <****> Therefore, no advantage to either side.
23:12 <****> The question is which has more features, which is more stable, easier to set up, robust, blah blah blah, etc.
23:12 <****> it wasn't needless to say since you didn't mention it, and your statements all err on your own side
23:12 <****> is it possible to run mysql db from 2 hard drives, we have db 1 and hd 1 is full and would like to somehow made use of hd2, without moving all current data to hd2, one way is with symbolic links, i wonder if it would be possible to move some tables1. ism, frm,isd files to other hd with symbolic links, anybody idea, what to do ?
23:12 <****> . . . well, this is a kind of stupid discussion, so never mind.
23:13 <****> Simetrical okay, no thanks to you, then - I don't feel stupid for it
23:14 <****> bsdman2 if it's purely isam, then yes, you can move the files; better to use innodb tables and split the data up physically though - something mysiam cannot do
23:14 <****> it will net you extra speed as well
23:15 <****> adaptr: As an aside, MySQL support an ANSI mode that uses the standard double quite for identifiers. I'm not sure MS SQL has that. Do you know off hand?
23:15 <****> s/quite/quote
23:15 <****> Xgc sorry no, I don't - I don't waste my time reading the standards when I have to manage the damn thing 4 hours a day :)
23:15 <****> perhaps backticks work there as well
23:15 <****> who knows/
23:15 <****> adaptr: I thought you were unemployed for a while?
23:16 <****> adaptr: I thought that was your entire point, about backtic .vs. [] .vs. double quotes.
23:16 <****> thumbs where did you get that idea ?
23:16 <****> I am pretty sure you mentioned it
23:17 <****> Xgc the point is that square brackets are a lot more visually intuitive with respect to readability than some sort of easily-confused quotes - of which there are at least 3 different kinds, none easily separated from the other
23:17 <****> adaptr ok, I would want to move just some tables and specify location to mysql where tables of db1 are located soo it can read-write from there
23:17 <****> thumbs I am fairly certain that I didn't...
23:17 <****> i use isam
23:17 <****> adaptr: Obviously, that's another thing MySQL manages to handle better (the entire world knows the standard) than MS SQL. :)
23:17 <****> bsdman2 then you'd better google on doing what you want first - I guarantee nothing :)
23:17 <****> Xgc you are not making any sense, sorry
23:17 <****> adaptr: then I apologise. I must have faulty tipsy memory
23:18 <****> thumbs no need - I will let chad bash you around some more next time
23:18 <****> he loves it
23:18 <****> adaptr on mysql forum I have read that its not possible to specify the location of partitions when using InnoDB
23:18 <****> adaptr: There is a standard. The fact that MS SQL uses a non-standard technique is fine, but calling that (non-standard []) better might be a stretch.
23:19 <****> could anyone help me creating a new table, I get an error about "there can be only one auto column and it must be defined as a key": http://rafb.net/p/Zctawn17.html
23:19 <****> adaptr: I can certainly understand if you think it's more readable.
23:19 <****> Xgc that's unthinking favouritism - WHY is it better ? I provide exactly that: because it causes less visual confusion
23:20 <****> if the standard makes no sense I see no need to cater to it
23:20 <****> adaptr: Because it's the standard. There are benefits to conforming to a standard. I think you'll agree with that.
23:21 <****> recommendations can be made for releasing a new version of a standard, if there is sufficiently strong motive
23:21 <****> Xgc both conform to ANSI99 AFAIAA - which implies that both accept the double-quote travesty, stupid though it self-evidently is
23:21 <****> it's easily tested
23:24 <****> figured out my problem, I needed PRIMARY KEY.
23:27 <****> samus is a girl.
23:28 <****> wow
23:29 <****> adaptr: SQL Server seems to treat double quotes similar to single quotes. Maybe there's an option to change that behavior. I don't believe there is. That's not microsoft's "way".
23:30 <****> Xgc they also claim SQL server is ANSI99 complaint, which would not be possible in that case :)
23:30 <****> in a robot suit
23:30 <****> adaptr: That's pretty typical of Microsoft.
23:31 <****> adaptr: Tested with SQL Server 2005.
23:32 <****> It's probably not even SQL 92/94 compiant.
23:32 <****> ompliant
23:32 <****> Damn. It's either the keyboard or me getting too olld
23:33 <****> It's probably not the keyboard.
23:47 <****> hi there, I'm trying to make a copy of a row, as follows: insert into articles select NULL, title 'copy' from articles where id = 1; as result i get the title but not my added 'copy' string can you help me?
23:49 <****> mysql book it shows 19 * 32 kb which is 2560kb <-- how did they come up with 2560kb ?
23:49 <****> Let me explain better... I get a new row, with the same title as the row with id = 1 (titled "Nice"). My goal is to obtain a new row titled "Nice copy"
23:52 <****> !man string functions
23:52 <****> (String Functions) : http://dev.mysql.com/doc/mysql/en/string-functions.html
23:52 <****> firepol: ^^
23:52 <****> just for your info i achieved my goal... i used the CONCAT function.
23:52 <****> look at concat
23:52 <****> thx
23:52 <****> already done ;)
23:56 <****> guys, shoud I use join to get the values from 2 tables?
23:56 <****> I am doing a search, but there are more than 1 table involved in this search
23:57 <****> it's only a LIKE 'pattern%' search
--- Log closed Mon Nov 05 00:00:16 2007
Total 16 pages. You are browsing page 16/16.
First :: Prev :: [...] [12] [13] [14] [15] [16] :: Next :: Last