Search results for query: *

say you have table1 and table2 table1=10000 rows table2=10200 rows both are keyed on rowid select rowid from table2 where rowid not in (select rowid from table1)

select a.id, a.data1, a.data2, b.info1, b.info2 from table1 a left outer join table2 b on a.id = b.id This gives you EVERY record in table1 even if there isn't a match record in table2 meaning... like the above id=4 is in table1 but not in table2, you'll still get the record from table1...

So do I have to change the init type files to reflect the directories redhat is using? file: my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock But the data is really in /var/lib/mysql/mysql For ex., should I change my.cnf file to: [mysqld] datadir=/var/lib/mysql/mysql

Files don't want where data and etc. are... example follows. file: my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock But the data is really in /var/lib/mysql/mysql I see in the MYSQL documentation that mysql was suppose to install in /usr/local/mysql or /usr/local...

what is the mysql_config file for ????