Can you get the results of an UPDATE command?

I've looked around and believe this to not be possible, but am checking just to be sure. Basically I want to run the command UPDATE MyTable SET SomeRecord = NewValue WHERE SomeRecord = OldValue But, I need to know which rows were modified, not simply how many. So far this is the best that I ha

Re: Can you get the results of an UPDATE command?

Hi Jason, If I understand correctly you need the SELECT statement first to detemine which records to update. However perhaps on the SELECT statement you could speed up things by showing only the required columns and not all. While this doesnt make a big difference for small tables, it can make

Re: mysql ended error

If You install Mysql from .dmg file it doesn't install mysql databases (grant tables, etc.) I think You have a permission problem so open a terminal and type su this command allows You to be root then chown -R mysql.mysql data(data owner must be mysql) chmod -R 577 data (allows everyone to wr

Re: Simple Question: MySQL and Shell Scripts

Zach wrote: I am writing a shell script using Born Shell. I am trying to get the result of a SQL statement into a variable. For example: /usr/bin/mysql -uroot -prootpass BOB << EOF SELECT * FROM Bobstable WHERE Name=1 EOF How do I get the result into a variable? Thanks in advance! May be: myva

Re: Simple Question: MySQL and Shell Scripts

On Mon, Jun 23, 2003 at 06:37:17PM -0500, Zach wrote: > > I am writing a shell script using Born Shell. I am trying to get the result of a SQL > statement into a variable. You mean Bourne shell. > For example: > > /usr/bin/mysql -uroot -prootpass BOB << EOF > SELECT * FROM Bobstable WHERE Name=1

Re: select * into outfile;mysql-delphi

Rahmat> 2. how can i use mysql with delphi?please give me more explanation about it.. and must i have some application for it? Goto google and find "TmySQL delphi component". You will get the examples there too. Ivan --

Foreign Key Concept

Hello, mysql, After I create this table,and add foreign key tno to this table. If I delete "tno" in "p_program_type" table,it would alarm that some data still in "p_schedule". How can I define the "p_schedule" or "p_program_type" table to make sure that while delete the tno in p_program_type,the

Re: Access denied for user: '@localhost' to database 'mysql'

don't piggyback on other people's threads. you can start your own for free. # [EMAIL PROTECTED] / 2003-06-19 13:23:04 -0700: > I ran a command which was part of the installation process for some php > accounting software. > > update user set host='%' where host='localhost' and user='roo

Re: default value does not set using LOAD DATA INFILE ...

please don't piggyback on other people's threads. you can start your own for free. # [EMAIL PROTECTED] / 2003-06-24 09:46:24 +1000: > I am using LOAD DATA INFILE to import some data to MySQL. I would like to > leave some fields blank and use the default value set in the tables. I have >

Re: Foreign Key Concept

# [EMAIL PROTECTED] / 2003-06-24 16:48:24 +0800: > After I create this table,and add foreign key tno to this table. > If I delete "tno" in "p_program_type" table,it would alarm that some > data still in "p_schedule". > How can I define the "p_schedule" or "p_program_type" table to make > sure that

Re: AES 256-Bit Encryption

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 11 Jun 2003, Herb Wartens wrote: > Does anyone know where to find the 256-Bit patch for AES encryption? No patch needed - just edit include/my_aes.h and change the AES_KEY_LENGTH define to the desired value (it defaults to 128 bits). Bye,

Transaction support

Hi, Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Transaction support

# [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: > Does MYSQL support transaction concept, which includes issues > like commiting data , rollbacking etc??? Did you know MySQL has documentation? -- If you cc me or remove the list(s) completely I'll most likely ignore your message.s

Re: Simple Question: MySQL and Shell Scripts

Joseph Bueno wrote: Zach wrote: I am writing a shell script using Born Shell. I am trying to get the result of a SQL statement into a variable. For example: /usr/bin/mysql -uroot -prootpass BOB << EOF SELECT * FROM Bobstable WHERE Name=1 EOF How do I get the result into a variable? But this is mor

Re: Transaction support

# [EMAIL PROTECTED] / 2003-06-24 12:29:33 +0200: > # [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: > > Does MYSQL support transaction concept, which includes issues > > like commiting data , rollbacking etc??? > > Did you know MySQL has documentation? # [EMAIL PROTECTED] / 2003-06-24

Re: Can you get the results of an UPDATE command?

# [EMAIL PROTECTED] / 2003-06-24 01:02:17 -0600: > But, I need to know which rows were modified, not simply how many. So > far this is the best that I have come up with > > LOCK TABLES MyTable WRITE > SELECT * FROM MyTable WHERE SomeRecord = OldValue > UPDATE MyTable SET SomeRecord = NewValue WHER

Re: Can't find file: './mysql/host.frm' (errno: 13)

# [EMAIL PROTECTED] / 2003-06-23 16:16:50 -0400: > I installed MySQL (mysql-standard-4.0.13-apple-darwin6.4-powerpc) ... > but now I get this error in the log file and I am unable to still start > the MySQL Server. > 030623 15:59:05 Fatal error: Can't open privilege tables: Can't find file:

Re: update to 4.0 mySQL question

# [EMAIL PROTECTED] / 2003-06-23 11:11:28 -0400: > I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I > attempted to run mysql_fix_privileges. This is the error I get: > > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) > > /tmp is

Re: select * into outfile;mysql-delphi

MySQL won't write data to a file if the file already exists. Make sure you've deleted the old file or given MySQL a new filename to write to. Jan -- Janice Wright Ingenta plc [EMAIL PROTECTED] http://www.ingentaselect.com/ Sometime recently Rahmat Hidayat said: > hello my friends.. i have so

Release timeframes --> need Internat. support

I am new to MySQL and was wondering if someone could share some past experience on timeframes from alpha to full release ? We need full Internationalization support and since 4.1 has it in it would like to get some guesses on when it will be "production release". Thanks

Re: LONGTEXT size problem?

Sam Evans <[EMAIL PROTECTED]> wrote: > > I am attempting to insert into my table a huge block of text (talking > almost a megabyte). It seems like maybe a quarter of the way through it > just cuts off with no errors to my import script. > > I've changed my max_allowed_packet to 20M as well as

Re: Can't find file: './mysql/host.frm' (errno: 13)

Pushpinder Singh Garcha <[EMAIL PROTECTED]> wrote: > > I am installing MySQL on my Mac OS Jaguar system. I was having some > trouble with the starting up my MySQL Server. I kpt getting "mysqld > ended" error and my logs showed that file "user.MYI" was corrupted. So > I decided to uninstall

Re: Foreign Key Concept

"MaFai" <[EMAIL PROTECTED]> wrote: > > After I create this table,and add foreign key tno to this table. > If I delete "tno" in "p_program_type" table,it would alarm that some data still in > "p_schedule". > How can I define the "p_schedule" or "p_program_type" table to make sure that while > del

Re: Transaction support

Palaparthy <[EMAIL PROTECTED]> wrote: > Does MYSQL support transaction concept, which includes issues > like commiting data , rollbacking etc??? Yes. http://www.mysql.com/doc/en/ANSI_diff_Transactions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ens

Re: update to 4.0 mySQL question

Susan Ator <[EMAIL PROTECTED]> wrote: > I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I > attempted to run mysql_fix_privileges. This is the error I get: > >ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) > > /tmp is: >

mysql.sock doesn't exist

I apologize for posting about something which has probably been covered before but I can't remember where I have seen this dealt with. I have been trying to upgrade/install/re-install MySQL 4.0.13 and when I try to do any administrative work (set root password, for example) I get this message:

RE: mysql.sock doesn't exist

Is the mysql server currently running? You can also use either -S or --socket to specify the socket connection. -Original Message- From: Kevin H. Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 8:10 AM To: [EMAIL PROTECTED] Subject: mysql.sock doesn't exist I apologize fo

Re: mysql.sock doesn't exist

Yes, the server is running. One odd thing about my setup is that when I restart the service I get a "Failed" signal for the shutdown phase but an "OK" for the start phase. Thanks, Kevin Victor Pendleton wrote: Is the mysql server currently running? You can also use either -S or --socket to spe

RE: mysql.sock doesn't exist

>From the mysql monitor `show variables` to see what socket the server is connecting on. -Original Message- From: Kevin H. Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 8:33 AM Cc: [EMAIL PROTECTED] Subject: Re: mysql.sock doesn't exist Yes, the server is running. One

RE: Getting the unique auto-increment primary key after an insert

last_insert_id() returns the last auto-increment your connection. Another connection might make an insert and the auto-increment may change between the time you insert and get your last_insert_id(); Curtis On Tue, 24 Jun 2003, Matt Hyne wrote: > > Thanks, > > I found it but I wasn't sure

mysqld question

On my server running linux several daemons opens when I run "msqld -u mysql" or "safe_mysqld". A listing of the process shows this: mysql24475 0.5 2.1 83292 2012 ?S15:46 0:03 mysqld -u mysql mysql24476 0.0 2.1 83292 2012 ?S15:46 0:00 mysqld -u mysql mysq

how to do multipul Joins

Hello all I am having trouble with joining tables i will explain. I have four tables Cat - CatFile - File - User. thay are related in the order. I need to join them around the file table. i tryed 'SELECT cat.name, catfile.catid, file.fileid, user.name FROM cat RIGHT JOIN catfile ON catfile.catid=

Re: mysqld question

Linux shows threads. BSD shows processes. The difference is in the way ps runs, not mysqld. Henrik Leghissa wrote: On my server running linux several daemons opens when I run "msqld -u mysql" or "safe_mysqld". A listing of the process shows this: mysql24475 0.5 2.1 83292 2012 ?S

Re: mysql.sock doesn't exist

Kevin H. Phillips wrote: Yes, the server is running. One odd thing about my setup is that when I restart the service I get a "Failed" signal for the shutdown phase but an "OK" for the start phase. Thanks, Kevin Victor Pendleton wrote: Is the mysql server currently running? You can also use eit

Re: mysqld question

At 16:21 2003-06-24, gerald_clark wrote: Linux shows threads. BSD shows processes. The difference is in the way ps runs, not mysqld. *doh* I guess the sun got to me, sorry mate! :-) But do you have any good ways to get the database to run any faster? I am running it on a really beat up piece of j

RE: mysqld question

it really depends on how big your database is what else is running on the server (apache..) how many connections at once percentage of selects to updates/inserts do you have indexes what version are you running what is your mom's maiden name if you look at the sun, how long to you blink :

RE: mysqld question

Not a silly question... we all had to start somewhere... you can do it during the create table ( primary key ) http://www.mysql.com/doc/en/CREATE_TABLE.html or after http://www.mysql.com/doc/en/CREATE_INDEX.html what indexes do... lets say you do ALOT of queries on column user_id in the table u

RE: mysqld question

At 16:52 2003-06-24, Christopher Knight wrote: Not a silly question... we all had to start somewhere... you can do it during the create table ( primary key ) http://www.mysql.com/doc/en/CREATE_TABLE.html Thanks for the explanation, I'm no sql-guru at all, so all info is welcome! :-) I'm running

Re: mysqld question

Sometime recently Henrik Leghissa said: > At 16:21 2003-06-24, gerald_clark wrote: > >Linux shows threads. > >BSD shows processes. > > > >The difference is in the way ps runs, not mysqld. > > *doh* I guess the sun got to me, sorry mate! :-) > > But do you have any good ways to get the database t

Browsing Tables

Hi, New, brand new to MySQL: are there software or apps to browse the TABLES? and if possible, add/edit/delete rows?? Thanks __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http

mysqldump 8.22 and inifinite double values: Bug?

Hi All, I use MySQL 3.23.53 and mysqldump 8.22 and there is a behaviour in mysqldump I consider a bug. Anyone agrees? % mysql test mysql> create table doubletest (d double not null); mysql> insert into doubletest values("inf"); mysql> insert into doubletest values("-inf"); mysql> exit % mysqldum

Re: Browsing Tables

Hi there, you can download this or download phpMyAdmin http://www.mysql.com/downloads/mysqlcc.html - Original Message - From: "Deosaran Bisnath" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 12:01 PM Subject: Browsing Tables > Hi, > New, brand new to MySQL:

Re: Delete orphan records

Jake, Since I am running MySQL 3.23.5x, I cannot do subselects. I am able to do the following: SELECT * FROM Items_Pictures LEFT JOIN Items ON Items_Pictures.Items_ID = Items.Items_ID WHERE Items.Items_ID IS NULL; *BUT*, if I try to do a DELETE instead DELETE FROM Items_Pictures

Re: Browsing Tables

If you're using Windows, you can use an application like urSQL (http://www.urbanresearch.com/ursql) for easy viewing, adding, editing, deleting, etc, or any of a number of available graphical clients... You may also want to have a look around http://www.mysql.com and the list archives for several

Re: Simple Question: MySQL and Shell Scripts

On 24-Jun-2003 Fred Whipple wrote: > Don't forget to use '-B' in order to make the output silent except for > the results: > and -N to suppress column names. > 2. you should stick your password (which shouldn't match > your UNIX password) in a textfile readable only by you so that

Re: Delete orphan records

Nevermind... Just read an interesting comment in the MySQL online docs. http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html First user comment pointed me in the right direction. Thanks for your help though. Much appreciated! (Especially when I upgrade to 4.x) -- Greg On Tue, Jun 24, 2003 a

[MYSQL] Question about 'SHOW PROCESSLIST' output columns

Hello All, I'm having an intermittent problem with a MySQL server that I have running on a Windows 2000 Advance server systems. This issue occurs every few days depending on the load of the system. Here are the details. MySQL version 3.23.42-nt (I know I need to upgrade. Soon). Machine: Wi

Anyone had a chance to try an Opteron yet?

I'm surprised there is not more interest in this; is it that not many work with large-ish (10+ gig) databases that need high-end performance? A 64-bit CPU won't have the 4-gig memory limit that a 32-bit processor will; even worse, Linux is apparently limited to about a 2-gig process. SuSe Enterpr

mysql 4.1 authentication problems

Just installed mysql 4.1. The same perl/DBIscripts which worked fine on 4.0 now failing toconnect with the following error: DBI connect('host=localhost;database=webdb','webdev',...) failed: Client does not support authentication protocol requested by server. Consider upgrading MySQL client at ./i

Freeing memory

Other than mysql_free_result() how can I free up memory upon the completion of a query? TIA! jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql.sock doesn't exist

check that the permissions in the data directory are correct. If mysqld does not have write perms in that directory, it will not start. ls -l /var/lib/mysql mysql_install_db "used" to set the permissions to the user that ran the script (usually root). -Original Message- From: John Nich

Re: mysql.sock doesn't exist

The output of the grep is: [EMAIL PROTECTED] root]# ps -ax | grep mysqld 4578 ?S 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf 4601 ?S 0:01 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file

mysql 4.1 client authentication

Does anyone know what is different in mysql 4.1 client authentication from mysql 4.0? After upgrading to 4.1 my scripts can no longer connect and produce the following message: Client does not support authentication protocol requested by server. Consider upgrading MySQL client -- MySQL General

RE: mysql.sock doesn't exist

Stop the process you currently have or start up the server on a port other than 3306. -Original Message- From: Kevin H. Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 1:46 PM Cc: [EMAIL PROTECTED] Subject: Re: mysql.sock doesn't exist The output of the grep is: [EMAIL P

Re: Anyone had a chance to try an Opteron yet?

In the last episode (Jun 24), David Griffiths said: > I'm surprised there is not more interest in this; is it that not many > work with large-ish (10+ gig) databases that need high-end > performance? I think we have a mysql database running on Tru64, and I'm sure it runs great on Solaris. My gues

Re: Anyone had a chance to try an Opteron yet?

Excellent point. How does MySQL run on Tru64? Any familiarity with it on Intel32? But there are some big drawbacks to these platforms: - they only run apps that have been specifically ported and compiled for them. The Opteron runs the same 32-bit code that an Athalon or Pentium class computer wil

Re: Anyone had a chance to try an Opteron yet?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David Griffiths wrote: > I'm surprised there is not more interest in this; is it that not many work > with large-ish (10+ gig) databases that need high-end performance? > > A 64-bit CPU won't have the 4-gig memory limit that a 32-bit processor will; >

InnoDB foreign keys

Hello, Is it possible to create a foreign key that referencestwo columns, if the referenced table uses more two colums for it's primary key? If possible, what is the syntax? Mikael Engdahl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Re: Anyone had a chance to try an Opteron yet?

Not necessarily. People that need relatively affordable 64 bit systems may be waiting for the Opteron to stabilize. My experience is the Wintel solutions (like Opteron) tend to have at least a 2-1 price performance over Sun and Dec. Also, given that HP has basically dropped Alpha, I don't think

Bug in last CVS

try to bk pull the mysql 4.0 from CVS tree... after I run: aclocal; autoheader; autoconf; automake inside dir... the error is: autoconf: Undefined macros: configure.in:8:AC_CONFIG_HEADERS(config.h) configure.in: 8: `automake requires `AM_CONFIG_HEADER', not `AC_CONFIG_HEADER'

Re: Anyone had a chance to try an Opteron yet?

64 bit servers have different performance characteristics and tend to be used for different things. than PC systems. They are generally backplanes to which are attached some number of processors and some amount of memory, and a lot of IO. They aren't used as much for processor speed (you could

Re: mysql.sock doesn't exist

Kevin H. Phillips wrote: The output of the grep is: [EMAIL PROTECTED] root]# ps -ax | grep mysqld 4578 ?S 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf 4601 ?S 0:01 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql

Re: Anyone had a chance to try an Opteron yet?

not exactly relevant to this discussion but... Apple did just release the new G5, 64bit PowerMacs. Could be another alternative for the inexpensive 64bit market. Granted, they don't ship until august, but they are nice to look at: http://www.apple.com/powermac/ from their site: The Power Mac

MySqL running very slow on HP 900-UX 11 - 32 bit

Hi all, I am trying to create tables and insert data into MySql Version 3.23.53-Max database on HP 900-UX 11 - 32 bit server. For some reason a job , which is suppose to take 45 mins, is not completing even after 2 days. It means all jobs against mysql are running very slow on HP 900-UX 11 - 32 b

Replication Performance

Hello 1/ I have a search engine which crawls auction sites and returns information which is inserted into a mysql database. This activity represents on average about 3 inserts per second with a combined payload of 450 bytes per second added to the database. This updating occurs continuously thr

Re: mysql 4.1 authentication problems

Funny. I was just readin about this on the www.mysql.com web site. Under the documentation section about upgrading form 3.23 to 4.0. The exact URL is http://www.mysql.com/doc/en/Upgrading-from-3.23.html Ensure that you don't have any MySQL clients that use shared libraries (like the Perl DB

Re: Anyone had a chance to try an Opteron yet?

On Tue, Jun 24, 2003 at 01:25:25PM -0700, Gabriel Guzman wrote: > > not exactly relevant to this discussion but... Apple did just release > the new G5, 64bit PowerMacs. Could be another alternative for the > inexpensive 64bit market. Granted, they don't ship until august, but > they are nice to

Re: Anyone had a chance to try an Opteron yet?

Michael Conlen wrote: 64 bit servers have different performance characteristics and tend to be used for different things. than PC systems. They are generally backplanes to which are attached some number of processors and some amount of memory, and a lot of IO. They aren't used as much for pr

Confused about MyISAM vs InnoDB tabel types

Can anyone either summarize for me a comparison between the MyISAM and InnoDB MySQL table type? I am getting ready to upgrade from MySQL 3.23.42 to 4.0.13 in the coming week and started reading the upgrade documents on the www.mysql.com site. Never had even thought about using another table t

Searchable docs in french, german, russian etc

Hi MySQL doc team, I have was wondering if a change could be made so that when I browse the MySQL docs in some selected language there is a search window that searchs first the language I have currently selected. The search always returns the english documentation page even when the page exists

RE: AES 256-Bit Encryption and /etc/my.cnf

It would be really nice if ANY of these kinds of configuration options were settable via the /etc/my.cnf file. I use RPM's almost exclusively for their ease of maintenance, compatibility and stability and I certainly wouldn't want to go and have to re-compile anything just to change a value from 12

Re: mysql.sock doesn't exist

What I'm trying to do is as root user. Kevin John Nichel wrote: Are you trying to stop the server as root, or some other user? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Strange "Mull" in show fields and table keeps crashing

Hello, I have this table: "CLUB" Field Type Null Key Default Extra clubid int(11) PRI NULL auto_increment clubusgf int(11) UNI 0 program char(3) url varchar(75) email varchar(75) phone varchar(14) fax varchar(14) address1 varchar(75) MUL address2 varchar(75) city varchar(75) notes varchar(255) z

Who can help me with fuselight?

Okay I tried to set it up on the server when trying the testbench it just blinks and doesnt do anyhting any 1 know why the site didnt help me www.sulake.com/fuselight could it be the port the host or what ?

RE: Strange "Mull" in show fields and table keeps crashing

The `MUL` indicates that the column have multiple values. When the server `crashes`, what errors are being reported log file? -Original Message- From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:13 PM To: [EMAIL PROTECTED] Subject: Strange "Mull" in show fiel

RE: Confused about MyISAM vs InnoDB tabel types

You should find the following informative: http://www.mysql.com/doc/en/Table_types.html InnoDB offers transaction support, and seems to recover better from crashes. You do sacrifice some speed and features such as FULLTEXT index support. Regards, Mike Hillyer www.vbmysql.com > -Original Me

Re: Strange "Mull" in show fields and table keeps crashing

Hi, What about upgrading to MySQL 4.0.13 ? 4.0.0 is not a "production" release, and a lot of bugs have been fixed between 4.0.0 and 4.0.13. Regards, Jocelyn - Original Message - From: "Karl J. Stubsjoen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 11:13 P

Re: Anyone had a chance to try an Opteron yet?

Linux compiled on an opteron and targeted for it will lose the 2-gig process limit. the 2-gig number is based on a 32 bit integer. You now would a have 64 bit integer (5 Quintillion as an unsigned integer. :-)). Imagine the 10GB database in memory, plus the temp and heap tables and the index

Re: mysql.sock doesn't exist

I changed the port in /etc/my.cnf and restarted the service but still get a message that I can't connect to the server, etc. I am still not seeing any "fresh" log messages. Why would there not be any output on that? Is there someplace I should look for a log file besides /var/log ? Kevin --

Re: Anyone had a chance to try an Opteron yet?

On Tue, Jun 24, 2003 at 05:37:24PM -0400, Curtis Maurand wrote: > > Linux compiled on an opteron and targeted for it will lose the 2-gig > process limit. the 2-gig number is based on a 32 bit integer. You now > would a have 64 bit integer (5 Quintillion as an unsigned integer. :-)). > > Imagi

RE: Strange "Mull" in show fields and table keeps crashing

MUL indicates a that the column is part of a composite INDEX. SHOW INDEX FROM tablename Should let you know what columns make up the MUL column INDEX. If this was not supposed to be indexed, your table is corrupt, best try MyIsamChk Regards, Mike Hillyer www.vbmysql.com > -Original Messa

Re: Replication Performance

On Tue, Jun 24, 2003 at 03:34:48PM -0500, Todd Burke wrote: > > Hello > > 1/ I have a search engine which crawls auction sites and returns > information which is inserted into a mysql database. This activity > represents on average about 3 inserts per second with a combined payload > of 450 byte

Installing On Red Hat 9?

Can anyone point me to docs on installing MySQL on Red Hat 9 on an Intel box? Thanks, -m === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld question

At 12:44 2003-06-24, Janice Wright wrote: Well, in the Managing MySQL course run by MySQL AB; they taught us that upgrading hardware is the *last* thing you do to get the database to run faster, not the first. Before you buy new hardware you should: Thanks for the info! (appreciate it) Though I

Re: Installing On Red Hat 9?

On Tue, Jun 24, 2003 at 02:54:23PM -0700, Mike wrote: > Can anyone point me to docs on installing MySQL on Red Hat 9 on an Intel box? I don't think it's any different from previous RedHats. Downlaod the RPMs from www.mysql.com. Install them using "rpm -i *.rpm" Granted, I'm no RH expert, but I

Re: mysql 4.1 client authentication

in Version 4.1 the passwords are 45 bits in Version <4.1 passwords are 16 bits Upgrade your client will make it work again. You sould be able to connect from any 4.1 mysql client. Best regards 2003年 6月 25日 水曜日 03:[EMAIL PROTECTED] さんは書きました: > Does anyone know what is different in mysql 4.1 clie

Re: InnoDB foreign keys

> If possible, what is the syntax? It's possible, but if you can't search, I'm not sure you can handle it. ;P http://www.innodb.com/ibman.html#InnoDB_foreign_keys Edward Dudlik Becoming Digital www.becomingdigital.com Did I help you? Want to show your thanks? www.amazon.com/o/registry/EGDXEBBWT

Temporary tables - MySQL 4.1 alpha

Hi MySQL Fans ;-), I have some questions about temporary tables. I would appreciate any replies: I created a temporary table f.e. like this: mysql> create temporary table temp SELECT * FROM relations; Query OK, 4 rows affected (2.35 sec) Records: 4 Duplicates: 0 Warnings: 0 When I do mysql>

Re: mysql.sock doesn't exist

Kevin H. Phillips wrote: I changed the port in /etc/my.cnf and restarted the service but still get a message that I can't connect to the server, etc. I am still not seeing any "fresh" log messages. Why would there not be any output on that? Is there someplace I should look for a log file besi

about desc command

Hello, mysql, After create a table,it can use desc tablename to describe the table scheme. But it can not demonstrate that the column is unique or not.It just simplely show the column is MUL type. How can I get more information from the table by using mysql commend?(Except use my

Query Execution Time in mysql

Hi All, I have 2 tables say "table1" and "table2" in the database. I am using the following query to copy all the data from table2 to table1. insert into table1 select * from table2; Table2 has some 10,000 records while table1 has around 11,00,000 records. The time reqd. to execute the above qu

datetime column dummy question

Hello, mysql, A table contains a column named "mydate". //Wrong sql statement alter table p_asset add mydate datetime default now(); alter table p_asset add mydate datetime default time(); alter table p_asset add mydate datetime default now; alter t

Re: about desc command

On Wed, 25 Jun 2003 11:29:25 +0800 "MaFai" <[EMAIL PROTECTED]> wrote: Hello, mysql, After create a table,it can use desc tablename to describe the table scheme. But it can not demonstrate that the column is unique or not.It just simplely show the column is MUL type. How can I get more

Database replication

I want to be able to take a database running on a primary server and duplicate/mirror it on a secondary server. I want to be able to update the secondary server on a selectable interval (every 15 mins, every hour, etc). What is the best way to accomplish this task? Consider that at least one table

Re: Freeing memory

At 13:19 -0500 6/24/03, Jay Blanchard wrote: Other than mysql_free_result() how can I free up memory upon the completion of a query? Why don't you want to use the function that is provided for that purpose? TIA! jay -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.my

Sorting Countries

I am getting a list of all countries from database, and then I am sorting by country name. However since most orders will be from US I want the US to appear first over the rest of the countries. How can I go about doing this? Currently, this is my query: SELECT countries_id, countries_name FROM T

SQL Query

Hi all, I just looked at the mysql doc and I didnt find an answer to my question. does mysql has the minus statement ? or is there something similar ? SELECT something FROM somewhere MINUS SELECT something_else FROM somewhere; Or this one could do the job but mysql doesnt seems to accept it e

Re: Authentication problem with MyODBC 3.51

At 9:17 +0200 6/17/03, Laura del Cano wrote: Hello, I have intalled Mysql 4.1.0 and MyODBC 3.51 under Windows 2000. I create a new database in Mysql and a user with all the privileges on it (using GRANT ALL privileges...). I create a User DSN in the windows Control Panel and when I test the connec

Re: MyODBC 3.51 for MySQL 4.1

At 9:54 +0100 6/17/03, [EMAIL PROTECTED] wrote: I am using MySQL 4.1 alpha for windows for new development. Is MyODBC 3.51.06 supposed to work for MySQL 4.1 alpha? I get message [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server. Consider upgrading MySQL c

Re: mysql 4.1 client authentication

Uuups I meant 16 bytes and 45 bytes of course ;-) - otherwise anybody with a 286 could have found out ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 25日 水曜日 07:35、Nils Valentin さんは書きました: > in Version 4.1 the passwords are 45 bits > in Version <4.1 passwords are 16 bits > > Upgrade your cl

  1   2   >