Witaj Gościu! ( Zaloguj | Rejestruj )

Forum PHP.pl

> [MySQL]Konwersja SQL do MySQL
trifek
post
Post #1





Grupa: Zarejestrowani
Postów: 340
Pomógł: 0
Dołączył: 28.09.2015

Ostrzeżenie: (0%)
-----


Witam serdecznie,
Mam taki zrzut z bazy danych:

  1. USE [DWH_NL_REF]
  2. GO
  3. /****** Object: Table [dbo].[REF_Postcode_NL] Script Date: 03/09/2016 11:35:15 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. CREATE TABLE [dbo].[REF_Postcode_NL](
  9. [id] [float] NULL,
  10. [postcode] [nvarchar](255) NULL,
  11. [postcode_id] [float] NULL,
  12. [pnum] [float] NULL,
  13. [pchar] [nvarchar](255) NULL,
  14. [minnumber] [float] NULL,
  15. [maxnumber] [float] NULL,
  16. [numbertype] [nvarchar](255) NULL,
  17. [street] [nvarchar](255) NULL,
  18. [city] [nvarchar](255) NULL,
  19. [city_id] [float] NULL,
  20. [municipality] [nvarchar](255) NULL,
  21. [municipality_id] [float] NULL,
  22. [province] [nvarchar](255) NULL,
  23. [province_code] [nvarchar](255) NULL,
  24. [lat] [float] NULL,
  25. [lon] [float] NULL,
  26. [rd_x] [float] NULL,
  27. [rd_y] [float] NULL,
  28. [location_detail] [nvarchar](255) NULL,
  29. [changed_date] [datetime] NULL,
  30. [geographypoint] AS ([geography]::STGeomFromText(((('POINT('+CONVERT([varchar](20),[lon],(0)))+' ')+CONVERT([varchar](20),[lat],(0)))+')',(4326)))
  31. ) ON [PRIMARY]
  32. GO
  33. INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23082, N'1185XE', 11858869, 1185, N'XE', 2, 14, N'even', N'Bovenkerkerweg', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.2841851341781, 4.8429645934418, 117863.198857142, 477493.264714285, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
  34. INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23083, N'1185XJ', 11858874, 1185, N'XJ', 163, 471, N'odd', N'Wimbledonpark', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.2906822356276, 4.844411817959, 117967.36141081, 478215.397416216, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
  35. INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23084, N'1185XK', 11858875, 1185, N'XK', 9, 49, N'odd', N'Wimbledonpark', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.2884812295665, 4.843539868722, 117906.036648148, 477970.957222222, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
  36. INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23085, N'1185XL', 11858876, 1185, N'XL', 51, 99, N'odd', N'Wimbledonpark', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.288406240247, 4.8437956701478, 117923.427, 477962.483, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))





Orientujecie się może co to jest za format bazy danych? W jaki sposób można to najprościej przekonwertować i wrzucić do MySQL?
Go to the top of the page
+Quote Post

Posty w temacie


Reply to this topicStart new topic
1 Użytkowników czyta ten temat (1 Gości i 0 Anonimowych użytkowników)
0 Zarejestrowanych:

 



RSS Aktualny czas: 23.08.2025 - 11:59