Hi All I know you will probably say that I should use MS SQL Server DBs with ASP, but my MySQL and ASP combo works and is affordable for me and up...

Laphan

11-09-2006 02:27 PM
Laphan

Hello, According to MySQL document: The expected row length for dynamic-sized rows is calculated using the following expression: 3 + (number of...

mhuiyang@yahoo.com

11-08-2006 01:55 PM
lark

I have just moved over to mysql as the back end and keeping access as front end. My database is for a ordering system. I use autonumber as the Order...

S.Dickson@shos.co.uk

11-08-2006 01:53 PM
lark

I'm DB architect and I work mainly with MS SQL 2000/2005. The 2005 install process is so poorly designed and it installs a ton of "crap". I tried...

vze1r2ht@verizon.net

11-08-2006 01:47 PM
lark

Hi, When linking with mysql 5.0 library, I can't no longer use gdb to debug my app anymore. It cores immediately with a bus error. I've also noticed...

teedee

11-07-2006 10:14 AM
teedee

Hi All My query is as follows: SELECT STRINGTEXT, TOKENID FROM WEBSTRINGS WHERE TOKENID IN (6,20,234,19,32,4,800,177) All I want is my resultset...

Yobbo

11-07-2006 12:58 AM
Bill Karwin

Hi everyone, hoepfully someone can help me with this problem, as I am new to Linux and not so sure how to troubleshoot this problem. I installed...

PowerLifter1450@gmail.com

11-04-2006 03:26 PM
PowerLifter1450@gmail.com

I have just exported database from access onto mysql with the wizard on DM manager I then create the ODBC conection and ink the table to...

S.Dickson@shos.co.uk

11-04-2006 08:44 AM
Jeff North

Hi, I would like to periodically start and stop mysql on a schedule using something like the Windows scheduler. Does anyone know a good way to do...

Bob

11-03-2006 11:10 PM
Norman Peelman

Hi there If I have a "Filename" column in a database, and I want to grab the EXTENSION of this filename... can I do it in a query using REGEXP...

Good Man

11-03-2006 05:48 PM
strawberry

I created a simple test case to reproduce the problem (also check Bug #15500): import java.sql.Connection; import java.sql.DriverManager; import...

David Linsin

11-03-2006 03:26 AM
David Linsin

Currently we have a database with a main table containing 3 million records - we want to increase that to 10 million but thats not a possibility at...

NancyJ

11-02-2006 02:45 PM
Jeff North

Hi everybody, I'm evaluating the possibility of using MySQL 5.0 as a database backend for an application we are doing and I'd like to have...

Federico

11-02-2006 08:18 AM
Federico

I've been having a very rough time installinig mySQL on Linux. I have been following the instructions form...

PowerLifter1450@gmail.com

11-01-2006 12:22 PM
PowerLifter1450@gmail.com

What is best selection for 'collation' parameter - for those, who need use two languages, latin(english) and cyrillic(russian) on website and need...

mistral

11-01-2006 07:36 AM
mistral

Hello, I'v installed mysql 5.0 (MySQL-server-standard-5.0.27-0.rhel4.i386.rpm) on RedHat AS4. When I start mysql through command line (i.e....

Chris Song

10-31-2006 08:51 PM
Thomas Bartkus

Volt is the leader in providing workforce design and is currently the 5th largest staffing firm nationwide. Volt is an E.O.E. Our client is a top...

Vineeta

10-31-2006 12:13 PM
Vineeta

Hi My computer is AMD athlon 64 3400+ with 1.5G DDR. when i execute the following sql in mysql 5.XX. select c.filename, c.topic from articles c where...

cmk128@hotmail.com

10-31-2006 08:28 AM
lark

I would like to dump out only the schema of a few tables that I have in a mysql db. But in addition I would like the returned schema to not reference...

muthuprasanna@gmail.com

10-31-2006 08:26 AM
lark

Hello, My hosting company has MySQL 5 and so do I on my local Fedora Core 5 Linux machine. However, when I import a dump file from...

laredotornado@zipmail.com

10-31-2006 08:24 AM
lark

i want to exclude email addresses which are in newsletter_email_addresses which also appear in mooky_private.sign_ups.email and...

starman7@hotmail.com

10-30-2006 03:07 PM
starman7@hotmail.com

hello, We are running mysql 4.1.18 Is there a way to prevent users from creating the same database name? for example our name schema goes like:...

javier.ortega@gmail.com

10-30-2006 02:30 PM
Jeff North

Can anyone describe to me, or point me perhaps to a link, to figure out how to mirror a MySQL database real-time? I need to create redundancy somehow...

Ike

10-30-2006 09:15 AM
Ian Pawson

Hi I need to design the database that will be storing a lot of personal information and preferences for my employer users. Right now I'm trying to...

Ralph

10-30-2006 09:03 AM
lark

Hi, I'm trying to find the following information from the table found bellow. Year_Sales - # of sales that have occurred this year Year_Income -...

crane.jake@gmail.com

10-29-2006 05:21 PM
crane.jake@gmail.com

Chow can i do something like that: SELECT rfc.radioid, rank, CONCAT_WS(' ', rfc.fac_callsign, rfc.fac_service, rfc.fac_frequency)...

Ralph

10-28-2006 07:50 PM
Ralph

I have a mysql query, "SELECT * FROM task ORDER BY duedate ASC", where "duedate" is a unix_timestamp and can be NULL. I want any NULL results to be...

Mark

10-28-2006 05:08 PM
Mark

hello, We are running mysql 4.1.18 Is there a way to prevent users from creating the same database name? for example our name schema goes like:...

javier.ortega@gmail.com

10-27-2006 07:09 PM
javier.ortega@gmail.com

hello, We are running mysql 4.1.18 Is there a way to prevent users from creating the same database name? for example our name schema goes like:...

javier.ortega@gmail.com

10-27-2006 02:38 PM
javier.ortega@gmail.com

hello, We are running mysql 4.1.18 Is there a way to prevent users from creating the same database name? for example our name schema goes like:...

javier.ortega@gmail.com

10-27-2006 02:32 PM
javier.ortega@gmail.com

I am trying to set the username and password after installing mysql 5, I run an ms dos prompt, and type in mysqld but am met with an error...

genio

10-27-2006 01:50 PM
genio

I am trying to set the username and password after installing mysql 5, I run an ms dos prompt, and type in mysqld but am met with an error...

genio117@dodgeit.com

10-27-2006 01:48 PM
genio117@dodgeit.com

I have the following query which is retrieving a set of data it is almost what I want but I can not manage to get the result I desire. SELECT r1,...

Jonathan

10-26-2006 04:58 PM
strawberry

Hi all, I have two query that I I would like to be one, but I can't figure out how to do it. (mysql 3.23) $sql = sprintf ("SELECT...

stefano.troiani@gmail.com

10-26-2006 01:26 PM
strawberry

Recently, I began using a different MySQL verver (i.e. different machine as well as different version#, going from 4.12a to 4.1.9 max). The...

Ike

10-25-2006 12:51 PM
Ike

I was wondering if there is a way to create a merge table using where clauses for the underlying tables. I have a date column in all tables and...

admin@binindex.net

10-24-2006 12:44 AM
Extremest

I;m having probs with this script. when i click update form the values from the text boxs that javascript updates won't be saved in the data...

Kathryn Gill

10-23-2006 07:55 AM
Kathryn Gill

Thomas Götz <tom (AT) richmountain (DOT) de> wrote in news:200610201219408930- tom@richmountainde: Hi Tom I'm not familiar with Frontbase, but you...

Jody

10-22-2006 05:50 PM
Jody

hi all ive been looking on the mysql site but i cant find the syntax to set a collumn in an existing table to be unique. could someone please give...

mcyi2mr3@googlemail.com

10-22-2006 11:45 AM
strawberry

Dear all, I'm new under mysql and have installed mysql5.0.24a community edition for win32. I have tried to implement a foreign key for this...

coosa

10-21-2006 11:18 PM
coosa

Hi, I have two tables. Table 1 (Date, Total) Table 2 (Date, Total) I'm trying to find a select statement which will give me all the dates from...

callista

10-21-2006 07:29 PM
Jody

Hi I've been working on a database which basically incorporates 3 tables to describe say a widget which is either sold or leased. I have the Widget...

Jody

10-21-2006 07:10 PM
Jody

Hi all, I am new to these so plz never mind if this is funny. here is my problem : Table : moody Column : Title

feucos@gmail.com

10-21-2006 01:21 PM
Jonathan

I have only 1m records in my database running on a laptop of speed 1.6GHz, memory 512MB ram, and Toshiba MK8032GAX hard disk. I use 'LIMIT x,10' for...

-

10-21-2006 03:36 AM
Jeff North

i am having problems with this query which worked perfrcly on mysql 3.0. It is able to extract dowloaders from a table and group them by...

xkp

10-19-2006 07:34 AM
xkp

I'm struggling to find the best query from performance point of view and readability for a normalized DB design. To illustrate better my question on...

phlype.johnson@gmail.com

10-19-2006 07:27 AM
phlype.johnson@gmail.com

Hi. Impossible to create a database using MySQL !!! Message : #1006 - Can't create database 'boby'. (errno: 13) I was told : chown mysql.mysql -R...

Henry16@2cuk.co.uk

10-19-2006 07:18 AM
Henry16@2cuk.co.uk

Is it possible to upload just the changes made to file since last time it was imported/updated to the database. For Eg: 1. File A has String...

mohitanchlia@gmail.com

10-19-2006 12:45 AM
Peter

This SQL statement returns the same result twice even though there is only one matching entry in the first table "tbl_Drivers" and none in the second...

Tenacious

10-18-2006 07:53 PM
Bill Karwin

I just downloaded ODBC drivers from the mySQL web site but whenever I try to create a DSN I get a system 1157 error The driver does show up ok in...

nark

10-18-2006 01:16 PM
Kunle Odutola