Hi, all
The version of Mysql is 4.0.15 on Solaris 9. I am in such a situation.
There are 2 tables something like these:
Table A:
--
location|timestamp | other fields
---
Table B
location|timestamp |
: 860.674.8341
-Original Message-
From: Xiaobo Chen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 10:09 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Help for query
I found if I divided into 2 steps, I will find the record in table B:
Ta - the given
I found if I divided into 2 steps, I will find the record in table B:
Ta - the given timestamp from table A;
1) select min(abs(Ta - timestamp)) as min_t from B;
2) select * from B where (timestamp + min_t = Ta) or (timestamp - min_t =
Ta);
But, how can I make these 2 steps into 1 query?
Hi, all
I have a table like this:
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| id_freq | int(11) | | PRI | 0 | |
| id_theta | int(11) | | PRI | 0 |
Hi, all
If I use 'mysqldump', I will get the script to create the tables and those
'insert' statements to insert the data.
I am wondering if I just want the first part, i.e, the script to create
the table, is there a command for this end? (I could copy paste the part
from 'mysqldump' but it's
Hi, all
I have a table which has a column with time. It's format is like
-00-00 00:00:00 (default value). I want to get the minimum and
maximum values for this cloumn. Obviously, -00-00 00:00:00 isn't the
minimum value I want.
What I did for the minimum time, suppose the column name is
Not sure yet. Could it be that you're behind the router? And you might
need to redirect the traffic to the model to the IP of your PC and you're
PC's IP should be set static so that next time when you reboot, it won't
change.
Xiaobo
Hi,
I have a problem connecting to MySQL. I could connect to
Hi, all
I have installed a portal server and which has Mysql 4.0.15-nt with it.
Before I installed this server, I have Mysql 4.1 in my PC. But thing is
that they will conflict and I have to delete the old Mysql service. So I
used mysqldump to export the databases from the 4.1 version to the sql
Hi, folks
I am trying to convert some Mysql database into Oracle. But their types
are not exactly match. Could any one give a hint?
Thanks in advance!
Xiaobo
--
Faculty of Computer Science
Dalhousie University
Halifax, Nova Scotia
Canada
--
MySQL General Mailing List
For list archives:
Hi, folks
First thank all you who replied to my question. I should be more specific
with my question.
In mysql database table, there is some thing like in the 'create table
syntax':
fieldname enum('yes','no') default null
and
fieldname datetime default null
I have no idea about the first
Hi, all
I have a questions:
I installed MySQL and Oracle 9i in the same XP box, is there any
interference with each other?
Thanks in advance.
Xiaobo
--
Faculty of Computer Science
Dalhousie University
Halifax, Nova Scotia
Canada
--
MySQL General Mailing List
For list archives:
Thank you Shawn. What I originally thought is that if there is any command
like 'sqldump' to copy a few tables of a database.
Xiaobo
Xiaobo Chen [EMAIL PROTECTED] wrote on 01/16/2006 03:33:36 PM:
Hi, all
How should I copy a table of a database?
Thanks in advance.
Xiaobo
--
Faculty
x.sql(or whatever you want to name it).
Dan
Thank you Shawn. What I originally thought is that if there is any command
like 'sqldump' to copy a few tables of a database.
Xiaobo
Xiaobo Chen [EMAIL PROTECTED] wrote on 01/16/2006 03:33:36 PM:
Hi, all
How should I copy a table of a database
Hi, all
I am trying to retrieve the password for one user in my database. When I
say this:
select password from user;
The returned value is not human readable. Any one know how to converted it
to readable format?
Thanks in advance.
Xiaobo
--
Faculty of Computer Science
Dalhousie University
Hi, all
How should I copy a table of a database?
Thanks in advance.
Xiaobo
--
Faculty of Computer Science
Dalhousie University
Halifax, Nova Scotia
Canada
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi, all
I am trying to use this with error:
drop temporary tabel temp_a if exists 'temp_a';
it said syntax error.
Could anybody tell me the right syntax? I didn't find the answer after
googling a while.
Thanks in advance.
Xiaobo
--
Faculty of Computer Science
Dalhousie University
Halifax,
Hi, Jigal
Thanks a lot. It works.
Xiaobo Chen wrote:
Hi, all
I am trying to use this with error:
drop temporary tabel temp_a if exists 'temp_a';
it said syntax error.
Try:
DROP TEMPORARY TABLE IF EXISTS `temp_a`;
('table' instead of 'tabel'; table name only once; backticks around
Try this:
CREATE TABLE tablename (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default ''
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Greetings,
I have a bunch of names and addresses that I am adding to MySql
database. I would like to
Try this:
CREATE TABLE tablename (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default ''
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Greetings,
I have a bunch of names and addresses that I am adding to MySql
database. I would like to
Oops, forgot ',' at the end of the 3rd line.
Try this:
CREATE TABLE tablename (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default ''
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Greetings,
I have a bunch of names and addresses that I am
Could it be the firewall? You might want to open the port 3306 for
external access(or both). In my XP, I did this:
Firewall -- Advance-- Network Connection Settings --Select Local Area
Connection -- Click Setting, then you might want to 'add...', from there
filling your IP, 3306 for both ports.
Have you tried to put the port 3306 after the host? I assume you are in
the localhost.
Not sure if this is the place to ask but hopefully someone can help me
here. I am setting an application system and have successfully setup
MySQL 5.0.15 and Tomcat 5.5.12. However, I cannot seem to get a
this issue.)
Good luck.
Xiaobo Chen wrote:
Have you tried to put the port 3306 after the host? I assume you are in
the localhost.
Yes, I am trying to connect in localhost. I did 'nmap localhost' and
port 3306 is open and I can connect to mysqld with mysql client. I will
try putting 3306
Hi, all
I follow the example:
CREATE TABLE animals (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO animals (name) VALUES
('dog'),('cat'),('penguin'),
('lax'),('whale'),('ostrich');
SELECT * FROM animals;
The thing is that
Hi, all
I am trying to find out how to check which user is connecting to the
server from which host.
I have a database, data_A; I wrote a simple java code to connect this
database as user 'root', then it just waits there for input from the
keyboard. Before I type anything, it should keep
I have a question related to connection control.
If I want to connect to one database A in the server from another
computer. I am using 'root' and it password. But how shall I add the host
in which table of which database (mysql?) so that the user 'root' can
connect to the database?
A little
issue?
Thanks for your kind help and patience.
Xiaobo
Xiaobo Chen [EMAIL PROTECTED] wrote on 11/03/2005 02:54:16 PM:
I have a question related to connection control.
If I want to connect to one database A in the server from another
computer. I am using 'root' and it password. But how shall
the
installation. It works because I didn't network to anywhere I guess.
Maybe, I should bring this to the system administrtor. It looking like a
networking issue.
Again, thank you very much for your patience and help.
Xiaobo
Answers intermixed. See below
Xiaobo Chen [EMAIL PROTECTED] wrote
and the server has the passwords
in
the new scheme (or the other way around)?
Just a couple guesses that are probably incorrect.
On Thursday 03 November 2005 16:02, [EMAIL PROTECTED] wrote:
Answers intermixed. See below
Xiaobo Chen [EMAIL PROTECTED] wrote on 11/03/2005 04:28:08 PM
Hi, all.
First, I should give some information on the setting:
I have mysql database, say, mydatabase, existing in one machine A which is
Solaris; I am trying to connect this database from another XP machine.
The code snippet in the XP machine looks like this:
String driver =
to
the mysql database.
If so, is there any way to enable the XP machine to access the database?
Thanks a lot for your reply.
Xiaobo
Xiaobo Chen wrote:
then I tried 'telnet':
telnet aaa.bbb.ca or telnet aaa.bbb.ca:3306
both case, it said: Could not connected to the host , on port 23:
connect
?
Thanks for your time and patience.
Xiaobo
Xiaobo Chen wrote:
I already turned off the firewall on the XP machine, but it doesn't work
either. I am doubting that in the database on the other Solaris machine,
it doesn't allow the connection from the XP machine. I am doubting this
way because other
Hi, all
I have a question like this:
There's a field in table_A, date_time, if I say this in Mysql:
select min(date_time), max(date_time) from table_A;
it returned something like this:
+-+-+
| min(date_time) | max(date_time) |
Hi,
I have such a situation:
There is a table with gene_ids and clone_ids. Each gene only resides on a
single clone and each clone may contain multiple genes. How do would I
find how many genes are on each and every clone?
Thanks in advance.
X.Chen
--
MySQL General Mailing List
For list
34 matches
Mail list logo