Re: Help for query

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? Thanks

RE: Help for query

Global Information Incorporated > 195 Farmington Ave. > Farmington, CT 06032 > > 860.674.8796 / FAX: 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.mys

Help for query

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 | ot

why didn't I insert small number into table?

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 |

Just need script for creating tables

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 n

simple query

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 na

Re: jdbc:mysql

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

problem with transfer databases from different Mysql versions

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

Re: Type conversion from Mysql to Oracle

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 on

Type conversion from Mysql to Oracle

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: htt

Mysql and Oracle

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: http://lists

Re: how to copt table not whole database

only want to copy table x. > mysqldump db x > 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 > >> "

Re: how to copt table not whole database

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 c

how to copt table not whole database

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 PROTECTED]

retriving password

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

Re: temporary table issue

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 I

temporary table issue

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, No

Re: sequential id

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 addres

Re: sequential id

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 auto

Re: sequential id

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 auto

Re: neet setup tips for remote mysql access

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

Re: Cannot get database connection

, otherwise you shouldn't have 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 >

Re: Cannot get database connection

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

How to adjust the row id after modifying the tabel

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

Re: How to add a host so 'root' can connect to the server from it

ling with > the > passwords using the old password scheme 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 interm

Re: How to add a host so 'root' can connect to the server from it

e from 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.... > > "X

Re: How to add a host so 'root' can connect to the server from it

java program from other machine in Solaris system to connect the database as the user 'root'. Does this imply that it's administration issue? Thanks for your kind help and patience. Xiaobo > "Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 11/03/2005 02:54:16 PM: >

How to add a host so 'root' can connect to the server from it

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 expl

Access control for mysql database

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 connecti

Re: Mysql and JDBC connection time out.

h Mysql database at this point? 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

Re: Mysql and JDBC connection time out.

ion 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

Mysql and JDBC connection time out.

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 = "com.mysql.jdbc.D

Question for JDBC and Mysql

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) | +

Help needed for SQL statement

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 arch