[MySQL]o co chodzi temu durnemu mysql? exportował po swojemu a teraz nie chce importować. Opcje

[szczrzcz]

wykonanie eksportowanego zapytania daje błąd o treści :

Ending quote ' was expected. (near "" at position 2210)

rozumiem, że chodzi o fragmenty jak poniższy:

Scott Fitzgerald\'s extraordinary fantasy

Na co mam to zamienić?


(fragment)

[SQL] pobierz, plaintext 
INSERT INTO `book` (`isbn`, `idcategory`, `title`, `author`,`description`, `price`, `picture`, `print`, `publishYear`, `created`, `updated`,  `quantity`) VALUES
('978-0010465284', 8, 'Accountant', 'Jorge Luis Borges', 'Scott Fitzgerald\'s extraordinary fantasy was written in the winter of 1921-1922  John T  Unger  a middle class American boy from a small town on the Mississippi River goes  for his summer holiday  to stay for the first time with an enigmatic school friend  Percy Washington  On the journey out Percy confides with an abrupt remark: My father is by far the richest man in the world  The Schnlitzer Murphys had diamonds as big as walnuts -  That\'s nothing  Percy had leaned forward and dropped his voice to a low whisper  That\'s nothing at all  My father has a diamond bigger than the Ritz-Carlton Hotel', '98.79', 'book_nr_100.jpg', 'Chocolate', 2005, '1901-01-01 00:00:00', '2017-01-08 16:57:15', 21),
('978-0012158981', 25, 'Actuary', 'Pearl Buck', 'Ruth Rendell\'s mysteries have become famous throughout the world  In Thornapple James Fyfield  a young boy with an enquiring  scientific mind  takes up a very unusual hobby - making deadly poisons in his mother\'s kitchen when she is out  Soon he has a large collection of jars tucked away on a the top shelf in his bedroom - hemlock  henblane and deadly nightshade  But the one of which he is proudest by far is a murky brown concoction  painstakingly prepared from the spiky fruit of the thornapple', '39.00', 'book_nr_101.jpg', 'Brown', 1984, '1901-01-01 00:00:00', '2017-01-08 15:32:55', 20);
[SQL] pobierz, plaintext 

Muszę trzysta zapytań wykonywać w grupkach po kilka bo jak wszystko naraz to wywala błąd.


Ten post edytował szczrzcz 31.05.2017, 18:24:38

[nospor]

A czym ty to importujesz?

[szczrzcz]

phpmyadmin. eksportowałem do .sql a potem nie chciał tego pliku importować. Tylko w kawałkach.

Już się naklikałem w godzinę. Chcę o tym zapomnieć (IMG:style_emoticons/default/mad.gif)

[nospor]

A jak pociales to na kawalki?

[szczrzcz]

o tak:

jeden kawałek:

[SQL] pobierz, plaintext 
INSERT INTO `book` (`isbn`, `idcategory`, `title`, `author`,`description`, `price`, `picture`, `print`, `publishYear`, `created`, `updated`,  `quantity`) VALUES
('978-0010465284', 8, 'Accountant', 'Jorge Luis Borges', 'Scott Fitzgerald\'s extraordinary fantasy was written in the winter of 1921-1922  John T  Unger  a middle class American boy from a small town on the Mississippi River goes  for his summer holiday  to stay for the first time with an enigmatic school friend  Percy Washington  On the journey out Percy confides with an abrupt remark: My father is by far the richest man in the world  The Schnlitzer Murphys had diamonds as big as walnuts -  That\'s nothing  Percy had leaned forward and dropped his voice to a low whisper  That\'s nothing at all  My father has a diamond bigger than the Ritz-Carlton Hotel', '98.79', 'book_nr_100.jpg', 'Chocolate', 2005, '1901-01-01 00:00:00', '2017-01-08 16:57:15', 21);
[SQL] pobierz, plaintext 

drugi kawałek:

[SQL] pobierz, plaintext 
INSERT INTO `book` (`isbn`, `idcategory`, `title`, `author`,`description`, `price`, `picture`, `print`, `publishYear`, `created`, `updated`,  `quantity`) VALUES
('978-0012158981', 25, 'Actuary', 'Pearl Buck', 'Ruth Rendell\'s mysteries have become famous throughout the world  In Thornapple James Fyfield  a young boy with an enquiring  scientific mind  takes up a very unusual hobby - making deadly poisons in his mother\'s kitchen when she is out  Soon he has a large collection of jars tucked away on a the top shelf in his bedroom - hemlock  henblane and deadly nightshade  But the one of which he is proudest by far is a murky brown concoction  painstakingly prepared from the spiky fruit of the thornapple', '39.00', 'book_nr_101.jpg', 'Brown', 1984, '1901-01-01 00:00:00', '2017-01-08 15:32:55', 20);
[SQL] pobierz, plaintext 

podczas gdy oba razem:

[SQL] pobierz, plaintext 
INSERT INTO `book` (`isbn`, `idcategory`, `title`, `author`,`description`, `price`, `picture`, `print`, `publishYear`, `created`, `updated`,  `quantity`) VALUES
('978-0010465284', 8, 'Accountant', 'Jorge Luis Borges', 'Scott Fitzgerald\'s extraordinary fantasy was written in the winter of 1921-1922  John T  Unger  a middle class American boy from a small town on the Mississippi River goes  for his summer holiday  to stay for the first time with an enigmatic school friend  Percy Washington  On the journey out Percy confides with an abrupt remark: My father is by far the richest man in the world  The Schnlitzer Murphys had diamonds as big as walnuts -  That\'s nothing  Percy had leaned forward and dropped his voice to a low whisper  That\'s nothing at all  My father has a diamond bigger than the Ritz-Carlton Hotel', '98.79', 'book_nr_100.jpg', 'Chocolate', 2005, '1901-01-01 00:00:00', '2017-01-08 16:57:15', 21),
('978-0012158981', 25, 'Actuary', 'Pearl Buck', 'Ruth Rendell\'s mysteries have become famous throughout the world  In Thornapple James Fyfield  a young boy with an enquiring  scientific mind  takes up a very unusual hobby - making deadly poisons in his mother\'s kitchen when she is out  Soon he has a large collection of jars tucked away on a the top shelf in his bedroom - hemlock  henblane and deadly nightshade  But the one of which he is proudest by far is a murky brown concoction  painstakingly prepared from the spiky fruit of the thornapple', '39.00', 'book_nr_101.jpg', 'Brown', 1984, '1901-01-01 00:00:00', '2017-01-08 15:32:55', 20);
[SQL] pobierz, plaintext 

razem wywalały błąd.

No cóż, jako programista może powinienem był zrobić pętlę (IMG:style_emoticons/default/wink.gif) . Ale w rzeczywistości kawałki zawierały zwykle nie jeden a kilka-kilkanaście wierszy. Dobra, nie ma o czym gadać, już po herbacie.

Ten post edytował szczrzcz 31.05.2017, 23:46:28