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 that
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 login
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, and
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 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
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
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 is
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
> 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.
> 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(NUL
On 18-Jun-2003 Jonas Geiregat wrote:
> 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 t
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
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 tha
EMAIL 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 ar
hat one.
Tim Ward
Internet chess www.chessish.com <http://www.chessish.com>
--
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 stu
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
lists.mysql.com
Cc: PHP General
Subject: Re: [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&qu
---Original Message-
From: michael kimsal [mailto:[EMAIL 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 wan
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 t
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
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 l
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
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 |
| www.magides
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,
> categor
> 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,
Jeremy Zawodny wrote:
> 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).
There are som
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 custome
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 "category
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 PROTECTE
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
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 KE
Martin Jeremic wrote:
>
> Can somebody tell me how to save "SHOW VARIABLES" query into file ?
>
> --
> Martin Jeremic - JSoft
>
> http://jsoft.webjump.com/
> mailto:[EMAIL PROTECTED]
>
> -
> Before posting, please check:
>
Can somebody tell me how to save "SHOW VARIABLES" query into file ?
--
Martin Jeremic - JSoft
http://jsoft.webjump.com/
mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
Would you please read this too :)
- Original Message -
From: Yusuf Incekara <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 7:08 PM
Subject: Mysql Server Client & Myodbc Silent Install
> Is there any spesification for
> Installing Mysql Server Clients & Myodbc.
- Original 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 qu
= 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 genera
er you use:
Select t1.*,
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 QUE
-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 have been searching and searching
but I can't find an answer to a question which
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 read a book called Teach
Yourself MySQL in 21 days. It talkes about defining relationships between tables but
it never actually shows you how you w
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...
--
38 matches
Mail list logo
