#mysql
26 October 2007
Total 21 pages. You are browsing page 1/21.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Fri Oct 26 00:00:48 2007
00:02 <****> #m kk
00:03 * sv2_ test
00:13 <****> hello, when I enter this code: http://pastebin.com/m5d49e8ee it does not print any values in the table. Does anybody know why?
00:17 <****> Hi. Why does this give a syntax error ? "LOAD DATA LOCAL INFILE 'errata_images' REPLACE INTO TABLE djbarney_MGSMOC.errata_images CHARACTER SET 'ascii_general_ci' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (volume_id, ......."
00:18 <****> .... on the character set.
00:18 <****> it's not two words?
00:20 <****> Nope that does'nt work either.
00:20 <****> nope
00:20 <****> I checked the manual page http://dev.mysql.com/doc/refman/5.0/en/load-data.html
00:20 <****> what is exact error message? it should say precisely where the sytanxe rror is
00:23 <****> cfgbfd
00:23 <****> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds
00:23 <****> to your MySQL server version for the right syntax to use near 'CHARACTERSET 'ascii_general_ci' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ' at line 1
00:29 <****> NULL;" returns zero rows
00:29 <****> is my syntax correct?
00:29 <****> "SELECT * FROM table WHERE new_col = NULL;" also returns zero rows
00:29 <****> IS NULL
00:30 <****> is the only valid syntax
00:30 <****> is not
00:30 <****> hhi chad
00:30 <****> hello
00:30 <****> adapter: thanks
00:30 <****> haha adapter
00:30 <****> oops haha
00:31 <****> grobda24: so you made it one word when it should be two
00:34 <****> hi #mysql :)
00:36 <****> this is #mysql?
00:36 <****> dang
00:36 * chadmaynard has been in the wrong channel for a year or two
00:37 <****> well, i guess that taking the channel name literally was a bit of an assumption on my part.
00:37 <****> i see a few different data types that seem to relate to date or time in some capacity. i'm wondering which might be most suitable for storing a value along the lines of 2007.10.25 18.40.36
00:37 <****> lunaphyte: that looks like a date
00:37 <****> how about datetime?
00:38 <****> I second that
00:38 <****> wow, chadmaynard actually backs me up for once.
00:39 <****> except I wouldn't do it the way thumbs suggests
00:39 <****> of course not
00:39 <****> do it the opposite of whatever he says
00:39 * lunaphyte ponders what the opposite of datetime might be.
00:40 <****> error: emitetad is not a valid data type
00:41 <****> I see you're picking u on chadmaynard's humour
00:41 <****> s/u /up /
00:41 <****> dkr ... thanks. I tried that and get the same error.
00:41 <****> : )
00:41 <****> dkr must be doing something right. He just got thanked for an error
00:47 <****> is it possible to do a SELECT that does what INTO OUTFILE does but using STDOUT?
00:49 <****> how do I export all my database procedures?
00:50 <****> eventualbuddha: most queries go to stdout....
00:50 <****> chadmaynard: right, but if i do a normal select it draws the table thing. using INTO OUTFILE does csv, but only to a file (it seems)
01:03 <****> re
01:03 <****> do
01:03 <****> mi
01:07 <****> fa
01:14 <****> la
01:14 <****> thumbs: where do you live?
01:16 <****> chadmaynard: Montreal, Canada
01:16 <****> thumbs: can you speak french?
01:17 <****> chadmaynard: somewhat.
01:18 <****> un peu
01:18 <****> thumbs: is your french better than mine?
01:18 <****> most likely.
01:18 <****> thumbs: is your french better than your spanish?
01:18 <****> yes.
01:18 <****> i'd hope so
01:19 <****> you suck!
01:19 * chadmaynard hehes
01:19 <****> frack you
01:20 <****> : (
01:22 <****> so what is the point of this.. do you need a translation?
01:25 <****> sorry, I'm in a terribly bloody miserable mood today
01:30 <****> http://rafb.net/p/UGjHUd42.html
01:30 <****> mysqladmin: unable to change password; error: 'Can't find any matching row in the user table'
01:30 <****> What did I do wrong?
01:34 <****> Running 3.23: I have a live server with some databases, innodb with foreign keys. I want a copy of the database structure and contents on a dev machine...how do I go about that?
01:34 <****> unstable: you skipped grants.
01:35 <****> FLUSH PRIVILEGES;'
01:35 <****> how do you alter a table to add a new column as a foreign key?
01:36 <****> you might want where user='root' and host='localhost'
01:36 <****> depending on how many roots you have
01:36 <****> ki77a77: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
01:36 <****> How can I just purge the entire package in fedora?
01:37 <****> unstable: your error message indicates you did not start the server with --skip-grant-tables
01:39 <****> or that he already changed the password
01:39 <****> How can I display bit types using select? I want the result to be (for a 4 bit type) 0000 or 0100, etc
01:46 <****> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';'
01:47 <****> Query OK, 0 rows affected (0.01 sec)
01:47 <****> Rows matched: 2 Changed: 0 Warnings: 0
01:47 <****>
01:47 <****> again
01:48 <****> im the only person using mysql right now and when i do status i get
01:48 <****> Threads: 1 Questions: 16675 Slow queries: 0 Opens: 19 Flush tables: 1 Open tables: 11 Queries per second avg: 0.031
01:48 <****> what is opens ?
01:48 <****> and how are 11 tables open ?
01:48 <****> im using 3
01:48 <****> zombie tables
01:49 <****> ?
01:49 <****> maybe different connection usign the same table is counted as multiples
01:49 <****> im only person connected ?
01:50 <****> is it possible to format the display results to display numbers in binary, specifically to show the first four bits, even if they are 0?
Total 21 pages. You are browsing page 1/21.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last