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 |

RE: Help for query

: 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

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?

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

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 name is

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 to

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

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:

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

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:

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 copy a table of a database? Thanks in advance. Xiaobo -- Faculty

Re: how to copt table not whole database

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

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

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

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,

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 IF EXISTS `temp_a`; ('table' instead of 'tabel'; table name only once; backticks around

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

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

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 addresses that I am

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

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

Re: Cannot get database connection

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

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

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

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

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

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

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

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

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

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

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 =

Re: Mysql and JDBC connection time out.

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

Re: Mysql and JDBC connection time out.

? 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

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