[PHP][MySQL] błąd przy importowaniu CSV przez LOAD DATA |
[PHP][MySQL] błąd przy importowaniu CSV przez LOAD DATA |
19.09.2018, 17:39:13
Post
#1
|
|
Grupa: Zarejestrowani Postów: 58 Pomógł: 0 Dołączył: 25.03.2018 Ostrzeżenie: (0%) |
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ć. |
|
|
19.09.2018, 18:43:34
Post
#2
|
|
Grupa: Zarejestrowani Postów: 8 068 Pomógł: 1414 Dołączył: 26.10.2005 Ostrzeżenie: (0%) |
No a gdzie ten błąd? Bo pokazałeś wygenerowane zapytanie które się odpala a błędu nie.
|
|
|
19.09.2018, 18:55:00
Post
#3
|
|
Grupa: Zarejestrowani Postów: 58 Pomógł: 0 Dołączył: 25.03.2018 Ostrzeżenie: (0%) |
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' |
|
|
19.09.2018, 18:58:44
Post
#4
|
|
Grupa: Zarejestrowani Postów: 8 068 Pomógł: 1414 Dołączył: 26.10.2005 Ostrzeżenie: (0%) |
No mówię Ci że to nie jest błąd tylko zapytanie ktore powinno się wykonać.
|
|
|
Wersja Lo-Fi | Aktualny czas: 24.04.2024 - 05:32 |