Web and Database Port Listing
PMA00:37
Categories: MySQL, Web Hosting
Related Posts:
Linking Affects the Speed of MySQL
Most of the following tests are done on Linux with the MySQL benchmarks, but they should
give some indication for other operating systems and workloads.
You get the fastest executable when you link with -static.
On Linux, yo… Read More
Advanced SQL
Many of the features shown in this chapter are specific to MySQL's version of SQL. For example, MySQL's functions are useful tools for working with strings, dates and times, and math. Also, we'll show some w… Read More
mysql_query-executes query
mysql_query function executes query on the default database, set using
mysql_select_db() or by a previous query using
mysql_db_query(), on the MySQL server connection referenced by connection . If no connection … Read More- LOAD DATA INFILE statement MySQL
LOAD DATA INFILE provides an alternative to INSERT for adding new records to a table. With INSERT, you specify data values directly in the INSERT statement. LOAD DATA INFILE reads the values from a separate datafile.The… Read More
- Query Strings
Query string data is very easy for the user to alter, because it ’ s visible and editable within the browser ’ s
address bar. Therefore, query strings should be used only in situations where sending incorrect data
won ’ t co… Read More
PHP-Database-Basics-DB-Arrays
Adding MySQL to PHP and combining the applications for your dynamic web site is a great start. But, it helps tremendously to structure your database right. We'll give you a solid understanding of both database de… Read More- Running MySQL on Windows
MySQL supports TCP/IP on all Windows platforms and named pipes on NT. The defaultis to use named pipes for local connections on NT and TCP/IP for all other cases if theclient has TCP/IP installed. The host name speci es whic… Read More
- Maximum Performance from MySQL
Optimization is a complicated task because it ultimately requires understanding of the whole
system. While it may be possible to do some local optimizations with small knowledge of
your system/application, the more optimal y… Read More
Database Backups using mysqldump
The MySQL server, and mysql, the MySQL client, a MySQL installation comes
with many useful utility programs. We have seen mysqladmin, which is
responsible for the control and retrieval of information about an operati… Read More- Web-Based MySQL Administration
Web-Based MySQL Administration
At http://phpwizard.net/phpMyAdmin you will find a PHP Web
application that can help you manage MySQL. It enables you to manage
a MySQL database using a browser and makes administrative work… Read More
- Table Types-MySQL
MyISAM is the default table type in MySQL Version 3.23. It's based on the ISAM code andhas a lot of useful extensions.
The index is stored in a le with the .MYI (MYIndex) extension, and the data is storedin a le with the .… Read More
- Conditional Functions mysql
The IF()
Function
The IF() function provides a way to return a value
based on a condition within a query.
The first argument is a condition that is evaluated for each
row of the query. The value in the second is return… Read More
- Why NoSQL?
Application requirements have fundamentally changed, and traditional
RDBMS technology has failed to keep pace. As a result, the use of NoSQL
technology is rising rapidly. Massive change is underway, disrupting the
databas… Read More
- MySQL Server Performance
To make things easier for administrators.
Minimal memory, relatively infrequent MySQL usage:
my-small.cnf
Minimal memory combined with reliance on MySQL, or larger
memory for a multipurpose system: my-medium.… Read More
- SQL inherently
SQL, or Structured Query Language, is not really a language. It does not follow all the rules of the typical computer programming language. There are no constructs in SQL to allow decision branches. You can't go to a sp… Read More