> I know i have to connect first to the server. I tried issuing
> the command like this:
> mysql> mysql -h localhost -u root -p;
> but it says error in syntax. if i take out the semi colon,
> the shell would just add a '->' below.
You are already running mysql by typing that. You should have
rea
On Mon, 23 Aug 2004 00:25:36 -0500, Debbie Woods
<[EMAIL PROTECTED]> wrote:
> I am building a search feature with Cold Fusion and need to have similar
> string matches included in the search results. I have a search form field
> called hsname. I am trying to use the SOUNDEX function in my query lik
I am building a search feature with Cold Fusion and need to have similar
string matches included in the search results. I have a search form field
called hsname. I am trying to use the SOUNDEX function in my query like
this:
SELECT *
FROM accounts
WHERE SOUNDEX(hsname) = SOUNDEX('#form.hsname#')
I
hi! im new to the php community and i hope i can find my place in here.
Im new to php programming, but im a fast learner. Lately im experiencing a tricky
problem.
I have installed an apache web server, mysql and php 4 and i have run several programs
with my current configuration of my php.ini and
> > x
> > ---
> > 1
> > 2
> > 3
> > 4
> >
> > Select sum(x) would return 10 right..
> >
> > Now I need a function .. Say fx() so that when I issued
> >
> > Select fx(x) ...
> > It would return 24 which is 1x2x3x4
> >
> I assume that the function that yielded 24 was fx(4), not fx(x). In high
> s
Hi,
I am trying to find how to use command "select count(*)". I tried it in
mysql query console, it shows the number of my rows in my table. But
when I tried it in perl with $sth->do("select count(*) from mytable")
and run the perl script from DOS console, I always gets "1" in value.
What is the r
- Original Message -
From: "Leonardus Setiabudi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 22, 2004 11:45 PM
Subject: Function to multiply multiple row values
> Hi All,
>
> Can someone point me a function that return the multiplication of query
result..
> Hack.. I
Hi All,
Can someone point me a function that return the multiplication of query result..
Hack.. It's hard for me just to explain what I nedd..
Ok, it goes like the sum() function, but instead of the summary.. It
will return the multiplication Here is what I need it to do
x
---
1
2
3
4
Selec
hi, I have some problem with full text search of mysql.
I have the same problem as below articles.
http://lists.mysql.com/mysql/157526
I'm using UTF-8 encoding for CJK.
I want to know solution about this error. In my case,
==
Hello everyone,
I am trying to install MySQL 5.0.0 on a fresh install
of Fedora Core 1, however I am running into a little
trouble and I was hoping someone could give me a
little insight on what I might be doing wrong.
I am able to install the 'server', 'clients', and
'devel' packages with no prob
Hi,
I have a problem, It's been months since I used MySQL and (I believe) I had
set it up with a root password. Now I can't log on to MySQL as root MySQL
user and create a new user or manage an existing user (I can log onto server
as root of course). I'm running MySQL 3.23 and RH Linux 8. The o
select id from mydata order by name.
If that puts the #125 first etc. simply created a field called
'order_field' or whatever and put numeric values in them.
The SELECT id, name FROM mytable ORDER by order_field.
dan orlic wrote:
Ok, I have a client that has a specific request. the ordering of da
Chris McKeever wrote:
RAID 5 is the wrong answer. If reliability is a big deal do mirroring.
Otherwise get as much memory as you can afford and use any money left
over to get the fastest disk drives you can afford. If you have multiple
disks, spread things between different drives. OS on on
Ok, I have a client that has a specific request. the ordering of data.
For example current the order by returns this:
id | Name
--
1 | #124
2 | #125
3 | #155
4 | apples
5 | bacon
but he would rather see the data as :
id | Name
--
1 | apples
2 | bacon
3 | #124
4 | #125
5 |
On Sun, 22 Aug 2004 16:40:24 -0700, Mike Wexler <[EMAIL PROTECTED]> wrote:
> Chris McKeever wrote:
>
> >On Sat, 21 Aug 2004 10:18:06 -0700, Info <[EMAIL PROTECTED]> wrote:
> >
> >
> >>After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the
> >>piggy bank and build a new linu
You are comparing the page_url column to a constant string (the contents of
$url_field). Constant strings must be quoted in SQL (otherwise they look
like column names). Since you use double quotes around the whole string,
you must escape double quotes within the string. Without escaping, you
Chris McKeever wrote:
On Sat, 21 Aug 2004 10:18:06 -0700, Info <[EMAIL PROTECTED]> wrote:
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy
bank and build a new linux mysql server. Here's my problem: I have, at present, two
rather large databases. (A: 4Mil
Wondered in this example why $url_field apparently must be in quotes
ie. escaped quotes? Since the whole php/mysql statement is quotes too
wouldn't it interpolate correctly w/out added quotes? What's the idea
behind it? I got this off of a a web tutorial. It's a varchar field.
Thanks for helping w
No, you enter that command at your shell prompt.
mysql
says, "launch the mysql client with input from mydb.sql." Add whatever
options you need:
mysql -u root -p dbname
for example.
If you have already started the client (you're at the mysql prompt), then
use the source command:
mysql>
Just thought I would add you should take a look at the man page for
mysqldump. At a shell prompt type "man mysqldump".
Michael J. Pawlowsky wrote:
Don't do it from within mysql.
Do it from your shell prompt.
[EMAIL PROTECTED] directoy]$mysql -p database < database.sql
"-p" is used for promptin
Don't do it from within mysql.
Do it from your shell prompt.
[EMAIL PROTECTED] directoy]$mysql -p database < database.sql
"-p" is used for prompting for a password. You only need it if you need
a password. "<" means to redirect the sql file as input to the mysql
command. "database" is the actual
I get:
mysql> -p database < /Users/me/Desktop/database.sql;
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near '-p database < /Users/me/Desktop/database.sql' at line 1
Thanks,
TR
On Aug 22, 2004, at
Generally it's just sql.
The easiest way would be from a command line on the server.
mysql -p dbname < mydb.sql
Cheers,
Mike
[EMAIL PROTECTED] wrote:
Hi,
I dumped an entire db (using phpMyAdmin, MySQL 4.0.18)
I have a file now: mydb.sql
Again, this is the entire db.
Now I have recreated the db an
Hi,
I dumped an entire db (using phpMyAdmin, MySQL 4.0.18)
I have a file now: mydb.sql
Again, this is the entire db.
Now I have recreated the db and all the tables, rows, etc.
All I need to do is to get the data (data only, db is built) that goes
into those tables and rows from the file into the
Al tratar de instalar mysql (mysql-4.0.20d-win.zip), después de descomprimir y ejecutar el setup...todo funciona bien, pero cuando voy a ...\php\mysql\bin\ y ejecuto winmysqladmin.exe para activar el usuario administardor me aparece el siguiente mensaje
"Access violation at address 0040289D
There should be a PID file somewhere - either in the MySQL directory or
under /var - that needs to be deleted before the init script will let you
start another server instance.
Cheers
Andrew.
- Original Message -
From: "Grant" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday,
I think I failed to make something clear. The form
and table that has the multiple selections from one
category into multiple columns / same category is
where users are inserting information.
Hope this helps.
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> Rhino,
> First, thank you f
Rhino,
First, thank you for the great response. Also, sorry
cause on the reply , Yahoo was truncating the part I
wanted to reply about.
Anyway, yes it was the second case. I ask a user to
pick 5 colors, so in my table I have fields
In my uneducated mind I "thought" that would make for
> In the last episode (Aug 20), Joshua Beall said:
> > Is there any way in MySQL to have calculated fields? E.g., a make
> > "expiration" equal to the "lastPaid" date, plus 1 year. Whenever
> > lastPaid gets updated, expiration can be updated as well.
> >
> > Is this possible? I know it could
- Original Message -
From: "Stuart Felenstein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 22, 2004 7:32 AM
Subject: Dynamic Queries
> Not sure what to call what I'm attempting to do,
> decided on dynamic queries. I should mention that I've
> been working with datab
Not sure what to call what I'm attempting to do,
decided on dynamic queries. I should mention that I've
been working with databases for just a little over a
month.
Example could be many web sites, but let's say Expedia
(the travel site..booking flights, cars, etc)
My understaning is that the SQL
31 matches
Mail list logo
