We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Information
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
bank
b_id
b_name
b_branch
b_account
b_account_name
b_amount
b_financing_amount
create_datetime
bank_key
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Information
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
The text was updated successfully, but these errors were encountered: