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

Thanks, I found it but I wasn't sure if it could be changed between my INSERT and the SELECT LAST..() by another instance of my application. I'll suck-it-and-see ! Matt [EMAIL PROTECTED] wrote: The good ol' LAST_INSERT_ID() function is what you probably need. Check it out in manual.

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

As stated only few days ago on this list, the LAST_INSERT_ID() is relevant per connection, i.e. it returns the correct last inserted id of the current connection, disregarding other possible inserts done through other parallel connections. So each connection has its own counter for this. HTH,

Re: Infos about the embedded server dll

Thanks I'll get a look libmysql still need a mysql server, isn't it ? I would like to integer the support for mysql whitout having to install a mysql server, that's why I search infos about libmysqld and not mysql. What do you mean with libmysql.dll seems to work better. The purposes are

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

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

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:

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 EOF

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='root';

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 while delete

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.

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 more

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 WHERE

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

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 my

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 MySQl and

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 delete the tno in

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=ensita

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

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

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

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 if

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

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 either

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

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

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 snip Thanks for the explanation, I'm no sql-guru at all, so all info is welcome! :-) I'm

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 to run any

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:

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 % mysqldump test

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: are

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

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: snip Don't forget to use '-B' in order to make the output silent except for the results: and -N to suppress column names. snipagain 2. you should stick your password (which shouldn't match your UNIX password) in a textfile readable only by you

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

[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:

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

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

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

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

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

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

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 guess

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

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:

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

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

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

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

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

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

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 look

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

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

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

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 PM

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

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. :-)). Imagine

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

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 bytes per

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: snip Thanks for the info! (appreciate it)

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 client

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?

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

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

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 query

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

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,

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

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

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

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

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:35Nils Valentin : in Version 4.1 the passwords are 45 bits in Version 4.1 passwords are 16 bits Upgrade your client will make it

mysqlhotcopy does not read configuration files.

Description: mysqlhotcopy does not read defaults from my.cnf and .my.cnf files. How-To-Repeat: Run mysqlhotcopy and observe it doesn't read client defaults. Fix: See below for patch, shown as a context diff Submitter-Id: submitter ID Originator:Larry Stone

Re: LAST_INSERT_ID() returns different values on different connections

At 16:02 +0300 6/17/03, Baris Akin wrote: Hello, I try to get last inserted autoincrement record ID on table with LAST_INSERT_ID() function (SELECT LAST_INSERT_ID() FROM TABLE). Every connection returns it's own last inserted ID not actual ID. Is this a bug? Also it returns more than one

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

Thank you for your response to my first post on this list. I really appreciate your time to answer my question. I tried every thing I could think following the manual for LOAD DATA before I joined this list. I probably did not explain my problem clearly in my initial post. What I try to do is

Re: SQL Query

SELECT Place.id, Place.name FROM Place LEFT JOIN Place_link ON Place.id=Place_link.Place WHERE Place.id!=1 AND Place_link.LinkTo!=1; This section of the manual will probably help you further. http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html Edward Dudlik Becoming Digital

emalloc() error being thrown {LONG}

Good morning! (My apologies for sending to both lists, I found emalloc() info on both PHP and MySQL that might be applicable and could not make a good call as to where this might be more appropriate) We are attempting to return a rather large file from a set of queries to MySQL via PHP. Each