Re: MySQL user privilages
Alright I have tried to do the grant like the following: GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; With no luck I keep getting an error message... ERRO 1064: You have an error in you SQL syntax near 'usre%.* To user@% IDENTIFIED BY password at line 2 Any help would be appreciated. TIA, Ryan --- Paul DuBois [EMAIL PROTECTED] wrote: At 9:25 -0800 12/8/02, Ryan McDougall wrote: Hi thanx for the details... Ok I know I am thick... and for some reason I cannot get my head around this, let me try to explain what I want to do then maybe you can tell me its possible and how it is possible. I want to create a user that can be creative as he wants... allow him to create ANY databases he wants and delete them if he no longer needs them, but at that same time not be able to mess with ANY other privileges or anyone elses DBs. That's not how it works. You can grant privileges for any database, but you can't grant privileges for any database except certain databases. One thing that may help is that you can use a pattern to specify the database name in the GRANT statement. Then the user can create any database that has a name matching the pattern. For example, GRANT ALL ON xyz%.* ... will allow the user to create and mess with any database having a name that begins with xyz. The only other way I can think of it to compare it to a windows situation. Lets say I'm in Windows and I start up MS Access... Now with me being a Windows user I can create any DB I want and do whatever I want to the DBs I've created (as long as its not in a read only folder) but I can't see or do anything to to the other peoples creations becuase I don't have permissions to do so. Am I going to have to, as root or another super user, create his DBs for him and then give him privileges to them? I just don't get how that sort of situation works in a production environment. But then again in a production environment you don't usually have people just creating DBs at will. Again sorry for my complete lack of understanding on this and stupidity, but my brain just will not wrap itself around this issue. You're probably trying to understand the MySQL privilege system as analogous to some other type of privilege system. Try to understand it as itself and you'll probably get farther. Thanx for all the help so far, Ryan McDougall __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sub-Select query
Dear all, I have the following query. When executed in MySQL I get an error on the first sub-select, and I can't find why: select slbc.stockcode, s.description, slp.qtyinstock, smax.pluqty, (slp.qtyinstock / smax.pluqty) from stocklevelbc slbc, stock s, stocklevel slp, stock smax, stocklevelbc slbcmax where slbc.stockcode = s.stockcode and slbc.restcode = NIC-PAG-1 and slp.plu = s.plu and slbc.restcode = slp.restcode and smax.stockcode=slbcmax.stockcode and slbcmax.stocklevelid in (select z.stocklevelid from stocklevelbc z, stock ss where z.restcode=slbc.restcode and z.stockcode in (select sss.stockcode from stock sss where sss.plu = s.plu) order by qtytransfered desc) The tables in use are: STOCK --- StockCode varchar(30) Description varchar(100) PLU varchar(20) PLUQty decimal(10,4) STOCKLEVELBC -- StocklevelIDint(11) auto_increment RestCodevarchar(20) StockCode varchar(30) QtyInStock decimal(10,4) QtyTransfered decimal(10,4) STOCKLEVEL -- StocklevelIDint(11) auto_increment RestCodevarchar(20) PLU varchar(20) QtyInStock decimal(10,4) QtyTransfered decimal(10,4) The idea is that there are several stock codes that are the same product, but different packagings. All same products have the SAME *PLU* code, so that they are grouped together. When sales are made (these are for a restaurant), the sale is done from the PLU and NOT from the stockcode, because products are purchased in bottles, but sold in glasses, so we cannot know which bottle was opened to sell a glass of whisky for example. So I have the QtyInStock in the STOCKLEVEL table showing the stocklevel for each PLU. Now, I want to know how many BOTTLES this QtyInStock refers to, by dividing the QtyInStock by the number of the PLUQty for the MOST PURCHASED TYPE OF PACKAGING/BOTTLE For example: Carlsberg beer (small bottle - 33CL) - Bottles transferred = 500 bottles Carlsberg beer (large bottle - 63CL) - Bottles transferred = 200 bottles Carlsberg beer (common PLU) - QtyInStock = 20,000CL Results should be: = Most popular packaging - Small Bottle 33CL = QtyInStock represented as a number of most popular packaging in stock = 20,000 / 33 = 606.06 Any ideas VERY much appreciated Regards, Christos Vorkas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sub-Select query
I have the following query. When executed in MySQL I get an error on the first sub-select, and I can't find why: http://www.mysql.com/doc/en/News-4.1.x.html You'll see that sub-select query will be in future 4.1.xx release ... David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL4 on Linux with Intel Hyperthreading CPUs?
Hi Group, I have a new dedicated mysql 4.0.5 server running redhat 8.0 that we are testing. The new server is a dual Intel Xeon 2.4GHZ with hyperthreading enabled, so Linux thinks there are 4 cpu's rather than the 2 real CPU's. I have a similar hardware running mysql 3.23.52 on linux. In my special case mysql has to handle few but very straining queries (running 10-30 seconds). As of my experience, mysql is not able to use both physical processors to process one of these jobs... it really bunches two virtual processors (even though top shows 0% load for the 3 remaining processors) but not physical processor spanning. I would like one single mysql process to make use of all available cpu capacity if no concurrent processes demand attention. But: is this possible using mysql 3.x? Thanks in advance Keith Sauvant - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
READ-COMMITTED does not behave as expected
If I use the transaction isolation level of READ-COMMITTED, I have the problems that I do not see changes to the table made within another connection (and commited) until I call commit in my connection. As of my understanding this behaviour is correct for the REPEATABLE-READ and SERIALIZABLE isolation level, but not for READ-COMMITTED. Beside the fact that this is not the behaviour I expect, this results in performance loss, because lots of version have to be created if multiple users have open connections. I tried this under Windows 2000 [Version 5.00.2195] SP 3. (The variables and status are attached to this mail) Thanks in advance! Best regards Horst Scheruga Show variables: Variable_name Value back_log50 basedir C:\mysql\ bdb_cache_size 8388600 bdb_log_buffer_size 32768 bdb_homed:\MySqlData\ bdb_max_lock1 bdb_logdir bdb_shared_data OFF bdb_tmpdir D:\Temp\ bdb_version Sleepycat Software: Berkeley DB 3.2.9a: (September 27, 2002) binlog_cache_size 32768 bulk_insert_buffer_size 8388608 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert ON connect_timeout 5 convert_character_set datadir d:\MySqlData\ delay_key_write ON delayed_insert_limit100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 1800 ft_min_word_len 4 ft_max_word_len 254 ft_max_word_len_for_sort20 ft_boolean_syntax + -()~*:| have_bdbYES have_innodb YES have_isam YES have_raid NO have_symlinkYES have_opensslNO have_query_cacheYES init_file innodb_additional_mem_pool_size 1048576 innodb_buffer_pool_size 8388608 innodb_data_file_path ibdata1:10M:autoextend innodb_data_home_dir innodb_file_io_threads 4 innodb_force_recovery 0 innodb_thread_concurrency 8 innodb_flush_log_at_trx_commit 0 innodb_fast_shutdownON innodb_flush_method innodb_lock_wait_timeout50 innodb_log_arch_dir innodb_log_archive OFF innodb_log_buffer_size 1048576 innodb_log_file_size5242880 innodb_log_files_in_group 2 innodb_log_group_home_dir .\ innodb_mirrored_log_groups 1 interactive_timeout 28800 join_buffer_size131072 key_buffer_size 8388600 languageC:\mysql\share\english\ large_files_support ON local_infileON log OFF log_update OFF log_bin OFF log_slave_updates OFF log_slow_queriesOFF log_warningsOFF long_query_time 10 low_priority_updatesOFF lower_case_table_names ON max_allowed_packet 1048576 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 100 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_user_connections0 max_tmp_tables 32 max_write_lock_count4294967295 myisam_max_extra_sort_file_size 268435456 myisam_max_sort_file_size 2147483647 myisam_recover_options OFF myisam_sort_buffer_size 8388608 named_pipe OFF net_buffer_length 16384 net_read_timeout30 net_retry_count 10 net_write_timeout 60 open_files_limit0 pid_filed:\MySqlData\scheruga.pid port3306 protocol_version10 read_buffer_size131072 read_rnd_buffer_size262144 rpl_recovery_rank 0 query_cache_limit 1048576 query_cache_size0 query_cache_typeON safe_show_database OFF server_id 0 slave_net_timeout 3600 skip_external_locking ON skip_networking OFF skip_show_database OFF slow_launch_time2 socket MySQL sort_buffer_size2097144 sql_mode0 table_cache 64 table_type MYISAM thread_cache_size 0 thread_stack65536 tx_isolationREAD-COMMITTED timezoneW. Europe Daylight Time tmp_table_size 33554432 tmpdir D:\Temp\ version 4.0.4-beta-max-nt wait_timeout28800 Show status: Variable_name Value Aborted_clients 336 Aborted_connects0 Bytes_received 0 Bytes_sent 0 Com_admin_commands 0 Com_alter_table 0 Com_analyze 0 Com_backup_table0 Com_begin 0 Com_change_db 2769 Com_change_master 0 Com_check 0 Com_commit 2276 Com_create_db 0 Com_create_function 0 Com_create_index0 Com_create_table1 Com_delete 2463 Com_delete_multi0 Com_drop_db 0 Com_drop_function 0 Com_drop_index 0 Com_drop_table 1 Com_flush 0 Com_grant 0 Com_ha_close0 Com_ha_open 0 Com_ha_read 0 Com_insert 2465 Com_insert_select 0 Com_kill0 Com_load0 Com_load_master_data0 Com_load_master_table 0 Com_lock_tables 0 Com_optimize0 Com_purge 0 Com_rename_table0 Com_repair 0
Re: MySQL3.23.52 with snort-1.9.0
Hi there , I am problems with snort logging to Mysql and I am wondering if this is a permissions problem . If any of you have worked on the snort IDS technology could you please help because I having severe difficulty with the product. The permissions I have given the User snort are GRANT CREATE,INSERT,SELECT,DELETE,UPDATE on snort.* to snort; GRANT CREATE,INSERT,SELECT,DELETE,UPDATE on snort.* to snort@localhost; Thanks in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to enter data in MySQLCC
Hi, I've installed MySQLCC as a client on Windows 2000, it connects via the net to a linux server running the mysql server and it's working ok to the point where I try to enter data into any cell of my tables other than one expecting a numerical value. I know MySQLCC is only in beta test mode but surely it should be able to accept data entry in non numerical cells? Thanks, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Inconsistent behavior when populating table?
Hi,
I've written a Perl script to populate my MySQL table. It grabs values from
my old database and uses the following for each to form a comma separated
list of single quoted items...
Each of the @values items is passed through: $value =
$db-quote($original_value) first.
$st = $db-prepare('INSERT INTO Enquiries VALUES (' . join(,,@values) .
')' )
|| print 'could not prepare: ' . $db-errstr;
$st-execute() || print Couldn't execute statement: . $st-errstr;
This works fine for _most_ of the fields but strangely, entire columns are
incorrect sometimes. Especially where I'm sending UCT (10-digit unsigned
ints) values to an unsigned int field. These work OK for some of my
coulmns/fields but not for others.
Any clues as to what I'm doing wrong?
Many thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pbm on install 3.23.54
Hi everyone... I have a problem, but maybe not related to mysql itself, for i have installed a RPM first, then deleted it, then tried the 4.0.5, then tried the 3.23.54, and still have the same problem... So here's the story Regarding the 3.23.54 install. I downloaded the source tar.gz... Put it in my home directory and typed : tar xzvf mysql then ./configure --prefix=/usr/local/mysql then make after this, as root, make install cd /usr/local/mysql ./bin/mysql_install_db chown -R mysql var chgrp -R mysql . then ./bin/safe_mysqld -u mysql but here's the first problem : ./bin/safe_mysqld: 5: command not found still, mysql seems to be running despite this error. But when trying to assign root a password, I can set it with mysqladmin -u root password 'myownpass', but can't set the mysqladmin -u root -h myhost.mydomain.mytld password 'myownpass'... the error is : ./bin/mysqladmin: connect to server at 'myhost.mydomain.mytld' failed error: 'Can't connect to MySQL server on 'myhost.mydomain.mytld' (111)' Check that mysqld is running on myhost.mydomain.mytld and that the port is 3306. You can check this by doing 'telnet myhost.mydomain.mytld 3306' when i go telnet on the box, i get a connexion refused so i thought that i could explicitly open the 3306, but it didn't changed anything. I created a my.cnf within which i have : [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K datadir = /usr/local/mysql/var # Start logging log [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=16M So my question is, does anybody sees why i have these errors ? I run with a RH7.3 TIA Stephane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
locking issues
Hi All,
I may be confused here but it would appear that when you issue a LOCK TABLES
tbl_name { READ|WRITE }; You cannot read from another unlocked table in the
same connection eg:
mysql LOCK TABLES users read;
Query OK, 0 rows affected (0.00 sec)
mysql select * from Logger limit 1;
ERROR 1100: Table 'Logger' was not locked with LOCK TABLES
I've read section 6.7.2 of the Manual:
http://www.mysql.com/documentation/mysql/bychapter/index.html#LOCK_TABLES
This is on 3.23.43.
I assume this is expected behaviour? Although at the moment it seems a
little odd that this thread cannot read from another (unlocked) table whilst
it has a lock.
Does anyone have a solution that I may be missing? We are locking tables to
do a fake transaction so that we can update a number of tables without
interference from other threads.
Thanks for any replies.
Greg Cope
JITC
This message and any attachment has been virus checked by
Pfizer Corporate Information Technology, Sandwich.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: READ-COMMITTED does not behave as expected
On Thursday 12 December 2002 11:23, Horst Scheruga wrote: If I use the transaction isolation level of READ-COMMITTED, I have the problems that I do not see changes to the table made within another connection (and commited) until I call commit in my connection. As of my understanding this behaviour is correct for the REPEATABLE-READ and SERIALIZABLE isolation level, but not for READ-COMMITTED. Beside the fact that this is not the behaviour I expect, this results in performance loss, because lots of version have to be created if multiple users have open connections. I tried this under Windows 2000 [Version 5.00.2195] SP 3. (The variables and status are attached to this mail) [skip] version 4.0.4-beta-max-nt [skip] READ COMMITTED is supported only since 4.0.5 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Can't find file: './mysql/host.frm'
On Wednesday 11 December 2002 22:41, SLefevre at i-m-i-international dot com wrote: OK, I'm making progess on my MySQL problem. The log file says this: 021211 15:32:05 mysqld started 021211 15:32:05 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021211 15:32:05 mysqld ended I've run the mysql_install_db script when I first installed mysql. I ran it again just today. I copied the directory from /var/lib/mysql to /usr/libexec/mysql (mysqld is in /usr/libexec), yet it says it still can't find the host.frm. [root@server test]# less /usr/libexec/mysql/ total 116 drwxr-xr-x3 root root 4096 Dec 11 15:30 ./ drwxr-xr-x7 root root 4096 Dec 11 15:28 ../ ... -rw-r-1 root root 8958 Dec 11 15:29 host.frm So now host.frm is in three places, but I get the same error. [root@server libexec]# locate host.frm /usr/libexec/mysql/host.frm /var/lib/mysql/mysql/host.frm /var/lib/mysql/host.frm Where the heck does it think it should be? It should be located in the directory of database 'mysql'. MySQL can't find the file because it doesn't have permissions on it. $ perror 13 Error code 13: Permission denied -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Newbie - auto_increment multiple table insert help
On Thursday 12 December 2002 07:23, Max Clark wrote: I would like to run an insert query across two tables at the same time. The first table has a primary key that is auto_increment, the second table needs to insert the primary key from the first table as a reference? How do I auto-populate the tableId field with the correct entry from the first table insert? Thanks in advance, Max insert into table1 (name, desc) values (foo, foouser); id name desc 55 foo foouser insert into table2 (table1Id, text) values (?, some text); id table1Id text 69 55 some text Use LAST_INSERT_ID() function: http://www.mysql.com/doc/en/Miscellaneous_functions.html http://www.mysql.com/doc/en/example-Foreign_keys.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: Mysql Hogging ram?
On Wednesday 11 December 2002 18:45, Benjamin Pflugmann wrote: These problems are causing me serious pain as whenever a large process starts my load avg jumps throught the roof. I run radius off of this database, and when the load jumps users fail to authenticate. Any help/sugestions with this matter would be great. 256MB for the key_cache on a 860MB system looks completely sane to me, maybe even small, depending what else runs on the machine. But if that memory usage makes problems, you should decrease it, of course. But remember that the price you pay is a performance loss for MySQL. How much, that depends on how efficient the key cache is with the new size. Well, my rough guess is that these 256m somehow gets swapped out. When large process that needs MySQL starts, MySQL gets loaded from swap and that, of course, makes loadavg go up alot. In rare cases some combination of these environment conditions makes system unusable. I've seen such. On the other hand, I wonder what claims the other 590MB of your system? Well :) What can I suggest - try to lower the requirements for MySQL significantly OR try to raise it. Of course, you can also run mysqld with --memlock. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
add multiple records as a result from an if statement
Hi, I have a form with two sections on it. The user either completes one or both sections. (The validation is controlled by JavaScript) at the moment no matter how many sections they complete all the information is added to one record(through asp). But what I want to happen, is if the user completes two sections, two records will be added into the database instead of one. and if they complete one section, only one record will be added. can any one help me? Thanks Kaan. MYSQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling 3.23.54-1
Hi ! I`m trying to compile 3.23.54-1 from src.rpm with error: ... + mv Docs/manual.ps.save Docs/manual.ps + automake aclocal.m4: 1272: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' aclocal.m4: 1273: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' aclocal.m4: 1379: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' libmysql_r/Makefile.am:26: library used but `LIBTOOL' not defined in `configure.in' Error: Bad exit status from /var/tmp/rpm-tmp.61894 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.61894 (%build) My conf is: rh 7.0 2.2.23 glibc-2.2.4-18.7.0.8 greetz gnu --- Konto bez opat i prowizji? TAK! eKONTO w mBanku! http://pf.wp.pl/mbank.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Field type conversion question
I need to create a table that will store employees that attended certain events. I have two tables set up for this purpose. One (EmpTable) stores employee demographic information. The other (Events) stores information about the events (date, time, location, etc.) In EmpTable, the employee name is stored in fields FirstName and LastName. I would like to have a field in Events that will store multiple names with both fields from EmpTable concatenated into one string (i.e. FirstName LastName) What is the most efficient way to do this in MySQL? Thanks, Brad This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by legal privileges or statutory protections. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify us and delete the original message. Upon request, we will reimburse you for reasonable costs incurred in notifying us. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL4 on Linux with Intel Hyperthreading CPUs?
If the OS can use hyperthreading, fortunately, benchmarks are showing that there's no preformance hits because of overhead created trying to keep resource contention down. This is good! So if your system _can_ support hyperthreading, leaving it on won't hurt, if it doesn't improve your system's performance. If the OS doesn't support hyperthreading, then it just won't use it, obviously, so it's not an issue. But as far as MySQL's usage and performance in particular with hyperthreading procs, I don't have any experience :/ Mike -Original Message- From: John Dell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 6:15 PM To: [EMAIL PROTECTED] Subject: MySQL4 on Linux with Intel Hyperthreading CPUs? Hi, I have a new dedicated mysql 4.0.5 server running redhat 8.0 that we are testing. The new server is a dual Intel Xeon 2.4GHZ with hyperthreading enabled, so Linux thinks there are 4 cpu's rather than the 2 real CPU's. Anybody have any experience with this and whether it can cause any problems with MySQL or Linux? Any performance reasons to enable/disable hyperthreading? Thanks! John Dell [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
porting MS SQL to mySQL
Hi all- I need to know what the mySQL equivalents are to the following MS SQL datatypes: nvarchar smallint bit int ntext real datetime float money smalldatetime numeric decimal Thanks for your help! Tom - Improve your reimbursement rate and lower your risk for audit. The MMI Coding Hotline is ready to assist you with coding answers and billing guidelines at http://hotline.institute.md - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.54 is released
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 3.23.54, a new version of the world's most popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. This is a bugfix release for the current stable tree. Apart from fixing several bugs, this release also resolves multiple security vulnerabilities that have been found and reported to us by Stefan Esser from e-matters GmbH, Germany. You can read the full text of Stefans advisory here: http://security.e-matters.de/advisories/042002.html We are very grateful for his help in spotting and reporting this problem to us. As these vulnerabilities can be exploited from a remote attacker to crash the MySQL server or to execute arbitrary code with the privileges of the user running the MySQL server, we strongly advise all users to upgrade to this version. MySQL 4.0 is also affected by this problem - we will provide updated packages for this version as soon as possible, too. The required fixes have already been applied to our public BitKeeper source repositories as well. From the ChangeLog: * Fixed a bug, that allowed to crash `mysqld' with a specially crafted packet. * Fixed a rare crash (double `free''d pointer) when altering a temporary table. * Fixed buffer overrun in `libmysqlclient' library that allowed malicious `MySQL' server to crash the client application. * Fixed security-related bug in `mysql_change_user()' handling. All users are strongly recommended to upgrade to the version 3.23.54. * Fixed bug that prevented `--chroot' command-line option of `mysqld' from working. * Fixed bug that made `OPTIMIZE TABLE' to corrupt the table under some rare circumstances. * Fixed `mysqlcheck' so it can deal with table names containing dashes. * Fixed shutdown problem on Mac OS X. * Fixed bug with comparing an indexed `NULL' field with `= NULL'. * Fixed bug that caused `IGNORE INDEX' and `USE INDEX' sometimes to be ignored. * Fixed rare core dump problem in complicated `GROUP BY' queries that didn't return any result. * Fixed a bug where `MATCH ... AGAINST () =0' was treated as if it was `'. * One can create `TEMPORARY' `MERGE' tables now. * Fixed that `--core-file' works on Linux (at least on kernel 2.4.18). * Fixed a problem with `BDB' and `ALTER TABLE'. * Fixed reference to freed memory when doing complicated `GROUP BY ... ORDER BY' queries. Symptom was that `mysqld' died in function `send_fields'. * Allocate heap rows in smaller blocks to get better memory usage. * Fixed memory allocation bug when storing `BLOB' values in internal temporary tables used for some (unlikely) `GROUP BY' queries. * Fixed a bug in key optimizing handling where the expression `WHERE column_name = key_column_name' was calculated as true for `NULL' values. * Fixed core dump bug when doing `LEFT JOIN ... WHERE key_column=NULL'. * Fixed `MyISAM' crash when using dynamic-row tables with huge numbers of packed fields. Additional notes: * Due to a hardware failure, we are currently unable to provide Solaris 2.7 binaries - we apologize for any inconveniences that may cause you. * The windows binaries may not have been copied to all mirror sites yet - please give the mirrors a while to synchronize. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE9+J68SVDhKrJykfIRAoOZAJ9bmYWgyPOkcx/067TM3vKt+81pTACdE3sG jCZsNbHwXpqigRpL96RHQZQ= =KcLE -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Manual on MySQL is not updated...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 11 Dec 2002, Dyego Souza do Carmo wrote: http://www.mysql.com/doc/en/Installing_source_tree.html In the manual , to compile a source tree only type: shell cd mysql-4.0 shell bk -r get -Sq shell aclocal; autoheader; autoconf; automake; shell ./configure # Add your favorite options here shell make but , if you using innodb this is not true, to perfect compilation of mysql with innodb you take: shell cd mysql-4.0 shell bk -r get -Sq shell aclocal; autoheader; autoconf; automake; shell cd innobase shell aclocal; autoheader; autoconf; automake; shell cd .. shell ./configure # Add your favorite options here shell make if you not type aclocal; autoheader; autoconf; automake; in innobase directory , the compilation print a error. i´m true ? Yes, that's correct. Thanks for the hint - I fixed this part of the manual now. Bye, LenZ - - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE9+KOsSVDhKrJykfIRAhv8AJwJX6831og2hBTRVaGq3gZIr7GTVgCfSFwE ZJfa8h+vQ8MFpE+gpkhEZ68= =WBQe -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: porting MS SQL to mySQL
Here's some info that might help: nvarchar = MS$ variable character string, up to 4000 characters, stored as UNICODE UCS-2. AFAIK, MySQL doesn't (yet) support UNICODE directly. However, M$ SQL often forces the nvarchar/ntext types on by default. So, if you don't need UNICODE, use varchar. If you do, you can use VARCHAR BINARY to store the data, but you won't get exactly what you're after when it comes to string operations and comparisons (? true -- can someone else elaborate - I'm not much into UNICODE). M$ SQL smallint = 16-bit signed integer = MySQL smallint M$ SQL bit = tinyint(1) (MySQL treats BIT as a synonym for tinyint(1)), just be careful to store only 0 or 1 -- or code things as = 0 and 0. M$ int = 32-bit signed integer = MySQL int ntext = variable-length UNICODE data, max 2**30 - 1 chars. Since MySQL doesn't (yet) support UNICODE directly, replace this with MySQL's blob for UNICODE storage or text if UNICODE is not required (? needs more on what would happen if you put UNICODE chars in a blob and then tried to sort/substring/compare/etc. the values -- I assume this won't work as expected). M$ SQL real = floating point number from -3.40E+38 to 3.40E+38 stored as 4 bytes = MySQL float M$ SQL float = floating point from -1.79E-308 to 1.79E+308 (but precision can be affected by size -- float(24) is a single-precision, float(53) is double-precision) = MySQL double M$ SQL datetime = Date time to 1/3 millisecond = MySQL DATETIME, however MySQL doesn't store the fractional time portion. You may have to split this into two columns, a DATETIME to hold date and time with accuracy to 1 second, and a separate INT to hold the millisecond portion of the time. M$ SQL money = 4-place decimal from -2**63 to 2**63 - 1 = MySQL DECIMAL(21,4), although you may not need that much space M$ SQL smalldatetime = Date and time with minute accuracy = MySQL datetime, but be sure to mask off any seconds before you store values, since MySQL stores the time down to seconds. M$ SQL numeric decimal = MySQL decimal hth Bob Diss, [EMAIL PROTECTED] From: Tom Coffin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Thu, 12 Dec 2002 09:25:38 -0500 Hi all- I need to know what the mySQL equivalents are to the following MS SQL datatypes: nvarchar smallint bit int ntext real datetime float money smalldatetime numeric decimal Thanks for your help! Tom - Improve your reimbursement rate and lower your risk for audit. The MMI Coding Hotline is ready to assist you with coding answers and billing guidelines at http://hotline.institute.md - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Manual on MySQL is not updated...
Hi, About bk -r get -Sq, after a bk pull, is bk -r edit still needed or bk -r get -Sq could replace it ? Thanks and regards, Jocelyn - Original Message - From: Lenz Grimmer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 2:56 PM Subject: Re: The Manual on MySQL is not updated... -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 11 Dec 2002, Dyego Souza do Carmo wrote: http://www.mysql.com/doc/en/Installing_source_tree.html In the manual , to compile a source tree only type: shell cd mysql-4.0 shell bk -r get -Sq shell aclocal; autoheader; autoconf; automake; shell ./configure # Add your favorite options here shell make but , if you using innodb this is not true, to perfect compilation of mysql with innodb you take: shell cd mysql-4.0 shell bk -r get -Sq shell aclocal; autoheader; autoconf; automake; shell cd innobase shell aclocal; autoheader; autoconf; automake; shell cd .. shell ./configure # Add your favorite options here shell make if you not type aclocal; autoheader; autoconf; automake; in innobase directory , the compilation print a error. i´m true ? Yes, that's correct. Thanks for the hint - I fixed this part of the manual now. Bye, LenZ - - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE9+KOsSVDhKrJykfIRAhv8AJwJX6831og2hBTRVaGq3gZIr7GTVgCfSFwE ZJfa8h+vQ8MFpE+gpkhEZ68= =WBQe -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL/InnoDB-3.23.54 is released
Hi! InnoDB is a MySQL table type which provides transactions, row level locking, foreign key constraints, and a non-free hot backup tool. InnoDB is included in MySQL-Max-3.23.54 and all downloadable versions of MySQL-4.0. You can download a free GPL version of these from http://www.mysql.com. 3.23.54 is a bugfix release of the stable MySQL-Max-3.23 branch, which is recommended for production use. * Fixed a bug: the InnoDB range estimator greatly exaggerated the size of a short index range if the paths to the endpoints of the range in the index tree happened to branch already in the root. This could cause unnecessary table scans in SQL queries. * Fixed a bug: SQL ORDER BY could fail if you had not created a primary key to a table, but had defined several indexes of which at least one was a UNIQUE index with all its columns declared as NOT NULL. * Fixed a bug: a lock wait timeout in connection with ON DELETE CASCADE could cause corruption in indexes. * Fixed a bug: if a SELECT was done with a unique key from a primary index, and the search matched to a delete-marked record, InnoDB could erroneously return the NEXT record. * Fixed a bug introduced in 3.23.53: LOCK TABLES ... READ LOCAL should not set row locks on the rows read. This caused deadlocks and lock wait timeouts in mysqldump. * Fixed a bug: if an index contains some column twice, and that column is updated, the table will become corrupt. From now on InnoDB prevents creation of such indexes. * An outstanding bug: in replication issuing SLAVE STOP in the middle of a multi-statement transaction can cause that SLAVE START will only perform part of the transaction. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: problem with replication
Any suggestion about this error? Thanks to all. --- Natale Babbo [EMAIL PROTECTED] ha scritto: Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET) Da: Natale Babbo [EMAIL PROTECTED] Oggetto: problem with replication A: [EMAIL PROTECTED] Hi all, I have a problem with replication between two servers. I created user repl on the master, I restored the master's dump on the slave, I changed both my.cnf settings but I got this error from slave .err file: MySql: ready for connections 021211 16:56:12 InnoDB: Started 021211 16:56:12 Slave I/O thread: connected to master 'repl@sviluppo01:3306', replication started in log 'FIRST' at position 4 021211 16:56:12 Error updating slave list: Query error 021211 16:56:12 Slave I/O thread exiting, read up to log 'FIRST', position 4 Master my.cnf: log-bin=/usr/local/mysql/log/MySQL-bin server-id=1 Slave My.ini: server-id=2 master-host=sviluppo01 master-user=repl master-password=repl What's wrong? Thanks in advance. __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Am I Violating Any Rules ?
In the last episode (Dec 12), Insanely Great said: Dan Nelson wrote: In the last episode (Dec 11), Karam Chand said: I want to statically link libmysql.dll with my closed source application, which I have not planned to distribute freely or commercial ? If you are not distributing the application, you are safe. If I distribute it free or commercial then ? If you distribute it, you must abide by the GPL license. Read http://www.mysql.com/doc/en/MySQL_licenses.html and both subsections. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL4 on Linux with Intel Hyperthreading CPUs?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Keith Sauvant wrote: Hi Group, I have a new dedicated mysql 4.0.5 server running redhat 8.0 that we are testing. The new server is a dual Intel Xeon 2.4GHZ with hyperthreading enabled, so Linux thinks there are 4 cpu's rather than the 2 real CPU's. I have a similar hardware running mysql 3.23.52 on linux. In my special case mysql has to handle few but very straining queries (running 10-30 seconds). As of my experience, mysql is not able to use both physical processors to process one of these jobs... it really bunches two virtual processors (even though top shows 0% load for the 3 remaining processors) but not physical processor spanning. I would like one single mysql process to make use of all available cpu capacity if no concurrent processes demand attention. But: is this possible using mysql 3.x? This would require operating system support for balancing a single process or thread across multiple CPUs, which I've never heard of (but might exist in some more exotic operating systems). In MySQL, each connection, and thus each query, maps to a thread. On almost all operating systems and hardware, any one thread or process executes on a single CPU at any one time. CPU cycles are not generally a 'sharable' resource, except in parallel processing type scenarios, which requires software to be built specifically for that kind of operation, and which is only useful to solve certain specific types of problems. -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9+K+ZtvXNTca6JD8RAujYAJ96qlQMqS4Lwk1PakCDOzEtna2VYQCePviC taG39ZYIVeR44ZkP8U0A9y4= =o4zz -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: READ-COMMITTED does not behave as expected
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Horst Scheruga wrote: If I use the transaction isolation level of READ-COMMITTED, I have the problems that I do not see changes to the table made within another connection (and commited) until I call commit in my connection. As of my understanding this behaviour is correct for the REPEATABLE-READ and SERIALIZABLE isolation level, but not for READ-COMMITTED. Beside the fact that this is not the behaviour I expect, this results in performance loss, because lots of version have to be created if multiple users have open connections. I tried this under Windows 2000 [Version 5.00.2195] SP 3. (The variables and status are attached to this mail) Thanks in advance! Best regards Horst Scheruga Show variables: Variable_name Value [snip] version 4.0.4-beta-max-nt [snip] The InnoDB storage engine shipped with MySQL-4.0.4 does not support the READ_COMMITED isolation level, it maps it to REPEATABLE_READ. The InnoDB storage engine that comes with MySQL-4.0.6 does support READ_COMMITTED. The particular isolation levels that InnoDB supports, and the details of their implementation can be found in the InnoDB manual at: http://www.innodb.com/ibman.html If you're using READ_COMMITTED for speed purposes, I would re-think that, as InnoDB tables using REPEATABLE_READ are as fast or faster than most other databases READ_COMMITTED isolation levels. For example, the e-week benchmark where MySQL with InnoDB performed as well as Oracle, and better than SQL Server, Sybase and DB2 was run at REPEATABLE_READ, while every other database ran at READ_COMMITTED. -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9+LDDtvXNTca6JD8RAu3vAJ9n6ZUWs7TyW0yTmYHGJMNZ84VElgCeIkJj 1a7CjPU/hSG0gdpzMNihTqs= =Tpi4 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem with replication
hi, try this : mysql SHOW MASTER STATUS; +--++--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--++--+- + | some-file| XX | | | +--++--+--+ mysql CHANGE MASTER TO MASTER_HOST='host', MASTER_USER='repl', MASTER_PASSWORD='repl', MASTER_LOG_FILE='some-file', MASTER_LOG_POS=XX; then restart the slave. -Message d'origine- De : Natale Babbo [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 12 décembre 2002 16:27 À : [EMAIL PROTECTED] Objet : Fwd: problem with replication Any suggestion about this error? Thanks to all. --- Natale Babbo [EMAIL PROTECTED] ha scritto: Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET) Da: Natale Babbo [EMAIL PROTECTED] Oggetto: problem with replication A: [EMAIL PROTECTED] Hi all, I have a problem with replication between two servers. I created user repl on the master, I restored the master's dump on the slave, I changed both my.cnf settings but I got this error from slave .err file: MySql: ready for connections 021211 16:56:12 InnoDB: Started 021211 16:56:12 Slave I/O thread: connected to master 'repl@sviluppo01:3306', replication started in log 'FIRST' at position 4 021211 16:56:12 Error updating slave list: Query error 021211 16:56:12 Slave I/O thread exiting, read up to log 'FIRST', position 4 Master my.cnf: log-bin=/usr/local/mysql/log/MySQL-bin server-id=1 Slave My.ini: server-id=2 master-host=sviluppo01 master-user=repl master-password=repl What's wrong? Thanks in advance. __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: MySQL user privilages
On Thursday 12 December 2002 10:03, Ryan McDougall wrote: Alright I have tried to do the grant like the following: GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; With no luck I keep getting an error message... ERRO 1064: You have an error in you SQL syntax near 'usre%.* To user@% IDENTIFIED BY password at line 2 Use backticks. mysql GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON `user%`.* TO 'user'@'%' IDENTIFIED BY password; Query OK, 0 rows affected (0.01 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: locking issues
On Thursday 12 December 2002 14:06, Greg_Cope at sandwich dot pfizer dot com
wrote:
I may be confused here but it would appear that when you issue a LOCK
TABLES tbl_name { READ|WRITE }; You cannot read from another unlocked table
in the same connection eg:
mysql LOCK TABLES users read;
Query OK, 0 rows affected (0.00 sec)
mysql select * from Logger limit 1;
ERROR 1100: Table 'Logger' was not locked with LOCK TABLES
I've read section 6.7.2 of the Manual:
http://www.mysql.com/documentation/mysql/bychapter/index.html#LOCK_TABLES
This is on 3.23.43.
I assume this is expected behaviour? Although at the moment it seems a
little odd that this thread cannot read from another (unlocked) table
whilst it has a lock.
Does anyone have a solution that I may be missing? We are locking tables
to do a fake transaction so that we can update a number of tables without
interference from other threads.
If you read the above section of the manual you can see:
When you use LOCK TABLES, you must lock all tables that you are going to use
and you must use the same alias that you are going to use in your queries! If
you are using a table multiple times in a query (with aliases), you must get
a lock for each alias!
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: RE: RE: UPDATE
On Thursday 12 December 2002 03:32, Cesar Aracena wrote: Exaclty, 0 rows affected, but no password changed... why's that? Thanks, If 0 rows were affected it's normal that password was not changed :) If you do a SELECT with the same condition, does MySQL find the any matched rows? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: create table ... select ... w/ index
On Thursday 12 December 2002 05:52, Amittai Aviram wrote: When you copy a table using CREATE TABLE ... SELECT ..., the indexes do not get copied automatically. Is there a convenient way to transfer all indexes, other than looking them up with DESCRIBE or SHOW INDEX and then using either ALTER TABLE ADD INDEX, etc., or CREATE INDEX? You can get output of SHOW CREATE TABLE, create table with indexes, then INSERT .. SELECT or do as you've described :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: INNODB still not working Re: Does mysql support foreign keyon delete cascade and on update cascade?
On Thursday 12 December 2002 01:45, Jing Dai wrote: I tried on delete cascade, it didn't work either. First of all , if you create table as you described in your previous mail, foreign key will not be created. You can check it with SHOW TABLE STATUS. Why? Because you specify .. FOREIGN KEY index_name(column_name) it's not a correct definition. According of the manual: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE CASCADE | ON DELETE SET NULL] Besides, MATCH FULL is also not supported yet and MySQL ignores ON DELETE clause in CREATE TABLE statement. If you remove it, it works perfectly well for me: mysql create table license_data( - licenseID integer(5), index licID_index (licenseID), foreign key (licenseID) REFERENCES license_info (licenseID) on delete cascade on update cascade, - logDate DATE NOT NULL, - totalLic integer(5) NOT NULL, - requestLic integer(5) NOT NULL, - issuedLic integer(5) NOT NULL, - queuedLic integer(5) NOT NULL, - deniedLic integer(5) NOT NULL) TYPE=INNODB; Query OK, 0 rows affected (0.00 sec) mysql insert into license_data values (LAST_INSERT_ID(), - 2002-01-11,1,1,1,1,1); Query OK, 1 row affected (0.00 sec) mysql select * from license_data; +---++--++---+---+---+ | licenseID | logDate| totalLic | requestLic | issuedLic | queuedLic | deniedLic | +---++--++---+---+---+ | 1 | 2002-01-11 |1 | 1 | 1 | 1 | 1 | +---++--++---+---+---+ 1 row in set (0.01 sec) mysql delete from license_info where LicenseID=1; Query OK, 1 row affected (0.00 sec) mysql select * from license_data; Empty set (0.00 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Select Where !=
So... Select n.uid, n.name from names_table n LEFT JOIN exclude ON n.uid = exclude.n_uid WHERE exclude.n_uid IS NULL; OK... this works, but I thought I would go a bit further... I have added a field in the exclude-table, cat_id. This shows which catalogue the names have been excluded from. I want to do the operation above, but limit it to only the current catalogue, namely 16. I tried: Select n.uid, n.name from names_table n, exclude e1 LEFT JOIN exclude ON n.uid = exclude.n_uid WHERE exclude.n_uid IS NULL AND e1.catid=16; I also tried putting some left joins in aswell, but I didn't get them to work. Am I mixing too much into the same query? // Michelle __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Select Where !=
So... Select n.uid, n.name from names_table n LEFT JOIN exclude ON n.uid = exclude.n_uid WHERE exclude.n_uid IS NULL; OK... this works, but I thought I would go a bit further... I have added a field in the exclude-table, cat_id. This shows which catalogue the names have been excluded from. I want to do the operation above, but limit it to only the current catalogue, namely 16. I tried: Select n.uid, n.name from names_table n, exclude e1 LEFT JOIN exclude ON n.uid = exclude.n_uid WHERE exclude.n_uid IS NULL AND e1.catid=16; I also tried putting some left joins in aswell, but I didn't get them to work. Am I mixing too much into the same query? // Michelle sql, query __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Remote Connection, please help
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using the
following code for simple remote connection test:
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
Connection con =
DriverManager.getConnection(jdbc:mysql://66.137.7.185:3306/prefill,prefill,jeem);
out.println(Testing Database Connectivity);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(select * from
state);
int i = 0;
while(rs.next() i 10)
{
out.println(h2 Output: +rs.getString(2) +
/h2);
i ++;
}
rs.close();
stmt.close();
con.close();
Your quick response will be highly appreciated.
=
Muhammad Salman
Sun Certified Java 2 Programmer
+92214932737 (H)
+923332234828(C 1)
+923332103334(C 2)
Email: [EMAIL PROTECTED]
Text Pager: [EMAIL PROTECTED]
Work Web: http://www.jeemsolutions.com
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
More locking issues
Hi, I'm new to MySQL. I see you all talking about locking databases etc... but isn't that the point of having a database server? So you don't have to worry about record locks? I'm designing the backend for a popular site where a user's visit will result in multiple read/write operations on a database. Is record locking something I definitely need to do? Thanks, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Load Data Infile command
HI all, I'm new to the list so I apologize if this subject has been answered already, I couldn't find a mailing list archive. We just upgraded (?) mysql to 3.23.49. We are running it on Linux Redhat 7.3 The load data local command is turned off by default. I have attempted to follow the instructions in the documentation (Ch. 4.2.4 and others) about this but it has been a dismal failure. I tried the following on restarting mysql: /etc/init.d/mysqld start --local-infile[=1] as in the manual. No luck. I also made some variations on this: --local-infile=1 --local-infile --local-infile(=1) --local-infile=[1] --local-infile=(1) None of these worked. I added the following two lines to the my.cnf file: [client] enable-local-infile and restarted. No luck. Has anyone been able to get this to work? I would really appreciate any help on this since I use the command to load data and it is part of several utility applications I use. Thanks in advance Jon Bertsch - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1
hi, i get the very same problem with: rh 6.2 2.4.17 glibc-2.1.3-28 the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. what could be the problem then? regards, tibyke GP I`m trying to compile 3.23.54-1 from src.rpm with error: GP GP ... GP + mv Docs/manual.ps.save Docs/manual.ps GP + automake GP aclocal.m4: 1272: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' GP aclocal.m4: 1273: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' GP aclocal.m4: 1379: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' GP libmysql_r/Makefile.am:26: library used but `LIBTOOL' not defined in `configure.in' GP Error: Bad exit status from /var/tmp/rpm-tmp.61894 (%build) GP GP GP RPM build errors: GP Bad exit status from /var/tmp/rpm-tmp.61894 (%build) GP GP My conf is: GP rh 7.0 GP 2.2.23 GP glibc-2.2.4-18.7.0.8 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Remote Connection, please help
I've never connected your way before. I'm using J/Connector from the MySQL site
(http://www.mysql.com/downloads/api-jdbc-stable.html). That way I have no problems
connecting. I do it this way:
// connect to the database
Class.forName(com.mysql.jdbc.Driver);
Connection dbConnection =
DriverManager.getConnection(jdbc:mysql://localhost/myTable, username, password);
Works like a charm. Give it a try...
-Pete
-Original Message-
From: Muhammad Salman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 11:36
To: [EMAIL PROTECTED]
Subject: Remote Connection, please help
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using the
following code for simple remote connection test:
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
Connection con =
DriverManager.getConnection(jdbc:mysql://66.137.7.185:3306/prefill,prefill,jeem);
out.println(Testing Database Connectivity);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(select * from
state);
int i = 0;
while(rs.next() i 10)
{
out.println(h2 Output: +rs.getString(2) +
/h2);
i ++;
}
rs.close();
stmt.close();
con.close();
Your quick response will be highly appreciated.
=
Muhammad Salman
Sun Certified Java 2 Programmer
+92214932737 (H)
+923332234828(C 1)
+923332103334(C 2)
Email: [EMAIL PROTECTED]
Text Pager: [EMAIL PROTECTED]
Work Web: http://www.jeemsolutions.com
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Group by problem
Hi, The following sql operators caused to incorrect results: CREATE TEMPORARY TABLE temp_list ( CurrID char(42) NOT NULL, OriginalID char(42) NOT NULL , DocRevision int(16) unsigned NOT NULL ) TYPE=InnoDB; insert into temp_list select CurrID, OriginalID, max(DocRevision) from some_table where DocRevision in (0,1,2,3) group by OriginalID having (sum(deleted) = 0); I revealed that temp_list table contains some incorrect values of CurrID (not matched to found OriginaID and Docrevision). According to Mysql documentation it should work. The values of CurrID is a primary key in some_table. These are the column definitions in some_table (InnoDB): CurrID char(42) NOT NULL, OriginalID char(42) NOT NULL , DocRevision int(16) unsigned NOT NULL . . . I check this in 3.51 and 3.53 and got the same results. Regards, Dmitry This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately and delete this communication. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote Connection, please help
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Muhammad Salman wrote:
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using the
following code for simple remote connection test:
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
Connection con =
DriverManager.getConnection(jdbc:mysql://66.137.7.185:3306/prefill,prefill,jeem);
out.println(Testing Database Connectivity);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(select * from
state);
int i = 0;
while(rs.next() i 10)
{
out.println(h2 Output: +rs.getString(2) +
/h2);
i ++;
}
rs.close();
stmt.close();
con.close();
Your quick response will be highly appreciated.
You need to tell us what the error you're receiving is, otherwise we
can't be of much help.
-Mark
- --
MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE9+MnBtvXNTca6JD8RAkxBAJ9tZD8OF6XByll9AW7IPabqMBZbiQCfdx4g
0lK6FUi8jP331x9czJqqK/E=
=kn1O
-END PGP SIGNATURE-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote Connection, please help
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
first a note: this is a topic best discussed on
[EMAIL PROTECTED]
* On Thu, Dec 12, 2002 at 08:35:40AM -0800, Muhammad Salman wrote:
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using the
following code for simple remote connection test:
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
Connection con =
DriverManager.getConnection(jdbc:mysql://66.137.7.185:3306/prefill,prefill,jeem);
out.println(Testing Database Connectivity);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(select * from
state);
int i = 0;
while(rs.next() i 10)
{
out.println(h2 Output: +rs.getString(2) +
/h2);
i ++;
}
rs.close();
stmt.close();
con.close();
that all looks pretty good. what error are you getting?
have you checked out the readme that comes with the driver?
it is pretty good at addressing some of the more often run
into problems of this variety.
- --
Peter Abplanalp
PGP: pgp.mit.edu
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9+NFVggA8sH0iRXQRArzMAJwLngnF/ouMCFMEEU846oExQE3H5gCgsrGv
IICJvZ3VPu4+MUtBAKsTAkU=
=NLko
-END PGP SIGNATURE-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: More locking issues
Hi, If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jeff Snoxell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 6:57 PM Subject: More locking issues Hi, I'm new to MySQL. I see you all talking about locking databases etc... but isn't that the point of having a database server? So you don't have to worry about record locks? I'm designing the backend for a popular site where a user's visit will result in multiple read/write operations on a database. Is record locking something I definitely need to do? Thanks, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
order results by count of searched expression
Hello mysql, I am trying to figure out sql command for ordering results descending by counts of searched expressions found in result. like this: $search=some; TEXT | COUNTS | - Something has..| 4| Some have..| 3| Some take..| 1| Can anyone help me please? -- Best regards, Martin mail [EMAIL PROTECTED] mobile +421.907.303.393 icq34358414 wwwhttp://www.corwin.sk PGP key fingerprint 21365ca05ecfd8aeb1cf19c838fff033 In those days spirits were brave, the stakes were high, men were real men, women were real women and small furry creatures from Alpha Centauri were real small furry creatures from Alpha Centauri. by Douglas Adams - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1
tibyke wrote: the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. Did the mysql team change tools versions? automake/autoconf? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Migration from Oracle
Dear Satish, Thank you for your help. Your welcome. I used MyODBC 3.51, and successfully migrated to MySQL. Is this a MySQL user stories case, or just a small migration? Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Satish Vohra [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 12:27 PM Subject: Re: Migration from Oracle Dear Stefan, Thank you for your help. I used MyODBC 3.51, and successfully migrated to MySQL. Regards Satish Stefan Hinz, iConnect (Berlin) wrote: Dear Satish, I want to migrate from Oracle to MySQL. So I need to import the tables and data from Oracle. Can anyone suggest any tool which can do this. Any pointer regarding this will be appreciated. (1) I am not familiar with Oracle, but I assume (oh, that word again) that it has a dump utility to create SQL files (with CREATE TABLE / INSERT statements). If it has, you can dump table definitions + data out of Oracle and import them into MySQL like that (using the MySQL Monitor command line client): shell mysql dump_from_oracle.sql In this case, it's fairly easy (and fast), but you will have to make sure the Oracle column types (DECIMAL, NUMERIC, INT, CHAR etc.) in use are being supported by MySQL. (2) Another way is to create the table definitions manually (choke!), export the data from Oracle (SELECT ... INTO OUTFILE) and import them into MySQL using LOAD DATA INFILE. (3) Yet another way is an ODBC connection from Oracle to MySQL, if Oracle supports ODBC. ODBC is slow, but not as desperately slow as I sometimes hear. As reported before on this list, I did a 1.2 million records import a couple of days ago from MS Access into MySQL using MyODBC 3.51.04. Table size was 500 MBytes, and it took 4 minutes on a 2 GHz machine running Win2K (table create definition and import of all data). HTH, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Satish Vohra [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 5:12 PM Subject: Migration from Oracle Hi All, I want to migrate from Oracle to MySQL. So I need to import the tables and data from Oracle. Can anyone suggest any tool which can do this. Any pointer regarding this will be appreciated. Regards Satish - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1
On Thu, 12 Dec 2002 13:15:05 -0500 Michael T. Babcock [EMAIL PROTECTED] wrote: MTB tibyke wrote: MTB MTB the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. MTB MTB MTB MTB Did the mysql team change tools versions? automake/autoconf? that's what im trying to figure it out.. im just writing a mail to [EMAIL PROTECTED] (rpm packages maintainer) regards, tibyke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote Connection, please help
Subject: Remote Connection, please help I am using the official type 4 mysql driver from www.mysql.com but unable to make a remote connection with the mysql database running on our companie's remote server. I mailed some mailing mailing lists but didnt find out the right answer yet. I am using the following code for simple remote connection test: Class.forName(org.gjt.mm.mysql.Driver).newInstance(); Connection con = DriverManager.getConnection(jdbc:mysql://66.137.7.185:3306/prefill,prefill,jeem); Are there no Exceptions thrown? - Cs. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
combine data from two tables
Hi, I'm hoping that someone can give me some pointers on this problem. I have two tables that contain similar data (eg, people.employees and people.volunteers). I need to run a select statement to retrieve names from both tables, and then display the data sorted by name so that it doesn't matter which table it came from. For example, if people.employees contains Amy, Charles and Eric, while people.volunteers contains Brian, David and Fred, then the resulting output needs to be displayed in this order: Amy Brian Charles David Eric Fred I could do this by post-processing the data in the script which retrieves it, but I'd prefer to get it in the correct order direct from MySQL. Any suggestions? Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: More locking issues
Gelu Gogancea wrote: If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Can I ask if this is in fact accurate? As I understand it, MySQL does a fairly good job of locking the tables, that's part of the performance problem of MyISAM vs. InnoDB table types with many updates running. And with InnoDB, you get a Repeatable Read isolation level by default which 'feels like' getting a read lock. What did you mean that it doesn't lock tables? SQL -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.54 safe_mysqld fix
The following code is incorrect in safe_mysqld on 3.23.54 at least (that is all I have checked) Line 162: if $NOHUP_NICENESS -gt 0 then $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup This needs to be: if test $NOHUP_NICENESS -gt 0 then NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup Thanks! Nickg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
load data local infile
Hi: I am using mysql v4_0_5 both clinet and server. I cannot get load data local infile to work after many different tries. Does anyone make it work with this version? It worked for when I used v3.23.52. Thanks for any tips, Yuyi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael T. Babcock wrote: tibyke wrote: the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. Did the mysql team change tools versions? automake/autoconf? Yes. You need automake 1.5 / libtool 1.4. It appears this made it into the CHANGES for the 4.0.x series, but not the 3.23.x series. I'm BCC'ing this to our build engineer, so he can correct the manual. Thanks! -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9+Nu7tvXNTca6JD8RAt7BAKCLcy1fXGJAjseB7PbpoqDKDB1xrgCgmIM7 /AOXkSqvVGLP4BirqpgAbAk= =1sUo -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query from5tables
Hi I want to get data from 5 tables to a form..the tables are linked in the following way. AppointmentTable 1 to 1 client ClientTable one to many ClientStaffTable SaleStaffTable one to many ClientTable AttendantsTable many to one AppointmentTable AttendantsTable one to one ClientStaffTable And the form will contain data from each one of these tables above. What is the best way to query and show a single record on the form...and in terms of using the Refrential Integrity...can do you recommend using that in SQLServer/AccessI dont mind if it works...as it might be quicker than writing recordsets and getting the ID after inserting a record in a table then writing that ID to the other table as a foreign key...so complicated and time consuming I would like to listen to your views... Many thanks... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: More locking issues
Hi, Is not the same caseJeff didn't said anything about TRANSACTIONS. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Jeff Snoxell [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 8:44 PM Subject: Re: More locking issues Gelu Gogancea wrote: If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Can I ask if this is in fact accurate? As I understand it, MySQL does a fairly good job of locking the tables, that's part of the performance problem of MyISAM vs. InnoDB table types with many updates running. And with InnoDB, you get a Repeatable Read isolation level by default which 'feels like' getting a read lock. What did you mean that it doesn't lock tables? SQL -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Collective Row Concatenation
Hi, I am having a bit of a problem with my MySQL database, and I am hoping someone can help me out. I have a table, that currently contains 350 million rows, all of which basically contain a String (VARCHAR) of size 60 characters or less, and a bunch of other identifiers. These 350 million chunks, if combined together properly, form about 10 million unique strings of varying length. What I am curious about is whether there is a way for me to put these chunks together with a query. So if my table looks like this: mytable -- | id | order |characters | -- 1 1 abcdefghijklmno 1 2 gadrcdassdasds 1 3 adfasdfasdffdwef 2 1 asdfeereqdfqweq 2 2 dsfeqerqerqwerqw... 3 1 qweqeotrmfnrofod... What I would like to do is something like: SELECT COMBINE(characters) as charcter_set FROM mytable WHERE id = 1 ORDER BY order asc; I know that I could simply pull the results into a temporary table, and then use CONCAT or CONCAT_WS to combine them manually, but I would really like to be able to combine the results on the fly, as it takes a really long time to perform all the SQL statements I need on the 350 million row table. Maybe I am thinking about this problem the wrong way, but if anyone has any suggestions, please let me know. Thanks in advance, Chris Stark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem with replication
Hi ... i have just tried by nothing's changed! ... i mean ... now in the show slave status i can see the right master_log_filename, log_position etc. but the error persists! What's wrong? help me please! Thanks and bye --- Maxime LEMAIRE [EMAIL PROTECTED] ha scritto: hi, try this : mysql SHOW MASTER STATUS; +--++--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--++--+- + | some-file| XX | | | +--++--+--+ mysql CHANGE MASTER TO MASTER_HOST='host', MASTER_USER='repl', MASTER_PASSWORD='repl', MASTER_LOG_FILE='some-file', MASTER_LOG_POS=XX; then restart the slave. -Message d'origine- De : Natale Babbo [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 12 décembre 2002 16:27 À : [EMAIL PROTECTED] Objet : Fwd: problem with replication Any suggestion about this error? Thanks to all. --- Natale Babbo [EMAIL PROTECTED] ha scritto: Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET) Da: Natale Babbo [EMAIL PROTECTED] Oggetto: problem with replication A: [EMAIL PROTECTED] Hi all, I have a problem with replication between two servers. I created user repl on the master, I restored the master's dump on the slave, I changed both my.cnf settings but I got this error from slave .err file: MySql: ready for connections 021211 16:56:12 InnoDB: Started 021211 16:56:12 Slave I/O thread: connected to master 'repl@sviluppo01:3306', replication started in log 'FIRST' at position 4 021211 16:56:12 Error updating slave list: Query error 021211 16:56:12 Slave I/O thread exiting, read up to log 'FIRST', position 4 Master my.cnf: log-bin=/usr/local/mysql/log/MySQL-bin server-id=1 Slave My.ini: server-id=2 master-host=sviluppo01 master-user=repl master-password=repl What's wrong? Thanks in advance. __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote Connection, please help
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Muhammad Salman wrote: Dear Mark, real thanks , Are you refering to this issues: Issue: When I try to connect to the database with MySQL Connector/J , I get the following exception: Yes. [snip] Thanks Mark for your real quick response. The error I am getting is when I try to connect with the machine's ip is : Invalid authorization specification: Access denied for user: '***@**' (Using password: YES) But when I connect it with localhost instead of the ip I am able to connect to MySQL, by putting the code on the same machine. This machine has several databases Your permissions are not setup correctly. You need to add GRANTs to allow this to happen as it appears that none currently exist that do allow it. You need to do a GRANT [foo] ON [blah] TO 'user'@'host' identified by 'some_password' to get this to work. I am deliberately leaving out what you need to put in for [foo] and [blah], because you _really_ need to read the MySQL manual (http://www.mysql.com/doc/en/GRANT.html) and understand exactly what you're doing here. -Mark -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9+N9WtvXNTca6JD8RAtpRAJ9+mZRg4gudtabx3yREo2RD+tNj/wCeKuOJ KeCv39g/Agxk4WG1m0PGFXo= =LyU/ -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load Data Infile command
Try this when your logging into mysql, not when starting mysql. This works for me on Linux. mysql --local-infile=1 -u username-p - Original Message - From: Jon Bertsch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 12:02 PM Subject: Load Data Infile command HI all, I'm new to the list so I apologize if this subject has been answered already, I couldn't find a mailing list archive. We just upgraded (?) mysql to 3.23.49. We are running it on Linux Redhat 7.3 The load data local command is turned off by default. I have attempted to follow the instructions in the documentation (Ch. 4.2.4 and others) about this but it has been a dismal failure. I tried the following on restarting mysql: /etc/init.d/mysqld start --local-infile[=1] as in the manual. No luck. I also made some variations on this: --local-infile=1 --local-infile --local-infile(=1) --local-infile=[1] --local-infile=(1) None of these worked. I added the following two lines to the my.cnf file: [client] enable-local-infile and restarted. No luck. Has anyone been able to get this to work? I would really appreciate any help on this since I use the command to load data and it is part of several utility applications I use. Thanks in advance Jon Bertsch - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sorting Results
Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(985)902-8484 MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sorting Results
Cancel this! :) after reading it again, I realized a simple ORDER BY will do the trick nicely... Happy Holidays, Mike(mickako)Blezien wrote: Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(985)902-8484 MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sorting Results
ORDER BY field ASC|DESC --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Mike(mickako)Blezien [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:45 AM To: MySQL List Subject: Sorting Results Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(985)902-8484 MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie - linking queries with dynamic where conditions
Hi- I am trying to write a sql query that will output (domain, transport, sum(count), sum(size)) from multiple tables for many records. When the domain field is dynamic based on the adminId passed to the query, how do I execute the second query at the same time? Thanks in advance, Max select a.domain, a.transport from transport as a, acl as b where a.id=b.transportId and b.adminId='1'; select sum(count), sum(size) from stats where email like '%a.domain'; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load Data Infile command
I'm new to the list so I apologize if this subject has been answered already, I couldn't find a mailing list archive. Where did you look? http://www.mysql.com/documentation/searchlists.html PB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sorting Results
Mike(mickako)Blezien wrote: Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. Well... you mean other than ... ORDER BY 'fieldname' ?? - Csongor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem compiling MySQL-3.23.54 on OpenUNIX 8.0.0
I can not compile the release of MySQL-3.23.54. Below is the errors. make[4]: Entering directory `/home/build/ou8/mysql-3.23.54/sql' source='mysqld.cc' object='mysqld.o' libtool=no \ depfile='.deps/mysqld.Po' tmpdepfile='.deps/mysqld.TPo' \ depmode=none /bin/bash ../depcomp \ CC -Kthread -DUNIXWARE_7 -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql \ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/my sql\ -DHAVE_CONFIG_H -I. -I. -I.. -I../bdb/build_unix -I../innobase/include -I ./../include -I./../regex -I. -I../include -I.. -I.-O3 -DDBUG_OFF -DNO_CPL USPLUS_ALLOCA -c -o mysqld.o `test -f mysqld.cc || echo './'`mysqld.cc mysqld.cc, line 1473: warning: variable error was set but never used int error;// Used when debugging ^ mysqld.cc, line 1523: warning: statement is unreachable return(0); /* purecov: deadcode */ ^ mysqld.cc, line 2478: error: argument of type size_socket * is incompatible with parameter of type size_t * length); ^ mysqld.cc, line 2544: error: argument of type size_socket * is incompatible with parameter of type size_t * if (getsockname(new_sock,dummy, dummyLen) 0) ^ make[4]: *** [mysqld.o] Error 1 make[4]: Leaving directory `/home/build/ou8/mysql-3.23.54/sql' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/home/build/ou8/mysql-3.23.54/sql' make[2]: *** [all] Error 2 make[2]: Leaving directory `/home/build/ou8/mysql-3.23.54/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/build/ou8/mysql-3.23.54' make: *** [all] Error 2 Thanks, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ1042 East Fort Union #135, Midvale Utah 84047 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: More locking issues
From MySQL Reference Manual: ... Normally, you don't have to lock tables, as all single UPDATE statements are atomic; no other thread can interfere with any other currently executing SQL statement. There are a few cases when you would like to lock tables anyway: * If you are going to run many operations on a bunch of tables, it's much faster to lock the tables you are going to use. The downside is, of course, that no other thread can update a READ-locked table and no other thread can read a WRITE-locked table. * If you are using a table handler in MySQL that doesn't support transactions, you must use LOCK TABLES if you want to ensure that no other thread comes between a SELECT and an UPDATE. The example shown below requires LOCK TABLES in order to execute safely: mysql LOCK TABLES trans READ, customer WRITE; mysql select sum(value) from trans where customer_id= some_id; mysql update customer set total_value=sum_from_previous_statement where customer_id=some_id; mysql UNLOCK TABLES; Without LOCK TABLES, there is a chance that another thread might insert a new row in the trans table between execution of the SELECT and UPDATE statements. By using incremental updates (UPDATE customer SET value=value+new_value) or the LAST_INSERT_ID() function, you can avoid using LOCK TABLES in many cases. ... That is the way I work with MySQL. In almost all cases I do not need to lock tables. I only use it when I am updating more than one tables, because of chances of getting data integrity broken. Hope I could help. []s Anderson Pereira Ataides Em Qui 12 Dez 2002 16:09, you wrote: Hi, If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jeff Snoxell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 6:57 PM Subject: More locking issues Hi, I'm new to MySQL. I see you all talking about locking databases etc... but isn't that the point of having a database server? So you don't have to worry about record locks? I'm designing the backend for a popular site where a user's visit will result in multiple read/write operations on a database. Is record locking something I definitely need to do? Thanks, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Field type conversion question
On Thu, 12 Dec 2002 08:59:45 -0500, Brad Harriger wrote: like to have a field in Events that will store multiple names with both fields from EmpTable concatenated into one string (i.e. FirstName LastName) What is the most efficient way to do this in MySQL? One approach is an EventAttendance table that has two fields (eventnum, employeenum). Then multiple employees can attend one event, and there are no long strings running around. - Steve Yates - If you smoke after sex, you're doing it too fast. ~ Taglines by Taglinator - www.srtware.com ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert record x 2
Hi, I have a form with two sections on it. The user either completes one or both sections. (The validation is controlled by JavaScript) at the moment no matter how many sections they complete all the information is added to one record(through asp). But what I want to happen, is if the user completes two sections, two records will be added into the database instead of one. and if they complete one section, only one record will be added. can any one help me? Thanks Kaan. MYSQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
boolean type
Does there exist a boolean column type? I checked the documentation, and it says that there exists a BOOL but it is a tinyint(1). Should I use that as a boolean? thanks in advance, prashant. query to go through filter. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sorting Results
ORDER BY col [ASC|DESC] http://www.mysql.com/doc/en/SELECT.html -Original Message- From: Mike(mickako)Blezien [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:45 AM To: MySQL List Subject: Sorting Results Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(985)902-8484 MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1 - new tools installed !
Hello, Yes. You need automake 1.5 / libtool 1.4. It appears this made it into the CHANGES for the 4.0.x series, but not the 3.23.x series. I'm BCC'ing this to our build engineer, so he can correct the manual. Thanks! -Mark well, [root@kula-szpiegula /root]# libtool --version ltmain.sh (GNU libtool) 1.4.3 (1.922.2.110 2002/10/23 01:39:54) [root@kula-szpiegula /root]# automake --version automake (GNU automake) 1.7.2 [root@kula-szpiegula /root]# autoconf --version autoconf (GNU Autoconf) 2.57 and error again: rpm --rebuild MySQL-3.23.54-1.src.rpm ... sql/Makefile.am:94: `YFLAGS' is a user variable, you should not override it; sql/Makefile.am:94: use `AM_YFLAGS' instead. /usr/share/automake-1.7/am/depend2.am: am__fastdepCC does not appear in AM_CONDITIONAL strings/Makefile.am: Assembler source seen but `CCAS' is undefined strings/Makefile.am: strings/Makefile.am: The usual way to define `CCAS' is to add `AM_PROG_AS' strings/Makefile.am: to `configure.in' and run `aclocal' and `autoconf' again. strings/Makefile.am: Assembler source seen but `CCASFLAGS' is undefined strings/Makefile.am: strings/Makefile.am: The usual way to define `CCASFLAGS' is to add `AM_PROG_AS' strings/Makefile.am: to `configure.in' and run `aclocal' and `autoconf' again. error: Bad exit status from /var/tmp/rpm-tmp.80279 (%build) -- Best regards, gnu_is_not_unix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't find hosts.frm -- permissions now okay?
I had a similar experience right down to the error message you are getting. Based on that experience, I am inclined to recommend the following: 1) Abandon your current installation which I perceive that your are attempting from a MySQL tarball. 2) Download the webmin-1.030 tarball and execute ./setup.sh after exploding the tarball with tar -xzvf webmin-1.030.tar.gz . 3) Download the RPMs for MySQL instead of the tarball you are now using. 4) Use webmin to install the RPMs. This was much easier for me. GL Lefevre, Steven [EMAIL PROTECTED] 12/12/02 03:17PM I'm still getting the error 'Can't find hosts.frm' when I try to laund the mysql daemon. I've run the mysql_install_db script several times. I've changed the user and group ownership for all the files in the /usr/libexec/mysql directory, and also in /var/lib/mysql to 'mysql' (it was 'root'). (RPM installed it originally in /var/lib/mysql, I copied it to /usr/libexec/mysql just in case that's where is was looking. That's where th mysqld was, and the error said can't find ./hosts.frm.) Any ideas? ls -la /var/lib/mysql/ total 120 drwxr-xr-x4 mysqlmysql4096 Dec 12 15:03 . drwxr-xr-x 13 root root 4096 Dec 6 10:07 .. ... -rw-rw1 mysqlmysql1024 Dec 6 11:10 func.MYI -rw-rw1 mysqlmysql8958 Dec 6 11:10 host.frm -rw-rw1 mysqlmysql 0 Dec 6 11:10 host.MYD ... ls -la /usr/libexec/mysql total 116 drwxr-xr-x3 root root 4096 Dec 11 15:30 . drwxr-xr-x7 root root 4096 Dec 11 15:28 .. ... -rw-r-1 mysqlmysql1024 Dec 11 15:29 func.MYI -rw-r-1 mysqlmysql8958 Dec 11 15:29 host.frm -rw-r-1 mysqlmysql 0 Dec 11 15:29 host.MYD ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't find hosts.frm -- permissions now okay?
Lefevre, Steven wrote: I'm still getting the error 'Can't find hosts.frm' when I try to laund the mysql daemon. I've run the mysql_install_db script several times. I've changed the user and group ownership for all the files in the /usr/libexec/mysql directory, and also in /var/lib/mysql to 'mysql' (it was 'root'). (RPM installed it originally in /var/lib/mysql, I copied it to /usr/libexec/mysql just in case that's where is was looking. That's where th mysqld was, and the error said can't find ./hosts.frm.) Any ideas? ls -la /var/lib/mysql/ total 120 drwxr-xr-x4 mysqlmysql4096 Dec 12 15:03 . drwxr-xr-x 13 root root 4096 Dec 6 10:07 .. ... -rw-rw1 mysqlmysql1024 Dec 6 11:10 func.MYI -rw-rw1 mysqlmysql8958 Dec 6 11:10 host.frm -rw-rw1 mysqlmysql 0 Dec 6 11:10 host.MYD ... ls -la /usr/libexec/mysql total 116 drwxr-xr-x3 root root 4096 Dec 11 15:30 . drwxr-xr-x7 root root 4096 Dec 11 15:28 .. ... -rw-r-1 mysqlmysql1024 Dec 11 15:29 func.MYI -rw-r-1 mysqlmysql8958 Dec 11 15:29 host.frm -rw-r-1 mysqlmysql 0 Dec 11 15:29 host.MYD ... How come your mysql is looking for hosts.frm while you have host.frm? Is that a normal behaviour? - Cs. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sorting UK Postcodes (WAS Sorting Results)
Hi, What about if you want to sort UK Postcodes ? They can be E1,E2,..,E12,E13 Order by name would do: E1,E10,E11,E12,E13,E2,E3,E4,... how can I get with a simple ORDER BY query E1,E2,E3,E4,E5,... ? Cheers, Damien COLA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Group by problem
Dmitry, - Original Message - From: Dmitry Kosoy [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, December 12, 2002 8:02 PM Subject: Group by problem Hi, The following sql operators caused to incorrect results: CREATE TEMPORARY TABLE temp_list ( CurrID char(42) NOT NULL, OriginalID char(42) NOT NULL , DocRevision int(16) unsigned NOT NULL ) TYPE=InnoDB; insert into temp_list select CurrID, OriginalID, max(DocRevision) from some_table where DocRevision in (0,1,2,3) group by OriginalID having (sum(deleted) = 0); I revealed that temp_list table contains some incorrect values of CurrID (not matched to found OriginaID and Docrevision). According to Mysql documentation it should work. The values of CurrID is a primary key in some_table. These are the column definitions in some_table (InnoDB): CurrID char(42) NOT NULL, OriginalID char(42) NOT NULL , DocRevision int(16) unsigned NOT NULL . . . I check this in 3.51 and 3.53 and got the same results. Sinisa fixed 2 weeks ago a bug where HAVING(aggregate_function(...) = ...) did not work. Please test with 3.23.54! Regards, Dmitry Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1 - new tools installed !
Hi, You should downgrade automake to 1.5 and if it still doesn't work, try with autoconf 2.52. Regards, Jocelyn - Original Message - From: gnu_is_not_unix [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 8:52 PM Subject: Re: Compiling 3.23.54-1 - new tools installed ! Hello, Yes. You need automake 1.5 / libtool 1.4. It appears this made it into the CHANGES for the 4.0.x series, but not the 3.23.x series. I'm BCC'ing this to our build engineer, so he can correct the manual. Thanks! -Mark well, [root@kula-szpiegula /root]# libtool --version ltmain.sh (GNU libtool) 1.4.3 (1.922.2.110 2002/10/23 01:39:54) [root@kula-szpiegula /root]# automake --version automake (GNU automake) 1.7.2 [root@kula-szpiegula /root]# autoconf --version autoconf (GNU Autoconf) 2.57 and error again: rpm --rebuild MySQL-3.23.54-1.src.rpm ... sql/Makefile.am:94: `YFLAGS' is a user variable, you should not override it; sql/Makefile.am:94: use `AM_YFLAGS' instead. /usr/share/automake-1.7/am/depend2.am: am__fastdepCC does not appear in AM_CONDITIONAL strings/Makefile.am: Assembler source seen but `CCAS' is undefined strings/Makefile.am: strings/Makefile.am: The usual way to define `CCAS' is to add `AM_PROG_AS' strings/Makefile.am: to `configure.in' and run `aclocal' and `autoconf' again. strings/Makefile.am: Assembler source seen but `CCASFLAGS' is undefined strings/Makefile.am: strings/Makefile.am: The usual way to define `CCASFLAGS' is to add `AM_PROG_AS' strings/Makefile.am: to `configure.in' and run `aclocal' and `autoconf' again. error: Bad exit status from /var/tmp/rpm-tmp.80279 (%build) -- Best regards, gnu_is_not_unix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie - linking queries with dynamic where conditions
So I am trying to accomplish something like this: select a.domain, a.transport, sum(c.recipient_count) sum(c.recipient_size) from transport as a, acl as b, recipientstats as c where a.id=b.transportId and b.adminId='1' and c.recipient_email like '%a.domain'; But I know I am missing something because of the error. Can anyone point me in the right direction? Thanks in advance, Max Max Clark [EMAIL PROTECTED] wrote in message ataq2r$ev1$[EMAIL PROTECTED]">news:ataq2r$ev1$[EMAIL PROTECTED]... Hi- I am trying to write a sql query that will output (domain, transport, sum(count), sum(size)) from multiple tables for many records. When the domain field is dynamic based on the adminId passed to the query, how do I execute the second query at the same time? Thanks in advance, Max select a.domain, a.transport from transport as a, acl as b where a.id=b.transportId and b.adminId='1'; select sum(count), sum(size) from stats where email like '%a.domain'; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't find hosts.frm -- *directory* permissions now okay?
mysql still doesn't own the mysql directory. OK, I changed that for /usr/libexec [root@server /]# ls -la /usr/libexec/ total 4008 drwxr-xr-x7 root root 4096 Dec 11 15:28 . drwxr-xr-x 16 root root 4096 Nov 27 09:32 .. ... drwxr-xr-x3 mysqlmysql4096 Dec 11 15:30 mysql -rwxr-xr-x1 root root 3771937 Sep 4 13:42 mysqld ... (BTW I also changed the ownership of mysqld in /usr/libexec from root to mysql, but no luck. Tried it both ways.) The /var/lib directory was already this way: [root@server /]# ls -la /var/lib/ total 60 drwxr-xr-x 13 root root 4096 Dec 6 10:07 . drwxr-xr-x 19 root root 4096 Nov 27 09:21 .. drwxr-xr-x2 root root 4096 Nov 27 09:22 alternatives ... drwxr-xr-x4 mysqlmysql4096 Dec 12 16:38 mysql ... and I still get the same error: 021212 16:38:14 mysqld started 021212 16:38:14 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021212 16:38:14 mysqld ended Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mail Abuse
Dear Alistair, dear list, someone with your e-mail address is trying to unsubscribe me from a mailing list. Please make sure this abuse will stop. thanks for the note, I tried to unsubscribe myself earlier today but how that got turned into unsubscribing you beats me, anyway apologies for the inconvenience Has anyone observed something like this before? I keep getting unsubscribe mails from the list (at least five times this month only). Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 * SQL, MySQL * - Original Message - From: Alistair Hill [EMAIL PROTECTED] To: Stefan Hinz [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 10:20 PM Subject: Re: Mail Abuse Stefan thanks for the note, I tried to unsubscribe myself earlier today but how that got turned into unsubscribing you beats me, anyway apologies for the inconvenience Alistair On Thu, 2002-12-12 at 19:32, Stefan Hinz wrote: Dear Alistair, someone with your e-mail address is trying to unsubscribe me from a mailing list. Please make sure this abuse will stop. Regards, -- Stefan Hinz [EMAIL PROTECTED] -- Alistair Hill [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Compiling 3.23.54-1
Hello, Yes. You need automake 1.5 / libtool 1.4. It appears this made it into the CHANGES for the 4.0.x series, but not the 3.23.x series. I'm BCC'ing this to our build engineer, so he can correct the manual. Thanks! -Mark well, [root@kula-szpiegula /root]# libtool --version ltmain.sh (GNU libtool) 1.4.3 (1.922.2.110 2002/10/23 01:39:54) [root@kula-szpiegula /root]# automake --version automake (GNU automake) 1.7.2 [root@kula-szpiegula /root]# autoconf --version autoconf (GNU Autoconf) 2.57 and error again: rpm --rebuild MySQL-3.23.54-1.src.rpm ... sql/Makefile.am:94: `YFLAGS' is a user variable, you should not override it; sql/Makefile.am:94: use `AM_YFLAGS' instead. /usr/share/automake-1.7/am/depend2.am: am__fastdepCC does not appear in AM_CONDITIONAL strings/Makefile.am: Assembler source seen but `CCAS' is undefined strings/Makefile.am: strings/Makefile.am: The usual way to define `CCAS' is to add `AM_PROG_AS' strings/Makefile.am: to `configure.in' and run `aclocal' and `autoconf' again. strings/Makefile.am: Assembler source seen but `CCASFLAGS' is undefined strings/Makefile.am: strings/Makefile.am: The usual way to define `CCASFLAGS' is to add `AM_PROG_AS' strings/Makefile.am: to `configure.in' and run `aclocal' and `autoconf' again. error: Bad exit status from /var/tmp/rpm-tmp.80279 (%build) -- Best regards, gnu_is_not_unix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sorting UK Postcodes (WAS Sorting Results)
Sorry, I forgot to say that postcode can be one or 2 letters in front of the numbers. -Message d'origine- They can be E1,E2,..,E12,E13 Order by name would do: E1,E10,E11,E12,E13,E2,E3,E4,... how can I get with a simple ORDER BY query E1,E2,E3,E4,E5,... ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New database doesn't show up in phpMyAdmin
This is a problem I had before with phpMyAdmin... Try closing your browser, flush all cachefiles in the browser and log on to your database again. If this helps, I can help you with a cure for this problem. If it doesn't help, you probably have no permissions reading your database via phpMyAdmin. Regards, Bjorn I am relatively new to mySQL. I have just installed mySQL from source on a local FreeBSD server. bin/mysql_install_db installed the mysql and test databases. I can verify this on the server and with phpMyAdmin from my Mac. Now when I create a new database I can verify that it exists like so: mysql show databases; ++ | Database | ++ | MyDatabase | | mysql | | test | ++ 4 rows in set (0.01 sec) mysql use MyDatabase; Database changed mysql create table MyTable (name varchar(20), address varchar(30)); Query OK, 0 rows affected (0.02 sec) mysql show tables; +--+ | Tables_in_MyDatabase | +--+ | MyTable | +--+ 1 row in set (0.00 sec) mysql describe MyTable; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | name| varchar(20) | YES | | NULL| | | address | varchar(30) | YES | | NULL| | +-+-+--+-+-+---+ 2 rows in set (0.01 sec) But when I connect to the server with phpMyAdmin the newly created database doesn't show up. Only the test database created by the install_db script shows up. What could I be doing wrong? Please cure me of my ignorance... Thanks, Steven -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sorting UK Postcodes (WAS Sorting Results)
Damien -- What about: select substring(code, 1, 1) as letter, substring(code, 2, 2) + 0 as number from epost order by 2 +++ | letter | number | +++ | E | 1 | | E | 2 | | E | 3 | | E | 4 | | E | 10 | | E | 11 | | E | 12 | | E | 13 | +++ 8 rows in set (0.00 sec) Then just use your scripting language to join the letter and number back together. I tried mysql concat() but it makes the whole thing into a wrong-sorted string again. FWIW -- Doug At 10:17 PM 12/12/2002 +0100, Alliax wrote: Hi, What about if you want to sort UK Postcodes ? They can be E1,E2,..,E12,E13 Order by name would do: E1,E10,E11,E12,E13,E2,E3,E4,... how can I get with a simple ORDER BY query E1,E2,E3,E4,E5,... ? Cheers, Damien COLA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sorting UK Postcodes (WAS Sorting Results)
Hi, Could you seperate the letters into one column and the numbers in another... Then you could group by the Alphabetical column, and order by the numerical column... Regards, Chris Stark -Original Message- From: Alliax [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 4:53 PM To: MySQL List Subject: RE: Sorting UK Postcodes (WAS Sorting Results) Sorry, I forgot to say that postcode can be one or 2 letters in front of the numbers. -Message d'origine- They can be E1,E2,..,E12,E13 Order by name would do: E1,E10,E11,E12,E13,E2,E3,E4,... how can I get with a simple ORDER BY query E1,E2,E3,E4,E5,... ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql-max-3.23.54-pc-linux-i686 doesn't work!
I downloaded the new binary version (3.23.54) mysql-max from the website but the safe_mysqld seems buggy .. Moreover when I try to start it up i got these errors: /usr/local/mysql-max-3.23.54-pc-linux-i686/bin/mysqld: /lib/libpthread.so.0: version `GLIBC_2.2' not found (required by /usr/local/mysql-max-3.23.54-pc-linux-i686/bin/mysqld) /usr/local/mysql-max-3.23.54-pc-linux-i686/bin/mysqld: /lib/libc.so.6: version `GLIBC_2.2' not found (required by /usr/local/mysql-max-3.23.54-pc-linux-i686/bin/mysqld) Running on debian 2.2 Nat -- Natalino Picone - [EMAIL PROTECTED] -- It's a horrible thing to be on top of the world and then to lose it and try to get it back. It's a whole lot harder the second time. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1 - new tools installed !
On Thu, 12 Dec 2002 21:29:40 - Jocelyn Fournier [EMAIL PROTECTED] wrote: JF Hi, JF JF You should downgrade automake to 1.5 and if it still doesn't work, try with JF autoconf 2.52. JF JF Regards, JF Jocelyn hi, MySQL folks! :) it works for me with (redhat 6.2):: - automake14-1.4p5-1 - libtool-1.4.2-4 - autoconf-2.52-6 it also works for me with (redhat 7.3): - automake 1-4p5-4 - libtool-1.4.2-7 - autoconf-2.13-17 7.3 has the out-of-the-box versions, while 6.2 is updated regularly :) regards, tibyke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mail Abuse
On 12 Dec 2002, at 22:42, Stefan Hinz wrote: Has anyone observed something like this before? I keep getting unsubscribe mails from the list (at least five times this month only). The reason it happened is that you've posted several messages in which you've quoted the unsubscribe text that the list manager software appends. The address in those instructions is personalized to you, so when you send it out to the list some people will be confused and use that address when they're trying to unsubscribe themselves. Yet another reason to quote only text that's relevant to your response. [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1
On Thu, 12 Dec 2002 13:15:05 -0500 Michael T. Babcock [EMAIL PROTECTED] wrote: MTB tibyke wrote: MTB MTB the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. MTB MTB MTB MTB Did the mysql team change tools versions? automake/autoconf? MTB MTB -- MTB Michael T. Babcock MTB C.T.O., FibreSpeed Ltd. MTB http://www.fibrespeed.net/~mbabcock Hi! As I wrote in another thread: it works for me with (redhat 6.2):: - automake14-1.4p5-1 - libtool-1.4.2-4 - autoconf-2.52-6 it also works for me with (redhat 7.3): - automake 1-4p5-4 - libtool-1.4.2-7 - autoconf-2.13-17 7.3 has the out-of-the-box versions, while 6.2 is updated regularly :) __however___! dont forget to modify /usr/bin/safe_mysqld: As Nick writes it in MySQL 3.23.54 safe_mysqld fix thread: snip The following code is incorrect in safe_mysqld on 3.23.54 at least (that is all I have checked) Line 162: if $NOHUP_NICENESS -gt 0 then $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup This needs to be: if test $NOHUP_NICENESS -gt 0 then NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup Thanks! Nickg /snip after all, now 3.23.54 just works fine for me :) Regards, tibyke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sorting UK Postcodes (WAS Sorting Results)
At 22:53 12/12/2002 +0100, Alliax wrote: Sorry, I forgot to say that postcode can be one or 2 letters in front of the numbers. -Message d'origine- They can be E1,E2,..,E12,E13 Order by name would do: E1,E10,E11,E12,E13,E2,E3,E4,... how can I get with a simple ORDER BY query E1,E2,E3,E4,E5,... ? If sorting by number is important, then split them on input and store them in two separate files. But I don't really know why you'd want to sort them numerically anyway - UK postcodes aren't sequential in operation: E1 is not necessarily adjacent to E2 on the map. So having a sequence of E1,E10,E2, etc is no less applicable than E1,E2,E10 would be. Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.54 safe_mysqld fix
what an important piece of information, thanks, Nick! tibyke On Thu, 12 Dec 2002 12:46:10 -0600 Nick [EMAIL PROTECTED] wrote: N The following code is incorrect in safe_mysqld on 3.23.54 at least (that N is all I have checked) N N Line 162: N if $NOHUP_NICENESS -gt 0 N then N $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup N N N This needs to be: N N if test $NOHUP_NICENESS -gt 0 N then N NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup N N N N Thanks! N N Nickg N N N - N Before posting, please check: Nhttp://www.mysql.com/manual.php (the manual) Nhttp://lists.mysql.com/ (the list archive) N N To request this thread, e-mail [EMAIL PROTECTED] N To unsubscribe, e-mail [EMAIL PROTECTED] N Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php N N - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sorting UK Postcodes (WAS Sorting Results)
Thank you and Yes, separating the postcodes into field letters and numbers may be the only way to be able to order a sequence like that: CV1,CV2,..,CV10,.. It would also work since there could as many letters as needed Anyone has a simple query for odering sequences correctly ? Cheers, Damien COLA -Message d'origine- Could you seperate the E's in one column and the numbers in another... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Collective Row Concatenation
Hi, I'm pretty sure that's not possible in MySQL - sounds like the kind of thing that would be way easier to write a bit of script for instead. picky I don't think you'll get away with using 'order' as a column name either - I'm fairly sure it's a reserved name in MySQL. /picky Cheers, Andrew Mysql,query -Original Message- From: Chris Stark [mailto:[EMAIL PROTECTED]] Sent: Thursday, 12 December 2002 18:58 To: '[EMAIL PROTECTED]' Subject: Collective Row Concatenation Hi, I am having a bit of a problem with my MySQL database, and I am hoping someone can help me out. I have a table, that currently contains 350 million rows, all of which basically contain a String (VARCHAR) of size 60 characters or less, and a bunch of other identifiers. These 350 million chunks, if combined together properly, form about 10 million unique strings of varying length. What I am curious about is whether there is a way for me to put these chunks together with a query. So if my table looks like this: mytable -- | id | order |characters | -- 1 1 abcdefghijklmno 1 2 gadrcdassdasds 1 3 adfasdfasdffdwef 2 1 asdfeereqdfqweq 2 2 dsfeqerqerqwerqw... 3 1 qweqeotrmfnrofod... What I would like to do is something like: SELECT COMBINE(characters) as charcter_set FROM mytable WHERE id = 1 ORDER BY order asc; I know that I could simply pull the results into a temporary table, and then use CONCAT or CONCAT_WS to combine them manually, but I would really like to be able to combine the results on the fly, as it takes a really long time to perform all the SQL statements I need on the 350 million row table. Maybe I am thinking about this problem the wrong way, but if anyone has any suggestions, please let me know. Thanks in advance, Chris Stark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sorting UK Postcodes (WAS Sorting Results)
Hi, yes, that would do, except that I don't know how many letters are in front of the numbers. And since they're not the same letters perhaps ORDER by 1,2 would have done it perfectly, if only we could substring() intelligently first. Cheers, Damien COLA -Message d'origine- SQL: select substring(code, 1, 1) as letter, substring(code, 2, 2) + 0 as number from epost order by 2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sorting UK Postcodes (WAS Sorting Results)
Sorting by number is not important, it was more a general question about sequences of variousnameXXX and how to order them correctly with a simple query. Splitting in 2 fields seems the only way then. For the postcode it's just to provide the user with an easy lookup table, but it's not *that* important since the way it's ordered now is the same as many (if not all) file systems do. If sorting by number is important, then split them on input and store them in two separate files. But I don't really know why you'd want to sort them numerically anyway - UK postcodes aren't sequential in operation: E1 is not necessarily adjacent to E2 on the map. So having a sequence of E1,E10,E2, etc is no less applicable than E1,E2,E10 would be. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: newbie - linking queries with dynamic where conditions
You´re missing the GROUP BY clause select a.domain, a.transport, sum(c.recipient_count) sum(c.recipient_size) from transport as a, acl as b, recipientstats as c where a.id=b.transportId and b.adminId='1' and c.recipient_email like '%a.domain' GROUP BY a.domain,a.transport; -Original Message- From: news [mailto:[EMAIL PROTECTED]] On Behalf Of Max Clark Sent: Thursday, December 12, 2002 5:30 PM To: [EMAIL PROTECTED] Subject: Re: newbie - linking queries with dynamic where conditions So I am trying to accomplish something like this: select a.domain, a.transport, sum(c.recipient_count) sum(c.recipient_size) from transport as a, acl as b, recipientstats as c where a.id=b.transportId and b.adminId='1' and c.recipient_email like '%a.domain'; But I know I am missing something because of the error. Can anyone point me in the right direction? Thanks in advance, Max Max Clark [EMAIL PROTECTED] wrote in message ataq2r$ev1$[EMAIL PROTECTED]">news:ataq2r$ev1$[EMAIL PROTECTED]... Hi- I am trying to write a sql query that will output (domain, transport, sum(count), sum(size)) from multiple tables for many records. When the domain field is dynamic based on the adminId passed to the query, how do I execute the second query at the same time? Thanks in advance, Max select a.domain, a.transport from transport as a, acl as b where a.id=b.transportId and b.adminId='1'; select sum(count), sum(size) from stats where email like '%a.domain'; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?
The way I've always done it, and I wonder if I am not doing lots of things wrong: i have 2 tables, one person and one address for a one to one relation, the way I do it: table person personID primary int 11 autoincrement addressID int 11 table address addressID primary int 11 autoincrement if it's a one ot many relationship i do it like that: table person personID primary int 11 autoincrement table car addressID primary int 11 autoincrement personID int 11 NOW, reading this great mailinglist, I've come to believe the right way to do it that works in both relationship types : table person personID primary int 11 autoincrement table car carID primary int 11 autoincrement table relation_person_car relation_personID primary int 11 autoincrement personID int 11 carID int 11 I understand it's closer to the real way to represent relations in database design, but I wonder what else can be done with mySQL to simplify the work. for example, should I make something special with the type of fields personID and addressID in table relation_person_car ? another example, it would be easier to name all the primary key fields 'id' instead of '*nameOfTheTable*ID', but what would be the backdraws when coding queries and server scripts ? Any critics on my beginner way of handling relations is most welcome. Cheers, Damien COLA Cordialement, __ Alliax ~CV : http://LingoParadise.com/cv.php Un site pour Toulon : http://www.ToulonParadise.com Un site pour Renaud : http://www.rfaucilhon.com Un site pour Director : http://www.LingoParadise.com Un site pour Harmonica: http://www.LingoParadise.com/mp3 -Message d'origine- De : Michael T. Babcock [mailto:[EMAIL PROTECTED]] Envoyé : lundi 9 décembre 2002 15:15 À : [EMAIL PROTECTED] Objet : Re: QUICK: What is the optimal way to store opening times ? On Fri, Dec 06, 2002 at 05:54:53PM +0100, Alliax wrote: I have one question : if I go the RestTimes route, that is having a row per day and so 7 row per restaurants : can I, in one SQL request, know if THAT restaurant is open or close now ? I now there are NOW() function in SQL and probably many others, but I am not at ease to use them since I have pretty basic SQL skills. This should be a personal work assignment for you, but try: SELECT * FROM RestTimes WHERE RestID = ... AND OpenTime now() and CloseTime now(); FWIW, you'll have to do a calculation in there such that OpenTime is midnight today + seconds from day offset. Its not difficult; find some calendaring code for examples. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
3.23.54 compile error
I've tried to build mysql-3.23.54 from rpm sources. My system is a RedHat 6.2 with glibc-2.1.3-28 and the compiler is gcc-2.95.4-4h. Had no problems at all building mysql until mysql-3.23.53, but now I get this error: [...] Making distclean in . make[1]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.54' test -z linked_client_sources linked_server_sources linked_libmysql_sources linked_libmysql_r_sources linked_include_sources || rm -f linked_client_sources linked_server_sources linked_libmysql_sources linked_libmysql_r_sources linked_include_sources rm -rf .libs _libs rm -f *.lo rm -f Makefile bdb/Makefile stamp-h stamp-h[0-9]* rm -f config.h rm -f libtool rm -f TAGS ID GTAGS GRTAGS GSYMS GPATH make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.54' rm -f config.status config.cache config.log + mv Docs/manual.ps.save Docs/manual.ps + automake aclocal.m4: 1272: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' aclocal.m4: 1273: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' aclocal.m4: 1379: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' libmysql_r/Makefile.am:26: library used but `LIBTOOL' not defined in `configure.in' error: Bad exit status from /var/tmp/rpm-tmp.34718 (%build) Any hint? Maybe a newer libtool is required? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
