Christian Calloway em Friday 26 July 2002 17:30 foi agraciado com uma
resposta por:
Sorry this may be a little offtopic, but I am currently moving a site I
was developing from coldfusion+MSAccess to PHP+MySQL. I remembered reading
somewhere that there is a utility that will convert/transfer
Got it figured out --
To export table structure:
C: mysqldump -d {database name} {tables} sqltextfile.sql
Then to import the new Table Structure:
To import table structure / data
C: mysql {database name} sqltextfile.sql
Just a note: If you want to copy the structure of an
You can use an id field in your table structure that is set to auto
increment for each entry into database then just do a query on the id number
you wish to view... of course this would mean that you would need to create
a new field on your table but that should get you what you need.
Jas
--
On Fri, 26 Oct 2001 23:27, Gerard Onorato wrote:
Hello,
I am a recent return to the list. Wow has the traffic grown! This is
awesome.
I have a couple of questions and one may be a RTFM but I can't find the
answer.
#1) While I thought I was extremely familiar with the MYSQL functions
Hello,
I am a recent return to the list. Wow has the traffic grown! This is
awesome.
I have a couple of questions and one may be a RTFM but I can't find the
answer.
#1) While I thought I was extremely familiar with the MYSQL functions
available in PHP I found on e in a code snippet that I have
Since I first made the tables for my site I've had to modify them quite a
bit. I always keep a copy of the commands I used to make the tables in case
I need to move a site. Is there a way to ask mysql to list the create table
commands?
Susan
--
PHP General Mailing List (http://www.php.net/)
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 08, 2001 7:49 PM
To: [EMAIL PROTECTED]
Subject: [PHP] easy mysql question
Since I first made the tables for my site I've had to modify them quite
a
bit. I always keep a copy of the commands I used to make the tables in
case
I need to move
On Sunday 08 July 2001 21:48, [EMAIL PROTECTED] wrote:
Since I first made the tables for my site I've had to modify them quite a
bit. I always keep a copy of the commands I used to make the tables in case
I need to move a site. Is there a way to ask mysql to list the create table
commands?
if you use phpMyAdmin you can dump the structure and data to a file and use
phpMyAdmin to place it on a new machine
At 10:48 PM 7/8/01 -0400, [EMAIL PROTECTED] wrote:
Since I first made the tables for my site I've had to modify them quite a
bit. I always keep a copy of the commands I used to
On 09-Jul-01 [EMAIL PROTECTED] wrote:
Since I first made the tables for my site I've had to modify them quite a
bit. I always keep a copy of the commands I used to make the tables in case
I need to move a site. Is there a way to ask mysql to list the create table
commands?
$ mysqldump -d
I have a listing of photos in a table as follows (not actual column names):
Image Name, Image Width, Image Height, Band Name, Venue, City, State, Date
I would like to have a list of the different bands with photos in the
archive. There may be 120 photos of any one band, but I would like to
-Original Message-
From: Rami Krayem [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 11:49 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Newbie - MySQL Question - Finding Unique Names in Column
I have a listing of photos in a table as follows (not actual
column names
To: [EMAIL PROTECTED]
Sent: Tuesday, March 27, 2001 11:49 AM
Subject: [PHP] Newbie - MySQL Question - Finding Unique Names in Column
I have a listing of photos in a table as follows (not actual column
names):
Image Name, Image Width, Image Height, Band Name, Venue, City, State, Date
I would like to h
]]
Sent: Saturday, March 10, 2001 6:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP/MySQL Question
Having some problems with syntax.
If I wanted to SELECT only 5 instances of something from a database and
order it by datetime, how would I do that?
- Kath
--
PHP General Mailing List (http
Is it possible to move through an array that is returned as a recordset
and then move back to the beginning of the array.
Julia
--
[ Julia Anne Case ] [Ships are safe inside the harbor, ]
[Programmer at large] [ but is that what ships are really for.]
[ Admining
reset($array), if this is what you need.
this resets (who would have thought it?) the internal pointer back to the
first
position.
""Julia A . Case"" [EMAIL PROTECTED] schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Is it possible to move through an array that is returned
usion, PHP, and mySQL
http://www.wizaerd.com
=
-Original Message-
From: Julia A . Case [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 4:15 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP/MySQL question
Is it possible to move throug
Joseph,
here it is:
Number of manpages in db:
?php $sql = "SELECT count(*) FROM manpagetool.manpages";
$result= mysql_query($sql);
$number = mysql_fetch_array($result);
echo $number["count(*)"];
?
hope that's
Hello everyone--
I've got a easy question that I can't seem to answer for myself. I'm
running a query in MySQL and want to know how many entries are in a table
and then echo that out onto a page. I thought this would be easy but I
don't know why it's not working. Anyway, here's what I am
101 - 119 of 119 matches
Mail list logo