[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [NOVICE] mysqldatabase.



On Wed, 16 Feb 2005 07:54:29 +0100
Erik Jakobsen <sslug@sslug> wrote:

> Jesper Lund wrote:
> 
> >Det samme er jo gældende hvis der er andre tabeller den er gsl med.
> 
> Hvad skal slettes her ?

Det kommer an på hvad du vil. Der kan jo godt være data i den nye
tabel du ikke vil af med. Er der det ? 

Hvis du bare vil lægge de data der er her, ind i den allerede
eksisterende tabel, skal du slette det her:

> CREATE TABLE calendarcat (
>   CALENDAR text,
>   RNAME text,
>   RARR text,
>   RPHONE text,
>   REMAIL text,
>   RWEB text,
>   PNAME text,
>   PADRESSE text,
>   PPOSTNUMMER text,
>   PBY text
> ) TYPE=MyISAM;

Og lade det her stå.

> INSERT INTO calendarcat VALUES 
> ('Kalender',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);


Hvis du vil tømme tabellen, men istedet oprette den forfra med de
data fra din gamle server, skal du ikke slette noget, men skrive:

drop table calendercat;

ind lige over "CREATE TABLE calendercat ("


> -- Table structure for table `calendarcon`

Det kunne godt se ud som om du vil løbe ind i det samme problemer med
denne tabel også. Men så er det stadig de samme betragtninger der gør
sig gældende.

Mvh. Jesper


 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2005-08-10, 21:20 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *