MySQL Database Forum

Hello, I have a MySQL table that has (among other fields) an affiliate_id, affiliate_sub_id, and a response_code field. - affiliate_id stores the unique number of each of my affiliates. - affiliate_sub_id stores the affiliate ID of their affiliates. - response_code holds a number between 1 - 6.

I have installed MySQL 4.1.7 and PHP 4.3.9 on our server. I'm trying to setup a form on our intranet website to submit orders from other stores (on the intranet) to a MySQL database. I've got the form trying to submit but get the following error message: "Warning: mysql_connect():Client does not support authentication protocol requested by...

Witam, szukając w dokumentacji mysqla odpowiedzi na moje pytanie trafiłem na taki przykład: SELECT user, MAX(salary) as max_sel FROM tmp GROUP BY user HAVING max_sel = MAX(salary); I faktycznie w tabeli, która na 2 kolumny wszystko działa dobrze ale ja potrzebuję czegoś więcej :-)

I'm using a mysql monitor under cygwin (on win xp) to do a 'load data infile' to put some data into a mysql database (I'm using the xampp bundle).. My problem is that I have a four line CSV file beign inserted, but only two records actually get inserted: mysql> use master; delete from data; LOAD DATA INFILE 'D:/customJobs/database...

Hi, Anyone know why I'm getting syntax error by Timestampdiff? It doesn't like Timestampdiff(Day,Trans_date,CurDate())>=91 What am I doing wrong? Here's the full Sql statement: "Select * From Artransp Where Date_Paid is null And Timestampdiff(Day,Trans_date,CurDate())>=91 And `Cust_#` = " &

Here's one for pathological SQL programmers. I've got a table of things called elements. They're components, sort of like amino acids, which come together to form complex web pages -- as nodes in trees which form parent-child relationships, sort of like newsgroups. For example, the parent_id field points to another element. Indent_level...

I am trying to install the DBD::mysql perl module. However, it claims I need mysql.h: cpan> install DBD::mysql CPAN: Storable loaded ok Going to read /home/alex/.cpan/Metadata Database was generated on Mon, 29 Nov 2004 16:01:05 GMT Running install for module DBD::mysql Running make for R/RU/RUDY/DBD-mysql-2.9004.tar.gz CPAN: Digest::MD5...

mySQL win32 (4.0.22) I am using mySQL Control Admin and seeing a lockup on a thread specific to a like query. select * from table1 where field1 like 'http://h%' limit 100 This request will sit (thread) forever and never return any records. (status : sending...) However : select * from table1 where field1 like 'http://h%' limit 100

i neglected to say thanks the last time you helped me out so thanks for the help. peter

Hello, I'm new to mysql (and databases, fo that matter) and have problems finding a solution. The situation is as follows: I have one table with filtered information about users, the columns are, say, id, field and value. As you can see, any id can have more rows assiciated with him, each containing one crucial piece of information. Now I...

Ok so I'm a MySql newbie. I have a DB that I need to pull out only selected username(s) that end on secected pattern(s). Original Query all usernames. $q = "select $cols from RADONLINE $orderby";

Hi, I just read in the online MySQL manual that there is a column type named VARBINARY. IT is what I was looking for, i think. Now I try to find how can I put (or retrieve) data in this kind of colum from SQL staments and from the MySQL++ API, i think I found how to do so with the API. So my question IS how to manipulate this kind of column...

Hello There's a revolutionary money making phenomenon that is spreading across the Internet like Wildfire. And right now, for a very limited time, You have the opportunity to be right at the Front of it. But time is of the essence, you need to lock in Your position now

Hi i'm working on a web project, and i would like to make my oracle query work in mysql. select match.numero "nummatch", to_char(match.datematch, 'yyyy-MM-dd') "datematch", p1.numjoueur "j1", p2.numjoueur "j2", po1.p1 "m1p1", po1.p2 "m1p2", po2.p1 "m2p1",

I have the following code: SELECT DISTINCT StudentID FROM Students WHERE StudentID != ANY (SELECT StudentID FROM Voted) It seems like it's worded correctly, but I keep getting an error regarding the second query. Referring to the manual on page http://dev.mysql.com/doc/mysql/en/ANY_IN_SOME_subqueries.html, I don't really see a...

I have a query with the following syntax to find students that haven't voted: SELECT * FROM Students WHERE Students.StudentID != Voted.StudentID The thing is, the results I'm getting are basically the same as if has just used 'SELECT * FROM Students' alone. The StudentID list of 'Voted' is shorter than that of 'Students', as some...

I'm sure there's a good explanation, but I haven't seen it in any of the documentation. When I query the mysql database in the user table I see two roots--one with the host as "localhost" and the other with the host as "linux.site." I suppose this is normal, but I don't understand why. This is sort of a repost from yesterday, but since then...

I'm not sure where my problem lies, but someone here might have a suggestion. I'm running MySQL 4.1.7-nt on my laptop, and I'm accessing it through ODBC (MyODBC-3.51.10-x86-win-32bit). I'm developing a .NET web application, but I don't think that's relevant. I already had the application running OK on my desktop, and when I created the...

Hi ! What do I need to compile MySql source? I want to create MySql with SSL, and AFAIK i need to compile it. Do I need MS Visual C++ or something like that ( I work in Delphi )? Best Regards Wojtek Z.

I installed the base MySQL 4.0 with Suse Linux and I try and start it and I get anb issue with the fact that mysql.sock file does not exist in /etc..../mysql/mysql.sock I created a file and made sure the owner is mysql. Can anyone share a template for what this file should look like?

Hello, I hope someone can help me with this. I have a large list of objects (think of them as car parts). Each part may be a substitute for some other part(s). E.g. p1 is a substitue for p2 and p3, but this doesn't mean (necessarily) that p2 and p3 are substitues for p1. What I have is a list a existing relationships, which will be updated...

Hopefully someone can help. I have two tables, namely master and postings: Fields include the following: master: staffno - int (11) primary key forename - varchar (20) surname - varchar (30)

Hi all I'm new to mysql so easy! I use PHPMyadmin as a front end to administering my databases but my simple question is how do I, from the command line (winxp prompt) drop a certain databse. so once I log into mysql, using mysql -u root, how would I go about deleting whole databases?

I have created 2 tables in my MySQL database. A_TAB and B_TAB. They have auto-incrementing integer primary keys respectively named A_ID & B_ID. When I created B_TAB, I declared a field named A_ID which references A_TAB.AID. I insert valid data into both tables. However, the foreign key constraint is NOT being enforced. The database allows...

CHARONWARE, s.r.o. is pleased to announce that a new version of CASE Studio 2 version 2.18 has been released. CASE Studio 2 allows database designers and developers to visualy create and maintain Entity Relationship Diagrams (ERD) and Data Flow Diagrams (DFD) and generate SQL scripts for various databases automatically. The new version...