Re: Help for query

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

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

hecked the book and research the internet, but didn't find a hint or solution yet. Could any one give me a hint please? Thanks in advance. Xiaobo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

why didn't I insert small number into table?

hint why this occured and how to avoid this? Thanks in advance. Xiaobo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Just need script for creating tables

rom 'mysqldump' but it's not what I want to do.) Cheers. Xiaobo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

simple query

is the query for "max" time value? I guess it's something about reverseing the "order by", but I couldn't find it. Could anyone please give me a hand? Thanks a lot. Xiaobo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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 connect

problem with transfer databases from different Mysql versions

to the sql files. But when I use "source" to retrieve those database in the 4.0.15-nt version, it reports errors. Can anyone tell me how I should tackle this problem? I am also concerned what the "-nt" here means? Thanks a lot. Xiaobo -- MySQL General Mailin

Re: Type conversion from Mysql to Oracle

l to do this from Mysql to Oracle (not the other direction). So I decided to write it up. Thanks again. Xiaobo > Hi, > >> I am trying to convert some Mysql database into Oracle. But their types >> are not exactly match. Could any one give a hint? > > What types do you need

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

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

Re: how to copt table not whole database

Dan, thank you very much. That's what I want. Xiaobo > > Xiaobo, > > Using mysqldump, you can specify which tables to copy. The man for > mysqldump > is as such: mysqldump [options] [dbname [tablename]] > > Say db 'db' has tables x, y, and z in it. You

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 Uni

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

7;ostrich'); SELECT * FROM animals; The thing is that after delete one of them like this: delete from animals where id=4; how can I have the 'id' to be continuous. Now it will be like: 1 2 3 5 6 Or shall I create the table differently at first? If so, how? Thanks for your

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

server.) block the connection from the XP to the port 3306 though I can use ssh or putty, winscp from the XP machine to remotely log in those Solaris machines. Again, thank you very much for your time and patience. I do appreciate it. Xiaobo > Its been a while since i've dealt much wi

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

/refman/5.0/en/connection-access.html I still didn't know how to do it. Anyone can help me? Xiaobo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

questiions for data type and limits of MySQL

Hi, all I have 2 questions: 1) Is there any limit on the number of tables I can create in MySQL and how large I can hold in a database? 2) Does MYSQL support to save binary data file in the table. I can't just save paths to the files. They files reside in another machine. Thanks for reply. X.C