Can someone help me how to use join in these tables I created?
Database name in mysqladmin?
Is there anyother way?
where could i be going wrong ?
Hi again anyone know bash command on Windows?
How would you recommend me to install it?
What exactly have you tried already?
From Table1 as t1 join table2 as t2 on here join condition
Wonderful !
Go live with this fact!
Send code as text, please, if it is big , send via pasterbin.com or similar
These are most probably problems of your PHP installation, not related to MySQL, offtopic in this chat
If you don’t show your code, don’t show your errors, no one will help you
if (!isset($GLOBALS[‘dbcon’])) {
if(LOCAL_MODE) {
$GLOBALS[‘dbcon’] = mysqli_connect(‘localhost’, ‘username’, ‘password’, ‘database’);
mysqli_select_db($ARR_CFGS[“db_name”]) or die(“Could not connect to database. Please check configuration and ensure mysqli is running.”);
} else{
$GLOBALS[‘dbcon’] = mysqli_connect($ARR_CFGS[“db_host”], $ARR_CFGS[“db_user”], $ARR_CFGS[“db_pass”]);
mysqli_select_db($ARR_CFGS[“db_name”]) or die(“Internal Server Error. Please contact website adminstrator if this problem persists.”);
}
}
if (!isset($GLOBALS[‘dbcon’])) {
if(LOCAL_MODE) {
$GLOBALS[‘dbcon’] = mysqli_connect(‘localhost’, ‘username’, ‘password’, ‘database’);
mysqli_select_db($ARR_CFGS[“db_name”]) or die(“Could not connect to database. Please check configuration and ensure mysqli is running.”);
} else{
$GLOBALS[‘dbcon’] = mysqli_connect($ARR_CFGS[“db_host”], $ARR_CFGS[“db_user”], $ARR_CFGS[“db_pass”]);
mysqli_select_db($ARR_CFGS[“db_name”]) or die(“Internal Server Error. Please contact website adminstrator if this problem persists.”);
}
}
this is PHP, not related to MySQL
What are different types of ha options(innodb, ndb cluster etc..)
I am trying to create a user interactive script in bash to be able to create and drop databases in mysql. Now my question is how can I pass the user input i.e. Database name in mysqladmin?
Below is a snippet
read -p ” enter database name : ” > db
enter database name : test
mysqladmin –login-path=/path create $db
Obviously this $db variable is not being accepted
Is there anyother way??
I am trying to create a user interactive script in bash to be able to create and drop databases in mysql. Now my question is how can I pass the user input i.e. Database name in mysqladmin?
Below is a snippet
read -p ” enter database name : ” > db
enter database name : test
mysqladmin –login-path=/path create $db
Obviously this $db variable is not being accepted
Is there anyother way??
Read the bash scripting manual. It’s not related to mysql
Am trying to load a .Jpg image into my db.. where could i be going wrong ?
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_load-file
LOAD_FILE(file_name)
Reads the file and returns the file contents as a string. To use this function, the file must be located on the server host, you must specify the full path name to the file, and you must have the FILE privilege. The file must be readable by the server and its size less than max_allowed_packet bytes. If the secure_file_priv system variable is set to a nonempty directory name, the file to be loaded must be located in that directory. (Prior to MySQL 8.0.17, the file must be readable by all, not just readable by the server.)
What are different types of ha options(innodb, ndb cluster etc..)
Bash will not help you in this task, is is not related to the task and not needed
true
What exactly have you tried already?
To install what?
You don’t need bash for loading anything into a MySQL db,
Bash is not needed for this and doesn’t change loading speed
I’m trying to import with cmd, but it’s too slow. I uploaded with the bash command, the values did not come. For example, the IDs came, but no counter values came
Show what are you doing
Bash command file this