EC-CUBE_ec-cube.sql

SELECT p FROM Product p ORDER BY productId asc', $builder->getDQL());
select create_date from dtb_product where id = 999';
SELECT p FROM Product p ORDER BY productId asc, name desc', $builder->getDQL());
SELECT p FROM Product p WHERE name = :Name', $builder->getDQL());
select * from dtb_plugin');
SELECT shop_name, email01 FROM dtb_base_info WHERE id = 1;');
CREATE TABLE test_entity(id INT, col INT, PRIMARY KEY(id))
SELECT p FROM Product p WHERE name = :Name AND delFlg = :DelFlg', $builder->getDQL());
SELECT p FROM Product p INNER JOIN p.ProductCategories pct INNER JOIN pct.Category c');
SELECT COUNT(*) FROM information_schema.sequences WHERE sequence_name = ?';
UPDATE dtb_base_info set shop_name = :shop_name, email01 = :admin_mail, email02 = :admin_mail, email03 = :admin_mail, email04 = :admin_mail, update_date = current_timestamp  WHERE id = 1
SELECT * FROM dtb_product_class WHERE product_code = 'class1-only' ORDER BY visible ASC
SELECT p FROM Product p ORDER BY name desc', $builder->getDQL());
select id, create_date from dtb_product where id = 9999';
UPDATE dtb_base_info SET migration_sample = ?  WHERE id = 1
SELECT p FROM Product p INNER JOIN p.ProductCategories pct');
select id, create_date from dtb_product where id = ?';
SELECT * FROM dtb_product_class WHERE product_id = 2 ORDER BY visible ASC';
SELECT p FROM Eccube\Entity\Payment p INDEX BY p.id');
SELECT id FROM dtb_member WHERE login_id = :login_id;');
UPDATE dtb_member set password = :password, salt = :salt, update_date = current_timestamp  WHERE login_id = :login_id
SELECT p FROM Product p', $builder->getDQL());
SELECT p FROM Product p');
SELECT p FROM Product p /', '', $builder->getDQL());
UPDATE dtb_base_info SET migration_sample = ?  WHERE id = 1