Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

MySQL

1-20 of 21     Previous     Next
Finding the Difference Between 2 Dates in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See which MySQL function computes the difference between two dates and returns a positive result if the first date is greater than the second date.
Quickly Get a List of Database Tables in MySQL
by Srinath M S
Language: SQL, Expertise: Beginner - Execute this command in MySQL to get a list of all tables in the database.
Connecting to a MySQL Database from the Command Prompt
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn an easy way to connect to a MySQL database from the command prompt.
Create a Table from an Existing Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to easily create a new table that includes the indexes of the source table.
Understanding UNION in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to identify unique records in MySQL.
Suppress Errors When Duplicate Data Is Inserted in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to use INSERT IGNORE in MySQL for cases in which ignoring duplicates might be useful.
Using IFNULL in MySQL
by M S Sridhar
Language: Java, Level: Intermediate: - Check out this MySQL command to handle null effectively in your code.
Identifying all the Index(s) Available on a Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn a way to increase performance in MySQL.
Knowing the Version and Supported Engines in MySQL
by M S Sridhar
Language: SQL, Level: Intermediate: - These commands are handy to find out the current version and supported engines in the MySQL.
Purging Binary Logs in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Stay out of trouble regarding reaching maximum disk space by purging old logs in MySQL when they are no longer needed.
Understanding Null Values Returned in MySQL
by M S Sridhar
Language: MySQL, Beginner: Intermediate - Learn why the null value often needs special attention in your code to work effectively.
Limiting the Rows Returned in MySQL
by Sridhar M S
Language: SQL, Expertise: Intermediate - In MySQL, LIMIT is a feature that helps fetch a certain number of records matching the criteria provided.
Using BETWEEN in MySQL Queries
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to filter a column based on dates and time using BETWEEN.
Making a Column Autoincrement the Value Itself in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to make a column auto-increment the value every time a record is inserted in that table.
Updating a Column with the Current Time Stamp in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate Learn how to add the current time from the database when updating a column.
Using the Replace Command in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - The REPLACE command behaves as INSERT when there is no record matching the constraints.
Import Large SQL Files into MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Follow these steps to import large SQL files into MySQL.
Understanding OFFSET in MySQL
by M S Sridhar
Language: SQL, Level: Intermediate: - Learn an easy way to fetch the next 10 records from a given point.
Using the GRANT Command
by Alexander Ocher
The SQL GRANT command is used to grant access privileges to database objects and role authorizations.
Using MySQL's LIMIT Command to Control Returned Rows
by Srinath MS
Use the script shown in this tip to select a particular number of rows after a certain row in MySQL.
1-20 of 21     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date