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
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
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 =
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
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
mysql
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;
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'
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
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
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-
From: rmck [EMAIL
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,
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,
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
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 datatype
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
-
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 * from Feb04
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 800
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;
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;
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;
+---+---+--++
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
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 * from
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
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]
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
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
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
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
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
29 matches
Mail list logo