#mysql
08 October 2007
Total 24 pages. You are browsing page 2/24.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
00:39 <****> holy crap
00:39 <****> is this a mysql thing? I dont remember any other database doing this.
00:40 <****> prakriti, I don't know, I'm not very familiar at all with non-MySQL DBs.
00:41 <****> pgsql is NOT case insensitive
00:41 <****> arg, that is really weird
00:41 <****> You can't configure it to be case-insensitive?
00:41 <****> maybe you can
00:41 <****> mysql is case sensitive for some things and not for others
00:42 <****> seekwill the index on a function thing sort of does make sense
00:42 <****> MySQL text types are *really* case-insensitive. You can't insert records that differ only in case if there's a UNIQUE INDEX on the text column, for instance.
00:42 <****> it's called a calculated index
00:42 <****> I have never dealt with a case-insensitive database, I always used upper();
00:42 <****> base insensitive by default
00:42 <****> but that can be changed
00:42 <****> Well, of course if you don't want it to be case-sensitive, you can use BINARY.
00:42 <****> Er.
00:42 <****> case-insensitive, rather.
00:42 <****> ebergen: To save a step in storing it as a calculated column?
00:43 <****> seekwill, you don't have to store it as a column at all. Saves space in the table itself, improves normalization, etc.
00:44 <****> Apparently in pgsql you can even write your own functions to generate the index. Although I don't know how it could figure out when to use such indexes, I suppose you have to tell it.
00:44 <****> so that you can use function operations as indexes
00:44 <****> a simple example is reverse();
00:46 <****> when i insert a row into a table, what should i set a datetime column to?
00:46 <****> or what might i set it to. :)
00:47 <****> now()
00:47 <****> and a time column?
00:52 <****> hrm
00:52 <****> how would I write a statement to fill up a column with data from a function on another column?
00:53 <****> update blah set newcolumn = somefunc(oldcolumn);
00:53 <****> update tbl set `field` = fct(`field2)
00:53 <****> that wouldt work would it?
00:53 <****> i want to do all rows
00:53 <****> yep that should work
00:55 <****> wow
00:55 <****> great
00:55 <****> thanks
00:56 <****> crap
00:56 <****> dont swear in here please prakriti
00:56 <****> what? crap?
00:56 * thumbs smashes prakriti
00:57 <****> :(
00:57 <****> sry
00:57 <****> ok... so I just added a column to this table, and then filled it up with data
00:57 <****> but... it was the wrong table...
00:57 <****> nice.
00:57 <****> oh.. i can drop it
00:57 <****> yaya
00:58 <****> I backed up my database before starting this foolishness :)
00:59 <****> good deal.
01:05 <****> what is the function to count the number of characters in a string?
01:05 <****> length
01:07 <****> I have 100 values I want to add to a kolumn, can I add them all at one time somehow?
01:07 <****> add to a row?
01:07 <****> or... oh
01:07 <****> hello all. I'm pretty new to mysql but was wondering if/how it is possible to join two tables together. I am compiling a table with data in it and one of the rows is always going to be one of 3 values (ie: red, yellow, or green) Is it possible to link this first table to a second table with colours in it and if so, what is this called so I might read up on it. Thanks for any info anyone can give me
01:08 <****> tomin: do a batch insert
01:08 <****> thumbs: a what? :)
01:08 <****> a batch insert
01:08 <****> I guess I am not joining two tables but having one table refer to another
01:08 <****> specifically one table row refer to another table
01:09 <****> !man join
01:09 <****> see http://dev.mysql.com/doc/refman/5.0/en/join.html
01:09 <****> normalization
01:09 <****> http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html and http://datamodel.org/NormalizationRules.html and http://mysqldump.azundris.com/archives/20-Nermalisation.html and some here http://www.keithjbrown.co.uk/vworks/mysql/
01:09 <****> Gumby: those will help
01:09 <****> you can do that in a select gumby
01:09 <****> thanks thumbs, I'll get reading
01:10 <****> he needs a simple inner join
01:10 <****> of course, he might need PK's and FK's
01:11 <****> Gumby: get a query together, and we'll help yo ufix it.
01:11 <****> thumbs, I'm just getting started so that might take awhile :)
01:11 <****> what is the function to count the number of characters in a varchar field?
01:11 <****> andresmh: length
01:11 <****> doh
01:12 <****> what is the function to count the number of characters in a string?
01:12 <****> length
01:12 <****> you seemed to have missed his answer
01:12 <****> oh, sorry
01:16 <****> hi
01:17 <****> hi?
01:17 <****> hi?
01:17 <****> ni!
01:17 <****> ni!
01:17 <****> ni@
01:18 <****> ni!
01:23 <****> I have backed up a database into mysql 5 coming from 4.1
01:23 <****> Is anyone running mysql on Gentoo? I have been having problems inserting records with accent marks and such on them. I'm guessing I need unicode support. Is that a recompile? configuration? help!
01:23 <****> there was a huge table with a size of 1.3 G and when I backed up againg the file was 800 MB.I could not see any error, is this normal?
01:24 <****> wfq_: are all the records present?
01:24 <****> thumbs, I think so
01:24 <****> in fact
01:24 <****> 1.3 G isn't huge, it's moderately large. If you dump the whole table and reinsert, it's possible that it will be smaller, yes.
01:25 <****> AFAIK anyway.
01:25 <****> Unless you've run OPTIMIZE TABLE lately.
01:26 <****> thumbs,Simetrical in fact I did a php script to insert row by row besides using the mysql client, and I got just on row out. The rest were isnserted fine
01:26 <****> as said, I used \. /path/backup.sql and I did not get any error
01:27 <****> TomCox: what errors are you getting?
01:27 <****> also, what character set is your database and table set to?
01:27 <****> ToeBee: No errors, Just when I insert a row with a character with an accent mark it crops the string at the character
01:27 <****> good question..let me see
Total 24 pages. You are browsing page 2/24.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last