Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: [PHP][MySQL] błąd przy importowaniu CSV przez LOAD DATA
Forum PHP.pl > Forum > Przedszkole
neurogen
mam b.duży plik csv zawierający 200.000 wierszy. przykładowy wers z nagłówkami i 1 przykładowy:

ID@post_author@post_date@post_date_gmt@post_content@post_title@post_excerpt@post
_status@comment_status@ping_status@post_password@post_name@to_ping@pinged@post_mo
dified@post_modified_gmt@post_content_filtered@post_parent@guid@menu_order@post_t
ype@post_mime_type@comment_count

1@1@2018-06-04@2018-06-04 12:00:00@<div style='text-align:justify;'><strong>Purpose:</strong> In endodontics, despite careful instrumentation and antimicrobial irrigation, root canals still harbor cultivable microorganisms. Such cases require intra canal medicament that eliminates the microbial inhabitants from the canals. Recent trend advocates the use of herbal extracts due to easy availability, cost-effectiveness, low toxicity, and lack of microbial resistance. Hence, in the present study, , , and extracts were used as intracanal medicaments.<br/><strong>Methods:</strong> This study aimed to evaluate and compare the antibacterial efficacy of , , extracts, and chlorhexidine against , when used as intracanal medicaments.<br/><strong>Results:</strong> One hundred and twenty-five extracted human teeth, inoculated with , were divided into four experimental groups and a control group ( = 25 in each group). The experimental groups were treated with chlorhexidine, , , and extracts and their antibacterial property was evaluated by estimating microbial counting (CFU/ml).<br/><strong>Conclusions:</strong> The reduction in bacterial count for chlorhexidine, , , and groups was 60.76%, 51.98%, 37.73%, and 34.93%, respectively. Statistically significant difference in reduction of bacterial count was observed in all the groups, when compared with the control group.<br/><br/>Ayu - Bhardwaj Ashutosh, Srivastava Nikhil, Rana Vivek, Adlakha Vivek Kumar, Asthana Ashish Kumar, - 04/06/2018 - <a href='https://www.ncbi.nlm.nih.gov/pubmed/29861597' target='_blank'>29861597</a></div>@How efficacious are , , Guduchi extracts and chlorhexidine as intracanal disinfectants? A comparative study.@In endodontics, despite careful instrumentation and antimicrobial irrigation, root canals still harbor cultivable microorganisms. Such cases require intra canal medicament that eliminates the microbial inhabitants from the canals. Recent trend advocates the use of herbal extracts due to easy availability, cost-effectiveness, low toxicity, and lack of microbial resistance. Hence, in the present study, , , and extracts were used as intracanal medicaments.@publish@open@open@@how-efficacious-are-guduchi-extracts-and-chlorhexidine-as-intracanal-disinfectants-a-comparative-study@@@2018-06-04@2018-06-04 12:00:00@@0@http://localhost/ebd/?p=1@0@post@@0

aby zaimportować plik wybieram w phpmyadmin import, format: CSV USING LOAD DATA, kolumny dzielone @,

wyskakuje mi błąd:
LOAD DATA INFILE '/tmp/phpsifeG3' REPLACE INTO TABLE `ebd_posts` FIELDS TERMINATED BY '@' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'

gdzie mam błąd, czy jest jakiś lepszy sposób żeby to zaimportować.
Pyton_000
No a gdzie ten błąd? Bo pokazałeś wygenerowane zapytanie które się odpala a błędu nie.
neurogen
wyskakuje mi błąd:
LOAD DATA INFILE '/tmp/phpsifeG3' REPLACE INTO TABLE `ebd_posts` FIELDS TERMINATED BY '@' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'
Pyton_000
No mówię Ci że to nie jest błąd tylko zapytanie ktore powinno się wykonać.
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.