database URL / JDBC connection trouble

My apologies if I am cross-posting as I am not clear on which is the proper list for gal questions (& I have also posted to [EMAIL PROTECTED]). What is the proper database URL for JDBC connectivity ? I have set String url = "jdbc:mysql://localhost:3306/music"; String user = "charly"; String passw

RE: OR in QUERY

> is there any way turn the following query to all ands instead of using an > or? > > select f1,f2,f3 from table1 where (f1 ='monday' or f2 ='monday') and > f3='34'; SELECT f1,f2,f3 FROM table1 WHERE 'monday' IN (f1, f2) AND f3 = '34'; --

MySQL and SSL

I think it would be possible to use MySQL with SSL in the following way: I know of a program called sslwrap, based on openssl. It can be found at sourceforge.net. It is a wrapper that will act like a tunnel end of a ssl connection and then forward the unencrypted data to another port on your

RE: Adding a [mysql] to the subject line

> I am not sure if this has been addressed before, I think it would > be neat if the list admin could put a [mysql] in the subject line > for messages. I get a lot of email and it would help having that > in the subject line. it would also help me in filtering my mail. > Please let me know your c

RE: integer&char problem

> i have a problem in query. My field type is integer. > The table is empty and i want to select max number from the > field but it display error message.Then i try to change the type > to char ,it's can but, > the max is until 9 only.is there anyone can help me. What query? What table? What er

integer & char

hai , i have a problem in query. My field type is integer. The table is empty and i want to select max number from the field but it display error message.Then i try to change the type to char ,it's can but, the max is until 9 only.is there anyone can help me. thanks in advance _

Question

Hi Sir, Now I'm trying the fulltext search of mysql 3.23.40. The question is : May I use chinese font as the substring in mysql script? I tried, but failed. Cheers! Winnie Xu - Before posting, please check: ht

integer&char problem

hai , i have a problem in query. My field type is integer. The table is empty and i want to select max number from the field but it display error message.Then i try to change the type to char ,it's can but, the max is until 9 only.is there anyone can help me. thanks in advance

Re: Can't start MYSQL on Linux

Yes, that's it. It worked!!! Thank you so much. Can I ask why? Ling >From: Gerald Clark <[EMAIL PROTECTED]> >To: Ling Wang <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: Can't start MYSQL on Linux >Date: Tue, 07 Aug 2001 10:29:21 -0500 > >chown -R mysql /var/lib/mysql > >Ling Wang wro

DBASE query question.

hai In mysql it can be done but do anyone know how to join table in DBASE? The situation :- table 1 - EM_id EM_gender table 2 - EN_id EN_name The question is how to select all field from table1 and EN_name from table2 at one query? .The EM_id and EN_id is same.Is tha

integer & char

hai , i have a problem in query. My field type is integer. The table is empty and i want to select max number from the field but it display error message.Then i try to change the type to char ,it's can but, the max is until 9 only.is there anyone can help me. thanks in advance

Re: Can't start MYSQL on Linux

>On Wed, 8 Aug 2001, Ling Wang wrote: > I have to login as root user to do mysql_install_db and safe_mysqld &. > Otherwise I will get permission denied message. You already made those files, and they're owned by root. You can't overwrite them that way. Just do a chown before you start the data

Re: Can't start MYSQL on Linux

I have to login as root user to do mysql_install_db and safe_mysqld &. Otherwise I will get permission denied message. How come when I type service mysqld start, Linux says command not found? I could not find the command chkconfig either. Your idea does not work for me. Thanks anyhow. Ling

DBASE question.

hai do anyone know how to join table in DBASE? The situation :- table 1 - EM_id EM_gender table 2 - EN_id EN_name The question is how to select all field from table1 and EN_name from table2 at one query? .The EM_id and EN_id is same.Is that any idea. please help me.

OR in QUERY

is there any way turn the following query to all ands instead of using an or? select f1,f2,f3 from table1 where (f1 ='monday' or f2 ='monday') and f3='34'; Thanks Randy - Before posting, please check: http://www.mysql.co

ASP & ADO

Hi Folks, New user here...How easy or not is it to use mySQL as a substitute when using .asp and ADO? What do I need to know in order to use mySQL with ASP and ADO? Are there 3rd party solns available? Thankyou, Steve. - Befo

Re: Adding a [mysql] to the subject line

You could just filter for "[EMAIL PROTECTED]". That's what I do. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com On Tue, 7 Aug 2001 17:12:29 -0700, Randy Johnson wrote: >I am not sure if this has been addressed before, I think it would be >neat if >the list adm

Re: Zerofill Auto_Increment

Thanks Paul, That works fine. :) >>On Tue, 7 Aug 2001 16:12:16 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: >>>Hi All, >>> >>>Not sure if this is a bug or just a standard behavior of a auto_increment >>>zerofill column. >>> >>>I have a column in a MySQL database table assigned as such: >>>

Re: load multiple files into the same table at once?

At 3:26 PM -0500 8/7/01, Bing Du wrote: >Hi, > >If this kind of question has been asked and answered, I'd appreciate if >somebody can point me to the right direction looking for the answers. > >The question is how I should load different external text files into >different columns of the same tabl

double column type why...

hi, please help me... i can't understand why are my doubles incorrect. create table test (dnum double(20,5)); insert into test values(8998); insert into test values(8998.0001); insert into test values(898.00

Re: Problem with MySQL over HP-UX 10.20

Hi! We had the same problem. Apparently, this is caused by the missing of some patches. After we applied the patches listed below, the problem disappeared. phco-23684, phss-12727, phss-19739 phss-23672. If I am not mistaken, they are related to dce. {}S Jose Vilmar Estacio de Souza MailTO:

AW: Compiling error in complete.c: filename_completion_function

Sinisa Milivojevic writes: >> Hi! >> You have something wrong on your system. Some include files has messed >> in and changed things. >> It is also possible that your dirent.h file is missing or is messed. The dirent.h file is located @ /usr/include/ /usr/src/linux/include/linux/ and in vari

Re: My databases got hosed when the server went down hard!

Thankyou, that fixed it. Man, I was concerned I'd have to rebuild those databases and re-enter all the data. thanks for the help, -- Chip [EMAIL PROTECTED] on 08/07/2001 11:35:31 PM Internet mail from: To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: My databases got hosed whe

Bad path to ibpthread.so.14.20?

I'm installed MySQL 3.23.37 and I can't get it started. I know there has be number of posts regarding such a problem but I haven't seen a resolution to fix mine specificly. I get this error when I try and load mysqld /usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or dire

Re: My databases got hosed when the server went down hard!

Your permissions are wrong on one of the directories. Make sure that the 'mysql' user has the correct permission to the ./mysql directory. [EMAIL PROTECTED] wrote: I see the .MYD, .MYI, and .FRM files in the /usr/var/db/mysql/ directory, but I get this - mysql> use bulletins Can't read dir

Re: Zerofill Auto_Increment

At 1:25 PM -0500 8/7/01, [EMAIL PROTECTED] wrote: >Hi All, > >Not sure if this is a bug or just a standard behavior of a auto_increment >zerofill column. > >I have a column in a MySQL database table assigned as such: > >memid int(8) auto_increment zerofill primary key, > >now when the a new row is

Adding a [mysql] to the subject line

I am not sure if this has been addressed before, I think it would be neat if the list admin could put a [mysql] in the subject line for messages. I get a lot of email and it would help having that in the subject line. it would also help me in filtering my mail. Please let me know your comments.

RE: Upgrading to 3.23.37 from 3.22.32

MySQL reports read only table. As for file permissions, everything is fine. Everyone has read and execute privileges. > > They are probably not owned by mysql anymore. > > Adam Douglas wrote: > > > I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was > > pkg_delete the old MySQL

Re: Can't start MYSQL on Linux

mike cullerton <[EMAIL PROTECTED]> writes: > on 8/6/01 10:13 PM, Trond Eivind Glomsrød at [EMAIL PROTECTED] wrote: > > > "Ling Wang" <[EMAIL PROTECTED]> writes: > > > >> I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was > >> installed together with the Redhat Linux. I can no

Re: Timezone problem.

On Tuesday 07 August 2001 09:10, Heikki Tuuri wrote: > Hi! > > No idea what is wrong. Below is the code which > prints the timestamp in InnoDB: > . > > struct tm cal_tm; > struct tm* cal_tm_ptr; > time_t tm; > > time(&tm); > > #ifdef HAVE_LOCALTIME_R > localtime_

Re: MySQL++ API under Mac OS X

On Tuesday, August 7, 2001, at 07:43 AM, Sinisa Milivojevic wrote: > Halim Chtourou writes: >> I was able to compile and install the MySQL++ API on my Mac OS X >> system, >> however, whenever I try to run a program linked against the library, I >> get undefined symbol errors. >> >> dyld: bin/w

RE: WANTED: Utility to reverse engineer existing database II

On 07-Aug-2001 Kevin wrote: > > Thanks for pointing out mysqldump. > > I now need to be able to copy a limited number of data records. I see that > mysqldump allows data copy by providing the cooresponding INSERT statements. > However, I don't always want all of the records. Some of my tables

Re: Upgrading to 3.23.37 from 3.22.32

They are probably not owned by mysql anymore. Adam Douglas wrote: > I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was > pkg_delete the old MySQL and install the new one. Before I delete the old > MySQL I copied all the database files to a temporary location. Once the new > insta

Re: Logging connections

You have timestamp fields in your table. When the user connects, you insert a row. The first timestamp field is set to the entry time automatically, you just record the user. When he disconnects, you update the second timestamp with the disconnect time. You can later compute the difference. I wo

RE: WANTED: Utility to reverse engineer existing database

Or you can just use the whereclause option in MySQLDump. (i.e. -w'RecordID<200') http://www.mysql.com/doc/m/y/mysqldump.html Jay -Original Message- From: Stefan Hinz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:47 AM To: Kevin; [EMAIL PROTECTED] Subject: Re: WANTED: Util

Re: Truncated User List

Steve Wright schrieb am Dienstag, 7. August 2001, 18:49:43: > I don't mean to sound ungrateful to those who are trying to help me, I just > need to grasp an understanding of what is causing my problem & why. > mysqldump has helped me & solved moving my databases, however I can still > recreate

load multiple files into the same table at once?

Hi, If this kind of question has been asked and answered, I'd appreciate if somebody can point me to the right direction looking for the answers. The question is how I should load different external text files into different columns of the same table. For instance, file1.txt contains 'ssn name'

Upgrading mysql on Win2K

What is the process of upgrading v3.23.36 to 3.23.40 on Windows NT. Can I just install over top or is there some other steps that should be taken? I am running two mysql servers, one a master and one a slave. Does this make a difference?

RE: Save object into MySQL

> Hi, > > I want to save object into MySQL database. Since MySQL > in not object relational database, is any problem to > save object into it? Which attribute I should select > to save object? Varchar BINARAY? First of all, you need to serialize the object somehow. I assume that the language i

Re: MySql and PHP

Speaking of Mysql and PHP, has anyone had a problem compiling PHP 4.0.6 (as a DSO) with MySQL 3.23.40 in use with Apache 1.3.14 on a redhat 7.0 box? The error I get occurs when I run apache, during startup it says that it can load the php module because the libmysqlclient.so.10 file cannot be fou

Re: WANTED: Utility to reverse engineer existing database II

Dear Kevin, > an option on mysqldump that would limit the number of records. Any ideas > without writing a program? AFAIK you cannot do this with mysqldump. But you can use the SELECT ... INTO OUTFILE syntax, in some way like this: SELECT * FROM my_table INTO OUTFILE "some_records" WHERE i

Re: importing data

Dear Kevin, > Is there an easy way or perhaps a utility to import a tab delimeted text > file of data into a mysql table Try PhpMyAdmin (www.phpmyadmin.com). Great browser based utility. You need to have PHP installed in order to use it. You may as well use the LOAD DATA INFILE command. Check h

Re: Speed (char or integer)

A numeric value will be faster in most cases. The reason being that a comparison between two numbers at most takes 1 comparison... but a comparison for a char at most takes n comparisons (n being the length of the field/string). In addition a numeric value would take less space... all around its a

RE: WANTED: Utility to reverse engineer existing database II

...Some of my tables have thousands of records and I may only want the first 200 or so. I did not see an option on mysqldump that would limit the number of records. Any ideas without writing a program? Kevin > Try the WhereClause option in mysqldump. Syntax is: -w 'where_clause

Re: Localization..

> Date |Tue, 7 Aug 2001 17:25:48 +0800 > From |"SDiZ Cheng" <[EMAIL PROTECTED]> > > Hello! > > > SC> I have read these docs. I can't find any charset option in CREATE TABLE > SC> syntax. > Oh no. > You need to set up charset in mysql configuration. > like this: > http://www.mysql.com/doc/C/h/Ch

Re: Localization..

> Date |Tue, 7 Aug 2001 17:25:48 +0800 > From |"SDiZ Cheng" <[EMAIL PROTECTED]> > > Hello! > > > SC> I have read these docs. I can't find any charset option in CREATE TABLE > SC> syntax. > Oh no. > You need to set up charset in mysql configuration. > like this: > http://www.mysql.com/doc/C/h/

Re: importing data

Please see section 6.17 of http://www.mysql.com/doc/index.html. Bing Bing Du <[EMAIL PROTECTED], 979-845-9577> Texas A&M University, CIS, Operating Systems, Unix >>> Kevin Fonner <[EMAIL PROTECTED]> 08/07/01 10:08AM >>> Is there an easy way or perhaps a utility to import a tab delimeted text f

Zerofill Auto_Increment

Hi All, Not sure if this is a bug or just a standard behavior of a auto_increment zerofill column. I have a column in a MySQL database table assigned as such: memid int(8) auto_increment zerofill primary key, now when the a new row is inserted in fills the column with the appropriate 0's, but

Problem with MySQL over HP-UX 10.20

HI, i am trying to install MySQL over an HP-UX 10.20 machine: # uname -a HP-UX hpbmp01 B.10.20 E 9000/899 1653421311 8-user license When i try to run the Installation procedure this fail with the follow error (Memory failt). # scripts/mysql_install_db Creating db table Creating host table Crea

Followup on 1054 error

Thanks for all the responses to my posting below. I was using phpmysqladmin to check on updating the database, and I finally figured out that phpmysqladmin was misconfigured, with the same database on two different servers but with different column names. Naturally I was sending the query to the

My databases got hosed when the server went down hard!

Geez, if it ain't one thing it's another. :-( My fbsd server went down hard today, now my mysql database is supposedly gone. I see the .MYD, .MYI, and .FRM files in the /usr/var/db/mysql/ directory, but I get this - mysql> use bulletins Can't read dir of './bulletins/' (Errcode: 13) Database chan

clueless newbie question re merge/union

Greetings, I am attempting to use MySQL's MERGE feature to link tables from different databases. All tables have identical structures, and I need to do this because each table is right up against the 2-Gbyte limit imposed by Linux's ext2 filesystem. System info: OS is RH Linux 7.1 (2.4.3-12smp

Re: WANTED: Utility to reverse engineer existing database II

emacs MJM - Original Message - From: "Kevin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 07, 2001 11:30 AM Subject: WANTED: Utility to reverse engineer existing database II > > Thanks for pointing out mysqldump. > > I now need to be able to copy a limited number o

Zerofill Auto_Increment

Hi All, Not sure if this is a bug or just a standard behavior of a auto_increment zerofill column. I have a column in a MySQL database table assigned as such: memid int(8) auto_increment zerofill primary key, now when the a new row is inserted in fills the column with the appropriate 0's, but

Re: WANTED: Utility to reverse engineer existing database II

Did you see the -w, --where option? It might be what you're looking for... "Dump only selected records." --http://www.mysql.com/doc/m/y/mysqldump.html If you have a more complicated query and you are using Windows, you can use urSQL + MyODBC to accomplish this as urSQL (http://www.urbanres

RE: WANTED: Utility to reverse engineer existing database II

> Thanks for pointing out mysqldump. > > I now need to be able to copy a limited number of data records. > I see that > mysqldump allows data copy by providing the cooresponding INSERT > statements. mysqldump -w / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL

Re: importing data

http://www.mysql.com/doc/L/O/LOAD_DATA.html http://www.mysql.com/doc/m/y/mysqlimport.html http://www.mysql.com/doc/L/o/Loading_tables.html On Tue, 7 Aug 2001, Kevin Fonner wrote: > Is there an easy way or perhaps a utility to import a tab delimeted text > file of data into a mysql table > > T

Driver? - SQLException Error "Before start of result set"

Hi Problems started after I upgraded my Driver from mm.mysql.jdbc-1.2c to mm.mysql-2.0.4-bin.jar, still using MySQL v.3.23.33 on ApacheTomcat (Win2000) where I formerly had the \org\ Driver dir in \classes\ but now have new Driver in \lib\ and haven't unzipped jar. Yes, updated Environ Var'bles p

RE: importing data

Look up IMPORT DATA INFILE in the manual / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq > -Original Message- > From: Kevin Fonner [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 07, 2001 5:09 PM > To: [EMAIL PROTECT

Re: Localization..

Date |Tue, 7 Aug 2001 17:25:48 +0800 >From |"SDiZ Cheng" <[EMAIL PROTECTED]> Hello! SC> I have read these docs. I can't find any charset option in CREATE TABLE SC> syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html

Auditing...

Title: Blank Has anyone built or implemented field level auditing in a mysql database? Any body have a quick down and dirty way of doing this?   Thanks for the suggestions   Wyly Wade Forefront Inc 1413 S. Howard Ave Suite 104 Tampa Fl, 33606 813-253-2267

Re: mysql w/SSL support howto?..

On 07 Aug 2001 16:21:13 +0800, louie miranda wrote: > Is it possible for mysql 3.23.40 to support SSL. > > hm, how? No, from MySQL 4.0 only. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROT

RE: SQL question

Dave Rigby wrote: > Hi, > > Could you create a linked list of the links- i.e. have a 'Next' field, > which contains the ID of the next URL in order. You will also need a > field to store if the link is the first (i.e. root) of the list. Then > you can just iterate though the rows, using the nex

Re: MySql and PHP

On 07 Aug 2001 13:51:01 +0100, Matt Gaskin wrote: > Currently I have rented space on a Web Server that has MySql installed and > PHP, They have created a database directory for myself. Do I need to install > Mysql and PHP locally to take advantage of this. If so where do I start. I > have had no

RE: Speed (char or integer)

> I have a table with (char)Username attribute which is the primary > key of the table and also acts as a foreign key in many other tables. > > My question is if the queries would be faster if i used a numeric > value for the primary key? Integers would be faster, but the question is really

Re: Remote MySQL Console?

Dear Chris, >Is there a method I can use to log into a remote mysql server through something such as >telnet to pass queries on my database? If you have a telnet account on the remote machine, log in. Then start mysql (MySQL monitor, command line tool) which will connect to the MySQL server. You

Re: Truncated User List

Ok, I follow that, in future when moving databases I will use mysqldump. However, I still wish to know why moving the databases by duplicating the files & directory structure does not work. This is 100% repeatable and I can't see why (unless file(s) exist I am not copying). If for some reason s

Save object into MySQL

Hi, I want to save object into MySQL database. Since MySQL in not object relational database, is any problem to save object into it? Which attribute I should select to save object? Varchar BINARAY? Thanks for your help! Zengfa __ Do You Yahoo!?

Re: Remote MySQL Console?

You did not mention what the 'client' or the 'server' were (i.e. NT, UNIX, Mac), or what the 'distance' between the 2 was (over the Internet ?, thru firewalls, etc). If you're trying to connect over any distance on a network, make sure you DON'T use 'telnet' or 'ftp' (or you will find your ser

Re: MySql and PHP

Dear Matt, > have had no experience of the above two products just some useful links: www.phpmyadmin.com www.php.net/documentation www.mysql.com/documentation Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gu

Re: WANTED: Utility to reverse engineer existing database

Dear Kevin, > index, etc.) needed to recreate the database. Does such a utility exist? Yes. It's called PhpMyAdmin, and the recent version supports everything you asked for. You can get it at www.sourceforge.net - look for PhpMyAdmin there. Note: You need to have PHP installed in order to run

Re: Import data question

Dear Chip, you cannot use reserved words as column names. You have "password" as a col name which is a reserved word in SQL. The error derives from there, only MySQL gets it wrong and points you into the wrong direction as to where to search. Regards, -- Stefan Hinz Geschäftsführer / CEO iC

Re: how to delete a database table?

Dear Louie, > how can i delete a database table? Check the manual? http://www.mysql.com/doc/D/R/DROP_TABLE.html DROP TABLE [IF EXISTS] tbl_name [, tbl_name,...] Or something like DROP TABLE my_database.my_table Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions G

Re: Truncated User List

Dear Steve, > (eg adding "drop table columns_priv; before the CREATE TABLE columns_priv; You can use various options for mysqldump, like --add-drop-table. This will add a drop table statement :) Anyway, it's always a good idea to re-create tables and their data. One reason: By default, mysqldum

Re: Tables relationships

Dear Chris, look here: http://www.mysql.com/doc/J/O/JOIN.html It's one of the JOINs (INNER JOIN or LEFT JOIN) you are looking for. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berl

Re: Help in Administration

Dear Carsten, > > Hi, Sorry to bother you people but I've just locked > > myself out of my own DB. Stop the MySQL server (mysqladmin shutdown) and start it again like this: mysqld --skip-grant-tables :) Here's the manual part: http://www.mysql.com/doc/C/o/Command-line_options.html Regards, --

Re: Can't start MYSQL on Linux

Dear Wang, > /usr/libexec/mysql: Can't find file './mysql/host.frm' (errno: 13) It's tricky, but you have to install the two databases (mysql and test) shipped along with the MySQL distribution. Here's that part: shell> ./scripts/mysql_install_db And here's the manual part: http://www.mysql.co

Re: Sub select.

Dear Anders, subselects have not yet been implemented. You can find lots of workaround examples here: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gust

Re: SELECT to get last entry

Dear Eldon, > record for each device ID without retrieving them all to find the most > recent name? SELECT * FROM my_table WHERE ID = LAST_INSERT_ID(ID) Check: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solut

Re: Remote MySQL Console?

Setup a user account that can access your databases from the remote hosts you wish to use. Do this using GRANT. Then install the mysql client on those systems and use mysql -h hostname -u user -p password to connect. Shon Stephens At 01:38 PM 8/5/01 -0400, Chris wrote: >Is there a method I can

RE: MyOdbc to unix

Hi ! > -Original Message- > From: SRIVATSAN RAGHURAMAN [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 07, 2001 6:13 PM > To: [EMAIL PROTECTED] > Subject: RE: MyOdbc to unix > > > Hi Sinisa, > Sorry I should have mentioned this earlier. From Windows. >

Re: Remote MySQL Console?

Get the mysql client from www.mysql.com. Tyler On Sun, 5 Aug 2001 13:38:09 -0400 "Chris" <[EMAIL PROTECTED]> wrote: > Is there a method I can use to log into a remote mysql server through > something such as telnet to pass queries on my database? >

Upgrading to 3.23.37 from 3.22.32

I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was pkg_delete the old MySQL and install the new one. Before I delete the old MySQL I copied all the database files to a temporary location. Once the new installation was successful I copied over all the database files into the proper

Re: Sub select.

Thanks everyone! I did´nt found this URL at first but when I did everything got clearer ;) http://www.mysql.com/doc/M/i/Missing_Sub-selects.html Sorry for all the fuzz and RTFM was the answer! /Anders Den 01-08-07 17.39, skrev "Sam Masiello" <[EMAIL PROTECTED]>: > > You are correct, Tyler.

Re: [MySQL] Database size

Hi! At 02:59 PM 8/7/01 +0300, you wrote: >Grigory Bakunov writes: >> Date |Fri, 3 Aug 2001 17:21 +0200 >> >From |TIGNAC BRUNO <[EMAIL PROTECTED]> >> >> Hello! >> >> TB> --- Reçu de CMB.TIGNABR 0298426574 03-08-01 17.21 >> >> TB> Hello, >> >> TB> I plan to use MySQL/I

RE: Sub select.

You are correct, Tyler. http://www.mysql.com/doc/M/i/Missing_Sub-selects.html The above URL has some more information on this. HTH :) Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Tyler Longren [mailto:[EMAI

WANTED: Utility to reverse engineer existing database II

Thanks for pointing out mysqldump. I now need to be able to copy a limited number of data records. I see that mysqldump allows data copy by providing the cooresponding INSERT statements. However, I don't always want all of the records. Some of my tables have thousands of records and I may only

Re: Nested Queries in MySQl

You can also do it programatically. I find, even with MySQL that this is faster since it avoids the NxM intermediate table creation where one can limit the number of rows intially. I'm using Debian so I'm stuck on .22 for now, this might change in .23. It would definitely be the way to go fo

Re: Can't start MYSQL on Linux

chown -R mysql /var/lib/mysql Ling Wang wrote: > I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was > installed together with the Redhat Linux. I can not start the mysql > server by executing /usr/bin/safe_mysqld &. It always ends immediately. > When I look at the /var/log/

importing data

Is there an easy way or perhaps a utility to import a tab delimeted text file of data into a mysql table Thanks, -- Kevin Fonner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://li

Re: SQL question

Hi, Could you create a linked list of the links- i.e. have a 'Next' field, which contains the ID of the next URL in order. You will also need a field to store if the link is the first (i.e. root) of the list. Then you can just iterate though the rows, using the next field to tell you which URL is

Re: Timezone problem.

Hi! No idea what is wrong. Below is the code which prints the timestamp in InnoDB: . struct tm cal_tm; struct tm* cal_tm_ptr; time_t tm; time(&tm); #ifdef HAVE_LOCALTIME_R localtime_r(&tm, &cal_tm); cal_tm_ptr = &cal_tm; #else cal_tm_ptr = localtime(&tm); #en

Re: Sub select.

On 07 Aug 2001 14:57:33 +0200, Anders Alstrin wrote: > SELECT * FROM media > WHERE media_id = (SELECT media_id FROM category_locks > WHERE category_id = (SELECT category_id FROM categories > WHERE dynamic_media = 'true')) > > A MySQL way to do it? Something like that should work: SELECT * FROM

Re: Sub select.

Anders Alstrin <[EMAIL PROTECTED]> writes: > Does anyone know how to do this sub select in MySQL. MySQL doesn't have subselects. Some workarounds can be found at http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#Missing_Sub-selects PostgreSQL supports them. -- Tron

Re: Some questions About DBMS.

On 07 Aug 2001 22:18:04 +0900, Heo, Jungsu Mr. wrote: > > Umm. MySQL AB Has any plan to make MMDB or Embedded DBMS? > > (Last month's survey asked us 'bout Embedded DBMS) Yes we are working hard to get embedded MySQL version possible in MysQL 4.0. This should make life easier for many software

mysql+gemini compile errors

Hello, SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc gcc version 2.95.3 20010315 (release) I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box. I get the following error which has me completly confussed: ctstset: Compile tstset.cc --> tstset.[c|s] --> tstset.o Assembler:

Re: Timezone problem.

Hello Michael, Tuesday, August 07, 2001, 10:20:18 PM, you wrote: OK guys I think I've found the problem. It seems like new innodb version (40b) does something bad with time. I've tested 3 binaries 1) Plain .40 with normal GLIBC -> OK 2) Plain .40 with patched GLIBC -> OK 3) Plain .40 with new

Re: MySql and PHP

Matt: MySQL and PHP are both 'server-side' components, so there is no need to instal them locally (unless, of course, you want to do your development and testing off-line). If you are doing any significant level of PHP work, I would suggest installing a local version of both MySQL and PHP. I hav

RE: Sub select.

you can rewrite this query to simple joins so you dont use sub selects. select media.media_id , media.price, media.filename from media,category_locks,categories where media.media_id = category_locks.media_id and category_locks.category_id = categories.category_id and categories.dynamic_media = 't

Re: Timezone problem.

Peter Zaitsev writes: > Hello mysql, > > It seems like you made an incomportable changes in 3.23.40 without > taking a time to write a release note :( > > The mysql 3.23.39 used the system timezone by default: > > maindb:/spylog/mysql/logs # date > Tue Aug 7 13:31:56 MSD 2001 > > | tra

  1   2   >