Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: dixondwayne
- Order by date
-
finding unique entries between two tables
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)- dixondwayne
- Post #2
- Forum: MySQL
-
query problem
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...- dixondwayne
- Post #3
- Forum: MySQL
-
Redhat Linux install of mysql
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- dixondwayne
- Post #3
- Forum: MySQL
-
Redhat Linux install of 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...- dixondwayne
- Thread
- Replies: 3
- Forum: MySQL
-
what is the mysql_config file for ????
what is the mysql_config file for ????- dixondwayne
- Thread
- Replies: 1
- Forum: MySQL
