MySQL - ¿Script de conexión a BBDD?

mysql -u usuario -p

mysql -h host -u usuario -p

mysql -h host -u usuario -pContraseña

mysql -h localhost -u root -p password

select m1.id from tabla1 m1 join tabla2 m2 on m1.id=m2.user$

create temporary table foo (id int);

insert into foo select m1.id from tabla1 m1 join tabla2 m2 $

update tabla1 m inner join foo on m.id = foo.id set m.deleted=1;

drop table foo;

<?

# Data config for connect to database server

$server           = 'localhost';         # Server (default:localhost)

$user_prefix      = '';              # User of hosting (default:test)

$username_mysql   = $user_prefix.'root';  # Mysql database user

$password_mysql   = 'password';         # Mysql database password

$database_mysql   = $user_prefix.'moodle';  # Mysql database

?>

<?

require_once('config.php');

#  Check database to host connection 

if(!function_exists('mysql_connect'))

{

    echo 'PHP cannot find the mysql extension. MySQL is required for run. Aborting.';

    exit();

}

$dbh = @mysql_connect($server, $username_mysql, $password_mysql)

or die('Error: Database to host connection: '.mysql_error());

mysql_select_db($database_mysql, $dbh)

or die('Error: Select database: '.mysql_error());

?>

<?

require_once('inc/connection.php');

#Execute a MySQL query

$result = mysql_query("SELECT name FROM users", $dbh);

while($row = mysql_fetch_array($result))

{

    echo 'User: '.$row['name'].'<br>';

}

?>

mysql -h localhost -u root -ppassword