|
Jan 29
2012
|
Update Passwords Wth MYSQLPosted by bohemia in Untagged |
Update MYSQL Passwords
UPDATE PASSWORDS WITH MYSQL
Using mysql password function
update tablename set password=password('mypass') where id=9;
Update MD5 Passwords
Using mysql password function
update tablename set password=password('mypass') where id=9;
Update MD5 Passwords
|
Jan 29
2012
|
How To Install Bohemian CMSPosted by bohemia in Untagged |
Installing Bohemian CMS
To load Bohemian CMS into a subfolder on a website,
1)Upload folder to the desired location (i.e. example.com/test)
2) create database
3)
1)Upload folder to the desired location (i.e. example.com/test)
2) create database
3)
|
Jan 28
2012
|
Using Distinct in MYSQL Query For OutputPosted by bohemia in Untagged |
Using Distinct For Output
Using distince in a query will output distince values for a chosen query.
For example, look at the following query:
"SELECT DISTINCT name from
For example, look at the following query:
"SELECT DISTINCT name from
|
Jan 28
2012
|
Replace String in PHPPosted by bohemia in Untagged |
Replace String in PHP With str_replace Function
Replacing Parts of String With str_replace Function
$string = "I like to eat.";
echo $string; //
Output is:
I like to
$string = "I like to eat.";
echo $string; //
Output is:
I like to
|
Jan 28
2012
|
Delete Rows From MYSQL TablePosted by bohemia in Untagged |
Delete Rows From MYSQL Table
Using PHPMYADMIN
1) Select desired database.
2) Open SQL Tab in PHPMYADMIN
Using MYSQL Console
1) Open MYSQL Console (mysql>)
2) Type
1) Select desired database.
2) Open SQL Tab in PHPMYADMIN
Using MYSQL Console
1) Open MYSQL Console (mysql>)
2) Type
|
Jan 28
2012
|
Count MYSQL ColumnsPosted by bohemia in Untagged |
MYSQL Count Columns
To count all columns of a mysql database table,
1) Open PHPMYADMIN
2) Select 'SQL' tab.
3) Type Command:
SELECT count(*) FROM
1) Open PHPMYADMIN
2) Select 'SQL' tab.
3) Type Command:
SELECT count(*) FROM
|
Jan 28
2012
|
MYSQL Count EntriesPosted by bohemia in Untagged |
MYSQL Count Entries
To count all rows of a mysql database table,
1) Open PHPMYADMIN
2) Select 'SQL' tab.
3) Type Command:
SELECT COUNT(*) FROM
1) Open PHPMYADMIN
2) Select 'SQL' tab.
3) Type Command:
SELECT COUNT(*) FROM
|
Jan 28
2012
|
PHPMYADMIN Excel Spreadsheet to DatabasePosted by bohemia in Untagged |
Excel Spreadsheet To MYSQL Database
Here is the basics you need to know about Excel spreadsheets in order to make, edit or move the data into a mysql database.EXCEL
|
Jan 28
2012
|
Copy MYSQL Rows QuicklyPosted by bohemia in Untagged |
Populate MYSQL Database
Intention: To populate a mysql database table very quickly by copying existing rows and adding them to the existing rows.To populate a table
|
Jan 25
2012
|
Show MYSQL Entries By Specific DayPosted by bohemia in Untagged |