#mysql
23 October 2007
Total 29 pages. You are browsing page 2/29.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:23 <****> information_schema is default
01:23 <****> how did you add the user?
01:23 <****> check out mysql.com/grant
01:24 <****> hmm
01:25 <****> after a flush privileges; my db stopped showing
01:25 <****> but information_schema is stil shown
01:25 <****> is that always supposed to be shown to any user?
01:25 <****> so you did insert into users....
01:25 <****> i used a mysql gui to add the user
01:25 <****> didn't add manually
01:26 <****> how can i hide information schema from showing?
01:26 <****> you cant, you dont have to
01:26 <****> read on mysql basics
01:28 <****> gvcoman: info schema isn't a real database
01:29 <****> chadmaynard: ya after i looked a little more into it, it's only displaying what the user can see
01:30 <****> gvcoman: yep
01:33 <****> if i use tinyint instead of int for storing a 3 digits number, it is better or is the same if i use int for al the cases?
01:35 <****> TINYINT is smaller than INT
01:36 <****> tinyint = 1 byte
01:36 <****> INT = 4 bytes
01:36 <****> If I'm doing bulk inserts into a table with a LOT of columns, but I'm only inserting 4 values into each row (with say, 20 columns), is there an easier way than:
01:36 <****> yes i know, but it is the same if a use int for all the cases?
01:36 <****> And the largest three digit number TINYINT holds is 255
01:36 <****> unsigned
01:36 <****> so if i use tinyint will be faster or better?
01:37 <****> INSERT INTO `wp_posts` ( `ID` , `post_author` , `post_date` , `post_date_gmt` , `post_content` , `post_title` , `post_category` , `post_excerpt` , `post_status` , `comment_status` , `ping_status` ....) VALUES ('', '', '', '',) and so on?
01:37 <****> TINYINT will be "faster" since it only uses 1 byte instead of 4...
01:37 <****> nice
01:37 <****> thanks
01:37 <****> If I'm only ever touching a few of those columns, is there a way to make the insert syntax smaller?
01:37 <****> setuid: Don't specify the column. MySQL will default to the default value.
01:38 <****> seekwill, I guess what I mean is... hrm, let me paste my larger insert line
01:38 <****> setuid: INSERT INTO table ( col4, col6, col8 ) VALUES ('hi', 'im', 'chadmaynard');
01:38 <****> http://rafb.net/p/IIvXJx70.html
01:39 <****> is there an easier way to do this where id != 1 and id != 2 and id != 3
01:39 <****> PaulB: WHERE id NOT IN (1,2,3)
01:39 <****> PaulB: WHERE id NOT IN (1,2,3)
01:39 <****> sukka
01:39 <****> seekwill, Ok, so I only need to declare the columns I'm touching?
01:39 <****> awww
01:39 <****> setuid: Yes
01:39 <****> wow identical
01:39 <****> Ok
01:39 <****> not in
01:39 <****> ok
01:40 <****> thanks chadmaynard and seekwill
01:40 <****> Awww, how come you thank him first?
01:40 <****> I am popular
01:40 <****> :(
01:41 <****> seek, so that becomes:
01:42 <****> seek?
01:42 <****>prepare(qq{INSERT INTO `wp_posts` (`post_author` , `post_date` , `post_content` , `post_title`) VALUES (?, ?, ?, ?)});
01:42 <****>execute($post_author, $new_date, @output, $title);
01:42 <****> lol
01:42 <****> alphabetical
01:42 <****> PaulB, What?
01:43 <****> i thanked them alphabeticaly
01:44 <****> which column type is good to store 2 letters?
01:45 <****> ionico: char(2)
01:45 <****> thanks
01:47 <****> hello, I have a large text file of 1000 lines. I would like to insert each one as a new record. How would I do that?
01:47 <****> LOAD DATA INFILE
01:47 <****> ADZ_: ^^
01:50 <****> umm so would: LOAD DATA INFILE 'ideas.txt' INTO TABLE project_ideas; be right?
01:51 <****> ok so if i'm using WHERE id NOT IN (1,2,3) will it matter if there's a comma at the end of the 3, ?
01:52 <****> PaulB: ye
01:52 <****> s
01:52 <****> how do you declare as unsigned an int column?
01:52 <****> or rather: LOAD DATA INFILE 'ideas.txt' INTO TABLE project_ideas LINES TERMINATED BY '\n' (idea);
01:52 <****> ok so no comma
01:53 <****> ionico: name INT UNSIGNED
01:53 <****> set, are you using PHP or Perl?
01:53 <****> set?
01:53 <****> moi?
01:53 <****> thanks a lot chadmaynard
01:53 <****> !tell ADZ_ about tias
01:53 <****> Alrighty.
01:53 <****> set, are you using PHP or Perl?
01:53 <****> set?
01:54 <****> seekwill, I'm using Perl
01:54 <****> haha
01:54 <****> damn
01:54 <****> DBI
01:54 <****> setuid: Try it
01:54 <****> DBD::mysql::st execute failed: called with 3 bind variables when 4 are needed at ./build.pl line 129.
01:54 <****> argle
01:55 <****> setuid: You can figure out that one yourself, right? :)
01:55 <****> how do i do something like this? select * from foo WHERE foo.bar IS NOT NULL;
01:55 <****> rookpawn: like that
01:56 <****>proxy() and randomize across some anon proxies to complete the fetch and inserts... let me code that up.
01:56 <****> Huh?
01:56 <****> So @output in my code was empty, because the remote site was returning no results. Bastidges.
01:57 <****> ok!
01:57 <****> set, you caused me a lot of trouble
01:57 <****> chadmaynard, I did?
01:57 <****> set, yes
01:57 * setuid furrows his brow
01:57 <****> How so?
01:57 <****> chadma, haha
01:57 <****> set, seek and I had a bet riding on you
Total 29 pages. You are browsing page 2/29.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last