On 09 Dec 2005 10:45:04 +0800, Jeffrey G. Ubalde
I have been thinking about this for hours, and I cant quite get the
correct keyword for me to search it in the manual.
for example i have a field that contains string1:string2:string3
where colon ':' is the delimiter.
How do i create a select
On 09/12/05, Frank Rust [EMAIL PROTECTED] wrote:
Is there a possibility to select all columns from a table except one or
two columns? For example I have a table with 30 columns and want all
columns but one column *not*. Do I have to write a very long select
statement with 29 column names that
I'm running MySQL 4.0.18-nt accessing the database primarily through Java
with MySQL/Connector J (similar vintage). I am administering this myself,
and can upgrade as needed. I know I'm a bit behind the times.
I apologize for a bit of background, skip to the end for the question
I am
If I remember right, the R-TREES are associated with the GIS extensions to
MySQL. I could be wrong but that's how I remember it (and I had a hard
time finding a reference to them in the official online manual. Can anyone
help?)
From what I've been able to dig up, this is correct. I was
I have searched the whole wide world (www) for months and have not found a
converter that properly convert a MS Access image (gif, jpeg etc) to MySQL blob.
How do I solve the problem, please? I am now frustrated.
I am using Java with MySQL.
Ant
A quick question on the performance of the SELECT statement.
I have a table with a set of 50 products, each product has about 10 attributes
associated with it.
The user will select certain aspects of a product (height, weight, colour,
length etc.), and many products may display a particular
='some_user', or to remove the entry
with Host='localhost' and User=''.
See the full documentation:
http://www.mysql.com/doc/en/Access_denied.html
--
Loren McDonald
[EMAIL PROTECTED]
-Original Message-
From: daniel [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 09, 2003 1:15 AM
To: Philip
/Option_files.html
If after all that you still have troubles, drop me an email (use addy in
my sig below). State what you did and any error messages you received
and I'll be glad to help get you on the right road again.
--
Loren McDonald
[EMAIL PROTECTED]
-Original Message-
From: Philip McCarthy
...and your problem is?
--
Loren McDonald
[EMAIL PROTECTED]
-Original Message-
From: Fernando Martins [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 02, 2003 6:00 PM
To: [EMAIL PROTECTED]
Subject: mySQL newbie confusion
Hi, my experience comes from VB6 with access databases.
I'am
by using SELECT and so
forth. This seems a bit redundant and extravagant a way to go.
Any help would be appreciated.
--
Loren McDonald
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
That's exactly what I was looking for and the way I hoped it could be
done, only I hadn't seen anything about this 'exec' function.
Thanks. I should be able to figure it out myself but I will get back
with you if I need further help.
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer
are still stumped there, write again and include the error
message and the c:\windows\my.ini and-or c:\my.cnf settings.
--
Loren McDonald
[EMAIL PROTECTED]
-Original Message-
From: Marg Brazil [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 11:31 AM
To: MySQL
Subject: Can
Thanks again to everyone who replied!
I finally decided on:
MySQL - Second Edition
Professional PHP Programming - Second Edition
After all the responses here and the feedback through the online
bookstores, those are what I'm after.
--
Loren McDonald
[EMAIL PROTECTED]
-Original Message
NOT
looking for basic step by step books, but ones that have good, working
examples, are formatted so to make finding things fairly simple, and
also make note of Windows (IIS) specifics that I may need to know.
Thanks in advance to all who reply!
--
Loren McDonald
[EMAIL PROTECTED
NOT
looking for basic step by step books, but ones that have good, working
examples, are formatted so to make finding things fairly simple, and
also make note of Windows (IIS) specifics that I may need to know.
Thanks in advance to all who reply!
--
Loren McDonald
[EMAIL PROTECTED
into is MySQL shutting down, for no apparent reason, every so
often. I have just installed .55, so I'm waiting to see if it is still
a problem.
--
Loren McDonald
[EMAIL PROTECTED]
-Original Message-
From: M Wells [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 10:19 AM
are and how (exactly) you want to pull the data.
--
Loren McDonald AKA MisterrMac
[EMAIL PROTECTED]
-Original Message-
From: Hoffman, Geoffrey [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 25, 2003 3:48 PM
To: [EMAIL PROTECTED]
Subject: RE: Need nulls in my join
Unfortunately I
running on the server but for the first week or two of
testing I hadn't experienced any kind of slow down. Obviously, for me,
something in the background WAS getting in the way, but I couldn't
figure out what in the short amount of time is was a problem.
--
Loren McDonald
[EMAIL PROTECTED
a = A;
- 0
--
Loren McDonald
[EMAIL PROTECTED]
-Original Message-
Am having a bit of a weird problem with a SELECT on my MYSQL
database:
If i use this:
SELECT * FROM tablehere WHERE userid = '$uid' AND password =
'$pwd'
with $uid and $pwd being
That seems to be a dead download link.
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 26, 2003 11:42 AM
To: Scott Lewis; [EMAIL
You're right.
Perhaps it had something to do with the massive worm attack yesterday.
It was erroring out with a file not found when I tried last night, but
today it worked.
--
Loren McDonald
[EMAIL PROTECTED]
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http
This one is relatively simple:
Drop the WHERE evtphoto.phtusage = 1.
SELECT it and then GROUP ON it.
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
-Original Message-
From: Hoffman, Geoffrey [mailto:[EMAIL PROTECTED
Oopssorry. That should have been GROUP BY and not GROUP ON
That's what I get for answering a post at 2am. :)
--
Loren McDonald AKA MisterrMac
[EMAIL PROTECTED]
This one is relatively simple:
Drop the WHERE evtphoto.phtusage = 1.
SELECT it and then GROUP ON it.
--
Loren McDonald
What I have discovered is that, when mysqld Windows service is running,
I can't do anything to the user table. If I start it on the command
line with the service stopped but set automatic, it works just fine. An
interesting bug? that creates a nice security block.
--
Loren McDonald AKA
Just tried. Nope...
mysql grant all privileges on mysql.* to ext identified by 'ext1tex2'
with grant option;
ERROR 1036: Table 'user' is read only
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
Does the user 'mysql' have write
Sounds like the same problem I'm having (for which I'm still stumped and
don't know what has caused it): table mysql.user is read only.
Test this by logging into mysql and using the GRANT or REVOKE
statements.
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED
not the problem.
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
You need indexes as soon as (or rather just before) they provide a
performance difference.
Alan
-Original Message-
From: Iain Lang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 22 December 2002 11:15 AM
To: [EMAIL PROTECTED]
Subject: How long is my piece of string?
.
Dear List,
I'm using
it only takes a few minutes to uninstall and install...
-Original Message-
From: Amittai Aviram [mailto:[EMAIL PROTECTED]]
Sent: Monday, 2 December 2002 9:37
To: Mysql
Subject: Embarrassing: can't log in
I've got an embarrassing problem. I installed MySQL on my WinXP machine
this might give you some ideas
select
CONCAT(DAYOFMONTH(p.DATEGOLIVE),'.',MONTH(p.DATEGOLIVE),'.',YEAR(p.DATEGOLIV
E)) DATEGOLIVEF
from my table p
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Friday, 22 November 2002 13:01
To: MYSQL
Subject: date conversion
I'd pick up the text file and search/replace all end of line character(s)
with a end of line00 comma combination so it reads
00,Abe,Lincoln,8347
on each line and try your first method. If that fails, I would drop the ID
field off the table, then do the import with original file, then atlter the
Do you have a space between PartNumber and Like?
Also there's not need to ORDER BY - the GROUP BY does that anyway (I know
that's the case elsewhere)
and finally, I have to guess that it's objecting to Obsolete not being in
the main select.. have you tried including it and grouping by it? you can
MySQLFront will create the tables and pump the data with one button
press
Alan
-Original Message-
From: Terry [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 12 November 2002 22:02
To: [EMAIL PROTECTED]
Subject: RE: How to port MS Access to MySQL ??
MyODBC works fine,
but what to
The .Neta Adapter.. does it make a persistent connection?
If the connection drops between the first insert and the call to select,
then the return would be zero
Alan
-Original Message-
From: Cain O'Sullivan [mailto:cos;iinet.net.au]
Sent: Wednesday, 13 November 2002 16:13
To: [EMAIL
You can't count the join?
Alan
-Original Message-
From: Rick Baranowski [mailto:rickb;baranconsulting.com]
Sent: Wednesday, 13 November 2002 12:10
To: [EMAIL PROTECTED]
Subject: Count Rows in two tables
Hello all,
Does anybody have a SQL string to count the rows in two
Ah, yes - sorry
Alan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:murad;godel.bioc.columbia.edu]On Behalf Of Murad Nayal
Sent: Wednesday, 13 November 2002 12:58
Cc: [EMAIL PROTECTED]
Subject: Re: Count Rows in two tables
Alan McDonald wrote:
You can't count
I agree mostly,... but why is ASP worthless?
Alan
-Original Message-
From: [EMAIL PROTECTED] [mailto:vanboers;why.dedserius.com]On
Behalf Of Van
Sent: Monday, 11 November 2002 6:21
To: Paul DuBois
Cc: MySQL
Subject: Re: PHP bias (Way OT)
Paul:
Not sure why my post didn't cc
As Far As I Know
-Original Message-
From: Gelu Gogancea [mailto:ggelu;arctic.ro]
Sent: Saturday, 9 November 2002 23:37
To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
Subject: Re: mysqld refuse to die
Yes.All processes are named mysqld...less one mysqld_safe
which is main
Also
In My Humble Opinion (IMHO)
For What It's Worth (FWIW)
-Original Message-
From: Gelu Gogancea [mailto:ggelu;arctic.ro]
Sent: Saturday, 9 November 2002 23:37
To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
Subject: Re: mysqld refuse to die
Yes.All processes are named
Every SQL database requires the ability to locate a record which is unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to read a primer on SQL databases
Alan
-Original Message-
From:
MySQLfront does it all
-Original Message-
From: tmb [mailto:topmailbox;yahoo.com]
Sent: Friday, 8 November 2002 23:18
To: [EMAIL PROTECTED]
Subject: How to port MS Access to MySQL ??
Is there a tool for doing a quick port from MS Access
to MySQL?
Or must you manually create
/INSERT_SELECT.html
On Thursday, November 7, 2002, at 08:56 PM, Alan McDonald wrote:
insert into mytable(field1, field2, field3) select field1, field2,
newvalue
from mytable where productcode=xx
-Original Message-
From: Doug Coning [mailto:lists;coning.com]
Sent: Friday, 8
insert into mytable(field1, field2, field3) select field1, field2, newvalue
from mytable where productcode=xx
-Original Message-
From: Doug Coning [mailto:lists;coning.com]
Sent: Friday, 8 November 2002 14:35
To: [EMAIL PROTECTED]
Subject: Copy Records in a table...
Hi everyone,
I was under the impression that hotbackup was only available with innodb
tables
where do you get amanda from?
Alan
-Original Message-
From: Lewis Watson [mailto:lists;visionsix.com]
Sent: Wednesday, 6 November 2002 14:22
To: mysql
Subject: MySQL and amanda
Hey MySQL users!
I have
Because a primary key is a table property and the index of the key is a
property of the primary key. If you want ot drop a primary key you alter the
table
-Original Message-
From: Eric Frazier [mailto:ef;kwinternet.com]
Sent: Tuesday, 5 November 2002 15:26
To: Paul DuBois
Cc: Uma
Then, why..., if I wait a little longer, does the alter command work? I do
not change the the permissions in the meantime. I just wait.
Alan
-Original Message-
From: gerald_clark [mailto:gerald_clark;suppliersystems.com]
Sent: Tuesday, 29 October 2002 1:38
To: Alan McDonald
Cc
I use MySQLFront and is creats the tables and imports the data with one
click
never had a problem
Alan
-Original Message-
From: [EMAIL PROTECTED] [mailto:Sam4Software;aol.com]
Sent: Wednesday, 30 October 2002 9:15
To: [EMAIL PROTECTED]
Subject: Access2MySQL
Hi all,
After setting
MySQL
I asume that when I add a field or rename a field etc and get the errcode
13, that I must wait til a connection timeout has occurred to be able to
make this structural change. While I'm developing, is there a quicker way to
do this?
Stopping/starting the service is not that quick.. Is
But after a while it does, cause I only have to wait a while with no
activity on the database, and the command executes. So it's not permissions
Alan
-Original Message-
From: gerald_clark [mailto:gerald_clark;suppliersystems.com]
Sent: Tuesday, 29 October 2002 1:38
To: Alan McDonald
Is it possible to update a field using SQL with the contents of a text file
previoously written to disk?
I want to update a mediumtext field with the contents of c:\data\mytext.txt
file.
update mytable set mymediumtext= filecontents where id=number... ?
Alan
SQL
ASP
I can't seem to find any examples of saving text area form inputs to TEXT
type fields.
They all seem to be text inputs or strings being saved to varchar fields...
Can someone point me to an example of saving large text quantities to a TEXT
Type field in ASP?
Thanks
Alan McDonald
http
McDonald
http://www.meta.com.au
-
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
John,
StudioName?
GenreName?
F_Name?
L_Name?
DatabaseName?
ServerName?
Alan
I can't seem to figure out the select statement to get the name. Do I need
the the StarID or ActorID in Titles table? Thank you.
I am using PHP and MYSQL.
Studios (StudioName, StudioID)
Genres (GenreName, GenreID)
isn't that the month changing?
it's changing from october to january...??
Alan
-Original Message-
From: Jay X [mailto:sparqz50;hotmail.com]
Sent: Monday, 21 October 2002 12:20
To: [EMAIL PROTECTED]
Subject: timestamp bug increments by one day
Hi There,
Just reciently (after
can someone tell me why I get this error back from postings?
Your message was not delivered for the following reason:
E-mail Account: lists-mysql is over the limit of 31457280 bytes.
Automated Postmaster
Alan McDonald
http://www.meta.com.au
I think you need to give us the SQL you are using to do the search - we'll
ba ble to see what your are trying to do better
Alan
-Original Message-
From: µÑ ¶Ì [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 October 2002 15:37
To: [EMAIL PROTECTED]
Subject: a mysql question
I'm a
a generator ID and using that (guaranteed to
be unique) for both the primary key of the master and the foreign key of the
detail records. Surely there is a good method for use with MySQL?
Alan McDonald
http://www.meta.com.au
? Or
does insert_id() return another connections last insert?
Alan
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 October 2002 0:59
To: Alan McDonald; [EMAIL PROTECTED]
Subject: RE: Inserting Master and Details records
Hi
insert_id returns
Sorry your second link makes that claim a little clearer - it's on a
per-connection basis
Alan
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 16 October 2002 23:58
To: [EMAIL PROTECTED]
Cc: Alan McDonald
Subject: Re: Inserting Master and Details
for you to clean up at your leisure.
More elaborate parsing would be required if the statements were multi-line.
Daniel J McDonald, CCIE 2495, CNX
Principal Network Specialist
Digicon Technologies
http://www.digicontech.com
Digicon, a Cisco Partner, Silver Certified
I am running MySql 3.23.38, Slackware Linux 7.1 (custom Kernel 2.4.4), PhP
4.0.5, and Apache 1.3.19.
I have found what I believe is a bug with this release of MySql. When I try
to delete an entry from a table (DELETE FROM articles WHERE article_id =
'3') the database only deletes the article_id
62 matches
Mail list logo