how to change / fix the root password in MySQL
If you have root authority on your server, login as root (su -) in a terminal session and at a command prompt, stop mysql and then restart it in a controlled mode:
/etc/init.d/mysql stop
or service mysql stop
then /usr/sbin/mysqld...
Read more »
MySQL
change root password in MySQL
SQL: some basic JOIN syntax
INNER JOIN and , (comma) are equivalent in the absence of a join condition
and "JOIN" is defined to be equivalent to an "INNER JOIN"
Examples:
SELECT * FROM customer AS c,
orders AS o
...
Read more »
SQL: date – time displays, conversions
UNIX TIME
example: start = (1196440219) 2007-11-30 10:30:19
FROM_UNIXTIME(start)
UNIX_TIMESTAMP() = NOW
ex:
SET start = UNIX_TIMESTAMP()
mysql ...
Read more »
Increasing phpMyAdmin’s export limits
phpMyAdmin is one of the MySQL tools no one lives without.
For non-programmers, it is great for looking at the contents of your database. For programmers, it is also indispensable for making changes, quick fixes.
However, the 2 meg limit for uploading (importing) files can feel like a severe limit. It is set...
Read more »
NorthWind db in MySQL
Microsoft's SQL Server 2000 comes with 2 sample databases, one of which is NORTHWIND a sample accounting database
Below are the table definitions needed to export NorthWind from MS SQL Server 2000 and import NorthWind into MySQL
I have exported out the main table definitions and their data and put them...
Read more »
A few NorthWind MySQL PHP scripts
Note that the dates on the NorthWind data range only across 1 full year, 1997: from July 1996 to May 1998.
Each line of data below comes from 3 files (tables): the orders file, the order-details file, and the customer file. There are also files of employees, products, suppliers,...
Read more »
