Db query help

In each database I have a table with one column I want to compare and then count. So db1.a.odip and db2.aa.newip are the databases, table and coulumns. The data in each column is Ip's, so my result would be a list and count for each by subnet. So the result would be like: db1.a.odip count

Query from two databases

In each database I have a table with one column I want to compare and then count. So db1.a.odip and db2.aa.newip are the databases, table and coulumns. The data in each column is Ip's, so my result would be a list and count for each by subnet. So the result would be like: db1.a.odip count

Query Help

I have two tables: DB 1: Table A: Userid: Dept: DB 2: Table B: Userid: Dept: Location: How would I query from DB 1 Table A for the Dept if I want to use that value for DB 2’s Dept? Both DB’s and tables have the same Userid. Does not work: Use 2; Select A.Dept from A where B.Userid = ‘sam’;

How to import data to diff tables

I have a table with 9 columns, one is an auto_increment for primary key. Data set: 2004-09-21 10:35:50,2004-09-21 10:45:48,tcp,111.111.111.111,80,222.222.222.222,1555,4700 Currently I just dump everyting into one table and query it that way. I was hoping to learn how to place the data into diff

load data in file with pipe

hello, I was tring to understand the steps to read from pipe and load using LOAD DATA INFILE? I dont understand the "x's" or the cat of tcp, can someone shed some light on this for me?? mkfifo /mysql/db/x/x chmod 666 /mysql/db/x/x cat < /dev/tcp/10.1.1.12/4711 > /mysql/db/x/x mysq

Select help

Hi, I have a table with ip,port and I want to see the top ten Ip's with the most entries? Ip's can be in db many times... Not the first distinct 10... Im stuck... I have tried: mysql> select DISTINCT ip from iptable limit 10;

help reading test-select

Hi, I was running the test-select under the /usr/local/mysql/sql-bench dir and was wondering if someone could help break it down for me ( Or at least the "Testing big selects on the table" section ) Thanks : [EMAIL PROTECTED] sql-bench]# perl test-select --password='d'

mysql remote to apache

Is there a good tutorial on installing Mysql on one machine and having Apache on another? I'm thinking on the server with Apache I guess you would just compile Apache with the mysql/php and in your php scripts just point to the hostname of the mysql server? Making sure you can talk to port 330

Re: One Mysql For loads and one for query

import to a table that does not match the text file it is reading from?? >From manual: mysqlimport strips any extension from the filename and uses the result to determine which table to import the file's contents into. Im sure someone can help me?? Rob -Original Message- Fr

One Mysql For loads and one for query

I have a Mysql db that is loaded with about 500,000 records a night using LOAD DATA INFILE. This goes on for a month then a new table is created and so on. Then data is then just queryed nothing else. To take some stress off of this server I was wondering if there is a way to have One Mysql ser

select from two tables #2

Hi I have two tables in the same Db : table 1: helpdesk | CREATE TABLE `helpdesk` ( `wcalledname` varchar(50) default NULL, `wcalledphone` varchar(50) default NULL, `wcalledemail` varchar(50) default NULL, `typeof` varchar(50) default NULL, `status` varchar(25) default NULL, `reason

select from two tables

Hi I have two tables in the same Db : table 1: helpdesk | CREATE TABLE `helpdesk` ( `wcalledname` varchar(50) default NULL, `wcalledphone` varchar(50) default NULL, `wcalledemail` varchar(50) default NULL, `typeof` varchar(50) default NULL, `status` varchar(25) default NULL, `reason

mysql openssl Question

Hello, I have a redhat system that is running mysql with openssl for secure connections. There was just a rpm update from redhat for openssl. I applied that and mysql/openssl connections seem fine. But my question is do I need to recomplie mysql to use the latest openssl This was a custom

date column question

I have a varchar field "start" on my db that stores dates. The dates are loaded into mysql from a txt file which are like this "2004-02-10 23:35:12" in the txt file. I'm thinking this is not a correct choice of datatype for the column which is called "start". What is the best or recommended dat

index question part 2

ssage- From: rmck <[EMAIL PROTECTED]> Sent: Feb 4, 2004 7:33 AM To: [EMAIL PROTECTED] Subject: index question I ran an insert..select from one table to the other ( changed some column types to int from varchar on new table). the insert went fine. mysql> INSERT INTO Feb04_int SELECT

index question

I ran an insert..select from one table to the other ( changed some column types to int from varchar on new table). the insert went fine. mysql> INSERT INTO Feb04_int SELECT * from Feb04; Query O

table design question

I have "ip_address" and "ports" that I want to use in my table. I was just going to make each one a varchar. But was wondering if anyone has a better suggestion? Should I use int for "ports", which will have an index. Not sure how to store "ip_address". This table has the possibility of having

2nd Request Repair Table Hung?

Help. I have a REPAIR table command that has been running since 1/15... I dont know if its hung or what? Should I kill it ? Top shows that it seems to be running? mysql> show processlist; ++--+---+-+-++--+--

Repair Table Hung?

Help. I have a REPAIR table command that has been running since 1/15... I dont know if its hung or what? Should I kill it ? Top shows that it seems to be running? mysql> show processlist; ++--+---+-+-++--+--

CHECK TABLE results

I'm getting an error when trting to update a table: ERROR 1034: Incorrect key file for table: 'Jan04'. Try to repair it So I ran CHECK TABLE, What does this result mean: mysql> CHECK TABLE Jan04 QUICK; +---+---+--++

Help with Update statement

Hello, I have a db that a script failed to run against, and becasue of that a column did not get updated. I have a varchar col that has unixtime timstamp in it. That column gets converted to be readable. My problem is I have many rows that need to be updated, but I dont want to re-convert t

? about user and db table

Hi, I'm trying to uderstand the difference between these tables (mysql.user, mysql.db) v.4.0. I want user "usera" from "hostname1" to connect to "hostname2" which is where the Mysql db is running and have only select priv on db "db_1". "Hostname1" has mysql clients on it. Host: mysql> select

MySQL with SSL enabled

Hello, I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL enabled. Does this feature come enabled with the binary download? Or do I need to download the source and compile it? Any good links ot setting up MySQL with SSL enabled? Thanks Rob -- MySQL General Mail

Tune ?

Hello, Is there any RH 9 kernel tuning tips for system running Mysql 4.0 db? Thanks Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Question on Query

If you have a varchar column (late) that holds a timestamp like: 2003-11-01 08:45:12 Can you use this select statement: select * from table where DATE_FORMAT(`late`, '%Y-%m-%d') > '2003-11-01'; Even though the varchar column is not at datetime,timestamp column... Rob -- MySQL General Mailing L

create own auto increment number

I have a request to create an auto increment field that increments like so: 1-112403 2-112403 3-112403 4-112503 etc... Is that possible??? Any variant of that is fine the big issue is they want the Date with the ID number of the record. Thanks, Rob -- MySQL General Mailing List For list arc

LOAD DATA ?

Hello, My Load data command seems not to load data into my db: mysql> load data local infile '/opt/week/ip.0311100440' into table logs.Nov03 ignore 2 lines; Query OK, 1 row affected (0.66 sec) Records: 48273 Deleted: 0 Skipped: 48272 Warnings: 48273 mysql> I have plenty of space where my d

MYI file

Hello, I have had some Error 127 on my system so I ran myisamchk -rf when mysqld was down. Now I noticed my .MYI file is at 1024K: -rw-rw1 mysqlmysql1024 Nov 11 16:33 table.MYI My .MYD, .frm are still there: -rw-rw1 mysqlmysql8802 Nov 6 07:04 table.frm

Error 127 = Record-file is crashed

Hello, I have "mysql-standard-4.0.16-pc-linux-i686" installed on a 4gig mem, 2cpu system, RH 9. I have a large table (Data records: 72426930) that is now giving me this error "Error 127" when doing selects... This is my first crash of any kind with Mysql. So I'm a liitle confused on what I s