dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Database Development

Database Development

Active Server Pages
Data Access
Database Administration
Database Apis
  ADO   ADOX   JDBC   ODBC   OLE DB   SQL-DMO
Database Tuning
DB2
Informix
MySQL
Oracle
Relational Databases
SQL
  PL/SQL   Transact-sql
Sql Server
Visual Foxpro
1-20 of 367     Previous     Next
Converting TIME to SECONDS in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: MySQL provides an inbuilt function named TIME_TO_SEC, that accepts time as a parameter. See an example of how to use it.
Understanding the SPACE Function in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: While the data is being fetched from the database, you may need to append space in some cases. MySQL provides the SPACE function that can help achieve this.
What Is Data Integrity?
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Explore what the term data integrity really means.
Understanding INSERT in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: Learn how to use the override insert function in MySQL.
Finding Object Dependencies in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Choose one of these three SQL queries that will return all the database objects that depend on it.
Understanding the TRIM Function in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: In MySQL, the TRIM function has additional implementations other than just trimming spaces. See what else you can do.
T-SQL Performance Tip: Stored Procedure Names
by Hannes du Preez
Language: SQL, Expertise: Beginner - See why you should avoid prefixing your Stored Procedure names with sp_.
Understanding Least and Greatest in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: Explore the least and greatest functions in MySQL.
Recompile a Stored Procedure
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to recompile certain stored procedures.
Quickly Monitor Log Space in SQL Server
by Hannes du Preez
Language: Java, Expertise: Beginner: Learn how to easily monitor free space in your database log files.
Using DBCC SHRINKDATABASE
by Hannes du Preez
Language: SQL, Expertise: Intermediate: See how to easily shrink the size of the data and log files in a database.
Find Error Log Location
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Learn an easy way to find where your error logs are being stored.
SQL Injection Tips, Part 3
by Hannes du Preez
Language: SQL, Expertise: Intermediate: SQL injection is probably the most common hacking technique out there. Learn more about hacking techniques to keep your data secure.
Understanding What Grants a User Has in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to view what permissions a given user has been granted.
Get the First Day of the Current Month
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to find the first date of the current month.
Adjusting Views to Reduce Visibility of Data in MySQL
by Sridhar M S
Language: MySQL, Expertise: Intermediate - See how to make it so that tables with sensitive information are not viewable by all.
Using Find_in_Set in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to search for, or look up, a given string.
Get All the Tables with a Count of Their Records
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this query to get all the tables with a count of their records.
Using AUTO_INCREMENT in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to set AUTO_INCREMENT values when they need to start from a number of your choice or as per some other criteria.
SQL Injection Tips, Part 2
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Learn more about how to avoid issues with SQL injection.
1-20 of 367     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date