To start the mysqld server, you should start an msdos window and type: C:/MySQL/bin/mysqld
This will start mysqld in a blank background. In this way, you can kill the MySQL server and execute: C:/MySQL/bin/mysqladmin-u root Shutdown Open command line
C:/MySQL/bin/MySQL Attached basic commands: Show all databases
Show databases; Open Database
Use test View All Tables
Show tables; View table structure
Describe PET; Create a table
Create temporary table TMP (
Article int (4) unsigned zerofill default '100' not null,
Price double (16,2) default '0. 00' not null ); Lock
Lock tables article read; Add
Insert into TMP select article, max (price) from shop group by article; Delete
Delete * from TMP where id = '1 '; Change
Update TMP set price = '000000' where id = '1 '; Query
Select article, dealer, price from shop, TMP
Where shop. Article = TMP. Articel and shop. Price = TMP. price; Unlock
Unlock tables; Delete table
Drop table TMP; |
