Extracting fields from a table

Claire, Thursday, February 07, 2002, 12:35:07 AM, you wrote: CF> I want to select all entries in my table that in a column with given CF> dates findes all dates inbetween $from_date - $to_date. (These are CF> vars that the user supplies from the HTML-page). I don't know how to set CF> up the S

What is MySQL-MAX.

sreedhar, Thursday, February 07, 2002, 9:41:24 AM, you wrote: s> Hi , s> I am already using MySQL 3.23.26, which is available by Redhat LINUX 7.1 s> If I would like to update to newer version I found the following s> What is MySQL-MAX. s> RedHat packages (rpm) s> MySQL 3.23.47 Server (i386)

MyODBC 3.51 driver - General SQL error

Hi all, I would like to know what means the following error in my application: General SQL Error [MyODBC][ODBC 3.51 Driver][mysqld-3.21.33b-log]parse error near '`id`,`dia`,`mes`,`ano`,`pernormal`,`pernoturno`,`totdia`,`local`,`descricao`' at line 1. My application was developed in Delphi

INSTALLATION and CONNECTION problem

Hi All, To Update current version on my new Redhat LINUX server I uninstalled MySQL 3.23.26 rpm and installed all MySQL3.23.47 rpms. When I tried to connect through shell > mysql -u root mysql Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). Please let me w

Re: dumping between tables?

> > I want to dump the contents of one table in to another table > > which has the same structure in MySQL, with just one column type changed > > from VARCHAR to TEXT. Whats the best way to do this? > > > Would INSERT...SELECT suit you? > =dn > > Yes, but it's a big table. Is there a way to d

Re: dumping between tables?

Hi Paul, > I want to dump the contents of one table in to another table > which has the same structure in MySQL, with just one column type changed > from VARCHAR to TEXT. Whats the best way to do this? Would INSERT...SELECT suit you? =dn --

Re: Print file

Christo: Write a query that does what you want to a text file called virtusertable.sql: USE databasename; SELECT name FROM tablename; Then run the query from the command line (mysql -uusername -p databasenamevirtusertable.txt) Gerald Jensen - Original Message - From: "Christo Rademeyer"

RE: dumping between tables?

Hello Paul, Why don't you just use mysqldump to dump the data to a textfile, and then insert the data from the textfile into your new table? --- Alain Fontaine Consultant & Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: Paul

RE: long query on php

Have you tried just putting the querys into a variable and pass the var along to mysql_query() ? Did it not work? --- Alain Fontaine Consultant & Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: savaidis [mailto:[EMAIL PROTECTE

long query on php

How is possible to pass a long query to MySQL server with php? I mean i.e a "create table" statement with more than 400 chars. Have I to use shorter "create" and then "alter"? Thanks Makis - Before posting, please check: ht

dumping between tables?

Re: sql query Hi, I want to dump the contents of one table in to another table which has the same structure in MySQL, with just one column type changed from VARCHAR to TEXT. Whats the best way to do this? Paul - Before

Re: PostgreSQL

Shankar Unni writes: > > > And one big reason not: no native Windows port. Or Mac port (though that > has probably changed with OS/X - anyone working on that?). > > Cygwin is dandy, but I definitely don't trust a database that uses cygwin > as an emulation layer underneath for basic file acce

Re: Print file

Hi Christo, > How can I take info from one table and print it into a txt file. > the table is (NAME) > and all the names in it I want to print out to a file name virtusertable. Would SELECT ... INTO OUTFILE 'file_name' suit you? (MySQL manual: 6.4.1 SELECT Syntax) Regards, =dn ---

domain name bug

Not sure if thius is supposed to go here but my version of MySQL mysql> status; -- mysql Ver 11.15 Distrib 3.23.45, for pc-linux-gnu (i686) the GRANT command errors out when the domain name has a '-' dash in it. mysql> grant Select, Insert, Update, Delete on X.* to [EMAIL PROTEC

Re: 1 billion row

Check that your file size limit on your machine is more than the usual 4GB. I have a 23 million row database, and it translates into 3GB data file, 3GB index file. 1 billion records would never fit. My record length is about 300 bytes. If you need more than a 4GB data file, you should check o

Re: regarding mysql DATE support

Hai, Where? Here! > is there any support of sys_date in mysql which is strong feature in oracle > 8.x . i am using MYSQL 3.23 server version . Short answer: RTFM 6.3.4 Date and Time Functions Don't have an Oracle book with me, please refresh my memory of the exact output from sys_date/you r

Re: regarding mysql DATE support

Hi, Now(), sysdate(). Anvar. At 03:02 PM 07/02/2002 +0530, you wrote: >Hai , > >is there any support of sys_date in mysql which is strong feature in oracle >8.x . i am using MYSQL 3.23 server version . > > >With Warm Regards > >[EMAIL PROTECTED] >JIN INformation Systems(P) Ltd >Voice : 527530

Backup Database MySQL to a Tape Backup

Howto backup databases MySQL direct to a Tape Backup. André Sartori [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

mySQL 4 - FullText searching syntax?

Hello, I am evaluating mySQL 4.0.1-alpha on Redhat Linux 7.2 (RPM version). I am playing with the new fulltext search features and I have a question regarding the syntax... I have created a fulltext index on a field 'Notes'. I'd like to search for records that have words starting with "app

JDBC Driver

Hi!!! I am using the Mysql JDBC Driver 2.0.11. I am trying to use the methods getImportedKeys(), and getExportedKeys() But it returns an empty result set. I am using Innodb tables. Thanks Amit - Before posting, please c

mysql replication....

Placed At : Hi all... I was curious to know if mysql replication would be possible based on specific rows in a table rather than the replicating the whole table.. I have a set up which has slaves spread across geographically. and my master has a t

Re: MySQL RE: insertion problem !!

Chetan, the type of the column user_id is different in your two tables: in the parent table it is UNSIGNED, but signed in the child table. The internal storage format of a signed integer is different from an unsigned integer. That is why adding the child row fails. I changed now InnoDB-3.23.48 s

long query status info

hi, i'm running a big query across a table containing more than 137 million rows comparing them to another one with about 4000 rows and i'm wondering how long it will still take... is there a way to see how many operations have been made and how many are left? as you can see it already took

Fw: Print file

Hi all How can I take info from one table and print it into a txt file. the table is (NAME) and all the names in it I want to print out to a file name virtusertable. Thanx Christo sql,query - Before posting, please c

regarding mysql DATE support

Hai , is there any support of sys_date in mysql which is strong feature in oracle 8.x . i am using MYSQL 3.23 server version . With Warm Regards [EMAIL PROTECTED] JIN INformation Systems(P) Ltd Voice : 5275300/5097603/5097604/5281822 ext 218 www.jinis.com With Warm Regards [EMAIL PROTECTED]

FW: MySQL RE: insertion problem !!

hi, I have two tables as : please concentrate on domain_id and INDEX Create table ls_domain ( domain_id INT(4) UNSIGNED AUTO_INCREMENT , domain_addr VARCHAR(80), domain_name CHAR(50) UNIQUE KEY, domain_port INT(6) UNSIGNED, domain_ip VARCHAR(15), created_by VARCHAR(40), created_date

MySQL RE: insertion problem !!

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 2:22 PM To: Chetan Lavti Subject: Re: insertion problem !! Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter

Re: Errors that i can't see find in the help system on mysql

You probably either need to increase the ulimit on file descriptors for that process, or increase the total number of file descriptors for the kernel. > 020206 15:11:47 mysqld started > /usr/pkg/libexec/mysqld: ready for connections > 020207 1:02:00 Error in accept: Too many open files

RE: Errors that i can't see find in the help system on mysql

Oops i was a bit hasty, this problem occurs after the mysql has been running for a little while, kill the mysql and restart it and it can run just fine again for a while. Terkel > -Original Message- > From: Terkel Olsen > Sent: 7. februar 2002 09:24 > To: '[EMAIL PROTECTED]' >

Errors that i can't see find in the help system on mysql

020206 15:11:47 mysqld started /usr/pkg/libexec/mysqld: ready for connections 020207 1:02:00 Error in accept: Too many open files 020207 1:06:19 Error in accept: Too many open files 020207 1:10:37 Error in accept: Too many open files 020207 1:14:56 Error in accept: Too many open files 020

<    1   2