RE: long query

2003-03-19 Thread Michael Shulman
Each line in MySQL is terminated with a semicolon (;). You can break your query into as many lines as you need, and just end the last one with a semicolon. C:\mysql\bin>mysql --user=root -p Enter password: ** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection

Embedded MySQL?

2003-03-19 Thread Roland Bengtsson
Hi, I have a question I hope you can help me with. I try to develop a database in Borlands Delphi or with C++ and Visual Studio 6 (Windows 2000). Probably I choose Delphi. Now I want to use MySQL as a platform for my program. According to http://www.mysql.com/doc/en/libmysqld_overview.html I can r

long query

2003-03-19 Thread geeta varu
if there is a long query i want to continue it in next like eg> Select canID from table1 where(text like '%a%' or text lik e '%b%') AND canID not in ( text like '%c%' or canID like '%d%') here i want to use some concatenation of lines any solution _

difference between 3.23.41 3.23.32.

2003-03-19 Thread RamananK
Kindly help. Where can I the difference between MySql versions 3.23.41 and 3.23.32. thanks in advance Ramanan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: appending to longtext field

2003-03-19 Thread Jeff Shapiro
At 1:50 + 3/20/03, Mr Orange wrote: GV wrote: I think is better to have an additional record each time a user inserts new information Mr Orange wrote: Hello all, I have a database with a type "longtext" called "notes". Say I wanted to append some text to this field, what command would

Re: appending to longtext field

2003-03-19 Thread Mr Orange
GV wrote: > I think is better to have an additional record each time a user > inserts > new information > > Mr Orange wrote: >> Hello all, >> >> I have a database with a type "longtext" called "notes". >> >> Say I wanted to append some text to this field, what command would I >> use? >> >> I have t

Re: JDBC Question [Using Multiple databases]

2003-03-19 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark C. Roduner, Jr. wrote: Scenario: The current JDBC Connection is jdbc:mysql//localhost:3306/=xql?user=root&password=myrootpass The database `xql` contains 1 table, `settings` Another database, `login` contains 1 table, `users` 'm' is a Matcher

Installation failure

2003-03-19 Thread Adam Stern
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Installation failure Description: I downloaded the "MYSQL Complete" package f

Reported to SpamCop

2003-03-19 Thread Alan W. Rateliff, II
A few minutes ago I noticed the emails from MySQL list were being rejected at my server because of the mysql.com server being listed in SpamCop. Information from http://spamcop.net/w3m?action=checkblock&ip=62.119.101.229 reveals that some of the spam messages that have made it through the list wer

JDBC Question [Using Multiple databases]

2003-03-19 Thread Mark C. Roduner, Jr.
Scenario: The current JDBC Connection is jdbc:mysql//localhost:3306/=xql?user=root&password=myrootpass The database `xql` contains 1 table, `settings` Another database, `login` contains 1 table, `users` 'm' is a Matcher Object, that contains the users Name i

Re: MySQL 4.0.12

2003-03-19 Thread Paul DuBois
At 19:38 -0500 3/19/03, Stephen Tiano wrote: Re: this latest version of MySQL. Has anyone installed a production version of MySQL 4 on the Macintosh platform yet? Anything significant to report? Advice not to do it yet? You can't use BDB tables. Thank you. Steve Tiano -- Paul DuBois http://ww

Re: MySQL 4.0.12

2003-03-19 Thread Stephen Tiano
Re: this latest version of MySQL. Has anyone installed a production version of MySQL 4 on the Macintosh platform yet? Anything significant to report? Advice not to do it yet? Thank you. Steve Tiano - Before posting, please che

Re: Column comment / metadata tables

2003-03-19 Thread Stephen Brownlow
> Basically, what I would like to do is associate a human readable label with > each column (in the comment field) so that I can automatically generate > web-based forms for any given table. The script would look at the column's > metadata, display the appropriate HTML element, and display the > co

New UNION ALL and problem with ORDER BY ?

2003-03-19 Thread Mike Lemke
Hello MySQL Guru's- This is regarding UNION support in MySQL 4.0.12. The query below is attempting to return rows that can be easily parsed for the purposes of creating XML. The ORDER BY is not being processed properly at the end of the query. Sample scripts are shown below, to setup the DB and

Re: Problems with the api c++

2003-03-19 Thread Warren Young
Tuomas Heroja wrote: I have red hat 8.0, gcc-3.2-7, gcc-c++-3.2-7 and mysql++-1.7.9-3.rh8x.i386.rpm. When I use the command g++ -I/usr/include/sqlplus myfirstdatabaseprogram.cpp, I get several basic errors concerning the include file Right now, MySQL++ isn't very well tuned for modern C++ environm

Re: another table to query!

2003-03-19 Thread Bruce Feist
Andrew wrote: ok this is making sense and I should have thought about this before* I created my city table as now I have a city table that in effect is useless and comlicated the existing queries :( Well, your city table probably isn't useless... it can be used to translate city IDs into city na

Re: Help with Query

2003-03-19 Thread Daren Cotter
Thanks, this works great in the MySQL server...I guess I've never used temp tables before, but when I try to run this in a PHP script, I get "table does not exist". How do I do this? --- Harald Fuchs <[EMAIL PROTECTED]> wrote: > In article > <[EMAIL PROTECTED]>, > Daren Cotter <[EMAIL PROTECTED]>

Re: Error 1030 during import batch

2003-03-19 Thread Paul DuBois
At 17:18 -0500 3/19/03, Tab Alleman wrote: Me again, new problem further down the same road: C:\mysql\bin>mysql < \dev_hotel_data.sql ERROR 1030 at line 73106: Got error 28 from table handler C:\mysql\bin>mysql < \dev_hotel_data.sql ERROR 1030 at line 74097: Got error 28 from table handler  Yes, j

Error 1030 during import batch

2003-03-19 Thread Tab Alleman
Me again, new problem further down the same road: C:\mysql\bin>mysql < \dev_hotel_data.sql ERROR 1030 at line 73106: Got error 28 from table handler C:\mysql\bin>mysql < \dev_hotel_data.sql ERROR 1030 at line 74097: Got error 28 from table handler Yes, just as it looks, the same error occurred

Re: Query Help

2003-03-19 Thread Ryan McDougall
--- Andrew <[EMAIL PROTECTED]> wrote: > Hi All MySQL guru's > > I have a query that I need some help with. I have put into operation a setup > that needs to be chnaged and could do with a little help before the Db get > any > bigger. It's only a small MySQL DB at the moment but will grow so I nee

Re: The MySQL Backup problem

2003-03-19 Thread Paul DuBois
At 16:11 -0300 3/19/03, Dyego Souza do Carmo wrote: Hi, I am developing a mySql Backup software and I intend to develop two different options for backup: Complete and Incremental, where Complete means the full copy of a database, and Incremental means that only the log file have to be copied

RE: Restoring from a .sql file

2003-03-19 Thread Paul DuBois
At 14:56 -0500 3/19/03, Tab Alleman wrote: Paul DuBois wrote: Line 7 is: USE `cm_central`; Try omitting the backticks from the database name. mysql has a slightly different parser than the server and that may be causing you a problem with the USE statement. Thanks again Paul, that did the tr

RE: Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Paul DuBois
At 21:21 +0100 3/19/03, Yasen Petrov wrote: how to ececute it from dos prompt as long as I have to connect to mysql first. so i'll have mysql prompt anyway. please give me a better explanation. thank you Uh, sorry. Apparently you didn't even *try* to use the instructions given, so I will just repe

Column comment

2003-03-19 Thread Ruvinskiy, Ray
Hi, I am aware of the fact that with 4.1.0, you can specify comments on a column by column by basis. I was wondering if this functionality could somehow be simulated in 4.0.x? It is high priority for me, but I cannot deploy the alpha stage 4.1.0 in a production environment. Basically, what I woul

Query Help

2003-03-19 Thread Andrew
Hi All MySQL guru's I have a query that I need some help with. I have put into operation a setup that needs to be chnaged and could do with a little help before the Db get any bigger. It's only a small MySQL DB at the moment but will grow so I need to get this right now before it gets bigger. An

RE: another table to query!

2003-03-19 Thread Andrew
ok this is making sense and I should have thought about this before* I created my city table as now I have a city table that in effect is useless and comlicated the existing queries :( A lesson to be learnt indeed. >-Original Message- >From: Bruce Feist [mailto:[EMAIL PROTECTED] >Sent: 1

Re: fulltext search

2003-03-19 Thread Heikki Tuuri
Sidar, - Original Message - From: ""Sidar Lopez Cruz"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, March 18, 2003 10:50 PM Subject: fulltext search > > > > > when MySQL will support fulltext search on InnoDB tables? we are still waiting for some customer t

RE: Restoring from a .sql file

2003-03-19 Thread Tab Alleman
Paul DuBois wrote: >> Line 7 is: >> USE `cm_central`; > Try omitting the backticks from the database name. > > mysql has a slightly different parser than the server and > that may be causing you a problem with the USE statement. Thanks again Paul, that did the trick...which is kind of a BitterSw

RE: Restoring from a .sql file

2003-03-19 Thread Paul DuBois
At 14:07 -0500 3/19/03, Tab Alleman wrote: Thanks for the replies, Ryan and Paul. I tried the suggestion of using the command prompt, and it did attempt to run the .sql file. That's when it *really* gets troublesome: C:\mysql\bin> mysql < \mysql\cm_central.sql ERROR 1049 at line 7: Unknown databa

Re: optimizer bug in the index used by mysql/Innodb in the search

2003-03-19 Thread Peter Zaitsev
On Tue, 2003-03-18 at 21:38, [EMAIL PROTECTED] wrote: > Description: > > Hello Peter, > > Have you explained to Heikki this problem? > Have you fixed it? > > Please, tell me about it. > Dear Rafarife, This problem is qualified as wrong optimizer plan selection. Happily yo

Re: OS X codewarrior libraries

2003-03-19 Thread ben nevile
To be honest, I've never tried to compile MySQL with the CodeWarrior compiler - it sounds like nobody has! i guess i'll be the guinea pig. I'd be interested to hear how it went! i'll be sure to let everyone know (ie, gloat) if I am successful. Ben --

RE: Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Yasen Petrov
how to ececute it from dos prompt as long as I have to connect to mysql first. so i'll have mysql prompt anyway. please give me a better explanation. thank you - Before posting, please check: http://www.mysql.com/manual.php

The MySQL Backup problem

2003-03-19 Thread Dyego Souza do Carmo
Hi, I am developing a mySql Backup software and I intend to develop two different options for backup: Complete and Incremental, where Complete means the full copy of a database, and Incremental means that only the log file have to be copied. The logic is the follow: Once a week, my custo

AUTO_INCREMENT Columns reacting differently to MyODBC

2003-03-19 Thread Andrew Kuebler
In one of my tables, I have an AUTO_INCREMENT column that changes to "#Deleted" in each column in Access when I add a new record. To read the data, I just entered, I must close the table and then reopen it. In another table when I do the same thing, I see the new AUTO_INCREMENT number come up in th

Re: Process Limit on Linux ?

2003-03-19 Thread walt
On Wednesday 19 March 2003 12:38 pm, Dan Nelson wrote: > In the last episode (Mar 19), Philipp said: > > i just talked about openmosix because i read about shared memory > > segments. my only desire is to make mysql able to spawn 1000-1500 > > connections and *not* to tell my client "cant create ne

RE: Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Tab Alleman
Hehe.. I just got past this problem and on to the next. You need to make sure you are executing the command from a DOS prompt..the response you got indicates (I'm pretty sure) that you are executing it from a mysql> prompt (ie: a mysql client prompt). Yasen Petrov wrote: > Hello, > > I'm using W

RE: Restoring from a .sql file

2003-03-19 Thread Tab Alleman
Thanks for the replies, Ryan and Paul. I tried the suggestion of using the command prompt, and it did attempt to run the .sql file. That's when it *really* gets troublesome: C:\mysql\bin> mysql < \mysql\cm_central.sql ERROR 1049 at line 7: Unknown database '`cm_central`' Line 7 is: USE `cm_cent

Re: Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Joe Lewis
I know DOS doesn't have a "cat" command, so try : type create_president.sql > samp_db Or have I been out of the DOS world too long? Joe Yasen Petrov wrote: Hello, I'm using Win98 OS and MySQL 3.23.39-max. Now, I'm trying to load data from the DOS Prompt into a new database (samp_db): samp_db

Re: Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Paul DuBois
At 20:57 +0100 3/19/03, Yasen Petrov wrote: Hello, I'm using Win98 OS and MySQL 3.23.39-max. Now, I'm trying to load data from the DOS Prompt into a new database (samp_db): samp_db < create_president.sql and it returns ERROR 1064: you have an error in your sql syntax near 'samp_db < create_presid

Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Yasen Petrov
Hello, I'm using Win98 OS and MySQL 3.23.39-max. Now, I'm trying to load data from the DOS Prompt into a new database (samp_db): samp_db < create_president.sql and it returns ERROR 1064: you have an error in your sql syntax near 'samp_db < create_president.sql' at line 1 Any ideas will be highl

Custom Authentication Mechanisms

2003-03-19 Thread Joe Lewis
Hello, all! I would like to alter MySQL in the following manner : - If the standard MySQL [PASSWORD()] fails, use PAM to auth - If the user is authenticated using PAM : - If a database does not exist of the users name, create it - Restrict the datamanipulation to that specific data

RE: Strange problem on the difference of mysql connection between cgi and shell

2003-03-19 Thread Jennifer Goodie
It is not strange, it is expected behavior. A browser can only handle so many lines of html before getting all wonky. Running a query that takes over 5 minutes to run in a web application is a bad idea, no one is going to want to sit there and wait for it and if there is no output for an extended

Re: Restoring from a .sql file

2003-03-19 Thread Paul DuBois
At 12:31 -0500 3/19/03, Tab Alleman wrote: MySQL 3.23.54, Win2k Server: I am trying to take a .sql file that I got from a mysqldump from one mysql server, and use it to populate a new mysql server, as though I were restoring a backup after a total system crash. I am using the following command, fo

Re: Restoring from a .sql file

2003-03-19 Thread Ryan Fox
On Wednesday 19 March 2003 12:31 pm, Tab Alleman wrote: > I am using the following command, following the only example I could > find in the documentation ("mysql>" prompt shown for clarity): > > mysql> mysql < u:/db backup 20030318/cm_central.sql; Run this from a command line, not the mysql clien

Re: another table to query!

2003-03-19 Thread Bruce Feist
Andrew wrote: I have done this and have now started to populate the items_city table with the appropriate records what I now need to do is show the records using the city items_table. At the moment the records are displayed when a city is selected bu the cityID is from the items table. Like this:

Re: Re: another table to query!

2003-03-19 Thread Bruce Feist
Andrew wrote: I have just discovered through luck that I need to have the same record in (table items) accessable if it is listed as being in more than one city (table city). Obviously I don't want to create new records for the same item so it can be displayed if it's in different cities. Is the

Re: appending to longtext field

2003-03-19 Thread GV
I think is better to have an additional record each time a user inserts new information Mr Orange wrote: Hello all, I have a database with a type "longtext" called "notes". Say I wanted to append some text to this field, what command would I use? I have tried the following sql.. update clien

Re: Text formatting of articles pulled from database??

2003-03-19 Thread Henning Heil
Landy Atkinson wrote on 19.03.2003 18:14 ... echo "$article"; The text displays, but the paragraph breaks are gone and all the text is just run together into one long paragraph. Any suggestions on how to get $article to display and keep the white space between paragraphs that it ha

Re: Process Limit on Linux ?

2003-03-19 Thread Dan Nelson
In the last episode (Mar 19), Philipp said: > i just talked about openmosix because i read about shared memory > segments. my only desire is to make mysql able to spawn 1000-1500 > connections and *not* to tell my client "cant create new thread, > perhaps out of memory" while 1.5 GB of RAM is only

Re: Text formatting of articles pulled from database??

2003-03-19 Thread Stefan Hinz
Landy, > echo "$article"; > The text displays, but the paragraph breaks are gone and all the text > is just run together into one long paragraph. In PHP, you can use nl2br(), like: echo "".nl2br($article).""; This will replace "\n" (the new-line character that makes that line break in TEXTARE

Restoring from a .sql file

2003-03-19 Thread Tab Alleman
MySQL 3.23.54, Win2k Server: I am trying to take a .sql file that I got from a mysqldump from one mysql server, and use it to populate a new mysql server, as though I were restoring a backup after a total system crash. I am using the following command, following the only example I could find in t

appending to longtext field

2003-03-19 Thread Mr Orange
Hello all, I have a database with a type "longtext" called "notes". Say I wanted to append some text to this field, what command would I use? I have tried the following sql.. update clients set notes=notes+"text to append" where id=1; But this doesn't seem to do the job. I am new to MySQL so

Re: Process Limit on Linux ?

2003-03-19 Thread Joseph Bueno
Hi, You may get a signal 11 because mysqld process is running out of virtual memory (instead of physical memory). If you want to run 1500 simultaneous connections, you have to be very careful on how mysqld allocates its memory: Since you are on a 32bits system, a process is limited to 4Gb. On Linu

RE: another table to query!

2003-03-19 Thread Andrew
I have done this and have now started to populate the items_city table with the appropriate records what I now need to do is show the records using the city items_table. At the moment the records are dipslyed when a city is selected bu the cityID is from the items table. Lie this: $result=mysql_q

Text formatting of articles pulled from database??

2003-03-19 Thread Landy Atkinson
I am setting u a simple article storage/retrieval system and have set up a MySQL database with a few VARCHAR fields for author, date, source and a BLOB field for article. I have also set up two pages, one for editing/adding new articles and a second one for viewing the articles. The adding/de

Re: OS X codewarrior libraries

2003-03-19 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, sorry for the late reply. On Wed, 5 Mar 2003, ben nevile wrote: > > Please define "not compatible". What exactly happens when you try to > > use them? Is there an error? Which version of MySQL/Code Warrior do > > you use? > > I am using the most

Re: please rename dbug.h

2003-03-19 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 14 Mar 2003, Jonathan Stockley wrote: > I've hit a problem on AIX 4.3 with mysql client include files. My app > needs to include which includes . The problem is that > I also need to access mysql. It turns out that the mysql include > di

Re: [PATCH] 1 line fix for gen_lex_hash.cc

2003-03-19 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 9 Mar 2003, SUGIOKA Toshinobu wrote: > I found obvious bug that causes segmentation fault while building on > sh-linux. Please apply. > > --- mysql-3.23.54a.orig/sql/gen_lex_hash.cc Thu Dec 5 18:37:06 2002 > +++ mysql-3.23.54a/sql/gen_lex

Re: Problem reinstalling MySQL on Mac OS X

2003-03-19 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, thanks for reporting this. I assume, you used the MySQL package from mysql.com? On Thu, 6 Mar 2003, Perry Arnold wrote: > I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X > machine (version 10.2.4) and I couldn't get it to star

Re: Process Limit on Linux ?

2003-03-19 Thread Philipp
Hi Dan, i just talked about openmosix because i read about shared memory segments. my only desire is to make mysql able to spawn 1000-1500 connections and *not* to tell my client "cant create new thread, perhaps out of memory" while 1.5 GB of RAM is only used for caching. Is that really possible

FW: another table to query!

2003-03-19 Thread Andrew
>Hi All MySQL ers > >I am now starting to confuse myself so everyone else should be just >fine with this query problem / clarification! > >I have just discovered through luck that I need to have the same >record in (table items) accessable if it is listed as being in more >than one city (table

another table to query!

2003-03-19 Thread Andrew
Hi All MySQL ers I am now starting to confuse myself so everyone else should be just fine with this query problem / clarification! I have just discovered through luck that I need to have the same record in (table items) accessable if it is listed as being in more than one city (table city). Obvi

Re: Process Limit on Linux ?

2003-03-19 Thread Dan Nelson
In the last episode (Mar 19), Philipp said: > thank you for your answer. While i was reading about clustering some > weeks ago i read the openmosix FAQ claiming that openmosix would not > work with apache, because apache was using shared memory to > communicate with its threads, and i always though

AW: EMS MySQL Manager for Linux 1.15 released!

2003-03-19 Thread Rusch (ext) Reiner
Hi, ok, no doubt about that's related software would be nice to informed about here. But what I found amazing that there wasn't a discuss just a non-related hint to get back in mind But if I'm lonely with my opinion, there's no problem for me! 2EMS HiTech Team: BTW, I'm not a member of Siemen

Re: how to display blob data back to text

2003-03-19 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul DuBois wrote: At 5:39 -0800 3/19/03, Karthikeyan Balasubramanian wrote: Hi, I m using the following query SELECT id, subject, news, date_format(date, '%m/%d/%Y %h:%i %p') AS date, author, link FROM news

Re: MySQL 4.1 for OS X compiling problems

2003-03-19 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 19 Mar 2003, Michael Edlund wrote: > I'm trying to compile MySQL 4.1 on Mac OS 10.2.4 (Darwin Kernel Version > 6.4) but run into some problems. When following the general compilation > guidelines... [...] > ...the make process exits wit

ʱÉн»ÓÑ

2003-03-19 Thread ÃÃÍø
http://since.vip.sina.com/shoujijiaoyou.html";>http://since.vip.sina.com/pic2/yzjiaoyou.gif"; width=730 height=59 border=0 alt="亚洲真情交友中心"> 邮件内容与以下文字无关= 优联网络 http://www.chinamysql.com 专业提供各类虚拟主机,不满意可获退款。 强势套餐:100M主机送顶级域名,送10个10M企业油箱,加送20个

Re: how to display blob data back to text

2003-03-19 Thread Paul DuBois
At 5:39 -0800 3/19/03, Karthikeyan Balasubramanian wrote: Hi, I m using the following query SELECT id, subject, news, date_format(date, '%m/%d/%Y %h:%i %p') AS date, author, link FROM news ORDER BY id DESC LIMIT 5 heres my table structure CREATE TABLE

Re: Fw: problem about bulk insertion

2003-03-19 Thread gerald_clark
How do you know these possibly duplicate records are not already in the table? What is wrong with adding a unique index on (fld2,fld3) ? Hu Qinan wrote: >Dear all, > >I intend to write a large volume of records to a table tbl. > >tbl: >fld1, int unsigned not null auto_increment primary key, >fl

Re: mysqladmin processlist = weird in version 4.0.12

2003-03-19 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 18 Mar 2003, Andrew Braithwaite wrote: > Anyone know why "mysqladmin processlist" is not showing the host that is > connected, but instead is showing the following in v4.0.12: > > <> > +-+-+--+--+---

Re: InnoDB Foreign Key

2003-03-19 Thread Rafal Jank
> > > Dear all, > > how can I remove a foreign key in InnoDB? > > ALTER TABLE DROP (FOREIGN) KEY `key` > > isn't working (and also not specified in documentation)... : ( > > > > > It's not implemented yet. You can copy your data to another table without > the foreign key constraint, drop origin

how to display blob data back to text

2003-03-19 Thread Karthikeyan Balasubramanian
Hi, I m using the following query SELECT id, subject, news, date_format(date, '%m/%d/%Y %h:%i %p') AS date, author, link FROM news ORDER BY id DESC LIMIT 5 heres my table structure CREATE TABLE news (

Re: Mysql, Need extra Cash? - Get Paid in 48hrs - Home Reps Needed .Com home representatives are required!

2003-03-19 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- ...and then Roger Davis said... % % Maybe the "[EMAIL PROTECTED]" address should be changed to % "[EMAIL PROTECTED]" so people can't pull the Username off the e-mail % address and bypass the filter. 1) There were some changes to the filte

InnoDB Foreign Key

2003-03-19 Thread Thorsten Schmidt
Dear all, how can I remove a foreign key in InnoDB? ALTER TABLE DROP (FOREIGN) KEY `key` isn't working (and also not specified in documentation)... : ( Thanks and best regards Thorsten (For bypassing the Filter: Here is sql,query,queries,smallint) -

re: Can it be true?

2003-03-19 Thread Egor Egorov
On Tuesday 18 March 2003 22:34, Salada Duncan wrote: > Is it possible? Can it really be true? I check the website daily and > watch the lists eagerly. As I looked at the website just now, I saw it... > > Database Server > Production: 4.0.12 > > Did I miss the announcement? Yup ;) http:

Test Please Ignore :)

2003-03-19 Thread Karthikeyan Balasubramanian
Test -- Karthikeyan Balasubramanian [EMAIL PROTECTED] -- http://www.fastmail.fm - Access your email from home and the web - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

îò Ýëåêñ îáîâëåííàÿ èíôîðìàöèÿ.

2003-03-19 Thread elex . izdvo
РАЗОВОЕ ИНФОРМАЦИОННОЕ СООБЩЕНИЕ для Mysql Издательство "ЭЛЕКС" (шесть лет работы на российском рынке)предлагаетподписку на ежемесячно выходящую на дисках CD-ROM справочную правовую систему "Законодательство России" (федеральный и региональный выпуски). Федеральны

View all temporary tables in a database

2003-03-19 Thread Ahmed S K Anis
HI, I create temporary tables using the query CREATE TEMPORARY TABLE .. How do i list all the temporary tables in the database "SHOW TABLES STATUS " does not show the temporary tables. Thanks Anis - Before posting,

Re: This query shouldn't be wrong, but mysql says it is???

2003-03-19 Thread Lai Liu-yuan
I reread the mysql manual again, and found the little piece I've missed : version 4!! That's the problem. Thanks for your reply. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.m

back to GRANT and database wildcards

2003-03-19 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- After experimenting with the input from Benjamin I can GRANT all I want, but still only on a single database (though if I know the name I can do so in advance of its creation). This still seems a little troublesome. I expect that it's in t

Mysql And Backup

2003-03-19 Thread sunil sharma
Dear Friends I am new in this list I am using mysql on linux My problem is about the backup of mysql database We are having 50 Databases and each database is of minimum of 300 MB in size and maximum of 2 G.B size I am planning to take incremental backup of the database For that i am planning

Re: defaults in MySQL

2003-03-19 Thread Barry Marler
/etc/my.cnf: Global options DATADIR/my.cnf: Server-specific options defaults-extra-file: The file specified with --defaults-extra-file=# ~/.my.cnf: User-specific options By default, data is in /var/lib/mysql. Jon Miller wrote: Can someone tell me how do I find the default settings in MySQL. Mainl

Mysql and Backup

2003-03-19 Thread sunil sharma
Dear Friends I am new in this list I am using mysql on linux My problem is about the backup of mysql database We are having 50 Databases and each database is of minimum of 300 MB in size and maximum of 2 G.B size I am planning to take incremental backup of the database For that i am planning

defaults in MySQL

2003-03-19 Thread Jon Miller
Can someone tell me how do I find the default settings in MySQL. Mainly I'm interested in knowing where are the data files stored. I'm building a application server (RH7.3) and need to know which partition should be sized to handle the database. -- Jon Miller <[EMAIL PROTECTED]> MMT Networks Pty

Re: Process Limit on Linux ?

2003-03-19 Thread Philipp
Hi Joseph, thank you for your answer. While i was reading about clustering some weeks ago i read the openmosix FAQ claiming that openmosix would not work with apache, because apache was using shared memory to communicate with its threads, and i always thought mysql is designed the same way. Please

MySQL 4.1 for OS X compiling problems

2003-03-19 Thread Michael Edlund
I'm trying to compile MySQL 4.1 on Mac OS 10.2.4 (Darwin Kernel Version 6.4) but run into some problems. When following the general compilation guidelines... cd mysql-4.0 bk -r get -Sq aclocal; autoheader; autoconf; automake (cd innobase ; aclocal; autoheader; autoconf; automake) (cd bdb/dist ; s

Re: Process Limit on Linux ?

2003-03-19 Thread Joseph Bueno
Hi, Since shm (shared memory) in Unix/Linux is only used to share memory between independent processes and mysql server is a single process (multi-threaded), I am convinced that shmmax value has no consequence on mysql. (OTOH Oracle has a multiprocess architecture and uses shared memory). Hope thi

Re: Mysql-max 4.0.12 missing GLIBC 2.2

2003-03-19 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 19 Mar 2003, Natalino Picone wrote: > can anyone tell me why the mysql-max 4.0.12 is not statically linked > against Glibc 2.2 ? (the standard one is ok)... This is done intentionally, to enable the use of User Defined Functions (UDFs) - you

Re: access primitives in php

2003-03-19 Thread Joel Rees
> We need to set up some primitives in php for mysql, then repeat for > postgresql, so that we bury most of the differences in the primitives. Sorry about the noise. Joe Conway on the postgresql list pointed me towards the database abstraction layers in pear, and I see lots of good stuff there. -