I store IP addresses using the INET_ATON function, e.g. INSERT INTO myTable(IP_Address) Values (INET_ATON(123.123.33.12)); I would like to create a...

Brent

07-26-2004 11:56 AM
Isaac Blank

Hi all, We are having a tough time tracking down a problem with my MySQL database. The version is 3.23.58 running as the backend for Request Tracker...

Chris Back

07-26-2004 07:04 AM
Chris Back

Hi, I am trying to do something I am not sure we can do... In fact, I would like to test that a field is included in a string. An example could be...

Jean-Baptiste

07-26-2004 02:15 AM
Raqueeb Hassan

Times they are a-changing! Before children begged money for driving license and then daddys car, now they want software license... I guess its more...

Jay

07-25-2004 11:04 PM
steve

Complements=2C Dear Sir=2C I am Mrs=2E Patrika Kovac a Yugoslavian and company secretary to YUKOS OIL South Africa owned by Mikhail Khodorkovsky...

MRS. PATRIKA KOVAC.

07-25-2004 01:51 PM
MRS. PATRIKA KOVAC.

Hi, This started as a phpmyadmin problem, but has somehow morphed into a mysql problem. I don't know how to fix it. I am posting the conversation...

Kirk Soodhalter

07-25-2004 01:42 PM
Aggro

Hi, I have my my.ini inside the c:\ in windows 2000 and while starting the MySQL server (4.0.20), none of the variables declared in that file...

Siva

07-23-2004 11:22 PM
steve

Hello I am new to PHP as well as arrays. I am using a select statement to obtain a table from mysql database. I want to store that table(with two...

sunaina

07-23-2004 01:54 PM
sunaina

Hello my name is Mira! There's a new revolutionary money making phenomenon on the internet! This is to inform you about our BUSINESS OPPORTUNITY...

flor Padillo

07-23-2004 12:03 PM
flor Padillo

I want to create a query that will select all the rows in table A that dont appear in table B based on a column of ints that appears in both tables....

Jason Tomlins

07-23-2004 11:11 AM
Jason Tomlins

sorry if this is a well-worn topic. I have seen much discussion of this on various groups and forums but I haven't really been able to get a...

Andy Fish

07-23-2004 09:19 AM
Andy Fish

Hi All This is probably very simple, but I just don't know the answer to it. What I want to do is select 50 chars of a field and then put '...' at...

Laphan

07-23-2004 06:02 AM
Astra

Helle, I create column with comment on table, and i need to display this comment. How to do this. Thanks. Loulou.

Sandra

07-23-2004 04:42 AM
Sandra

Hello Everyone, I have tried to install DBD::mysql with no success. I have read some hints from previous posts, but no luck yet. It started with...

Ramey Muforo

07-23-2004 02:13 AM
jignaasu

Hi All, I have a JSP / mysql problem. I would like a (JSP) user selected variable to be passed into an sql statement. My code is passing the...

vivienne wykes

07-22-2004 07:54 PM
vivienne wykes

Is it possible to add column data in table A and have (dynamically linked) table B column headers?

Gooseman

07-22-2004 02:49 PM
Gooseman

A question to MySQL users: Do MySQL has its own ERD tool or tools? If not what ERD tool - if any - can be used when working with...

Marek Kotowski

07-22-2004 12:22 PM
Marek Kotowski

Hi, I've set up the following table in MySQL 3.23.58 and all seemed to be working fine: CREATE TABLE advert ( id INT NOT NULL...

Aaron Whiffin

07-22-2004 10:17 AM
ScareCrowe

Hi, The MySQL SQL syntax allows COMMENTS to be added while creating columns and tables. In the manner of Access, one could expect to retreive these...

Claude Schneegans

07-21-2004 09:29 PM
Claude Schneegans

Hi, I just installed the last version of the MySQL ODBC driver, version 03.51.08 A bug in the previous version (Default values not returned by the...

Claude Schneegans

07-21-2004 08:16 PM
Claude Schneegans

Dear All I'm a newbie to MySQL and I have this piece of SQL, which MySQL is complaining about: select ID, (select autorollforward from lucategory...

Adrian

07-21-2004 03:01 PM
Adrian

I'm starting to get frustrated with the mysql licensing model. I was pushed into moving some of my companie's databases to it under the impression...

m.cantaloupe

07-21-2004 10:32 AM
Al Kolff

Complements=2C Dear Sir=2C I am Mrs=2E Patrika Kovac a Yugoslavian and company secretary to YUKOS OIL South Africa owned by Mikhail Khodorkovsky...

MRS. PATRIKA KOVAC

07-21-2004 09:07 AM
MRS. PATRIKA KOVAC

Complements=2C Dear Sir=2C I am Mrs=2E Patrika Kovac a Yugoslavian and company secretary to YUKOS OIL South Africa owned by Mikhail Khodorkovsky...

MRS. PATRIKA KOVAC

07-21-2004 08:50 AM
MRS. PATRIKA KOVAC

Hello, i've a db on my PC. It has 192.168.50.195 IP. It has a user, named amministrazione, who can select records in this db. If i launch mysqlCC...

Vittorio Zuccalà

07-21-2004 06:00 AM
Vittorio Zuccalà

I want to save textarea contents to a mysql database with the paragraph breaks intact without having to type paragraph or break tags in HTML. How can...

Jonathan

07-21-2004 04:51 AM
2metre

Found this at http://icc.ucdavis.edu/iccdocs/joes.htm It does work and is so much easier than anything else I tried. PROBLEM: How to move all tables...

Al Kolff

07-20-2004 08:15 PM
Al Kolff

I can't connect to mysql server using the mysql-connector-java-3.0.11. I was able to run the same program when I was running Suse 9.0 but since I...

Denis Labon

07-20-2004 02:07 AM
Denis Labon

Is there some way to restrict in mysql that certan field has only ONE ROW with CERTAIN VALUE X while other rows can have any values but not...

Perttu Pulkkinen

07-19-2004 03:22 PM
Bill Karwin

This question is about MySQL and how it can be accessed with OpenOffice (presumably the same issue would arise with MS Office, but I'm not sure about...

Bob M

07-19-2004 02:53 PM
Bob M

Can anyone supply tips on connecting to mysql database hosted by easily.co.uk using ASP and DreamweaverMX. I have been unable to connect, used a...

colin

07-19-2004 11:21 AM
colin

I have 2 tables: Table1 contains (among other things): ID Data1 Data2 Data3 1 aaa bbb ccc 2 ddd eee fff 3 ...

Bill H

07-19-2004 10:49 AM
Isaac Blank

Complements=2C Dear Sir=2C I am Mrs=2E Patrika Kovac a Yugoslavian and company secretary to YUKOS OIL South Africa owned by Mikhail Khodorkovsky...

MRS. PATRIKA KOVAC.

07-19-2004 07:33 AM
MRS. PATRIKA KOVAC.

Complements=2C Dear Sir=2C I am Mrs=2E Patrika Kovac a Yugoslavian and company secretary to YUKOS OIL South Africa owned by Mikhail Khodorkovsky...

MRS. PATRIKA KOVAC.

07-19-2004 07:22 AM
MRS. PATRIKA KOVAC.

I am doing a news-oriented multiuser cms, where authors can design html-pages or plaintext-pages and then editor(s) accept them. Also they can load...

Perttu Pulkkinen

07-18-2004 11:47 PM
Perttu Pulkkinen

I'm making a web-site thats backended by php-2-mysql. A common problem seems to be when processing form data, I use information early in the form...

Ravenslay3r

07-18-2004 04:37 PM
Aggro

I am using the following script to connect but keep getting <?php $conn = mysql_connect("", "mjohn", ""); mysql_select_db("testDB",$conn); ?> but...

MJ

07-18-2004 01:58 PM
Ravenslay3r

Can someone help me with a query to get the date/time that a database was last modified? I looked at the SHOW command but there was no mention of...

Shawn McKenzie

07-18-2004 12:26 PM
Shawn McKenzie

Hi, can anyone help me if it is possible to make indexing for fulltext from formats in: 1) *.doc 2) *.xls 3) *.html 4) *.pdf Many thanx for your...

Radim B

07-18-2004 08:42 AM
steve

Hello If I a user table and a item table has - in both a incremental value is led (ID) - and I beside it in an order table all sales the user lead,...

Rene

07-18-2004 06:01 AM
Rene

Trying to get at mysql. I installed mysql on two separate machines and am unable to access either one. On the first I couldn't put it on C: because...

fritz

07-17-2004 07:35 PM
steve

Has anyone have any experience with Pogo Linux's Dataware 2600 (their MySQL appliance). I have a pretty solid background in MySQL, but am looking to...

Norman ELton

07-17-2004 05:50 PM
Norman ELton

what is the most stable download I can get that includes mysql cluster? the site says it is included in 4.1, and there's an rpm for 4.1, but it also...

luke crouch

07-17-2004 01:10 PM
luke crouch

I tried what's below, seemed OK, so I replaced an "IN" for the "=" in the subquery below because of the subquery's error message. I thought w/"IN"...

leegold2

07-17-2004 12:54 PM
leegold2

Hi. I've got an exported database from an external system. It's in the format of MYI, MYD and frm extension files. However, one table in...

Steve

07-17-2004 12:41 AM
steve

Hi everybody, I have the following scenario. Several computers with shared disk in a LAN. Each of these computer has a MySQL server that serves...

Sergio

07-16-2004 07:49 PM
Bill Karwin

I'm a bit new to MySQL (know MS SQL well...and that may be the problem...getting the syntax confused) and I'm having a join problem...can anyone...

Bruce Duncan

07-16-2004 06:57 PM
Isaac Blank

Still seeking to welcome more mysql members in our friendly forum If you are a beginner or you are knowledgable about mysql we welcome...

Design-Crowd

07-16-2004 06:35 PM
Design-Crowd

But I'm stumped..... I've got a windows 2000 server and I am trying to set up PHPBB on it using a mysql database.. I am very inexperienced on...

Walter

07-16-2004 12:38 AM
steve

Is it safe to say that restoring the directory from a backup would that restore all database data and structure? All usr/pwd and GRANT...

Thomas Bartkus

07-16-2004 12:35 AM
steve