Jump to content
Sign in to follow this  
GeorgyM

Помогите создать SQL запрос к БД (опции)

Recommended Posts

Всем привет, кто то сможет помочь с этим вопросом ?

Как то можно экспортировать опции через PHP MY Admin в один CSV ?

Вот эти таблицы:

option_value_description

option_value

option_description

option

А потом их вгрузить обратно в БД - через PHP MY Admin

Там два ключевых поля.

option_id

option_value_id

Share this post


Link to post
Share on other sites
SELECT ... INTO
SELECT *
INTO OUTFILE '/path/to/option_description.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM option_description
LOAD DATA INFILE
LOAD DATA 
INFILE 'path/to/option_description.csv' 
INTO TABLE option_description FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'

вопрос какие цели вы преследуете

Share this post


Link to post
Share on other sites

вопрос какие цели вы преследуете

Спасибо - буду пробовать.

Цель к существующим опциям подгрузить картинки через CSV

Не могу найти модуль который это умеет делать.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.