Chris W wrote:
By default MySQL uses port 3306 so you need to be sure that port is open
on the server, and not blocked by a firewall. You also need to be sure
the user you are trying to login as can login remotely. In the MySQL
user data base, there is a column for host which is the host
Hi,
Im sure this is a stupid problem but im a bit confused, and some assistance
would be greatly appreciated.
Im trying to assist with the maintenance/updating of a php site for a school
which uses mysql, and is allready up and running on a remote server.
I have the ftp username and password,
By default MySQL uses port 3306 so you need to be sure that port is open
on the server, and not blocked by a firewall. You also need to be sure
the user you are trying to login as can login remotely. In the MySQL
user data base, there is a column for host which is the host that user
can
I am a Windows User and very used to the Dos Prompt. Can someone please
tell me what the Shell Prompt is?
What I am asking is the difference between a shell and a dos prompt
vis-a-vis mysql.
Thank you.
Ola
to as shell prompts.
Jack
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Friday, August 01, 2003 8:28 AM
To: [EMAIL PROTECTED]
Subject: Really stupid Question...
I am a Windows User and very used to the Dos Prompt. Can someone please
tell me what the Shell Prompt
It's conceptually the same. Both allow you to enter in commands to either
execute code in batch or enter program names to be excuted. I'm not sure
about Win platforms. But, in the *.nix environments you have a choice
of different shells. And, also you can run things in the background and
a host of
stupid Question...
I am a Windows User and very used to the Dos Prompt. Can someone please
tell me what the Shell Prompt is?
What I am asking is the difference between a shell and a dos prompt
vis-a-vis mysql.
Thank you.
Ola
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hey,
Here is what I want to do
I have 2tables
let's say table A and B for simplicity.
in table A I have column id
and in table B I have column A_id
I insert a new value into table A insert into a values(NULL)
Since id is auto_incremenet and the primary key it will have an auto value.
Now I want
Check out LAST_INSERT_ID() in the manual
-Original Message-
From: Jonas Geiregat [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 12:26 PM
To: 'Mysql'
Subject: probably a stupid question
Hey,
Here is what I want to do
I have 2tables
let's say table A and B for simplicity
On 18-Jun-2003 Jonas Geiregat wrote:
snip
I insert a new value into table A insert into a values(NULL)
Since id is auto_incremenet and the primary key it will have an auto
value.
Now I want that the column A_id contains that id nr.
I could query for the biggest id in column A and insert
Jonas,
After the insert, execute
SELECT LAST_INSERT_ID();
This always gives the last auto increment value generated by your database
connection.
Andy
-Original Message-
From: Jonas Geiregat [mailto:[EMAIL PROTECTED]
Sent: 18 June 2003 19:26
To: 'Mysql'
Subject: probably a stupid
PROTECTED]
Subject: stupid question
do you know any fonction that convert int to char*
thantks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
--
From: Chuck PUP Payne [SMTP:[EMAIL PROTECTED]]
Sent: 11 March 2002 02:59
To: Cary; mysql lists.mysql.com
Cc: PHP General
Subject: Re: [PHP] Re: A stupid question...
I want to sort my a letter in a set colomn. Let say I want
Hi,
I not a newie but I am not a pro at mysql either. I want to do a query by
letter(a, b, c..ect.). Is there a simple way to do it. I am writing in PHP.
So can someone please so me the how.
| Chuck Payne |
| Magi Design and Support |
|
At 08:24 PM 3/10/02, Chuck \PUP\ Payne wrote:
Hi,
I not a newie but I am not a pro at mysql either. I want to do a query by
letter(a, b, c..ect.). Is there a simple way to do it. I am writing in PHP.
So can someone please so me the how.
I'm not totally sure what your looking for. If you could
I want to sort my a letter in a set colomn. Let say I want to sort the
colomn last_name
http://www.myserver.com/mysort.php?Letter=A
Like to create a link like A then sort only the last name ore what ever I
want to sort by that letter.
I hope that's helps. I can order by, but I can't so a sort
I want to sort by a letter in a colomn. Let say I want to sort the colomn
last_name. I can do order by but I can do just the A's.
http://www.myserver.com/mysort.php?Letter=A
Like to create a link on a web A then sort only the last name are A.
I hope that's helps. I can order by, but I can't
Chuck Pup Payne wrote:
I want to sort by a letter in a colomn. Let say I want to sort the colomn
last_name. I can do order by but I can do just the A's.
http://www.myserver.com/mysort.php?Letter=A
Like to create a link on a web A then sort only the last name are A.
I hope that's
PROTECTED]]
Sent: Sunday, March 10, 2002 8:17 PM
To: Chuck \ Pup\\ Payne
Cc: mysql lists.mysql.com
Subject: Re: [PHP] Re: A stupid question...
Chuck Pup Payne wrote:
I want to sort by a letter in a colomn. Let say I want to sort the colomn
last_name. I can do order by but I can do just the A's.
http
: [PHP] Re: A stupid question...
I want to sort by a letter in a colomn. Let say I want to sort the
colomn
last_name. I can do order by but I can do just the A's.
http://www.myserver.com/mysort.php?Letter=A
Like to create a link on a web A then sort only the last name are A.
I hope that's helps
G'day Daren
$query = SELECT * FROM tbl_name WHERE LEFT(last_name, 1) == '$letter');
NOTE: LEFT() is a special function, I'd consider it a derivative of
SUBSTRING()
Does MySQL have a function that can selectively return words from a column?
What I'm looking for is the equivalent of
Use an index
If you mean use a primary key to create a unique record
regardless of the other data in the row, I've already done
that. However I'm using that primary key as a means of
creating a relationship with another table.
What I don't want, is the same category name and
customerID twice,
On 08-Jul-01 Jonah Klimack wrote:
What I don't want, is the same category name and
customerID twice, even if it does have an index column
that differentiates it from other rows.
I've tried this:
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
customerID INT UNSIGNED,
categoryname
HI,
Does it make any sense to create an index on the primary key?
Ken
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, July 06, 2001 3:49 PM
Subject: Re: Perhaps a stupid question about KEY
On Sat, Jul 07, 2001 at 07:22:19AM -0700, Ken Sommers wrote:
Does it make any sense to create an index on the primary key?
Primary Keys are automatically indexed. In fact, you might say that a
primary key is just a special type of index (it is).
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Hi
I want to enforce unique records in one of my
tables.
The table goes like this:
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
customerID INT UNSIGNED,
categoryname VARCHAR(20)
With customer ID pointing to a customers table.
I suddenly realized that one customer could input
the same
Use an index.
--
Jonah Klimack wrote:
Hi
I want to enforce unique records in one of my
tables.
The table goes like this:
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
customerID INT UNSIGNED,
categoryname VARCHAR(20)
With customer ID pointing to a customers table.
At 12:14 AM +0200 7/7/01, Fournier Jocelyn [Presence-PC] wrote:
Hi,
Is there any structural difference between a PRIMARY KEY and a UNIQUE key ?
Thanks ;)
Jocelyn Fournier
Presence-PC
www.presence-pc.com
They're mostly the same, with these differences:
There can only be one PRIMARY KEY per
t2.*
from table1 t1,
table2 t2
where t1.t2ID = t2.t2ID
Clear as mud?
Cal
http://www.calevans.com
-Original Message-
From: GERARDO GALLARDO [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 5:57 PM
To: [EMAIL PROTECTED]
Subject: STUPID QUESTION
I'm new to MyS
= table2.id;
or use alias
SELECT t1.ID, t2.Name from table1 t1, table2 t2 where t1.id = t2.id
ChrisB
-Original Message-
From: GERARDO GALLARDO [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 3:57 PM
To: [EMAIL PROTECTED]
Subject: STUPID QUESTION
I'm new to MySQL and SQL in general. I
Message -
From: "GERARDO GALLARDO" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 27, 2001 7:56
Subject: STUPID QUESTION
I'm new to MySQL and SQL in general. I have been searching and searching
but I can't find an answer to a question which I know is simple. I have
r
Hi,
How do I put two or more hosts in a single user row? I have all them at
'localhost' but I'd like to set it to something like
'localhost,machine.domain.tld,machine2.domain.tld' without having to
repeat the line since I've got to manage a *bunch* of users.
Thanks...
32 matches
Mail list logo