Deleting a large group of numbered records

I have a huge text file, \r seperated, for example: 10065 10066 10067 10069 10070 10075 10091 10093 10094 10100 10103 10104 10107 10108 10113 10114 10115 10116 10117 10118 10119 10120 10121 10122 10123 10124 However, there are about 5000 numbers in it, I need a way to delete from table where old_id

Re: ERROR 1130

It works mr. Vyas Thank you. Here the step. 1. I put skip-grant-tables into my.cnf file 2. Restart the server with " net start/stop mysql" command 3. Add user and password for root with all privileges options to 'Y' 4. Issue FLUSH PRIVILEGES command 5. Edit my.cnf file again and marked skip-grant-

[newbie] localhost login problems from MSW2k command line

MySQL 4.0.12, MSW2k. Here's what's puzzling me -- I set up a new user yesterday. I'm pretty sure I was able to connect as the user from the command line yesterday, before I shut my machine down and went home. I can't today. I have this user entry in my mysql.user table: | localhost | fromWeb |

Cannot Update MYSQL Database

I'm running this code with no errors but it's not inserting the string into the database ? public void addInfo( String referer ) throws SQLException, Exception { if (con != null) { try{ PreparedStatement updateInfo; updateInfo =

RE: Speed of SELECT ... LIMIT #,#?

> -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > Sent: Monday, March 24, 2003 9:17 PM > Please post the query and the output of running it thru EXPLAIN. > > It is likely sorting the results without an index and having to weed > thru more and more records the farther

Re: CONNECT BY PRIOR in MySQL

Nitin- If you want a SELF Join try http://www.devshed.com/Server_Side/MySQL/SQLJoins/page9.html Regards, -Martin - Original Message - From: "Nitin Nanivadekar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 10:07 PM Subject: CONNECT BY PRIOR in MySQL > Dear Fri

Re: SSL With Visual Basic ADO

Sean- lots of examples here http://www.winsockvb.com/ -Martin - Original Message - From: "Sean Biganski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 10:25 PM Subject: SSL With Visual Basic ADO > I am looking for a way to encrypt my ADO queries using SSL wit

SSL With Visual Basic ADO

I am looking for a way to encrypt my ADO queries using SSL with Visual Basic. Does anyone have ANY idea how to do this? Any suggestions would be helpful. Thanks in advanced.

Re: Speed of SELECT ... LIMIT #,#?

On Mon, Mar 24, 2003 at 04:48:01PM -0800, Nick Arnett wrote: > I'm reading 1,000 records at a time from a large table (overcoming the FT > indexing problem I wrote about yesterday) and I'm discovering that as the > starting record number grows larger, the retrieve speed is dropping rapidly. > Any s

CONNECT BY PRIOR in MySQL

Dear Friends, i am stuck at a great problem where a i have to find a solution to Oracle's "CONNECT BY PRIOR" clause. Do you have a solution using MySQL's own functions or using VB program? -Nitin __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA Ma

Re: MyISAM rebuilding questions

In the last episode (Mar 24), Wynne Crisman said: > I am trying to determine what would cause my needing to rebuild an > MyISAM table in MySQL 4.0.x? By "rebuild" I assume you mean "repair"? Only a crash should require a table to be repaired. Make sure your OS doesn't crash, report any MySQL cra

MyISAM rebuilding questions

I am trying to determine what would cause my needing to rebuild an MyISAM table in MySQL 4.0.x? I also would like to know how I can minimize the time necessary to get the MyISAM table up and running under MySQL 4.0.x? I have read the http://www.mysql.com/newsletter/2002-12/a91.html docume

Data not UPDATING

Im trying to update this database, I don’t receive an error anymore but nothing gets entered in? Can anyone see why? public void addInfo( String referer ) throws SQLException, Exception { if (con != null) { try{ PreparedStatement updateInfo;

Re: ERROR 1130

restart the server with the --skip-grant-tables option and then add users. - Original Message - From: "Anthon Tagor" <[EMAIL PROTECTED]> To: "Bhavin Vyas" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 11:31 PM Subject: Re: ERROR 1130 > Mr. Vyas > > But sir, i cann

Re: ERROR 1130

Mr. Vyas But sir, i cannot log in to mysql server. How can i apply GRANT command..? On Mon, 24 Mar 2003 23:05:27 -0500 Bhavin Vyas <[EMAIL PROTECTED]> wrote: You don't have permissions. Look up GRANT on www.mysql.com. - Original Message - From: "Anthon Tagor" <[EMAIL PROTECTED]> To: <[

Re: maintaining delivery order in a table

On Mon, 24 Mar 2003 15:17:09 -0500, Keith C. Ivey wrote: >You should definitely keep IDs and order as separate columns, since >you don't want to have to change IDs if the order changes. You might >consider representing the order with a nonconsecutive series of >integers -- for example, leave g

RE: Your professional opinion Please...

> -Original Message- > From: Brian [mailto:[EMAIL PROTECTED] ... > I have a client with approximately 2 gigabytes of un-indexed > document files > (includes text and graphics). > > He wants to be able to enter a few parameters and bring up a list of all > documents that fit, and then be a

ERROR 1130

Hi all.. I am beginner in mysql. I had install mysql in winnt4. I accidently delete all users in mysql database so i cannot connect to mysql server, the message is : ERROR 1130: Host 'localhost' is not allowed to connect to this MySQL server Does anybody give solution to my problem regards Ant

Re: Your professional opinion Please...

Brian- why not use grep or fgrep on the files and catch the hyperlink resultset to formatted html..? Regards, Martin - Original Message - From: "Brian" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 7:41 PM Subject: Your professional opinion Please... > H

Re: Question on MySQL, MyODBC & VC++

Terry- Personally I cant do much until I can see the stack trace, local variables and any diagnostics from your try/catch.. Regards, -Martin > > Hello Everybody, > I install MySQL in my W2K server and MyODBC also. I created a new > database named "Log" and tried to connect from my project in

java.sql.SQLException: Update failed, possible duplicate entry

Here is another beginner question of sorts I imagine. I receive this error. java.sql.SQLException: Update failed, possible duplicate entry I've got this code in a .jsp page. <% String ref=request.getHeader("Referer");%> <% count.addInfo( ref ); %> count is calling the method addInfo

Question on MySQL, MyODBC & VC++

Hello Everybody, I install MySQL in my W2K server and MyODBC also. I created a new database named "Log" and tried to connect from my project in VC++ via MyODBC. But my program get a runtime error when it try to open the database. I used CRecordset class to open it. Then I tried to open My

Your professional opinion Please...

Hello Dear Friends: I have a client with approximately 2 gigabytes of un-indexed document files (includes text and graphics). He wants to be able to enter a few parameters and bring up a list of all documents that fit, and then be able to download them over a web interface - sort of like a privat

RE: BEGINNER QUESTION.

ALTER TABLE table_name DROP col_name http://www.mysql.com/doc/en/ALTER_TABLE.html So... mysql> use hitcounter; mysql> ALTER TABLE info DROP count; Assuming info is the table name and count is the column you'd like to drop. -Original Message- From: Wileynet [mailto:[EMAIL PROTECTED] Sent

Re: BEGINNER QUESTION.

You were so close... ALTER info DROP count; -Brian McCain - Original Message - From: "Wileynet" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 5:26 PM Subject: BEGINNER QUESTION. > I have looked everywhere online, books. > I simply would like to DELETE a FIEL

RE: BEGINNER QUESTION.

USE hitcounter; ALTER TABLE info DROP count; Hope this helps Roger -Original Message- From: Wileynet [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 8:27 PM To: [EMAIL PROTECTED] Subject: BEGINNER QUESTION. I have looked everywhere online, books. I simply would like to DELETE a F

MySQL 4.0 debian packages

Speaking of binaries, I noticed that there are RPM and Mac OS X packages for MySQL 4.0, and was just curious if there were any plans to release a Debian package. The Debian site lists MySQL 4 packages as "experimental", and it will probably be awhile before we see them release a stable package. Th

BEGINNER QUESTION.

I have looked everywhere online, books. I simply would like to DELETE a FIELD from the command line. I have a database called hitcounter. Inside hitcounter I have one table with 3 fields. I've tried... DELETE FROM info FIELD count; ALTER info DELETE count; DROP count; Can someone please tell me

SSL binaries

Anybody have a clue as to when we will see openssl binaries The mysql folks state:"For maximum stability and performance, we recommend that you use the binaries we provide." I would love to play with this feature, but am not sure I want to go through the trouble of compiling with source. mysql,s

Speed of SELECT ... LIMIT #,#?

I'm reading 1,000 records at a time from a large table (overcoming the FT indexing problem I wrote about yesterday) and I'm discovering that as the starting record number grows larger, the retrieve speed is dropping rapidly. Any suggestions for how to speed this up? It's a strategy I use fairly of

Re: Creating fulltext index never completes...?

Hi! On Mar 23, Nick Arnett wrote: > I'm trying to create a full-text index on a large (2.1GB, 1.6M records), two > column table (primary key and a TEXT field), using MySQL 4.0.12 on Win2000. > All looks like it is proceeding well, I see .TMP files in the database > directory and a couple of tempor

RE: MySQLD won't stay started on Mandrake 9?

Hello we are trying to upgrade from 3.22 mysql to 3.23 or 4.0 on Mandrake 9.0 Everytime the new version is installed when safe_mysqld is run it starts then stops both with 3.23 and 4.0. It also gives a message chown 'mysql' not a valid user. 3.22 stays started.Any ideas as to why. How

RE: IN and comma delimitered id's

wicked thanks heaps this worked select * from User where userID=3 AND FIND_IN_SET(34, site_access); your a champ ! >>> Don Read <[EMAIL PROTECTED]> 03/24/03 03:02pm >>> On 24-Mar-2003 Daniel Rossi wrote: > hi there i have a field which i place comma delimitered id's like so > > 64,14,13,15 >

Re: Cannot Restore MySQL 3.23.37 dump to Mysql 3.23.55

DM wrote: Im trying to restore a database dumb taken from a Sun Cobalt RAQ4 running Mysql 3.23.37 and restore it to a new Dell PowerEdge running Redhat 7.3 with Mysql 3.23.55. I have tried from both the command line and using phpmyadmin With Command line /usr/bin/mysql database -uuser -ppassword

Cannot Restore MySQL 3.23.37 dump to Mysql 3.23.55

Im trying to restore a database dumb taken from a Sun Cobalt RAQ4 running Mysql 3.23.37 and restore it to a new Dell PowerEdge running Redhat 7.3 with Mysql 3.23.55. I have tried from both the command line and using phpmyadmin With Command line /usr/bin/mysql database -uuser -ppassword < /var/li

Re: InterBase vs. Mysql

David- There are many of us out there who have a variety of DBs to choose from CodeBase, InterBase, FileMaker, Access..Before selecting MySQL or any other DB make sure it works for your client's needs..Otherwise you just would be tossing good money out the window... Regards, -Martin > > Hello David

Re: fulltext search

Maybe they should set up some way to donate via PayPal. I'm sure there are plenty of developers around the world who'd be willing to chip in $10 here or $20 there in order to be able to use fulltext searching on InnoDB tables. I know I would. -Brian McCain - Original Message - From: "Je

RE: CREATE syntax wrong?

Hi AUTO_INCREMENT needs to be an integer, NUMERIC is a decimal? not 100% sure but it looks like it Peter -Original Message- From: Cesar Baquerizo [mailto:[EMAIL PROTECTED] Sent: 24 March 2003 20:59 To: MySQL Subject: CREATE syntax wrong? Hello, I am on: mysql Ver 11.18 Distrib 3.23

[Fwd: InnoDB Foreign Keys]

--- Begin Message --- Hi all this is what Mysql Reference Manual tells me about creating foreign keys. I understood how to use them, except for the restrict here ---\ | [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...)

RE: InterBase vs. Mysql

On Fri, 2003-03-21 at 17:46, John Griffin wrote: > Hello David, > > Since you were kind enough to clarify some matters on licensing I was > hoping you would also be open to suggestions. Instead of charging a > flat fee for each copy of MySQL that is resold why not charge a > percentage up to a cer

InnoDB Foreign Keys

Hi all this is what Mysql Reference Manual tells me about creating foreign keys. I understood how to use them, except for the restrict here ---\ | [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) |

Re: fulltext search

On Mon, Mar 24, 2003 at 12:59:17PM -0800, Jennifer Goodie wrote: > You don't. > http://www.mysql.com/doc/en/Fulltext_Search.html > > There was a discussion on this mailing list last week or the week before on > when innoDB support would be implemented. I'm too lazy to look it up, you > should sea

difference between libmysql and libmysql_r

Hi, I have a question. I know that the code in libmysqld is for the Embedded MySQL Server Library. Would anyone mind to direct me where I can find what the folder libmysql and libmysql_r for? Thanks Terry

Re: mySQL with C

If you mean a tutorial for compiling MySQL from source using gcc3.2, try here: http://www.mysql.com/doc/en/Installing_source.html -Brian McCain - Original Message - From: "David Matthews" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 23, 2003 6:48 PM Subject: mySQL with

mySQL with C

Could someone point me to a tutorial on using mySQL with gcc3.2? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: maintaining delivery order in a table

On 24-Mar-2003 Trevor Smith wrote: > I want to create a table of customers on a delivery route. I want to > include the order of delivery in the table. Creating a column with a > sequential id # would be very cumbersome because in the future some new > customers may subscribe -- and these new cust

RE: CREATE syntax wrong?

Try changing this... category_id NUMERIC NOT NULL AUTO_INCREMENT, to this... category_id INT NOT NULL AUTO_INCREMENT, or MEDIUMINT/BIGINT if you need that much. The INT type is the only type to accept an auto_increment qualifier. http://www.mysql.com/doc/en/CREATE_TABLE.html Hope this help

RE: fulltext search

You don't. http://www.mysql.com/doc/en/Fulltext_Search.html There was a discussion on this mailing list last week or the week before on when innoDB support would be implemented. I'm too lazy to look it up, you should search the list archives for it. -Original Message- From: Sidar Lopez C

CREATE syntax wrong?

Hello, I am on: mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686) Is there any reason the following should not work: CREATE TABLE category ( category_id NUMERIC NOT NULL AUTO_INCREMENT, category_name VARCHAR(40), description VARCHAR(80), PRIMARY KEY (category_id) ) TYPE=MyISAM; I

fulltext search

how can i implements a fulltext search engine on InnoDB tables? i need it... :-) Sidar Lopez Cruz - Cero Riesgo, S.A.

mysqld immediately stops

i would like to ask: i've got MySQL installed from RPM. when i try to run the MySQL server, this happens: [EMAIL PROTECTED] root]# /usr/bin/safe_mysqld Starting mysqld daemon with databases from /var/lib/mysql 030324 21:09:10 mysqld ended why does it stop immediately? should i create any datab

Re: Allowing a user to change their password

That is all ok but what do you suggest? Row level privileges are not available in MySQL (yet). Or did I miss something? Cheers/h On 3/24/03 12:18 PM, "Shawn P. Garbett" <[EMAIL PROTECTED]> wrote: > On 3/24/03 10:37 AM, "R. Hannes Niedner" <[EMAIL PROTECTED]> wrote: >> On 3/24/03 7:41 AM, "Shawn

Unable to create database using WinMySqlSdmin

I recently install MySql for Windows to try it out for an upcoming project.. The install went fine. However when I try to create a new database using the admin tool the only options I receive are Flush Hosts Flush Logs Flush Tables Flush Threads Anyone know why I do not get the options to Crea

Re: maintaining delivery order in a table

On 24 Mar 2003 at 13:08, Trevor Smith wrote: > I want to create a table of customers on a delivery route. I want to > include the order of delivery in the table. Creating a column with a > sequential id # would be very cumbersome because in the future some new > customers may subscribe -- and thes

Re: Allowing a user to change their password

On 3/24/03 10:37 AM, "R. Hannes Niedner" <[EMAIL PROTECTED]> wrote: > On 3/24/03 7:41 AM, "Shawn P. Garbett" <[EMAIL PROTECTED]> wrote: > > How can one allow a user to change their mysql password securily? > > > > If I do a grant update on the user table, then a user could change > > anyone's passw

RE: mysqlimport: Error: Can't get stat of

Probably a permission problem. If it cannot read the file it cannot import it. monster> perror 13 Error code 13: Permission denied -Original Message- From: James E Hicks III [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 11:48 AM To: Mysql Subject: mysqlimport: Error: Can't get

RE: mysqlimport: Error: Can't get stat of

You're having a permissions problem. >From the Load data infile section of the manual: For security reasons, when reading text files located on the server, the files must either reside in the database directory or be readable by all. Also, to use LOAD DATA INFILE on server files, you must have the

RE: mysqlimport: Error: Can't get stat of

On 24-Mar-2003 James E Hicks III wrote: > mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode: > 13), when using table: thefile > localhost.dread$ perror 13 Error code 13: Permission denied localhost.dread$ -- Don Read [EMAIL PRO

RE: mysqlimport: Error: Can't get stat of

Please ignore this this problem as I found the answer. For those inquring minds, I added a -L to the mysqlimport command and we are all happy now. James -Original Message- From: James E Hicks III [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 2:48 PM To: Mysql Subject: mysqlimpor

Re: PHP before mysql on a mac?

Here's a couple of links that should help. PHPMac http://www.phpmac.com/ has an article about turning on PHP in Apache. MySQL on Mac OS X http://developer.apple.com/internet/macosx/osdb.html PHP on Mac OS X http://developer.apple.com/internet/macosx/php.html Even though OS X comes with Apache and

mysqlimport: Error: Can't get stat of

Why am I getting this error? I have looked on google and it said to use the full path when naming the import file. I have done this and still get the error. What else could I be doing wrong? # mysqlimport -d --fields-optionally-enclosed-by=\' --fields-terminated-by=, --use r=userid --password=pwor

RE: disabling version number

At 13:35 -0500 3/24/03, Adam Nelson wrote: I would be wary of disabling version(). That's the kind of annoying thing that sys admins do when they don't understand the life of a developer. Some programs and modules require the version() function to work. Security to that extreme is only useful if

RE: disabling version number

On 24 Mar 2003 at 11:02, Jeremy Tinley wrote: > but paying for a low end account, finding the version > number the host is running and finding an exploit for that version would > probably be what the original poster had in mind of preventing. Suppose you prevented customers from seeing the versio

Problem using DBI with MySQL and SSL

I am having a problem getting this to work and the documentation I have found doesn't seem to be helping, hopefully someone out there can help me. I am using MySQL 4.01-Gamma on a Debian Linux box. I have configured MySQL exactly as the manual shows in Section 4.3.9 - Using Secure Connections, inc

RE: disabling version number

I would be wary of disabling version(). That's the kind of annoying thing that sys admins do when they don't understand the life of a developer. Some programs and modules require the version() function to work. Security to that extreme is only useful if you understand that it may cause more down

Re[2]: LOAD DATA / mysqlimport doesnŽt work with 3.23.49

Victoria, >> LOAD DATA LOCAL INFILE "member.txt" INTO TABLE member; >> -> ERROR 1148: the used command is not allowed with this MySQL version > Add --local-infile=0 to mysqld commandline. > See: http://www.mysql.com/doc/en/LOAD_DATA.html This doesn't work with MySQL <= 4.0.10. I reported to [EM

Re: PHP before mysql on a mac?

Open a terminal/console Window and type: mysql If You got an error message You have to follow these steps: su mysql_install_db chown -R mysql.mysql /var/mysql chmod 577 /var/mysql then go in the Application/Utility folder and launch the MySqlMonitor Click on "Launch at startup". I followed these st

Re: Foreign Key

tab3.cod2 is not the first field in an index. -- On Mon, 24 Mar 2003, Luis Matos Lima wrote: > The thing his i already have created the first field > in an index on other tables. I write this: > > CREATE TABLE tab1 ( > Cod1 int(3) NOT NULL default '0', > PRIMARY KEY (Cod1) > )TYPE=INNODB

PHP before mysql on a mac?

My test.php page recognizes the potential for mysql but something went wrong when I first tried to install mysql so I removed mysql and am about to attempt a re-install. I've a couple of books on hand, neither of which addresses MAC OSX which is unix based. OSX comes with apache and php pre-install

RE: disabling version number

At 11:02 -0600 3/24/03, Jeremy Tinley wrote: Authorized != trusted. If you're a hosting provider who allows access to MySQL for customers, your users have access to see the version number by way of simply connecting to their own database. Not that "mysql --version" from a shell doesn't give you th

Re: Foreign Key

Here's info about the error code: Error code 150: Unknown error: 150 150 = Foreign key constraint is incorrectly formed Here's info on InnoDB foreign keys: http://www.mysql.com/doc/en/SEC459.html At 16:33 + 3/24/03, Luis Matos Lima wrote: i´m having some trouble in creating a table like this o

Re: Foreign Key

In 3.23, all foreign keys must be on columns that exist as the first field in an index on the table. This applies to the columns they reference as well. Ernie Hershey -- On Mon, 24 Mar 2003, Luis Matos Lima wrote: > i´m having some trouble in creating a table like this > one. > > CREATE TA

maintaining delivery order in a table

I want to create a table of customers on a delivery route. I want to include the order of delivery in the table. Creating a column with a sequential id # would be very cumbersome because in the future some new customers may subscribe -- and these new customers may need to be inserted into the deliv

Re: mysqld dies

Sorry, we do not accept bug reports in HTML format. Please re-send it in plain text format. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnac

Re: disabling version number

;-) - Original Message - From: "Joseph Bueno" <[EMAIL PROTECTED]> To: "Florian Effenberger" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 5:39 PM Subject: Re: disabling version number You can patch mysql source and recompile ;) However, if someone has enough

RE: disabling version number

Authorized != trusted. If you're a hosting provider who allows access to MySQL for customers, your users have access to see the version number by way of simply connecting to their own database. Not that "mysql --version" from a shell doesn't give you the same thing... but paying for a low end acco

Re: Question

Luis, a sneak peek of MySQL-4.0.13: mysql> show innodb status; ... LATEST FOREIGN KEY ERROR 030324 16:14:01 Error in foreign key constraint of table test/tab3: There is no index in the table test/tab3 where the columns appear as the first column

Re: building MySQL on Alpha-Dec-OSF4 with gcc

In the last episode (Mar 24), Ralf Hupfer said: > I do face problems building MySQL 3.22.32 with gcc 3.2.2 on an Alpha- > DEC-OSF4 workstation. > > CC="cc -pthread" CXX="cxx -pthread -O" ./configure > --with-named-thread-libs="-lpthread -lmach -lexc -lc" --with-low-memory > > Everything run's s

Foreign Key

i´m having some trouble in creating a table like this one. CREATE TABLE tab3( cod1 int( 3 ) NOT NULL , cod2 int( 3 ) NOT NULL , PRIMARY KEY ( cod1, cod2 ) , FOREIGN KEY ( cod1 ) REFERENCES tab1( cod1 ) ON UPDATE CASCADE ON DELETE CASCADE , FOREIGN KEY ( cod2 ) REFERENCES tab2( cod2 ) ON UPDATE

Re: disabling version number

Florian Effenberger wrote: No, why? Part of my security concept, I generally disable all version numbers. You can patch mysql source and recompile ;) However, if someone has enough access rights on your system to run "select version();", showing mysql version number should be the least importa

Re: disabling version number

> No, why? Part of my security concept, I generally disable all version numbers. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: load data infile question

-Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 9:06 AM To: [EMAIL PROTECTED] Subject: re: load data infile question Hi! On Friday 21 March 2003 20:41, Salada Duncan wrote: >> I am using MySQL 3.23.49 and have started having a proble

Re: Two values for LIMIT?

At 16:44 +0100 3/24/03, COMUNICA wrote: Hi I need help for prompt LIMIT with two values, the first value is the starting row, the second value end of LIMIT. The following instrction work? "SELECT A, B, C FROM Table LIMIT value1,value2" value2 is intended obtained with the COUNT() function. I do

Re: disabling version number

At 16:45 +0100 3/24/03, Florian Effenberger wrote: Hi, is there any configuration directive of disabling the output of the MySQL servers version number? Thanks Florian No, why? -- Paul DuBois http://www.kitebird.com/ sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.c

RE: Two values for LIMIT?

Hi Antonio, > I need help for prompt LIMIT with two values, the > first value is the starting row, the second value > end of LIMIT. I think your syntax is a little bit out... if you're passing two values, the following apply: - The first value is the starting row - The second value is the numb

disabling version number

Hi, is there any configuration directive of disabling the output of the MySQL servers version number? Thanks Florian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Two values for LIMIT?

Hi I need help for prompt LIMIT with two values, the first value is the starting row, the second value end of LIMIT. The following instrction work? "SELECT A, B, C FROM Table LIMIT value1,value2" value2 is intended obtained with the COUNT() function. value1 = is inferior of value2 and the start

Allowing a user to change their password

How can one allow a user to change their mysql password securily? If I do a grant update on the user table, then a user could change anyone's password. I just want a user to be able to change their password. Is this possible? Shawn -- MySQL General Mailing List For list archives: http://lists

RE: group by quesion?

Another way, if you're using MySql 4 and up (since anything less does not support sub selects) could be to try this: SELECT Date, COUNT(Date) AS Cnt FROM MyTable GROUP BY Date HAVING COUNT(Date) >= (SELECT COUNT(B.TypeID) AS Cnt2 FROM MyTable GROUP BY TypeID

RE: group by quesion?

You could simply do something like SELECT Date, COUNT(Date) AS C_Date GROUP BY Date ORDER BY C_Date DESC This would give you back a result set as follows Date| C_Date -- 29 | 3 30 | 3 31 | 2 28 | 1 You could put that in a temp table an

re: load data infile question

On Friday 21 March 2003 20:41, Salada Duncan wrote: > I am using MySQL 3.23.49 and have started having a problem with the "load > data infile" command. > > I recently created a new user with select,insert,update,and delete on one > table only (tableA). Because I want the user to be able to use "l

re: Storing of media files/data in MySQL

On Monday 24 March 2003 13:24, Michael Edlund wrote: > Are there any special performance considerations I should have in mind > when making the decision of whether to store a large number of browser > uploaded media files (images, audio and video) in BLOB-fields in MySQL > or whether I should choo

re: LOAD DATA / mysqlimport doesn´t work with 3.23.49

On Sunday 23 March 2003 21:04, Klaus Mueller wrote: > LOAD DATA LOCAL INFILE "member.txt" INTO TABLE member; > -> ERROR 1148: the used command is not allowed with this MySQL version > Does anybody know how to manage these two commands in MySQL 3.23.49? Add --local-infile=0 to mysqld commandline.

re: Presentation and data size

On Monday 24 March 2003 03:18, Esteban Cabezudo wrote: > If I define a BLOB(760) column. The maiximum size of the text it is 760 > or 758? > I gonna put it in another way. It is the 760 the maximum string size and > the allocation storage is 762 bytes? The maximum string size is 760 bytes and the

re: mysqldump

On Monday 24 March 2003 12:03, Stefan Toobe wrote: > does anybody know how to use mysqlump with "big tables"? > I´ve got a db with a few tables. One of that tables has > 10 rows. > Making a dump with mysqldump 3.23.54 causes following error: > mysqldump: Got error: 1104: The SELECT would exa

re: Output data to file

On Monday 24 March 2003 06:09, Scott Haneda wrote: > I want to send the results of > Select name, email from messages > To a plain text file, how can I do this? The solution: SELECT name,email FROM messages INTO OUTFILE '/tmp/my-file-name'; > Scott HanedaTel: 4

Re: building MySQL on Alpha-Dec-OSF4 with gcc

P.S.: Sorry for the strange layout, but somehow all the underlines (i.e. in "__cxa_pure_virtual") got removed. Ralf -- Ralf Hupfer Fraunhofer Institut für Verkehrs- und Infrastruktursysteme Dresden WWW : www.ivi.fhg.de www.intermobil.o

building MySQL on Alpha-Dec-OSF4 with gcc

Hi, I do face problems building MySQL 3.22.32 with gcc 3.2.2 on an Alpha- DEC-OSF4 workstation. CC="cc -pthread" CXX="cxx -pthread -O" ./configure --with-named-t hread-libs="-lpthread -lmach -lexc -lc" --with-low-memory Everything run's smoothly, till mysqld is to be build. The linker produces:

Re: Presentation and data size

Esteban Cabezudo wrote: First of all, I want to say hello and sorry because my english it s very poor. I hope you don't care about it. My name is Esteban, I'm from Uruguay. I begin whit mySQL and I have a simple question... for the moment... :) If I define a BLOB(760) column. The maiximum size o

Re: Wrong mysql.sock

Did you add a socket option to the proper paragraph in /etc/my.cnf? Ex: [client] socket=/raid2/var/lib/mysql/mysql.sock Ville Mattila wrote: Hi there, I'm upgrading my old MySQL 3.2 to a new MySQL 4.0 and at the same time I decided to change the location of my data directory. Everything went fine

  1   2   >