#mysql
28 October 2007
Total 17 pages. You are browsing page 5/17.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
02:11 <****> (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/grant.html
02:11 <****> Would binary be the right type to use for a yes/no bool value?
02:12 <****> Electrosys: use tinyint(1) or enum
02:12 <****> do i have to explicitly set the size of tinytext?
02:12 <****> if i can and don't have to , would the default would be 255 right?
02:13 <****> ki77a77: thanks, I'll try some stuff. I was hoping there was an "access hosts" list of some kind I could edit. cPanel has a button and you just list IPs in its MySQL config section.
02:13 <****> (or so says Google)
02:13 <****> mysticron: review this http://dev.mysql.com/doc/refman/5.0/en/connection-access.html
02:14 <****> Electrosys: you don't set a length value for tinytext
02:19 <****> ki77a77: thanks so much for the help, your great. =)
02:19 <****> So maybe this would work: GRANT ALL PRIVILEGES ON (database).* TO root@192.168.0.10
02:21 <****> Would that mean anyone can call themselves root on 192.168.0.10 and get "all privileges" from MySQL?
02:21 <****> mysticron: root has all privileges on all databases by default. 'grant all on db.* to 'username'@'192.168.0.10' identified by password 'somepwd';'
02:22 <****> mysticron: don't confuse the system users and the mysql users, they're different.
02:22 <****> mysticron: the mysql root is not the same as the system root
02:23 <****> mysticron: review http://dev.mysql.com/doc/refman/5.0/en/grant.html
02:23 <****> I'm just trying to get PHP forum software running on OS X Server and the vendor emailed me "but the XP Server MySQL installation is not allowing connection from OS X. You will need to add the OS X server's ip address to its access hosts." - since I'm not a database guy, I don't know what that means.
02:24 <****> Ok, I'll read through that page, thanks.
02:25 <****> mysticron: remote access requires 3 areas of attention. The mysql service has to allow it, the server firewall has to allow it, and the mysql user has to have the correct access privileges in the database.
02:25 <****> really appreciate your help guys
02:25 <****> later....
02:27 <****> I have a 4-line table creation statement http://pastebin.ca/752103, can someone tell me if this will work (and allow new entires without date column)?
02:27 <****> ki77a77: Firewall stuff is no problem, it's just MySQL that might as well be Chinese to me. I think I've learned enough that I need a professional. I locked myself out earlier today and got back in through sheer luck. ;)
02:27 <****> mysticron: best way to learn. ;^)
02:29 <****> Gm4n: the manual includes a complete, simple tutorial. Here's the section on creating a table: http://dev.mysql.com/doc/refman/5.0/en/creating-tables.html
02:31 <****> ki77a77: my question is more about the timestamp data type than about table creation :)
02:32 <****> (I read that tutorial you linked, and I knew the contents already)
02:33 <****> Gm4n: timestamp has some interesting capabilities for setting values during insert and update. You can see them here; http://dev.mysql.com/doc/refman/5.0/en/timestamp.html
02:35 <****> Gm4n: you'll note, for the first timestamp in the table, '...With neither DEFAULT nor ON UPDATE clauses, it is the same as DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP...'
02:35 <****> so ki77a77, would this set timestamp on creation but not update on modify? .... `date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
02:36 <****> Gm4n: yes, I believe so. Test it, you can always drop it or alter it.
02:36 <****> thanks :)
02:37 <****> Gm4n: "...With a DEFAULT CURRENT_TIMESTAMP clause and no ON UPDATE clause, the column has the current timestamp for its default value but is not automatically updated..."
02:38 <****> yep, that's what I thought, I'm just double-checking :)
02:38 <****> I'm still new to mysql, so I feel safer if someone takes a look at what I'm doing ;)
02:38 <****> Gm4n: well, here you'll often see "tias", which means try it and see. ;^)
02:39 <****> alrighty :)
02:39 <****> so there's no glaring conceptual flaws, anyway
02:40 <****> Gm4n: mysql error messages are usually very clear, and helpful.
02:45 <****> ki77a77, not the syntax errors, those are crap.
02:46 <****> Well, they could be worse, they could fail to tell you where the error is.
02:46 <****> But they're still not great.
02:46 <****> I am trying to access my remote server via mysql query browser, when connected only the default information_schema database is accessible, the mysql database and one of my own databases are not visible or accessible, anyone know what may cause that?
02:51 <****> Simetrical: back in the 80s there was a db called RBase. It's single error message was, "Syntax error." ;^)
02:51 <****> ki77a77, yeah, I've seen that kind of thing.
02:52 <****> hello
02:52 <****> Like in MediaWiki's texvc.
02:52 <****> It sucks considerably more than MySQL's error reporting.
02:52 <****> can anyone here teach me how to get a unix format date value like if i wanted to know todays date/time in unix format?
02:52 <****> i know in php its date(U)
02:52 <****> I am trying to access my remote server via mysql query browser, when connected only the default information_schema database is accessible, the mysql database and one of my own databases are not visible or accessible, anyone know what may cause that?
02:53 <****> testnick: UNIX_TIMESTAMP()
02:53 <****> so i would just insert that into my insert query?
02:54 <****> testnick: yes
02:54 <****> spank you
02:54 <****> very much
03:01 <****> how can you select two columns as one (SELECT (firstName, lastName) as complete_name from table) ?
03:01 <****> caotic: concat()
03:02 <****> right, thanks
03:02 <****> !man string functions
03:02 <****> (String Functions) : http://dev.mysql.com/doc/mysql/en/string-functions.html
03:02 <****> caotic: ^^
03:03 <****> how would i encrypt md5 when insert?
03:04 <****> is there a command in sql?
03:04 <****> testnick: yes. See http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
03:04 <****> ty
03:05 <****> and ty for the help before as well
03:05 <****> np
03:06 <****> testnick: insert into table (fiels)VALUES(md5('somevalue')
03:06 <****> )
03:06 <****> :P
03:07 <****> Enough for me, g'night.
03:08 <****> bye ki77a77
03:18 <****> Where can I read about how to name mysql variables?
03:22 <****> Where can I read about how to name mysql variables?
03:22 <****> Or can i use the _ (underscore) i guess may be a better question?
03:22 <****> can i use the - (slash) ?
03:39 <****> hello
03:40 <****> is there a statement I can use so that in a query I only get one result once?
03:40 <****> limit=1
03:44 <****> testnick: thanks, but doesn't work for me , I meant only one result of each , I 'm searching trough classes an I only want each one of them once
03:46 <****> Is there some option like no repeat ?
03:49 <****> i dont understand what youre asking
03:50 <****> is there a way to make mysql ultra-verbose?...
03:55 <****> is there an example of how to properly use md5() in an sql statement?
03:56 <****> this is one im currently doing: INSERT INTO `anope_ns_core` (display,pass,email,icq,url,flags,language,accesscount,memocount,memomax,channelcount,channelmax,greet,active) VALUES ('webmasterwolf', MD5('password'), 'mirxwolf@hotmail.com', 0, '', 17907, 0, 1, 0, 20, 0, 20, '', 1);
04:01 <****> im sorry that paste mightve been rude
04:01 <****> i wont do it again
04:02 <****> Nah, that's not too long.
04:02 <****> one line is not horrible.
04:02 <****> Your usage appears correct.
04:02 <****> basically, anything more than a cpl lines pastebin it, thats fine
04:02 <****> thx
04:02 <****> smoke break
04:03 <****> Simetrical: nice to see 'ya in here
04:03 * Simetrical waves
04:09 * tawker waves back
04:09 <****> is there a recommended way of getting the # of entries in a tables or the last entry in a table?
04:10 <****> ORDER BY position DESC LIMIT 1
04:11 <****> Xgc, ya, im using the former, is either one recommended for any certain reason though?
Total 17 pages. You are browsing page 5/17.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last