| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> in that case it doesn't make sense
<1> roh on internet I found this command SHOW CHARACTER SET LIKE 'latin%'; but I can t execute it?
<0> though you could have it and use ON DELETE SET NULL
<2> yeah but you never know if you suddenly need such functionality..
<3> deleting the order and not the details doesnt make a lot of sense either
<0> in which case it would set the child's foreign_key to null
<0> you'd keep the details, just not the pointer to the order, since it doesn't exist anymore
<2> true.
<2> i'll setup some contraints
<2> my bunnies
<4> http://pastebin.com/737031 what did i wrong that the table gave an error upon creating
<0> cc2k: your ID must be PRIMARY KEY
<4> how do i set that?
<0> !m cc2k create table
<5> cc2k: (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
<6> hey can someone help me with the mysqldump command? i want to export just one table only... but mysqldump --opt database table1 > c:\test\dump.sql returns Outfile Disabled
<4> found it
<4> thx for the help :)
<7> hi, I just install mysql 5.0.21-0 on linux using rpm binaries and I cannot start the service. In the log I only see mysql started mysql ended. anybody have any clues ?
<4> http://elbekko.pastebin.com/737041
<4> shabbs u still there? and if u got time can u check that link plz?:)
<8> hi all can somebody help me I am trying to install php with mysqli support i have installed mysql 5 using the rpms however when i try to configure php with mysqli support i get the following error configure: error: wrong mysql library version or lib not found.
<8> the configure line points to the mysql_config program (/usr/bin/mysql_config)
<8> --with-mysqli=/usr/bin/mysql_config
<6> hello?
<8> can i ask php/mysql question here?
<6> doesnt matter... it wont get answered
<8> can you recommend a php/mysql group?
<6> not really... u can try the quakenet server but i'm on there too and they're just as talkative as they are there...
<6> *here
<8> cheers
<6> ffs
<9> try ##PHP
<9> for php questions
<10> hello
<10> i have got problems with german
<11> i have two tables, one contains the status of a service ticket with one row for each ticket. the other contains the history for each ticket and contains a minimum of two rows for each ticket. i need to the number of tickets that only have two rows in the second table and have a column in the first table that is set to a specific value. is this possible with SQL in MySQL 4.1 or will i need to write a script to do it?
<12> sure
<12> use a JOIN
<2> what do you guys usually do when your primary key reaches its bounds?
<12> Jax: increase the size of the primary key
<2> it's bigint
<13> Jax: UNSIGNED?
<12> disable foreign key checks, delete random rows, and find a new job before anyone notices
<2> yes
<2> :D
<2> is just a hypothetical scenario
<13> Jax: You can't be serious :)
<13> Jax: Let's imagine you can insert 1 000 000 rows per second
<13> Jax: Someday ..
<3> when your dead
<2> haha
<2> jax never dies
<14> And rotted.
<2> and digested by worms..
<2> >;/
<11> Darien_: i know how to do something akin to "SELECT * FROM table1 as one, table 2 as two WHERE one.col1=two.col1" but i'm not sure how i am going to select only the tickets that have two rows in the table 2
<12> at a million rows per second, that's 584,542 years
<13> Jax: Max BIGINT UNSIGNED is 18446744073709551615
<14> People just don't comprehend the size of an unsigned bigint.
<2> ok, so generally we are expecting computers to handle higher numbers quicker than we can insert new records?
<3> during the next dinasaur age
<13> Jax: If you insert 1M rows/sec you need: 18446744073709 sec to overflow it :)
<12> jsumners: something like SELECT t1.id, COUNT(t2.col2) FROM table1 t1 LEFT JOIN table2 t2 USING (t1.id = t2.id) GROUP BY t1.id
<13> Jax: Can you calculate how many years that is? :)
<0> 3598381.7247403636079900124843945 years :D
<15> How many seconds are in *your* years? :)
<0> I don't know :D
<12> 31557600 seconds/yr
<3> +- a leap second
<12> yeah
<12> I'm rounding off to the nearest multiple of 31557600
<15> heh
<15> +/- a leap DAY, even :P
<16> that's alot of seconds.
<3> plus the odd bit every 400 years
<0> I came up with 31536000 secs per year
<16> is that in a leap year or a non leap year, shabbs?
<0> non leap
<16> and remember that, technically, there are only 23.5 hours in a day.
<17> A question (Im fairly new) If I want to do a Select and pull a single row from a table but I have to go through 3 tables prior. can that be done in one Select or should I do it in multiple selects (ie SELECT table4.name FROM table1,table2,table3,table4 WHERE table4.id=table3.id AND table2.ID=table3.id AND table1.ID = 12) <_That select btw doesnt work
<0> either way my original calculation was wrong :D
<11> Darien_: looks like i need to read about left join. thanks
<0> ~584942 years
<12> jsumners: couldn't hurt
<12> jsumners: without knowing your schema, I can't help you much more specifically than that
<11> right
<16> Lorthien: Yes, yes you can.... I don't see where you reference tables 2,3, and 4 to table 1 though by ID.
<17> maybe Im not explaining it well (Wouldnt be a first)
<16> lorthien: You have 4 = 3, and 3 = 2, and 1 = 12 But you never have a 1 = 2, 3, or 4.
<18> I want to backup mysql using mysqlhotcopy in a script w/out embedding the username and p***word in the scipt...is this possible?
<17> that was my bad the 12 was referring to the table1.row
<12> rado2: you could embed it in a config file and p*** that on the command line instead
<12> rado2: or put it in ~/.my.cnf for the user running the backup script
<16> lorthien: Right. So you select ID 12 of table 1, and ANY ID from tables 2, 3 and 4.
<18> ummm...there is no way to get around backing up w/out putting the user info somewhere?
<18> I don't like the idea of user names and p***words just sitting in a file
<18> it seems like everytime I try to get back into this...I always run into this same thing
<18> ok...by the replies, I guess it can't be done...thx for your replies
<12> you could store them in the database :p
<18> the username and p***word?
<12> the problem is that you want to run a script in an automated fashion, which means that the data the script needs in order to run has to be stored somewhre that the script can access
<12> but look at it this way
<12> store it in a file that is readable only by root
<12> if someone has root access on your server, they don't need your p***words anyway
<19> Is it possible to suppress the warnings in MySQLdb?
<12> what warnings?
<19> Warning: Records: 6642 Duplicates: 0 Warnings: 0
<19> curs.execute(query%flattened)
<19> that sort of thing
<19> they are actually informative messages in this case
<12> what's that output from?
<19> the MySQLdb package (python)
<12> ok
<12> no idea
<12> ask in #python I guess
<18> Darien_: you are saying that if I write a scipt...that is only readable by the root user....then just go ahead and put the u/pwd in them?
<12> rado2: I would suggest putting it in a 'defaults extra file', but that only works in MySQL 5 I guess
<19> I love having problems that are inbetween two real subjects
<18> no...I'm using 4.1
<12> rado2: or putting the user/p*** in /root/.my.cnf if the script is being run by root
<3> rado2 or a read only backup user
<18> the script will be run by root in a cron job
<12> then put it in /root/.my.cnf
<12> and chmod 600
<12> and chmod 700 /root as well
<12> voila, problem solved
<18> touch /root/.my.conf
<18> wait
<12> http://pastebin.com/737117
<12> like that
<18> ok I want the /root/.my.conf just owned by root and noone but root is it readable huh?
<12> yes
<12> chmod 700 /root && chmod 600 /root/.my.cnf
<18> ok....let me google some get the right syntax for the .my.cnf
<12> wtf
<12> http://pastebin.com/737117
<12> I just gave it to you
<12> right there
<18> well, I have to read up on the syntax for my.cnf file tho
<12> !man my.cnf
<18> I don't mess w/this every day lol
<5> (Using Option Files) : http://dev.mysql.com/doc/mysql/en/Option_files.html
<18> k thx
<12> but you don't need to touch my.cnf
<18> /root/.my.cnf has to be created huh?
<18> or is it already there?? I doubt it
<18> lemme look
<12> it's created if you've created it
<12> it doesn't matter if it's there or not
Return to
#mysql
or
Go to some related
logs:
#web
dapper joy2key
#perl
fatal: gethostbyname: Resource temporarily unavailable
#css
#perl
4x6.bdf gentoo
Sn33z fluxbox
#web
'union _SourcePict' has no member named 'source'
|
|