Re: [QUERY] Problem with Syntax/Query. Need Help Please.
I don't now ich language you are using to perform this query.
But as mysql does not know any stored procedures, you will have to do it in
code with different call's.
the value of the id (seed in mssql) can be obtained with the SQL function
LAST_INSERT_ID()
a little hint. in your stored procedure in case of non existance of a
personid, personid has a value of null on mssql.
so it is better to cheque on mssql personid IS NULL.
- Original Message -
From: Pure Krome [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, November 17, 2001 9:02 AM
Subject: [QUERY] Problem with Syntax/Query. Need Help Please.
G'Day All.
I'm trying to do the following in a query, in mySQL.
All my previous years of SQL has been on MS-SQL, and i'm having some
little
problems with tricky sql statements.
*
i'm trying to insert a new record if the name doesn't exist in the table.
If
i insert, return ID, else return 0
*
pseduo -sql syntax
SET NOCOUNT ON
DECLARE @intPersonID INTEGER
SELECT PersonID from tbl_PERSON WHERE Name = @strName
SELECT @intPersonID = @@IDENTITY
IF @intPersonID 1
BEGIN
INSERT tbl_PERSON (Name, Surname) VALUES ('TestName', 'TestSurname')
SELECT @intPersonID = @@IDENTITY
END
ELSE
SET @intPERSONID = 0
end psedu untested code
I have NO idea how i can do this on MYSQL..
Any help would be extreamly appreciated.
-Regards : Pure Krome-
-
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: ORDERING A LEFT JOINED TABLE
Hi, At 05:35 PM 15/11/2001 -0800, you wrote: I'm having a problem sorting records that are used in a left join statement. Basically what happens is that any record that is not in table1 doesn't get sorted correctly. It first sorts all the records that have valid 'c2' records in both table1 and table2, then moves on to all the records that only have valid 'c2' records in table2. Is there any way to make the ORDER BY portion of the statement insert a '0' value for records that do not have a table1.c2 value. Here is the a simplified SQL statement that illustrates my point. SELECT * FROM table2 LEFT JOIN table1 USING (c1) ORDER BY (table2.c2 - table1.c2) If I read you right I feel you are looking for this qurey: SELECT * FROM table2 LEFT JOIN table1 USING (c1) ORDER BY (table2.c2 - ifnull(table1.c2,0)) Note Any mathematical operation with a null value yields null. Anvar. - 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
hai
Hai All, I am using Mysql, JDBC on LINUX. I am unable to connect Mysql from JDBC. I am getting these errors :: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:320) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:133) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:120) at java.net.Socket.init(Socket.java:273) at java.net.Socket.init(Socket.java:100) at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:114) at org.gjt.mm.mysql.Connection.init(Connection.java:229) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:146) at TextToDatabaseTable.main(TextToDatabaseTable.java:23) java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is ther e a MySQL server running on the machine/port you are trying to connect to? (java .net.ConnectException) at org.gjt.mm.mysql.Connection.init(Connection.java:239) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:146) at TextToDatabaseTable.main(TextToDatabaseTable.java:23) Please help me to solve out this problem. Thanks, Prasad. - 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
about MySQL
dear Sir/Madam, I have downloaded mySQL from your company's website. Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that means I can create table very easy. just from window screen. I hope get your reply. Thanks for you help. john - 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: about MySQL
hi Yang ! You have to control MySQL from command promt. MySQL dont have windows screen. r u using windows c:\[mysql dir]mysqld -create table read mysql manual for more detail. --- Trong Phuc - Original Message - From: Zhou Jiang Yang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 4:15 AM Subject: about MySQL dear Sir/Madam, I have downloaded mySQL from your company's website. Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that means I can create table very easy. just from window screen. I hope get your reply. Thanks for you help. john - 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: hai
Hi Valmeti ! it's general error, have too many reason. how about yr source code. maybe grant access, mm.mysql driver ... - Original Message - From: Prasad Valmeti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 2:49 AM Subject: hai Hai All, I am using Mysql, JDBC on LINUX. I am unable to connect Mysql from JDBC. I am getting these errors :: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:320) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:133) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:120) at java.net.Socket.init(Socket.java:273) at java.net.Socket.init(Socket.java:100) at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:114) at org.gjt.mm.mysql.Connection.init(Connection.java:229) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:146) at TextToDatabaseTable.main(TextToDatabaseTable.java:23) java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is ther e a MySQL server running on the machine/port you are trying to connect to? (java .net.ConnectException) at org.gjt.mm.mysql.Connection.init(Connection.java:239) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:146) at TextToDatabaseTable.main(TextToDatabaseTable.java:23) Please help me to solve out this problem. Thanks, Prasad. - 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
java.sql.SQLException: Cannot connect to MySQL server on localhost:3306.
Thanks for ur response.
I am sending code also. Earlier it was connected to data base.
I haven't used it sometime. Now i am trying but unable to connect to Data
base.
Please have look and suggest me some solution to solve this problem.
import java.io.*;
import java.sql.*;
import java.util.*;
public class TextToDatabaseTable {
private static final String DB = secmngr,
TABLE_NAME = records,
HOST = jdbc:mysql://localhost:3306/,
ACCOUNT = scott,
PASSWORD = tiger,
DRIVER = org.gjt.mm.mysql.Driver,
FILENAME = records.txt;
public static void main (String[] args) {
try {
// connect to db
Properties props = new Properties();
props.setProperty(user, ACCOUNT);
props.setProperty(password, PASSWORD);
Class.forName(DRIVER).newInstance();
Connection con = DriverManager.getConnection(HOST + DB, props);
Statement stmt = con.createStatement();
// open text file
BufferedReader in = new BufferedReader(
new FileReader(FILENAME));
// read and parse a line
String line = in.readLine();
while(line != null) {
StringTokenizer tk = new StringTokenizer(line);
String first = tk.nextToken(),
last = tk.nextToken(),
email = tk.nextToken(),
phone = tk.nextToken();
// execute SQL insert statement
String query = INSERT INTO + TABLE_NAME;
query += VALUES( + quote(first) + , ;
query += quote(last) + , ;
query += quote(email) + , ;
query += quote(phone) + );;
stmt.executeQuery(query);
// prepare to process next line
line = in.readLine();
}
in.close();
}
catch( Exception e) {
e.printStackTrace();
}
}
// protect data with quotes
private static String quote(String include) {
return(\ + include + \);
}
}
I am not sending errors because those are in the below mails.
Thanks,
Prasad.
-Original Message-
From: Nguyen Trong Phuc [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 18, 2001 8:50 AM
To: Prasad Valmeti; [EMAIL PROTECTED]
Subject: Re: hai
Hi Valmeti !
it's general error, have too many reason. how about yr source code.
maybe grant access, mm.mysql driver ...
- Original Message -
From: Prasad Valmeti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 17 November, 2001 2:49 AM
Subject: hai
Hai All,
I am using Mysql, JDBC on LINUX.
I am unable to connect Mysql from JDBC.
I am getting these errors ::
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:320)
at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:133)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:120)
at java.net.Socket.init(Socket.java:273)
at java.net.Socket.init(Socket.java:100)
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:114)
at org.gjt.mm.mysql.Connection.init(Connection.java:229)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at TextToDatabaseTable.main(TextToDatabaseTable.java:23)
java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is
ther
e a MySQL server running on the machine/port you are trying to connect to?
(java
.net.ConnectException)
at org.gjt.mm.mysql.Connection.init(Connection.java:239)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at TextToDatabaseTable.main(TextToDatabaseTable.java:23)
Please help me to solve out this problem.
Thanks,
Prasad.
-
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
Book review: MySQL - Building User Interfaces
Recently, Stephanie Wall from New Riders posted a message saying that she'd be willing to give out a few books in exchange for reviews. I was one of the lucky people who got to review Matthew Stucky's MySQL - Building User Interfaces. Summary: If you already know your way around a (My)SQL database and want to experiment with creating Linux GUIs using some of the free tools available on the internet, you will have a great time reading this book. The title is unfortunately misleading: Although the examples and discussions on DB connectivity and usage can be easily extended to other DBMSs, the UI part of the book is very narrowly scoped on the use of Glade and GTK+. Full review at: http://www.bitbybit.dk/mysqlfaq/MySQL-BUI.html / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: Need help migrating MSSQL to MySQL...
Hi. On Tue, Nov 06, 2001 at 12:34:26AM -0700, [EMAIL PROTECTED] wrote: In MSSQL I can aggregate various fields like the [totalRev] field listed below: Does anyone know if or how to do this in MySQL? You can't. You only can do this in the SELECT clause or make a column that your application keeps current on INSERT/UPDATE. Bye, Benjamin. CREATE TABLE [dbo].[Financials] ( [...] [revM11] [float] NULL , [revM12] [float] NULL , [totalRev] AS ([revM1] + [revM2] + [revM3] + [revM4] + [revM5] + [revM6] + [revM7] + [revM8] + [revM9] + [revM10] + [revM11] + [revM12]) ON [PRIMARY] [...] -- [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: Selling MySQL to Government
Hi, I have been through a similar case. I am working for a large organization, which had the Human Resources data scattered through seven different Access databases counting about 200K records. The challange was not only to migrate them, but also to unify into one armonized structure. I made a prototype with MySQL, after a cursory data migration, with ONE MILLION records (between real and simulated ones), which showed the potential users most of the benefits in matter of reliability, speed, accessibility and security. The users were fascinated. The IT department not so much, since they had in mind a more expensive tool (which, under the most optimistic view, is not going to be deployed before 18 months) and they don't like the open source philosophy. However, since the users were so supportive, I got over the opposition and managed to finish the project. Now I have 100 days uptime in my server and of course the users love it. The key part was the business case that I proposed to the users. With a prototype, they were able to appreciate the difference and support my choice. Best of luck Giuseppe - 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: about MySQL
Hi guys, Just curious... Can't he use the ODBC driver with Access to use MySQL? I think it *might* be possible. Pretty sure I read about it somewhere... Correct me if I'm wrong. Thx. On Sat, 17 Nov 2001 19:13:10 -0800 Nguyen Trong Phuc [EMAIL PROTECTED] wrote: hi Yang ! You have to control MySQL from command promt. MySQL dont have windows screen. r u using windows c:\[mysql dir]mysqld -create table read mysql manual for more detail. --- Trong Phuc - Original Message - From: Zhou Jiang Yang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 4:15 AM Subject: about MySQL dear Sir/Madam, I have downloaded mySQL from your company's website. Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that means I can create table very easy. just from window screen. I hope get your reply. Thanks for you help. john - 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: about MySQL
Hello, you can use phpMyAdmin script for controling MySQL. it works on http and provides you with graphical front end. have a look at this link. http://phpmyadmin.sourceforge.net/ Deepanshu --- Nguyen Trong Phuc [EMAIL PROTECTED] wrote: hi Yang ! You have to control MySQL from command promt. MySQL dont have windows screen. r u using windows c:\[mysql dir]mysqld -create table read mysql manual for more detail. --- Trong Phuc - Original Message - From: Zhou Jiang Yang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 4:15 AM Subject: about MySQL dear Sir/Madam, I have downloaded mySQL from your company's website. Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that means I can create table very easy. just from window screen. I hope get your reply. Thanks for you help. john - 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 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.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: Fwd: Help? create function returns errno 0: unsupported file type
Troy Bowman writes: System: FreeBSD 4.4-STABLE MySQL version: 3.23.43 UDF code: http://www.aros.net/~lump/udf_int_ip.cc I've been trying to implement my own loadable function for mysql. I needed a function which converts a 4-byte integer into an IP address. I wrote a UDF for mysql, and It compiles fine, but when I try to create the function in mysql, it tells me that the type is unsupported. i.e.: mysql CREATE FUNCTION int2ip RETURNS STRING SONAME libudf_int_ip.so; ERROR 1126: Can't open shared library 'libudf_int_ip.so' (errno: 0 /usr/lib/libudf_int_ip.so: unsupported file type) I figured it might be my code, and tried compiling the udf_example, and it gives me the same thing, i.e.: mysql CREATE FUNCTION lookup RETURNS STRING SONAME libudf_example.so; ERROR 1126: Can't open shared library 'libudf_example.so' (errno: 0 /usr/lib/libudf_example.so: unsupported file type) I don't get why it would be unsupported, and need some outside help :) Please? Pretty please? thanks, ...troy. Hi! Please check a type of the above ...so file with a file command. Also check execute permissions. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: about MySQL
Hi, Wouldn't you have to set up a web server with PHP support to use that? I thought he just wanted a simple GUI client... What's the best thing to use? Nick On Sat, 17 Nov 2001 07:11:22 -0800 (PST) Deepanshu Shukla [EMAIL PROTECTED] wrote: Hello, you can use phpMyAdmin script for controling MySQL. it works on http and provides you with graphical front end. have a look at this link. http://phpmyadmin.sourceforge.net/ Deepanshu --- Nguyen Trong Phuc [EMAIL PROTECTED] wrote: hi Yang ! You have to control MySQL from command promt. MySQL dont have windows screen. r u using windows c:\[mysql dir]mysqld -create table read mysql manual for more detail. --- Trong Phuc - Original Message - From: Zhou Jiang Yang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 4:15 AM Subject: about MySQL dear Sir/Madam, I have downloaded mySQL from your company's website. Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that means I can create table very easy. just from window screen. I hope get your reply. Thanks for you help. john - 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 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.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: truncation operator
Hi. Don't know whether you got any answer yet, but I did not see any. On Tue, Nov 06, 2001 at 11:01:55AM -, [EMAIL PROTECTED] wrote: Hi folks... I've been using the + and the - operators to which seem to work fine in 4.0 but cannot seem to work out what to do with the *. A truncation operator would be of great help, can somebody tell me how to use it in a MATCH... AGAINST query please? thanks Chris MATCH ... AGAINST is going to supports the following boolean operators: * +word means the that word must be present in every row returned. * -word means the that word must not be present in every row returned. * and can be used to decrease and increase word weight in the query. * ~ can be used to assign a negative weight to a noise word. * * is a truncation operator. Well, as far as I understand, word will match only word, not e.g. wording, whereas work* will match both word and wording. I did not try it, though. If that doesn't work for you, could you please elaborate. Bye, Benjamin. -- [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: about MySQL
-Original Message- From: Nick Ooka [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 17, 2001 7:06 AM To: MySQL-General Subject: Re: about MySQL Correction: I meant that he can use the ODBC driver with *MySQL* to be able to use Access as a MySQL client... :) Is this true? Yes. Thx. On Sun, 18 Nov 2001 00:00:49 +0900 Nick Ooka [EMAIL PROTECTED] wrote: Hi guys, Just curious... Can't he use the ODBC driver with Access to use MySQL? I think it *might* be possible. Pretty sure I read about it somewhere... Correct me if I'm wrong. Thx. On Sat, 17 Nov 2001 19:13:10 -0800 Nguyen Trong Phuc [EMAIL PROTECTED] wrote: hi Yang ! You have to control MySQL from command promt. MySQL dont have windows screen. r u using windows c:\[mysql dir]mysqld -create table read mysql manual for more detail. --- Trong Phuc - Original Message - From: Zhou Jiang Yang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 4:15 AM Subject: about MySQL dear Sir/Madam, I have downloaded mySQL from your company's website. Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that means I can create table very easy. just from window screen. I hope get your reply. Thanks for you help. john - 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 Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ 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: java.sql.SQLException: Cannot connect to MySQL server onlocalhost:3306.
Hi,
-Original Message-
From: Prasad Valmeti [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 17, 2001 4:31 AM
To: Nguyen Trong Phuc; [EMAIL PROTECTED]
Subject: java.sql.SQLException: Cannot connect to MySQL server on
localhost:3306.
Thanks for ur response.
I am sending code also. Earlier it was connected to data base.
I haven't used it sometime. Now i am trying but unable to connect to Data
base.
Please have look and suggest me some solution to solve this problem.
import java.io.*;
import java.sql.*;
import java.util.*;
public class TextToDatabaseTable {
private static final String DB = secmngr,
TABLE_NAME = records,
HOST = jdbc:mysql://localhost:3306/,
ACCOUNT = scott,
PASSWORD = tiger,
DRIVER = org.gjt.mm.mysql.Driver,
FILENAME = records.txt;
public static void main (String[] args) {
try {
// connect to db
Properties props = new Properties();
props.setProperty(user, ACCOUNT);
props.setProperty(password, PASSWORD);
Class.forName(DRIVER).newInstance();
Connection con = DriverManager.getConnection(HOST + DB, props);
Statement stmt = con.createStatement();
// open text file
BufferedReader in = new BufferedReader(
new FileReader(FILENAME));
// read and parse a line
String line = in.readLine();
while(line != null) {
StringTokenizer tk = new StringTokenizer(line);
String first = tk.nextToken(),
last = tk.nextToken(),
email = tk.nextToken(),
phone = tk.nextToken();
// execute SQL insert statement
String query = INSERT INTO + TABLE_NAME;
query += VALUES( + quote(first) + , ;
query += quote(last) + , ;
query += quote(email) + , ;
query += quote(phone) + );;
stmt.executeQuery(query);
// prepare to process next line
line = in.readLine();
}
in.close();
}
catch( Exception e) {
e.printStackTrace();
}
}
// protect data with quotes
private static String quote(String include) {
return(\ + include + \);
}
}
I am not sending errors because those are in the below mails.
The possible reasons are:
1. The server is not up and running
2. The server is up and running, but not to the default port.
Regards, venu
Thanks,
Prasad.
-Original Message-
From: Nguyen Trong Phuc [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 18, 2001 8:50 AM
To: Prasad Valmeti; [EMAIL PROTECTED]
Subject: Re: hai
Hi Valmeti !
it's general error, have too many reason. how about yr source code.
maybe grant access, mm.mysql driver ...
- Original Message -
From: Prasad Valmeti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 17 November, 2001 2:49 AM
Subject: hai
Hai All,
I am using Mysql, JDBC on LINUX.
I am unable to connect Mysql from JDBC.
I am getting these errors ::
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:320)
at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:133)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:120)
at java.net.Socket.init(Socket.java:273)
at java.net.Socket.init(Socket.java:100)
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:114)
at org.gjt.mm.mysql.Connection.init(Connection.java:229)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at TextToDatabaseTable.main(TextToDatabaseTable.java:23)
java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is
ther
e a MySQL server running on the machine/port you are trying to connect to?
(java
.net.ConnectException)
at org.gjt.mm.mysql.Connection.init(Connection.java:239)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at TextToDatabaseTable.main(TextToDatabaseTable.java:23)
Please help me to solve out this problem.
Thanks,
Prasad.
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_,
RE: about MySQL
I have downloaded mySQL from your company's website. Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that means I can create table very easy. just from window screen. I hope get your reply. You can of course run MySQL.exe, the command line tool that comes with MySQL. You should use this briefly, just so you know how to use it. It's the tool to use when nothing seems to be working and you can't figure out what's going on, because it introduces the fewest layers. MySQL.exe works fine and can do everything, it is just more difficult than you'd like. :) If you are running on the server, there is a graphical tool automatically installed with MySQL called WinMySQLAdmin. It's in the MySQL/bin directory. Just run it. This will let you create tables and do other administrative tasks from a GUI. It does not run from a client computer, however. It is convenient for initial setting up of users, permissions, etc. If you are running on some other computer (not the server), I suggest downloading WinSQL Lite from www.indus-soft.com. The lite version is free. This is a GUI tool for querying MySQL and any other database you can access via ODBC. You can create tables using SQL commands. You will need to install MyODBC on your client, but you'll need to do that for almost any solution other than the MySQL.exe command line tool. I'm sure there are other similar tools, but this is the one I happen to know about. It's simple and clear, shows your data clearly, and just runs under windows - no install, no need to install anything else (other than MyODBC). You can work with MySQL from Microsoft Access (as Nick mentioned). First, install MyODBC. Then use ODBC Administrator to create a DSN for the MySQL database you wish to access. Then from Access, do File, Open, and set the file type to ODBC Databases. Access will bring up a dialog to let you choose your DSN; select the one that you created for MySQL. Then you'll get some more dialogs letting you select the tables you want, etc. Bingo, you can view and update your data from Access. Modifying, inserting, or deleting records works just like Access. However, if you select the design view for a table, it is read-only. You can't modify the table structure (for example, add a column) using the design view where you just insert a field. :( You can do this via SQL statements, however. Unless you need a web server and php, do not install them just to access MySQL. Either WinSQL or Access or both are easier solutions. If you have more questions, you might want to post to the win32 mailing list ([EMAIL PROTECTED]). It is windows specific, and there's less traffic. Don - 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 get row size for a given table?
Row sizes in MySQL tables can't exceed 65535 bytes (BLOB and, presumably, TEXT fields are not counted towards this total). That means you can't defined a table where the *possible* size of a row might be larger than that -- e.g. a column of type VARCHAR(255) gets counted as taking up 256 bytes towards that total, even though most of the time it will be much smaller. I had tried creating a table with a lot of fields, then ran into problems because of the size limit, so I changed some of the field types from text to integer (which they should have been to begin with, but I was just using a script to create the table quickly so I hadn't bothered with that tweak). Now I'm under the 65535-character limit, but I don't know how close I am. Is there a way to determine the size (or rather, the maximum possible size) of a row in a given table? -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - 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 get row size for a given table?
Bennett Haselton wrote: Row sizes in MySQL tables can't exceed 65535 bytes (BLOB and, presumably, TEXT fields are not counted towards this total). That means you can't defined a table where the *possible* size of a row might be larger than that -- e.g. a column of type VARCHAR(255) gets counted as taking up 256 bytes towards that total, even though most of the time it will be much smaller. I had tried creating a table with a lot of fields, then ran into problems because of the size limit, so I changed some of the field types from text to integer (which they should have been to begin with, but I was just using a script to create the table quickly so I hadn't bothered with that tweak). Now I'm under the 65535-character limit, but I don't know how close I am. Is there a way to determine the size (or rather, the maximum possible size) of a row in a given table? Not sure of the answer in the case of MySQL, but I will say that if you have a table with so many columns as to be close to a 64k row size limit, then you're approaching this whole relational database thing from the wrong angle. Even if it's a logging application, that takes quite a lot of information, no table needs to be that wide, especially if you need the database to perform relatively well. From a performance standpoint, the best way to look at it is something like this: Most file systems store data as pages of octets these pages are generally small, let's say 4k for the sake of an example. If you have a database row that's 64k, it will extend across 16 pages. That's a lot of IO overhead, especially if you're not going to be using anywhere close to all of those columns for any single database operation. If you break the table out into multiple tables, segmented into groups of entities that logically relate to each other, you can actually achieve much better performance. Then, when you need some of the data that's been isolated from the main table, you can just perform a 1-to-1 joined query on the data that you need. Just my 2 cents. -- Tom Bradford - http://www.tbradford.org Developer - dbXML - http://www.dbxml.org Maintainer - jEdit-Syntax - http://syntax.jedit.org Co-Author - O'Reilly Associates' Learning dbXML - 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: about MySQL
Yeah i almost forgot to mention it.you would have to configure Apache and install php module...well its an easy step if he wants some easy to use graphical interfacei work on it..makes life a lot easier.moreover database can be edited from other systems also without any hassles.whats best is still up to the person who intends using it. Deepanshu --- Nick Ooka [EMAIL PROTECTED] wrote: Hi, Wouldn't you have to set up a web server with PHP support to use that? I thought he just wanted a simple GUI client... What's the best thing to use? Nick On Sat, 17 Nov 2001 07:11:22 -0800 (PST) Deepanshu Shukla [EMAIL PROTECTED] wrote: Hello, you can use phpMyAdmin script for controling MySQL. it works on http and provides you with graphical front end. have a look at this link. http://phpmyadmin.sourceforge.net/ Deepanshu --- Nguyen Trong Phuc [EMAIL PROTECTED] wrote: hi Yang ! You have to control MySQL from command promt. MySQL dont have windows screen. r u using windows c:\[mysql dir]mysqld -create table read mysql manual for more detail. --- Trong Phuc - Original Message - From: Zhou Jiang Yang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 4:15 AM Subject: about MySQL dear Sir/Madam, I have downloaded mySQL from your company's website. Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that means I can create table very easy. just from window screen. I hope get your reply. Thanks for you help. john - 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 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.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 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.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
width and height performance
hi! i have to store a dataset of 20 elements. the data is a int(1). i would have about 800 000 datasets. now the question is what performs better with mysql? one table like this: mytable -- someId element1 int(1) element2 int(1) element3 int(1) element4 int(1) ... element20 -- or mytable -- someId elementNum int(2) elementValue int(1) -- is it better to have 800 000 rows with 21 columns or 160 000 000 rows with 3 columns? thanks alot! =) best, florian - 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: width and height performance
In the last episode (Nov 17), florian said: i have to store a dataset of 20 elements. the data is a int(1). i would have about 800 000 datasets. now the question is what performs better with mysql? one table like this: or: mytable mytable ---- someIdsomeId element1 int(1) elementNum int(2) ... elementValue int(1) element20 -- -- is it better to have 800 000 rows with 21 columns or 160 000 000 rows with 3 columns? The 21-column one. Especially if every row has all 20 elements populated. The 2nd option is better for layouts where you want to dynamically add or remove elements, and where each row only has a couple of elements. -- 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
many similar requests - 1 request
hi fellow mysql users :)
i'm programming a little application, and i do the following :
for ($i=0 ; $i200 ; $i++)
{
$result=mysql_query(select $i, title from book where position1=$i \
or position2=$i); // this query returns only 1 row
$row=mysql_fetch_row($result);
print(position: $row[0] -- title: $row[1] \n);
}
this generates 200 sql queries... :/
do you see a way to make 1 sql query that would return my 200 rows ?
maybe something like :
select (increment j 0 - 200) , title from book where position1=j \
or position2=j;
note: given a number between 0 and 199, the number is stored in
position1 OR position2 , but never both.
any idea ?
--
Boris Hajduk [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: many similar requests - 1 request
How about a query something like this:
SELECT position, title FROM WHERE position1 IN (1...200) OR position2 IN
(1...200);
Caviats:
1.) I don't do this everyday so that query syntax could be all wet
(probably is in fact). You may have to programaticly generate the IN
clauses to make it work. I don't think elipses are supported.
2.) I may have misunderstood the result set you're trying for.
In anycase, I think you can get ther general idea of what I have in
mind.
boris hajduk wrote:
hi fellow mysql users :)
i'm programming a little application, and i do the following :
for ($i=0 ; $i200 ; $i++)
{
$result=mysql_query(select $i, title from book where position1=$i \
or position2=$i); // this query returns only 1 row
$row=mysql_fetch_row($result);
print(position: $row[0] -- title: $row[1] \n);
}
this generates 200 sql queries... :/
do you see a way to make 1 sql query that would return my 200 rows ?
maybe something like :
select (increment j 0 - 200) , title from book where position1=j \
or position2=j;
note: given a number between 0 and 199, the number is stored in
position1 OR position2 , but never both.
any idea ?
--
Boris Hajduk [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 need help -- safe_mysql
Following the instructions in the INSTALL-SOURCE file I can get to the last instruction - /usr/local/mysql/bin/safe_mysql --user=mysql I get a No such file or directory file, which is correct, I dont have safe_mysql anywhere on the system Did I miss a step somewhere? Running mysql-4.0.0.0-alpha on RedHat 7.2 thanks __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.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: width and height performance
florian writes: i have to store a dataset of 20 elements. the data is a int(1). i would have about 800 000 datasets. now the question is what performs better with mysql? is it better to have 800 000 rows with 21 columns or 160 000 000 rows with 3 columns? That's 16M rows, not 160M rows, and using INT(1) makes little sense when you can save 3 bytes per value by using TINYINT(1). Anyway, I don't think I can answer your question without knowing more about what you'll do with your data. If the 20 numbers in a set will be representing different things, it makes sense to have 20 columns to save space and time, but if you're going to e.g. search for all sets that have a member greater than x, it's a pain to handle. Normally, though, I think that having 20 columns is a better way to do it, if you're going to treat those 20 values as one set, which always has the same number of members (20). //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: many similar requests - 1 request
Saturday, November 17, Bruce Ferrell wrote: BF SELECT position, title FROM WHERE position1 IN (1...200) OR position2 IN BF (1...200); no, i wasn't clear enough, let's try it again. the table book contains : |-- title -|--position1--|--position2--|--lots of other fields--- | bravenewworld| 0 | | | foundation | 1 | | | shortstories | 2 | 3 | | neuromancer | 4 | 7 | | hyperion | 8 | 6 | | salem| 5 | | | lovedeath| 11 | 9 | the table could grow further than 200 elements i want to design a sql request than returns : |--position--|--- title -| | 0 | bravenewworl | | 1 | foundation| | 2 | shortstories | | 3 | shortstories | | 4 | neuromancer | | 5 | salem | | 6 | hyperion | | 7 | neuromancer | | 8 | hyperion | | 9 | lovedeath | | 11 | lovedeath | - 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
mysqld dumps core
Description: MySQL core dumps with the following trace: 0x807b83f handle_segfault__Fi + 383 0x812bdca pthread_sighandler + 154 0x80f5e3f _mi_key_cmp + 575 0x80f86e0 _mi_seq_search + 200 0x8100872 w_search + 194 0x810099b w_search + 491 0x81013dc _mi_ck_write + 88 0x81003c4 mi_write + 548 0x80c69e9 write_row__9ha_myisamPc + 89 0x80a7cd2 write_record__FP8st_tableP12st_copy_info + 514 0x80a75ff mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4Item15enum_duplicates13thr_lock_type + 1055 0x808309b mysql_execute_command__Fv + 5103 0x8085d96 mysql_parse__FP3THDPcUi + 210 0x80813bd do_command__FP3THD + 1261 0x80808bc handle_one_connection__FPv + 548 AND 0x807b83f handle_segfault__Fi + 383 0x812bdca pthread_sighandler + 154 0x812d482 pthread_rwlock_rdlock + 178 0x80f4c0a mi_rnext + 122 0x80c654b index_next__9ha_myisamPc + 39 0x80be904 get_next__12QUICK_SELECT + 76 0x80c0cb3 rr_quick__FP14st_read_record + 23 0x80a0eb9 sub_select__FP4JOINP13st_join_tableb + 253 0x80a0bf3 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 395 0x8099b37 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemRt4List1Z15Ite m_func_matchP8st_orderT5P4ItemT5UiP13select_result + 4231 0x80825dd mysql_execute_command__Fv + 2353 0x8085d96 mysql_parse__FP3THDPcUi + 210 0x80813bd do_command__FP3THD + 1261 0x80808bc handle_one_connection__FPv + 548 How-To-Repeat: The last binlog entry for the thread that failed in the second crash was: #07 12:33:39 server id 1 Query thread_id=63971 exec_time=131 error_c\ ode=0 SET TIMESTAMP=1006029219; # /home/services/tias/cgi-bin/gifts.fcgi (adams.tias.com 12593) CREATE TEMPORARY TABLE rn1 SELECT item.itemKey, itemNo,title,price, item.description, account.accountKey, relativeUrl, account.storeid FROM inventory.item, account.account, inventory.thumbs WHERE account.groupKey=1 AND thumbs.itemKey=item.itemKey AND account.active=1 AND account.storeid=item.storeid AND status=forsale AND ((title IS NOT NULL) OR (LENGTH(item.description)10)) AND relativeUrl IS NOT NULL AND price BETWEEN 5 AND 9.99 ORDER BY RAND() LIMIT 500 ; Fix: Submitter-Id: submitter ID Originator:Mike Wexler Organization: TIAS.COM MySQL support: license Synopsis: mysqld dumps core Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.44 (Official MySQL RPM) Environment: System: Linux spode 2.2.19-6.2.7 #2 SMP Tue Jul 17 14:41:17 PDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Dec 26 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101836 Jan 15 2001 /lib/libc-2.1.3.so -rw-r--r--1 root root 20273324 Jan 15 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 15 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Jun 29 16:32 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux - 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: many similar requests - 1 request
Hi! On Nov 17, boris hajduk wrote: Saturday, November 17, Bruce Ferrell wrote: BF SELECT position, title FROM WHERE position1 IN (1...200) OR position2 IN BF (1...200); no, i wasn't clear enough, let's try it again. the table book contains : |-- title -|--position1--|--position2--|--lots of other fields--- | bravenewworld| 0 | | | foundation | 1 | | | shortstories | 2 | 3 | | neuromancer | 4 | 7 | | hyperion | 8 | 6 | | salem| 5 | | | lovedeath| 11 | 9 | And what's the problem ? $_=join(,,(1..200)); $result=mysql_query( ); SELECT IFNULL(position2,position1) as position,title WHERE position1 IN ($_) OR position2 IN ($_) ORDER BY position; You may change IFNULL to IF, if you use another 'dummy' value. Still, it won't be very fast as MySQL cannot use _two_ indexes at one. If you don't mind using MySQL 4.0 you can use UNION: $_=join(,,(1..200)); $result=mysql_query( ); SELECT position1 as position,title WHERE position1 IN ($_) UNION SELECT position2 as position,title WHERE position2 IN ($_) ORDER BY position; This way MySQL will resolve both SELECT with indexes. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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
Setting up Mysql to work through ODBC
Hello, I am on a RH 7.1 PC, with the following RPM installed: php-4.0.4pl1-9 php-manual-4.0.4pl1-9 mysql-server-3.23.36-1 MyODBC-2.50.39-1 unixODBC-devel-2.0.7-1 asp2php-0.75.11-1 mysql-3.23.36-1 mysql-devel-3.23.36-1 php-mysql-4.0.4pl1-9 unixODBC-2.0.7-1 unixODBC-generic-2.0.7-1 mysqlclient9-3.23.22-4 unixODBC-mysql-2.0.7-1 what should I do to set up mysql so that it manages a database when it is called from PHP pages via unixodbc? Are there specific tutorial/online examples about this? TIA, mweb -- We need to focus on how to be productive, not just active. Scott McNealy, chairman, CEO, and cofounders, Sun Microsystems. - 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: many similar requests - 1 request
SG Correction - this one is wrong, it will list each entry only once. confirmed :) SELECT position1 as position,title WHERE position1 IN ($_) UNION SELECT position2 as position,title WHERE position2 IN ($_) ORDER BY position; SG This one is ok. what about a way that would work with 3.23 ? :)) (ah, damn real-life admins, who don't want to upgrade before 6 months of proven reliability) PS: i add the following words to pass the spam filter :) database sql query table -- Boris Hajduk [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: mysqld dumps core
On Saturday 17 November 2001 03:20 pm, Mike Wexler wrote: Description: MySQL core dumps with the following trace: 0x807b83f handle_segfault__Fi + 383 0x812bdca pthread_sighandler + 154 0x80f5e3f _mi_key_cmp + 575 0x80f86e0 _mi_seq_search + 200 0x8100872 w_search + 194 0x810099b w_search + 491 0x81013dc _mi_ck_write + 88 0x81003c4 mi_write + 548 0x80c69e9 write_row__9ha_myisamPc + 89 0x80a7cd2 write_record__FP8st_tableP12st_copy_info + 514 0x80a75ff mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4Item15enum_duplicates13thr_lock_type + 1055 0x808309b mysql_execute_command__Fv + 5103 0x8085d96 mysql_parse__FP3THDPcUi + 210 0x80813bd do_command__FP3THD + 1261 0x80808bc handle_one_connection__FPv + 548 AND 0x807b83f handle_segfault__Fi + 383 0x812bdca pthread_sighandler + 154 0x812d482 pthread_rwlock_rdlock + 178 0x80f4c0a mi_rnext + 122 0x80c654b index_next__9ha_myisamPc + 39 0x80be904 get_next__12QUICK_SELECT + 76 0x80c0cb3 rr_quick__FP14st_read_record + 23 0x80a0eb9 sub_select__FP4JOINP13st_join_tableb + 253 0x80a0bf3 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 395 0x8099b37 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemRt4List1Z15Ite m_func_matchP8st_orderT5P4ItemT5UiP13select_result + 4231 0x80825dd mysql_execute_command__Fv + 2353 0x8085d96 mysql_parse__FP3THDPcUi + 210 0x80813bd do_command__FP3THD + 1261 0x80808bc handle_one_connection__FPv + 548 How-To-Repeat: The last binlog entry for the thread that failed in the second crash was: #07 12:33:39 server id 1 Query thread_id=63971 exec_time=131 error_c\ ode=0 SET TIMESTAMP=1006029219; # /home/services/tias/cgi-bin/gifts.fcgi (adams.tias.com 12593) CREATE TEMPORARY TABLE rn1 SELECT item.itemKey, itemNo,title,price, item.description, account.accountKey, relativeUrl, account.storeid FROM inventory.item, account.account, inventory.thumbs WHERE account.groupKey=1 AND thumbs.itemKey=item.itemKey AND account.active=1 AND account.storeid=item.storeid AND status=forsale AND ((title IS NOT NULL) OR (LENGTH(item.description)10)) AND relativeUrl IS NOT NULL AND price BETWEEN 5 AND 9.99 ORDER BY RAND() LIMIT 500 ; Fix: Submitter-Id:submitter ID Originator: Mike Wexler Organization: TIAS.COM MySQL support: license Synopsis:mysqld dumps core Severity:critical Priority:high Category:mysql Class: sw-bug Release: mysql-3.23.44 (Official MySQL RPM) Mike: You have enough info to create a repeatable bug report. Please copy the tables involved in the trouble query to a test machine and try it there. One thing was not clear, though. you had two traces, but only one query. Also, you should check the query that is listed in the coredump handler message - that is usually more reliable than simply the last query in the log. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: Fwd: Help? create function returns errno 0: unsupported filetype
On Sat, 17 Nov 2001, Sinisa Milivojevic wrote: mysql CREATE FUNCTION lookup RETURNS STRING SONAME libudf_example.so; ERROR 1126: Can't open shared library 'libudf_example.so' (errno: 0 /usr/lib/libudf_example.so: unsupported file type) Hi! Please check a type of the above ...so file with a file command. Also check execute permissions. Thanks for the reply. Even though Sasha Pachev told me about INET_ATON and INET_NTOA, I'm still interested in what I did wrong. Permissions have execute. -rwxr-xr-x 1 root wheel 1428 Nov 16 17:38 libudf_int_ip.so File type is: /usr/lib/libudf_int_ip.so: ELF 32-bit LSB relocatable, Intel 80386, version 1 (FreeBSD), not stripped What should it be? Any hints on how to get it right? I must admit, most of what I do is in Perl, and in C only when I have to. This is one of those times that I have to :) ...troy. - 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: about MySQL
Actually, when I checked out the link you posted, I realized that it was the same interface that my webhosting service uses for their customers' databases. Pretty nice interface indeed. Might still take some time to get used to for people accustomed to Access, but still a lot easier than using the command line. :) Nick On Sat, 17 Nov 2001 09:42:01 -0800 (PST) Deepanshu Shukla [EMAIL PROTECTED] wrote: Yeah i almost forgot to mention it.you would have to configure Apache and install php module...well its an easy step if he wants some easy to use graphical interfacei work on it..makes life a lot easier.moreover database can be edited from other systems also without any hassles.whats best is still up to the person who intends using it. Deepanshu --- Nick Ooka [EMAIL PROTECTED] wrote: Hi, Wouldn't you have to set up a web server with PHP support to use that? I thought he just wanted a simple GUI client... What's the best thing to use? Nick On Sat, 17 Nov 2001 07:11:22 -0800 (PST) Deepanshu Shukla [EMAIL PROTECTED] wrote: Hello, you can use phpMyAdmin script for controling MySQL. it works on http and provides you with graphical front end. have a look at this link. http://phpmyadmin.sourceforge.net/ Deepanshu --- Nguyen Trong Phuc [EMAIL PROTECTED] wrote: hi Yang ! You have to control MySQL from command promt. MySQL dont have windows screen. r u using windows c:\[mysql dir]mysqld -create table read mysql manual for more detail. --- Trong Phuc - Original Message - From: Zhou Jiang Yang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 4:15 AM Subject: about MySQL dear Sir/Madam, I have downloaded mySQL from your company's website. Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that means I can create table very easy. just from window screen. I hope get your reply. Thanks for you help. john - 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 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.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 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.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: newbie need help -- safe_mysql
I'm not sure, but isn't it supposed to be safe_mysqld (notice the extra d at the end). Not sure, just curious... (^^;;; Nick On Sat, 17 Nov 2001 13:12:14 -0800 (PST) a a [EMAIL PROTECTED] wrote: Following the instructions in the INSTALL-SOURCE file I can get to the last instruction - /usr/local/mysql/bin/safe_mysql --user=mysql I get a No such file or directory file, which is correct, I dont have safe_mysql anywhere on the system Did I miss a step somewhere? Running mysql-4.0.0.0-alpha on RedHat 7.2 thanks __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.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
UNIX ODBC
I'm looking for a way to download MySQL tables from a remote server to MS' Access 97 in my PC. Many suggested MyODBC. Although I was originally told othewise by my hosting provider, the provider now tells me that UNIX doesn't support ODBC. How can I then do it? Thanks! Anthony F. Rodriguez ([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: downloading manual
Is there a way to download the latest MySQL manual? The only manual I am able to download appears to be an outdated version. - 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
column maximum?
I'm creating a table, and because i'm a fan of single-table databases, its turning out to have many colums. (It will have over 1100). Will this be possible? Will this cause problems? A note: 1020 of the colums will be a numeric value less than 10. I'm creating a database that keeps track of a group of judges scores for something. 20 judges...3 rounds...17 categories...1020 single digit entries. Thanks, Kurt - 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: column maximum?
I am curious, what is your reasoning for being a fan of single-table databases? The number of columns a table may have depends on the table type you are using, this should be in the documentation. Your decision to put 20 judges... 3 rounds... 17 categories into a single table probably is (well almost definitly is) a bad choice. You might want to consider breaking that into a table for judges (contains name, court, address, blah blah), a table for round information, and a table for categories... putting it all into one table makes very little sense. ryan - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 17, 2001 8:59 PM Subject: column maximum? I'm creating a table, and because i'm a fan of single-table databases, its turning out to have many colums. (It will have over 1100). Will this be possible? Will this cause problems? A note: 1020 of the colums will be a numeric value less than 10. I'm creating a database that keeps track of a group of judges scores for something. 20 judges...3 rounds...17 categories...1020 single digit entries. Thanks, Kurt - 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
what is - ric-bin.001, for
Can anyone explain to me what these files are for. If they are related to innodb why don't they go in my specified ibdata directory. I set innodb to use 4gig's and when i start mysql it creates this file in the specified location so why does it need to create bin files when i insert rows into my database? ric-bin.001 ric-bin.index Ric - 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: UNIX ODBC
I'm looking for a way to download MySQL tables from a remote server to MS' Access 97 in my PC. Many suggested MyODBC. Although I was originally told othewise by my hosting provider, the provider now tells me that UNIX doesn't support ODBC. How can I then do it? 1. UNIX does have ODBC but seldom by default ( http://www.unixodbc.com ) 2. You just need to get MyODBC running on your MS Windows machine. It does not sound like you need ODBC on the UNIX box because ODBC is just needed on the client side and it sound like the client is MS Windows. Peter - 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]: many similar requests - 1 request
Sunday, November 18, 2001, 1:26:23 AM, Sergei wrote:
SG Or you can emulate UNION with temporary table.
SG CREATE TEMPORARY xxx SELECT ...
SG INSERT xxx SELECT ...
SG SELECT xxx ...
I used this solution for a good reason : it seems cleaner than the
1..200 thing
:) Thank you so much !
for the record, here is the SQL request:
if ($sortby==POS) {
mysql_query(create temporary table POS_TEMP select iPosition as pos, iCDAid as cd_id
from cdaudio where iPosition!=0);
mysql_query(insert into POS_TEMP (pos, cd_id) select iPosition2, iCDAid from cdaudio
where iPosition2!=0);
mysql_query(insert into POS_TEMP (pos, cd_id) select iPosition3, iCDAid from cdaudio
where iPosition3!=0);
mysql_query(insert into POS_TEMP (pos, cd_id) select iPosition4, iCDAid from cdaudio
where iPosition4!=0);
mysql_query(insert into POS_TEMP (pos, cd_id) select iPosition5, iCDAid from cdaudio
where iPosition5!=0);
$result=mysql_query(select cdaudio.iCDAId, user.vchEmail, cdaudio.vchCDATitle,
cdaudio.dtCDADate,
cdaudio.vchComments, cdaudio.irating, user.vchFirstName, loan.iLoanId,
genre.vchGenreDesc,
cdaudio.iRegion, cdaudio.vchCDAArtist, cdaudio.iNumberofCDs,cdaudio.iCopie,
user.iJukebox,
cdaudio.iPosition, cdaudio.iPosition2, cdaudio.iPosition3, cdaudio.iPosition4,
cdaudio.iPosition5, pos
from cdaudio
left join loan on cdaudio.iCDAId = loan.iCDAId
left join genre on cdaudio.iGenreID = genre.iGenreID
left join user on cdaudio.iUserId = user.iUserId
left join POS_TEMP on cdaudio.iCDAid=POS_TEMP.cd_id
and user.iUserId = $userid
order by pos);
}
Sergei, Bruce, thank you again for your help !
--
Boris Hajduk [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: Fwd: Help? create function returns errno 0: unsupported file type
In the last episode (Nov 17), Troy Bowman said: On Sat, 17 Nov 2001, Sinisa Milivojevic wrote: mysql CREATE FUNCTION lookup RETURNS STRING SONAME libudf_example.so; ERROR 1126: Can't open shared library 'libudf_example.so' (errno: 0 /usr/lib/libudf_example.so: unsupported file type) Please check a type of the above ...so file with a file command. Also check execute permissions. File type is: /usr/lib/libudf_int_ip.so: ELF 32-bit LSB relocatable, Intel 80386, version 1 (FreeBSD), not stripped What should it be? Any hints on how to get it right? The file type should read shared object instead of relocatable. The correct procedure for building a udf is in the manual, under Compiling and Installing User-definable Functions. For FreeBSD, you can pretty much use the example in the docs: gcc -I /usr/local/include/mysql -shared -o udf_myfunc.so myfunc.c If your file is c++, add -felide-constructors -fno-implicit-templates -fno-exceptions fno-rtti, just to match the rest of mysqld (not sure if it's required or not). -- 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
load data local infile problems
Hi, I am creating a database for a university project. I say this because obviously certain things are not done the professional way due to time constraints. I've created a database, and entered the data into files. This is done because the teacher needs to see the files used for data entry. I then issue a command like: load data local infile Products.data into table Products; Occasionally I will get the response: Query ok, 29 rows affected (0.00 sec) Records: 29 deleted: 0 Skipped: 0 warnings: 0 But the vast majority of the time I get the response: Query ok, 0 rows affected (0.00 sec) Records: 29 deleted: 0 Skipped: 29 warnings: 0 I cannot seem to find any consistancy in MySQL's behaviour. This is an extremely annoying problem! If anyone out there can help then please do contact me. Thanks in advance. Regards, Saqib Shaikh Email: [EMAIL PROTECTED] Web site: http://www.saqibshaikh.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
