| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> insert into tabley (col1, col2) select col1, col2 from tablex
<1> INSERT INTO table.dbx (z,a) SELECT x,y FROM table2.dbz?
<1> zeitoun: but theyre in different databases..
<0> insert into dby.tabley (col1, col2) select col1, col2 from dbx.tablex
<1> k
<1> now
<1> say i have more static nonchanging information to insert into dby.tabley
<1> zeitoun: example
<1> INSERT INTO `phpbb_users` (`user_id`, `user_active`, `username`, `user_p***word`, `user_session_time`, `user_session_page`, `user_lastvisit`, `user_regdate`, `user_level`, `user_posts`, `user_timezone`, `user_style`, `user_lang`, `user_dateformat`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_emailtime`, `user_viewemail`, `user_attachsig`, `user_allowhtml`, `user_allowbbcode`, `user_allowsmile`, `user_allowavatar`, `user_allow_p
<1> sorry for hte paste
<1> meant to pastebin
<1> hold up
<1> zeitoun: http://pastebin.com/527567
<1> basically i want the username and userp*** to be automaticlly populated
<2> How can I simply add a user/database name and give it a p***word?
<1> the rest of the information stays the same
<0> nphase: I don't get it...
<3> !m KerPlunk add user
<4> KerPlunk: (Adding New Functions to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_functions.html
<3> !m KerPlunk adding user
<4> KerPlunk: (Adding New Functions to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_functions.html
<3> !m KerPlunk grant
<4> KerPlunk: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<5> zeitoun - Can you explain to me what USING does?
<6> hehe
<0> SunShineLady: it deletes form table you specifiy USING the join you want to use, as you may want to delete from 2 table using a query joining on 3 or more.
<5> zeitoun - can I uses it insread of LEFT JOIN ?
<5> with normal a SELECT query
<0> ?
<5> I don't think I fully understand the use of USIN
<5> USING
<0> Maybe you get confused since the keyword can be used in 2 different places: to specifiy a query to use for a delete on multiple table or to define a join condition.
<5> no no ... I can corporate this example but I won't be able to use for anything else because I don't know what it really does nor how it really works
<0> nphase: think I finally got you..... http://pastebin.com/527580
<1> ahhhhh
<1> zeitoun: brilliant
<0> nphase: but since most of the columns probably have a default value, I don't think you need all those fields....
<1> yeah
<0> SunShineLady: just a sec, trying to put up a very simple example.
<5> I need a tutorial not an example...
<7> jpm_ how can i see the querys of last 1 second?
<2> http://www.rafb.net/paste/results/9sG1hc95.html
<2> My site is up...and phpbb/cacti work which both use mysql... but I can't seem to add a drupal user to mysql.
<0> SunShineLady: lets ***ume you want to delete all post and rating belonging to a particular user....
<2> And with my debian system, usually when I install a program like phpbb2 or cacti...an ncurses program pops up and asks me questions and adds the database automatically..but it failed this time..the database isn't listed.
<1> thanks zeitoun, that was brilliant !
<1> :)
<2> http://www.rafb.net/paste/results/TnhubN44.html
<0> you would need to delete from table posts and table rating... but using a query joining tables posts, rating and users
<7> people how can i see the querys of last 1 second?
<0> but you don't want to delete anything in this last table.
<7> neverone know that? :S
<5> I gave an example with JOIN because there post with no rating
<0> MalMen: are you talking about slow queries ?
<7> zeitoun im talk about all
<7> but of 1s
<7> show the number of querys executed at last sec
<0> MalMen: ha ok. No idea.
<8> eve
<9> hey anyone here interested in a portable computer, price 550 made by alinware. message me if interested
<0> 550 swiss francs ?
<3> cents
<0> pounds ?
<3> monopoly money
<0> reals ?
<10> reels
<10> 550 reels of 16mm
<3> pieces of eight
<11> hi, where do I set the max connections?
<10> my.cnf
<10> max_connections=800
<10> for example
<12> Hi Darien
<12> I got a question for you if you have a quick moment
<10> not really
<10> if it's really super quick sure
<10> but ask your question either way
<12> I've accidently screwed up my numbering on an auto-***ign and its now counting from 304 instead of 4
<12> is there anyway to reset it?
<10> remove the column and re-add it
<12> okay simple eh
<12> thanks
<10> y
<10> np
<13> can I talk someone into messaging me real quick like. Trying to test some notification software.
<14> not registered so i cant ;)
<1> how does phpmyadmin get the row names of the tables?
<10> desc table
<1> thanks
<15> can someone give help on setting up mysql with php?
<16> hey how would i alter a table so that it removes the max_rows and avg_row_length options on it?
<17> hackmiker, what's the problem?
<17> sean_micken, You don't remove it. You change it.
<16> well, that's teh defaults then?
<16> like if i were to omit those 2 directives?
<17> Why does it matter?
<15> will, well basically it just doesn't work with php. i got mysqld running
<17> !tell us about doesnt work
<4> will asked me to tell you this: Look buddy, doesn't work is a strong statement. Does it sit on the couch all day? Is it on IRC all the time? Please be specific! Give us the FULL EXACT error message and FULL EXACT query. Tell us what it does and/or does not do.
<16> because it was set to something it shouldn't have been.
<15> will, and if i try mysql_connect() it just ends the page (nothing after that is output)
<17> It's safe to just leave it alone.
<17> Unless it's causing problems.
<17> hackmiker, mysql_error()
<17> Or ask in #php.
<16> will: well, the avg row length was set to 50 and i think it should be more like 8096 if it was indeed supposed to be set, but this SQL setup file (for dspam) just omits it entirely.
<17> Change it to 8096 then.
<16> will: there are 2 SQL setup files, one is normal and the other is optmized for speed and we used the speed optimized one, but my buddy ran an alter on one of them setting the avg_row_length to 50 and i have no idea what it was before...
<17> Look at the SQL to see what it was set to?
<16> will: it just omitted it.
<17> You don't have to worry about it.
<17> 8k is a pretty long row...
<16> k, this table is big... 4gig right now
<16> critical
<16> you sure its alright?
<17> Nope, but do you notice any problems? I vaguely recall avg_row_length was used for indexing optimization... The more accurate it was, the better. But it's not going to kill anything.
<16> will: we're havign problems with slow queries right now.
<16> but.. it's set to 8096 in the normal schema, but it's completely omitted in the speed-optimized schema, i'd like to get it back to that... whatever it is.
<17> Was it slow to begin with? Or did it become slow because of this avg_row problem? Because there are much bigger things to look to/
<16> will: it just started becoming slow, then my colleague googled some **** and found an ALTER that changed the avg row size and he ran it.
<16> that's on one table, the other day just finished a repair and optimize and it went from 30 second queries to 6 second ones, but still not 0.01 seconds im looking for :P
<16> any ideas?
<16> will: err.. the other day? i meant the other table
<16> sorry.
<18> Is storing things such as images in a MySQL DB generally considered a bad idea?
<18> ...and/or a silly one? :)
<17> sean_micken, What kind of queries are you running?
<17> enginuitor, Yes.
<18> Thought so.
<18> ...but it would be interesting ;)
<18> What's the maximum length for a "TEXT" field?
<18> Is there one?
<17> !man column type
<4> (Column Type Overview) : http://dev.mysql.com/doc/mysql/en/Column_type_overview.html
<18> Neat, thnks
<18> thanks*
<17> !man overview of string types
<4> (Overview of String Types) : http://dev.mysql.com/doc/mysql/en/String_type_overview.html
<17> Better link..
<18> Thanks
<19> does anyone have a guide on how to install MySQL 4.1.16 on Windows with PHPMyAdmin, beacuse I can't get the phpmyadmin to connect to the database at server, but i can connect using MySql Front... any ideas what the hell the problem is, i get #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client in PhPMyAdmin
<18> Ahh, "can be extremely long"... sounds good to me :-D
<17> !m Squee old client
<4> Squee: (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<17> Squee, You should install 5.0. You should also install the new PHP extension found on mysql.com.
<19> is 5.0 bacwards compitable with most scripts out there?
<17> Compatible with the ones that were written properly :)
<17> Time to make like a banana and leaf.
<20> how do i clone a record?
<18> Well, I only waste two bytes by using LONGTEXT instead... so I'll go with that
Return to
#mysql
or
Go to some related
logs:
/INCREMENTAL:NO + mozilla
grub nvram-wakeup dapper
#suse
#sdl
mysqldump errno 144
#php
iptables http acccept
#mysql
mysql select into outputfile
#debian
|
|