RE: Does MySql support Synchronous/asynchronous I/O
I'm sorry. When did it start supporting raw disk devices? As far back as I can remember, MySQL stores it's data files on an existing filesystem, in 3 separate files: .frm, .MYI, .MYD. Ah, InnoDB apparently supports raw disk files. I suppose I should have said that the NATIVE MySQL backend doesn't support raw disk devices. I stand corrected. -Tilghman -- A computer without Windows is like a chocolate cake without mustard. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 11:52 On Tue, Sep 18, 2001 at 07:53:23AM -0500, The Tilghman wrote: MySQL doesn't support raw disk devices Where did you hear that? - 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: get_lock()
It's purely advisory locking. You aren't locking anything other than a certain value within the server itself. The benefit comes only if all clients agree to use the same advisory locking schema. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 11:01 To: [EMAIL PROTECTED] Subject: get_lock() When using getlock what goes in the str in the following syntax GET_LOCK(str,timeout) is the the primary key of the row that you would like to lock? the manual isn't very specific on that Thanks randy - 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: special characters messing me up
mv file file~ ; tr -d '\015' file~ file ; rm file~ Or, in vim, :set fileformat=unix Or, use PFE32.EXE on Windows as your editor (allows saving as Unix text file). -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: John W Ford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 01:04 I can't figure out why my windows machine leaves "^M" character at the end of each line of code. This causes the file to be messed up when I put it on the Linux server. It makes my perl interpreter look for a file named ^M after the very first line. #!/usr/sbin/perl also... what else I can't figure out is why this special character is sometimes hidden and sometimes visible in my Emacs program in Linux... this is the program I used in which I found the problem. anybody know? John Ford - 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: problems running mySQL via Telnet
I suppose you mean that you've been using telnet to access the server and mysql to access the mysql server. From a security standpoint, you should probably install sshd, deinstall telnet, rsh, rexec, etc. and use ssh exclusively to login to your server. Of course, this is only a tiny piece of an overall security strategy, and you should invest some time in developing a complete security solution, if you haven't already. However, this is now almost completely off-topic. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: John Jensen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 18:10 Alright, you've got me worried. I have been using telnet to access mysql. Could that have something to do with the problems I have been having with the server? (The root password was erased, but there was no other evidence of a breakin.) On 8 Feb 2001, at 7:56, Quentin Bennett wrote: You don't connect to mysql server using telnet, you use the mysql command line client 'mysql'. -Original Message- From: @ndYD [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 February 2001 07:13 server version: 3.22.34-shareware-debug OS: Windows 98 I tried to access the mySQL- server via the Win-Telnet Client. If the connection is established, the following mysterious string appears: ( 3.22.34-shareware-debugk7qS,~Z), After that, I entered some characters. Then the connection will be closed by the server and the error string "Bad Handshake" appears. Question: Is this feature (Telnet) not available in the shareware-version. Or is this a basically problem? - 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: Finding Duplicates and Deleteing
Depending upon the function of the table, you might consider designing your table such that duplicates aren't possible (e.g. putting a UNIQUE index on a column or set of columns). Other than that, try dumping your table, removing the rows you don't want, and reloading the table. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Linsen Limsico [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 12:09 Does anyone know how to find duplicates in a table and deleting them. I can't figure out how to structure the 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: Bug converting string into integer
It's a bug either in your processor or in your distribution libraries. Your SELECT returns correctly on my Linux and FreeBSD servers. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Federico Giannici [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 09:09 To: MySQL mailinglist Subject: Bug converting string into integer In a SELECT I have to convert a string into a number. I used to use something like 'string'+0, where 'string' is a string rapresentation of an integer. Now I noticed that in many cases it returns a rounded floating point!!! For example: mysql select '11'+0; +-+ | '11'+0 | +-+ | 10.99046326 | +-+ 1 row in set (0.00 sec) Is it normal? Or it happens only in my system? (OpenBSD 2.8 i386) What is the best (more efficient) way to convert an integer string to an integer value? Thanks, ___ __ |- [EMAIL PROTECTED] |ederico Giannici http://www.neomedia.it ___ - 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: PRIMARY KEY (userid), UNIQUE (userid)
No. A primary key is a unique key, by definition. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 09:58 To: [EMAIL PROTECTED] Subject: PRIMARY KEY (userid), UNIQUE (userid) Is there an idea in having a PRIMARY KEY and UNIQUE key for the same table column ? - 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: problems running mySQL via Telnet
You're trying to use a Telnet client with a MySQL server. Instead, use a MySQL client with a MySQL server and a Telnet client with a Telnet server. Mixing protocols doesn't really work for anybody. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: @ndYD [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 12:13 To: [EMAIL PROTECTED] Subject: problems running mySQL via Telnet Hello, server version: 3.22.34-shareware-debug OS: Windows 98 I tried to access the mySQL- server via the Win-Telnet Client. If the connection is established, the following mysterious string appears: ( 3.22.34-shareware-debugk7qS,~Z), After that, I entered some characters. Then the connection will be closed by the server and the error string "Bad Handshake" appears. Question: Is this feature (Telnet) not available in the shareware-version. Or is this a basically problem? Thanks in advance for all tips. Regards Andy - 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: slicing strings for comparison?
Check out SUBSTRING in the manual. On the zip codes, you're better off not trying to do any comparisons in SQL -- the way they work is extremely complicated. I would suggest that you purchase distance measurements between two arbitrary zip codes from the Postal Service, if you intend to be accurate. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Cindy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 13:33 To: [EMAIL PROTECTED] Subject: slicing strings for comparison? I have a select I'd like to do...I have 2 kinds of people -- those needing interviews, and those doing interviews. Among other things, each person has their home address/phone in the tables. I want to generate lists of interviewers in close geographical proximity to the interviewees. I can do the city check easily of course, but I'm stumped on telephone exchanges and zipcode matches. The telephone numbers are stored as char[12] (three digits, dash, three digits, dash, four digits). I want to compare the second set of three digits to each other, something like WHERE Interviewee.homephone[4-6] = Interviewer.homephone[4-6] Similarly for zip codes, I want to compare the first three characters of a char[10] (zip plus 4], essentially WHERE Interviewee.zip[0-2] = Interviewer.zip[0-2] Are these types of comparisons possible? If so, what's the syntax? I couldn't find anything in the online documentation, though it's possibly not called "slicing" or "string range"... --Cindy -- [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: slicing strings for comparison?
Couldn't find it on usps.com, but a quick search of google turned up the following url: http://www.tpsnet.com/html/zipmenu.html -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 15:32 To: The Tilghman; 'Cindy'; [EMAIL PROTECTED] Subject: RE: slicing strings for comparison? Does the post office offer this info? There used to be a service (Melissa) that had Lat. and Long. for the center of each zip code. You could use that to computer "all addresses in a 50 mile radius". but from what I understand, it's gone now. I would love to find something where I could make these kind of comparisons. Gotta URL ? -Original Message- From: The Tilghman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:26 PM Check out SUBSTRING in the manual. On the zip codes, you're better off not trying to do any comparisons in SQL -- the way they work is extremely complicated. I would suggest that you purchase distance measurements between two arbitrary zip codes from the Postal Service, if you intend to be accurate. -Original Message- From: Cindy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 13:33 I have a select I'd like to do...I have 2 kinds of people -- those needing interviews, and those doing interviews. Among other things, each person has their home address/phone in the tables. I want to generate lists of interviewers in close geographical proximity to the interviewees. I can do the city check easily of course, but I'm stumped on telephone exchanges and zipcode matches. The telephone numbers are stored as char[12] (three digits, dash, three digits, dash, four digits). I want to compare the second set of three digits to each other, something like WHERE Interviewee.homephone[4-6] = Interviewer.homephone[4-6] Similarly for zip codes, I want to compare the first three characters of a char[10] (zip plus 4], essentially WHERE Interviewee.zip[0-2] = Interviewer.zip[0-2] Are these types of comparisons possible? If so, what's the syntax? I couldn't find anything in the online documentation, though it's possibly not called "slicing" or "string range"... - 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: CHECK variable incorrect?
Two things: 1) Read the manual to see the correct syntax for the CREATE TABLE. 2) Constraints don't actually do anything in MySQL. Again, read the manual. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: SF [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 15:26 When I try to run the following command: CREATE TABLE Salespersons (empid INTEGER NOT NULL PRIMARY KEY, ename CHAR(15) NOT NULL, rank INTEGER NOT NULL DEFAULT 1 CHECK (rank IN (1,2,3)), salary DECIMAL(7, 2) NOT NULL DEFAULT 1000.00 CHECK (salary =1000.00)); gives me the following error: You have an error in your SQL syntax near 'CHECK (rank IN (1,2,3)), salary...' I've looked through the MySQL manual and cannot find anything that would help explain why I cannot run any of the CHECK constraints - it does not work when I delete that first CHECK constraint, because the second one is there - if I delete both CHECK constraints, the command to create the table works. I've tried it with creating different tables and it still doesn't work - and I can't figure out why. I'm pretty new to SQL. Other than using it in a number of databases I've designed using MS Access, I don't have much experience. I'm working (if any other newbies might have noticed) straight from a book by Wrox called "Instant SQL Programming" to try and cut my teeth on this... - 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 a range from 0-9 or A-z
Check out REGEXP in the manual. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Ung, Seng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 11:03 To: [EMAIL PROTECTED] Subject: Select a range from 0-9 or A-z hi: Here is my SQL statement to select a range of number from 0-9 Is there a short cut to this? id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%' thank you seng - 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: problems migrating from mysql 3.22.22 to 3.23.32
'when' is a reserved word in 3.23 -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Noah Romer [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 14:38 In the process of moving a database to a new server, I decided to upgrade to the 3.23 series MySQL, as it had been declared "stable" and has some new features I want to investigate. However, I've had to drop back to 3.22.22, as I started getting an "invalid SQL syntax" error on certain insert commands. Specifically, when I try to do an insert into a change logging table in our bug tracking database, I get "ERROR 1064: You have an error in your SQL syntax". An example would be the following, which I tried from the command line mysql client when our bug tracking software started complaining about not being able to log changes: mysql insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue) values (334,18,20010131145149,'bug_status','NEW','RESOLVED'); ERROR 1064: You have an error in your SQL syntax near 'when,field,oldvalue,newvalue) values (334,18,20010131145149,'bug_status','NEW','' at line 1 I can't find anything in the above SQL command that would constitute invalid syntax, and MySQL 3.22.22 doesn't have any problems with it, so I was wondering if anyone on this list might have an idea as to what's going on. The systems involved here are dual processor Linux machines. I've tried this using the MySQL-3.23.32-1 rpms (installed on the new system, which is running RedHat 6.2 on dual PIII 933's) and using the source code (mysql-3.23.32.tar.gz), compiled and running on the old system (a dual PPro system running a heavily modified RedHat 5.1). The result are the same in either case. - 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: How to select the 10 last items from a table?
Try sorting in DESCending order. SELECT * FROM item ORDER BY id DESC LIMIT 10; -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Remco van den Berg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 17:29 On Tue, Jan 30, 2001 at 11:48:22PM +0300, Rus wrote: May be it could work SELECT * FROM item ORDER BY ID LIMIT count(*)-10,10 mysql SELECT id FROM lid ORDER BY ID LIMIT count(*)-10,10; ERROR 1064: You have an error in your SQL syntax near 'count(*)-10,10' at line 1 or SELECT * FROM SELECT * FROM item ORDER BY ID DESC LIMIT 10 ORDER BY ID mysql select * from select * from lid order by id DESC limit 10 order by id; ERROR 1064: You have an error in your SQL syntax near 'select * from lid order by id DESC limit 10 order by id' at line 1 I think you have to make use of at least two queries. One to get MAX(id) and one for the actual query: mysql select MAX(id) from lid; +-+ | MAX(id) | +-+ | 489 | +-+ 1 row in set (0.00 sec) mysql select id from lid order by id limit 479,10; But that only works when all id's up to the last one exist. If you delete records from the table calculating 479 by substracting 10 from MAX(id) doesn't work. So, the only solution left, I can think of, is to make use of an temporary table (in memory) to store the results of your query which are in the wrong order. And then query the temporary table to get right order. - 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: Auto-Increment - how can I avoid repeating IDs?
Upgrade to 3.23. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Viken Nokhoudian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 14:58 I am using MySQL ver. 3.22.32 When a table has an auto-incrementing ID field and the last inserted record had an ID of, say, 100, then I delete that record, the database engine will re-use the 100 value. How can I get the engine to never repeat an ID value to avoid corrupted data correlations? - 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: Browser-based client UI design question
One approach might be to use a hierarchal menu -- first level is first letter of the company, second level is all of the companies whose names begin with that letter. Or, set a search to pull up the list of companies which contain a certain phrase. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Mark Chalkley [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 10:17 I apologize for the OT question, but I've asked this on several other forums and gotten no constructive replies. If someone wants to refer me to a better place to ask this, I'd be grateful. I've got a complicated question, which probably has a simple answer, so I'll try to avoid wasting everyone's time as best as I can. I've read tons of stuff about relational database design - normalization, integrity, etc., but none of it is really relevant to my question. My question is this: When you're designing the user interface for a browser-based data entry system, what's the best way to accomodate linked records? There's loads of info out there on querying and reports, but everyone seems to ignore the fact that the data has to get into the database somehow, and often it's via online entry. For example: You have a table of Service Calls and a table of Companies. Each Service Call can be linked to one or two companies (trust me, there's a reason). You're using an Auto-Incremented Integer, call it 'comp_id', for a Primary Key for Companies. Now, when someone goes to enter a Service Call online, how do they establish the relationship to the correct Company or Companies? If you have two attributes in Service Calls, say 'comp1' and 'comp2', surely you don't expect the person entering the data to just happen to know the correct value of 'comp_id'? But you can't pop up a list of 1,000 'comp_id' and 'comp_name' combinations, either. What am I missing? (I have the feeling I'm going to feel stupid when I get the answer, so let's go ahead and get it over with...) Sorry for the long-winded question, and thanks in advance for any suggestions. - 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: sql problem - it may be a version problem ??
That feature is only available in 3.23, while you're running 3.22. Upgrade your server and you'll get it. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: lrado [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 13:51 Cc: MySQL List Subject: sql problem - it may be a version problem ?? hi everybody !!! i need to resolve the following query ( a silly one ) in a mysql server 3.22.30 and i get the following error: mysql select count(distinct ip_dst) from iphdr; ERROR 1064: You have an error in your SQL syntax near 'distinct ip_dst) from iphdr' at line 1 mysql i looked up in the manual ( i downloaded it from the web ) and the syntax is correct !!! ( here is the example in the manual COUNT(DISTINCT expr,[expr...]) Returns a count of the number of different values. mysql select COUNT(DISTINCT results) from student; ) please help thanks in advance !!! laura. - 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: mysqld crashes on FreeBSD 4.2
Typically, processes which die with either a signal 10 or 11 are due to hardware problems, such as bad memory or an overheating CPU. You might consider trying a memory tester or simply do a 'make world' in /usr/src (to heavily tax the CPU and memory). -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Pawel Krawczyk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 06:47 Every several hours mysqld crashes and it seems to be correlated with heavy load. For example I can repeat the crashes with mysqldump. MySQL is 3.23.31 started with the following options: -O key_buffer=20M \ -O table_cache=512 \ -O sort_buffer=8M \ -O max_connections=600 \ -O record_buffer=1024k \ -O query_buffer_size==1024k \ -O max_tmp_tables=256 Host system is FreeBSD 4.2-STABLE on a SMP machine (Intel ISP-2051 platform) with DPT hardware RAID-5 disk array. The process crashes with the following message in dmesg: Jan 23 13:45:32 db /kernel: pid 8528 (mysqld), uid 1002: exited on signal 10 (signal 10 is SIGBUS) Can anyone suggest what could be the reason? 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
RE: Syntax error in my Update staement
Kill the final comma, i.e. ... SET SailPort = ?, SailDate = ?, Deleted = ? WHERE ... -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Don [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 13:24 To: msql list Subject: Syntax error in my Update staement Hi all, The compiler is reporting a syntax error in mySQL statement near the WHERE clause. Help. Perl code is as such: $sqlCmd = $dbh-prepare (q{ UPDATE Sailings SET SailPort = ?, SailDate = ?, Deleted = ?, WHERE Vessel = ? AND Voyage = ? }) or die "Can't update Sailings record: $DBI::errstr"; $sqlCmd-execute($sailPort, $sailDate, $deleted, $vessel, $voyage) or die "Can't execute update statement into Sailings: $DBI::errstr"; - 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: Selecting a random record
See section 7.39 of the manual. 'when' is a reserved word in 3.23. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Alan Halls [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 15:15 To: [EMAIL PROTECTED] Subject: FW: Selecting a random record Any idea why I get this error when I try to create this table on a clean 3.23.30 install on a BSDI box. This was the output from a mysqldump from version 2.22.32 on a working database. It will not allow me to recreate my database on the new version. mysql CREATE TABLE pp_additional_features ( -id int(11) DEFAULT '0' NOT NULL auto_increment, -profile_id varchar(11) DEFAULT '0' NOT NULL, -video char(3) NOT NULL, -audio char(3) NOT NULL, -slide_show char(3) NOT NULL, -toll_free char(3) NOT NULL, -scanning char(3) NOT NULL, -numpicts varchar(11) NOT NULL, -type_letter char(3) NOT NULL, -cards char(3) NOT NULL, -when datetime DEFAULT '-00-00 00:00:00' NOT NULL, -approved char(3) NOT NULL, -KEY id (id) - ); ERROR 1064: You have an error in your SQL syntax near 'when datetime DEFAULT '-00-00 00:00:00' NOT NULL, approved char(3) NOT NU' at line 12 - 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