#mysql
08 November 2007
Total 26 pages. You are browsing page 1/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Thu Nov 08 00:00:24 2007
00:00 <****> idiocrash: you have to provide an appropriate format string in the second parameter.
00:01 <****> snoyes: so does that mean I have to write something kind of like a CASE statement to deal with the month abbreviations?
00:01 <****> idiocrash: no, there's a format string for those. Look on that date/time functions page, there's a table under the date_format function.
00:02 <****> !man drop table
00:02 <****> (DROP TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/drop-table.html
00:02 <****> Okay. I know I can be heard then. :)
00:07 <****> flush priveleges;
00:07 <****> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'priveleges' at line 1
00:07 <****> how come I get this error?
00:08 <****> cause you misspelled privileges
00:09 <****> ok
00:09 <****> lol
00:16 <****> i have an ordered select with several rows of output. and i have an integer value. and i have a specified id which identifies one of the rows. my task: i want to check if the position of that specific row is greater or less than my integere value
00:16 <****> how could i do that?
00:18 <****> Our of curiousity, why would you want to do that? But as far as I know, you'd have to pull out a subset of the rows - how many rows are we talking about?
00:19 <****> _Lemon_: not much. maximum of 50
00:19 <****> You could add a LIMIT [your integer value] Then, in your application, if a row matches your id value, you'd knows it's in the first part.... if it isn't matched you know it's still in the database
00:20 <****> Yeah, if you're just pulling out ID's that's 50*3 bytes? 150 bytes? Not much data at all.... probably quite feasible
00:20 <****> _Lemon_: ye, that's a possibility
00:21 <****> I think what you're asking is beyond databases.... perhaps a stored procedure might fair better though
00:21 <****> _Lemon_: you're right, why would someone do that? it's a quite old and outdated db-structure. but still in use and i have to do some modifications...
00:21 <****> What immediately comes to mind would be rankings.... "you're in the top 50!" etc..
00:21 <****> heh it's something like that, yes
00:22 <****> It's not quite that bad in reality, I've heard people who have come in here trying to fix up application which creates about 3 tables per user (it's a web app...)
00:26 <****> Okay. I give up. I'm going to go home and sob in my soup now. Good luck everyone! :)
00:26 <****> _Lemon_: ok thats really bad
00:27 <****> Just count yourself lucky ;)
01:10 <****> hi
01:10 <****> Hey, I'm a mysql newb... I could really use some help getting mysql to play nice with apache/php on my linux box. Anyone want to point me at some good docs or would be willing to help me out?
01:15 <****> hi
01:15 <****> how can i pass in an array of variables to a stored procedure??
01:15 <****> am i right in assuming that i can't pass in an array data type, so how else can it be done?
01:21 <****> pclip: well, there is no array data type in MySQL
01:21 <****> pclip: you could put them in a table and pass in the table name
01:21 <****> re
01:21 <****> pclip: you could put them in a temporary table and simply reference that temporary table from the SP
01:22 <****> litheum isn't making a temporary table resourceful?
01:23 <****> pclip: yes! but i think "resourceful" does not mean what you think it means
01:23 <****> so, if i have say 10 calls to the sproc a second, it would bog it down, by resourceful i actually meant to say 'resource hungry'!
01:24 <****> well, it could
01:24 <****> but that could happen for a hundred other reasons, too
01:24 <****> ?
01:24 <****> using some certain function 10x/sec could also bog things down
01:24 <****> would it be less resource hungry to pass a string, and then parse it?
01:24 <****> so, like everything else, you need to load test...
01:25 <****> yeah, i'm needing some way to pass data in for an in(....)
01:25 <****> Anyone have any possible suggestions as to why my table join isnt quite working. Basically the join works and all the data is correct except for some of the columns which are returning 0 or 0.00 when there are actual values in them. an out put can be found here http://hashphp.org/pastebin.php?format=plain&pid=35563.
01:25 <****> well you don't really need to have an array to be able to put it in an IN clause
01:25 <****> you just need a string of comma-separated values
01:25 <****> ?
01:26 <****> i thought passing a string wouldn't work?
01:26 <****> ii tried that in a prepared statement in php once, and it failed!
01:27 <****> how do I select two numbers and then divide the result?
01:29 <****> select (select number 1) / (select number 2) ?
01:29 <****> good evening
01:30 <****> i've got a pretty annoying problem: This command takes ages to execute: mysql -e "SELECT COUNT(*) from ut_netflow_20070726_orig" --user=root --password=xxxx netflowdata
01:30 <****> When I hit ctrl+c iet get: ERROR 1317 (70100) at line 1: Query execution was interrupted
01:30 <****> I've no idea why it takes so long to execute since the table is empty!
01:31 <****> call bob ("'foo','bar'"); <-- returns an empty result set litheum
01:31 <****> Anyone know where I could get a mysql 5 extention for php 4.3.2?
01:31 <****> pclip: thanks :)
01:34 <****> hm even when I log into mysql and run SELECT COUNT(*) from ut_netflow_20070726_orig nothing happens
01:34 <****> The database is empty, and no other clients are using the mysql server
01:43 <****> Hi everyone there is a new site out that is real great!!! This site is called Wired Geeks Forums and is based on Computer Security, hacking, gaming, warez, and also many more things. This is a fast growing community. Please check it out at http://www.wgforums.com
01:43 <****> Hi everyone there is a new site out that is real great!!! This site is called Wired Geeks Forums and is based on Computer Security, hacking, gaming, warez, and also many more things. This is a fast growing community. Please check it out at http://www.wgforums.com
01:44 <****> all work and no spam makes Jack a hungry boy
01:49 <****> REPOST: Anyone have any possible suggestions as to why my table join isnt quite working. Basically the join works and all the data is correct except for some of the columns which are returning 0 or 0.00 when there are actual values in them. an out put can be found here http://hashphp.org/pastebin.php?format=plain&pid=35563.
01:51 <****> hello
01:51 <****> Hello, I have made my own SuperSQL that is better than MySQL.
01:52 <****> It can create tables faster.
01:52 <****> I have only one question....about replicate MySQL ...how to do it
01:53 <****> http://dev.mysql.com/doc/refman/5.0/en/replication.html
01:53 <****> http://dev.mysql.com/doc/refman/5.0/en/replication.html
01:53 <****> oh...thx
01:53 <****> or "google"
01:54 <****> re
01:56 <****> i keep having issues with mysql starting
01:56 <****> Timeout error occured trying to start MySQL daemon.
01:57 <****> fuse_lt: what is your o/s?
01:58 <****> ooh, nm
01:58 <****> fc7, linux
01:59 <****> it was looking for mysql.sock in /tmp/mysql.sock, when it is actually in /var/lib/mysql/mysql.sock
01:59 <****> weird
01:59 <****> fuse_lt: check your startup script in /etc/init.d
02:00 <****> fuse_lt: or my.cnf
02:11 <****> is there a way to change the userprivileges from 1 user easily?
02:11 <****> so not create a new user, but change the rights from the current user?
02:22 <****> hi, reading the mysql documentation I'm a smidge unclear..
02:22 <****> what's the best way to dump all the data from an old server into a new one ?
02:22 <****> how old? :)
02:23 <****> database versions are the same, but copying raw data isn't an option.
02:23 <****> oh well then mysqldump
02:23 <****> okay
02:24 <****> and the command to dump all data out of one server (including users, and all tables) and into the new one would be... ?
02:24 <****> I believe there is a --all-databases option... check the man page to make sure
02:25 <****> backup.sql
02:25 <****> aarcane: and on the other end, mysql -uroot -p < backup.sql
02:25 <****> --opt is the default mode on 4.1+
02:26 <****> ToeBee: true, old habit
Total 26 pages. You are browsing page 1/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last