Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to select table indexes? #1026

Open
kelly806 opened this issue Nov 25, 2021 · 0 comments
Open

How to select table indexes? #1026

kelly806 opened this issue Nov 25, 2021 · 0 comments

Comments

@kelly806
Copy link

Information

  • Version of Medoo: 1.7
  • Type of Database (MySQL, MSSQL, SQLite...): MySQL
  • System (Liunx\Windows\Mac): Linux

Describe the Problem
How to use select function to select bank table indexes?

Detail Code
$db->select("bank", ["b_id", "b_name"], ["ORDER" => ["b_name" => "ASC"]]);
CREATE TABLE bank (
b_id int(8) NOT NULL AUTO_INCREMENT,
b_name varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
b_branch varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
b_account varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
b_account_name varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
b_amount int(11) NULL DEFAULT NULL,
b_financing_amount int(11) NULL DEFAULT NULL,
create_datetime int(11) NULL DEFAULT NULL,
PRIMARY KEY (b_id) USING BTREE,
INDEX bank_key(b_id) USING BTREE
)
Expected output

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant