| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> yeah
<1> there's a couple open ones
<2> I've tried using SELECT COUNT(*) in phpmyadmin and it tells me Unknown column 'count' in 'field list'
<0> what's the exact query?
<2> SELECT xname, COUNT( * ) AS xname, count FROM hits GROUP BY xname ORDER BY count DESC LIMIT 0 , 30
<2> I tried to follow the syntax here http://dev.mysql.com/doc/refman/5.0/en/counting-rows.html and the syntax as posted by firewire
<2> both say the same thing
<3> " AS xname, count "
<1> xname alias duplicates a column
<3> that's your proble,.
<3> SELECT xname, COUNT( * ) AS count
<2> ok I'll try it, thank you : )
<2> hmm wow that worked, thank you. : ) What are the best resources where I can learn more about MySQL? Thank you again guys, truly.
<1> I get all my stuff from the online manual personally
<4> can someone help me with this problem: http://hashmysql.org/paste/viewentry.php?id=1491
<1> or ask in newbie forum
<4> anyone ?
<1> how about a brief summary of the problem?
<5> TodoInTX: Hi there, the log file for DBDesigner seems to be missing libXft.so.1. Do you know how I can get this?
<4> bobfield: the problem is I cannot execute an insert query.. the columns match the structure so I am puzzled. I'll post the error message as well
<1> your list of fields should be backticked not apostrophes
<4> bobfield: so how do I deal with other databases.. like postgresql ?
<1> I've never used postgre, I came to mysql from access world
<4> k thanks
<3> sonic: my suse 10.0 box has this file in xorg-x11-libs-6.8.2-100
<1> Are you trying to convert from postgre?
<5> Aha, I'm on Kubuntu. Just trying in the package manager now. Cheers btw, this programs looks pretty good :-)
<1> I'm a slackware person and I install things by bruce force usually
<1> brute force rather
<1> okay chow time, ciao y'all see ya
<6> hi. any idea on why my query don't work? http://pastebin.com/572785
<6> (im trying to learn INNER JOIN queries)
<7> http://pastebin.com/572789
<6> thank you :)
<6> so I have to do like this: "table1 INNER JOIN table2"?
<8> that is the syntax
<6> yeah
<8> otherwise you could not join more than two tables together
<6> okey
<6> but this works also for me: "SELECT table1.row1, table2.row2 FROM table1,table2", what is the difference between this and INNER JOIN?
<7> pavlion: the inner join syntax reads clearer
<7> for some
<6> ok
<7> but this syntax is more relevant for outer joins
<7> [LEFT|RIGHT|FULL] OUTER JOIN
<7> this you cannot do in FROM table1, table2 style
<7> unless you are on oracle
<7> which have their own special syntax for outer joins
<6> okey, I will read some more about these :) thanks for all help
<3> pavlion: also you should be mindfull that the optimization for these two types of joins may be differnt.
<3> !m TodoInTX join optimization
<9> TodoInTX: Nothing found
<3> !m TodoInTX left join optimization
<9> TodoInTX: (How MySQL Optimizes LEFT JOIN and RIGHT JOIN) : http://dev.mysql.com/doc/mysql/en/LEFT_JOIN_optimization.html
<10> hi
<11> Hi.
<11> Is it OK to remove the test database created when mySQL is installed?
<12> Angel-SL: Which database?
<12> If you mean "test", yes. You can drop it.
<12> I honestly don't remember if test was in the initial install. :)
<3> Xgc: it is part of the inital install.
<3> Angel-SL: you can also run mysql_secure_installation on linux to remove the test db, the anonymous user, and set the root p***word.
<3> all good stuff.
<11> It's from apt-get, so I don't know if it's there
<11> I already set the root p***word.
<11> And there's no test user, anymore, too.
<11> Anyway, mySQL port isn't forwarded to server
<13> how do i put a mysqldump in a mysqldb?
<13> like restore the db?
<14> mysql -u root -p < file.dump
<15> hi...if I have a table with id of unsigned int(10) then what will the most number of table records be?
<13> yeah
<13> i got it myself, thanks x86
<3> firestorm: BIGINT = 18446744073709551615 = int(8)
<3> firestorm: so int(10) I think would be 36893488147419103230
<3> unsigned.
<15> TodoInTX: okay, that is plenty :)
<3> firestorm: however you'll probably run out of rows in the table before that.
<3> firestorm: do -- show table status like 'yourtable'\G
<3> select Max_data_length / Avg_row_length to get an idea what MAX_ROWS is set as.
<3> you can set MAX_ROWS = N when you create the table.
<15> TodoInTX: what is the maximum for autoincrement?
<3> whatever the column supports I think.
<3> !m firestorn auto increment
<9> firestorn: (How to Get the Value of an AUTO_INCREMENT Column in ODBC) : http://dev.mysql.com/doc/mysql/en/ODBC_and_last_insert_id.html
<3> hrm...
<3> http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
<15> TodoInTX: hmm....i'm getting a 'mysql table full' and when I divide max_data_length / by avg_row_length I get about the same id (from auto-increment) as the last insert before it filled....is there a way to increase the database capacity without losing information?
<3> firestorm: I usuially just set auto_increment int(4) it's about 4Bill rows.
<3> firestorm: you can do an ALTER TABLE <table name> MAX_ROWS = <some really big number>
<3> it will take a while.
<3> and the table will be locked.
<3> and you have to have enough room on your drive to hold a second copy of this table during the ALTER TABLE operation.
<3> firestorm: http://dev.mysql.com/doc/refman/5.0/en/full-table.html
<15> TodoInTX: how long would we be talking if the table had approx 40 million records?
<12> firestorm: Feel free to make some coffee.
<3> hehe
<3> yea
<15> hehehe I will :) are we talking minutes, hours, days or months? i'm hoping minutes to an hour or two :)
<3> firestorm: it depends on the speed of your disks mainly. So expect a few hours.
<15> TodoInTX: ok thanks for your help!
<3> firestorm: luckily it's late on a Sat. (at least here in TX )
<15> :)
<16> I've just done a dump with mysqldump --opt db > db.sql now I'm trying to restore it with mysql db < db.sql but it looks like the tables are in the wrong order and can't be restored due to foreign key constraints. I'm getting the following error ERROR 1005 (HY000): Can't create table './customer_care/account.frm' (errno: 150)
<3> johnf: can you try dumping just the structure, rearranging it into the right order, restore the structure then play your original dump file back in ? (as long as you don't have the drop table commands on it)
<0> johnf set the disable foreign key checks flag at the top of your sql file
<3> or you can do that ;)
<16> yep just found that in a google search :)
<16> thanks guys
<17> when i query a mysql db, is there anyways to convert hex to decimal?
<18> !m kuhwalskee numeric functions
<9> kuhwalskee: (Numeric Functions) : http://dev.mysql.com/doc/mysql/en/Numeric_Functions.html
<19> i tried installing mysql without any security settings... but when i try to run it it still asks me for a p***word.
<19> what's the p***word?
<19> actually nm i got it
<20> we could tell you, but ... ;)
<21> can anyone guide me how to do a silent install for the mysql database 4.0.26-gpl verion?
<19> how do i get over ERROR 1045 (28000): Access Denied for user 'root'@localhost (using p***word: NO)
<19> ?
<21> can anyone guide me how to do a silent install for the mysql database 4.0.26-gpl verion?
<0> what is a silent install?
<21> Silent Install : no user input like to click next button or confirming the destination folder !! something like that...
<0> yes
<21> any idea?
<0> don't use the .exe to install
<21> u mean to use an non-install version like zip file?
<0> yeah
<22> !man affected rows
<9> (How to Find the Total Number of Rows Affected by a Particular SQL Statement in ADO?) : http://dev.mysql.com/doc/mysql/en/Total_number_of_rows.html
<17> ok I got a question.. I'm using mysql for logging snort, and I want timestamped entries. Snort doesn't create a Timestamp anywhere, so is there a way I can do it through mysql?
<17> it doesn't put it into it's tables automatically.
<22> kuhwallskee: if you create a timestamp column, MySQL will automatically put the current timestamp into that if you insert it as NULL
<22> but you have to make sure the queries snort makes will work
<19> just a general question... if mysql is free why would people prefer to use oracle or mssql?
<17> Darien: k, ok.. so just like put it at the end ?
<22> foreyezz: more features, more capabilities, more industry support, bigger name, already using Oracle, integrates better with their current systems, etc.
<22> foreyezz: or, don't trust mysql, don't trust open source, think that you get what you pay for, think that you can't get technical support, etc.
<22> does anyone know how I can get the number of queries (a la mysql_affected_rows()) via SQL?
<19> Darien, whats considered the best db out there then? neglecting costs
<22> depends on what you're using it for
<22> !man create function
<9> (CREATE FUNCTION/DROP FUNCTION Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_FUNCTION.html
<19> Darien, say for a big *** database like yahoo's user base...
<22> foreyezz: Yahoo uses MySQL
<19> darien, no kiddin... so mysql doesn't have a limit on how big it can get?
<23> google uses mysql too!
<22> Google uses EVERYTHING
<22> foreyezz: nope
<17> the only limit is your wallet.. :)
<22> foreyezz: it really depends on what you need out of your database
<19> Darien, what's an example to something that mysql wouldn't be able to provide me
Return to
#mysql
or
Go to some related
logs:
#suse
#web
mqueue + purge
hp psc1310 etch
rtlfreeheap qt
#perl
#ldap
firefox 0x80530008
Postfix noqueue: reject: RCPT Domain not found
#centos
|
|