These spam filters are really annoying. It's hard to get an answer to my
question when my message gets bounced 'cause it doesn't have MySQL or query
in the message.
In any event,
Is there a way to duplicate a complete table. I am making some
modifications and don't want to use the working table
Try this when your logging into mysql, not when starting mysql. This works
for me on Linux.
mysql --local-infile=1 -u username-p
- Original Message -
From: "Jon Bertsch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 12:02 PM
Subject: Load Data Infile comman
Hi,
Not sure if this is a PHP of a MySQL question, so I am sending it to both
groups. Basically I have a list of numbers with two decimal places in the
MySQL database, but I only want to display some of them with the decimal
points.
i.e.
70 (not 70.00)
87
51.5
46.75
12
29
5.5
-1
45
I know it's
> This is most definitely a quoting issue with your PHP string. If it is
> quoted correctly, the MySQL server will never see the string $var
> appearing after the keyword REGEXP, so if $ has meaning to a regular
> expression wouldn't matter (unless the value of $var contained a $).
> I've used RE
"where name like binary '$var'". It's jury rigged, but works
the way I need it to work for the most part.
Thanks for your suggestions.
- Original Message -
From: "Andy Bakun" <[EMAIL PROTECTED]>
To: "Beauford.2003" <[EMAIL PROTECT
Beauford
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: "Beauford.2003" <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 9:31 AM
Subject: Re: Select * From table where name Like 'help'; Help
> No it doesn
at http://www.mysql.com/doc/en/Regexp.html, but it does
not cover this.
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Beauford.2003" <[EMAIL PROTECTED]>
Cc: "Robert Citek" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL
t; <[EMAIL PROTECTED]>
To: "Beauford.2003" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 8:16 PM
Subject: Re: Select * From table where name Like 'help'; Help
>
> Try the REGEXP modifier. For example:
>
Hi,
Hey, did this list change their spam filters? Now every time I send an email
it gets bounced unless the word MySQL or Query is in the email. Anyway,
Please read below for a recent problem I am having.
I want to be able to search on my database and be able to get the
following, but running i
If your using a Linux machine try using this when logging on to mysql:
mysql --local-infile=1 -u username -p
Not sure about Windows.
There is apparently a security issue with this so it is not enable by
default. Can't remember where I read this, but the above works for me.
Beauford
- Origi
Thanks to all who recently answered some of my MySQL questions, although I
am still having some problems with the concept of joins, but what I have
figured out certainly does make it more efficient and versatile. I have
managed to eliminate two tables (actually combine them into one) which made
my
: "Adolfo Bello" <[EMAIL PROTECTED]>
To: "'Beauford.2003'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, December 04, 2002 4:28 PM
Subject: RE: Table setup question
> Let's assume you want the entire albums list which the song
>
album name and song title for song ID # 1
above).
Sorry if this is long, I just wanted to make sure there is enough info.
TIA
Beauford
- Original Message -
From: "Adolfo Bello" <[EMAIL PROTECTED]>
To: "'Beauford.2003'" <[EMAIL PROTECTED]>; <[E
Hi,
Is there a good tutorial somewhere on the join command. No matter what I do
it just doesn't work. Obviously I'm doing something wrong, but the MySQL
manual just doesn't help at all.
TIA
-
Before posting, please check:
h
Alex,
That's it - I have a if (mysql_fetch_row($result)) before the while loop.
I've changed it slightly and now it works fine. The little things are always
the ones that get you.
Thanks
- Original Message -
From: "Alex Pukinskis" <[EMAIL PROTECTED]>
T
Sorry, where it says echo $item should have read echo $line['item']; Simply
a typo, but the problem is still the same.
Hi,
I'm trying to do a search on database through a web interface using PHP and
having one small problem. Example: If I search for items that cost $5.00 and
there are three of th
DL,
Yep, I see what your saying. In my application it may work fine, but in
larger applications where things may change, it would be easier to do it
with the 3 tables.
Thanks
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Beauford.2003" &l
Hi,
I'm trying to do a search on database through a web interface using PHP and
having one small problem. Example: If I search for items that cost $5.00 and
there are three of them, the query works and displays the information, but
if there is only one item the query works but doesn't display the
-
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Beauford.2003" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, December 02, 2002 10:41 AM
Subject: Re: Table setup question
> Beauford,
> [please reply to the list - there are always others 'lurking&
Hi,
I have a database of albums by a group and I want to be able to search on
this table to find out what songs are duplicated on what albums (there are
36+ albums). The problem is how do I set up the database.
Example:
Album1 has 3 songs. 1.song, 2.song, 3.song, 4.song
Album2 has 4 songs. 4.s
20 matches
Mail list logo
