[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.



Jesper Lund wrote:

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 ?


Nej det er der ikke.

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;





Ok.

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 ("




Det er noget af et arbejde, for så skla der skrives drop rigtig mange steder, for efter jeg skrev sidst opdagede jeg, at det ikke blot var
en table, der var tle om, men rigtig mange.


-- 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.



Ja netop

Mvh. Jesper

sslug-novice: Listen for begynder-relaterede spørgsmål





Erik



 
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] *