Ask a Question related to ASP Database, Design and Development.
-
Laphan #1
IF EXISTS command in Access and MySQL
Is it possible to do a sort of IF EXISTS sql statement in Access and/or
MySQL?
The reason is that at present, I'm having to query the DB to see if the row
exists and then either do an update or an insert depending on the result.
If I could do an exist check in the same query, I think you can do this in
SQL Server then it must provide better performance - right?
Rgds
Laphan
Laphan Guest
-
Dislay mySql version from a SELECT command?
Is there a way to display the mySql version number from a SELECT command? I need to check on a server where I have limited access. Thanks -
Starting MySQL from the Windows Command Line
Hello, Mysql is running on Windows. With previous versions of mysql I can start mysql from the command line with: C:\> C:Mysql\bin\mysqld ... -
Does MS Access have a Show Columns SQL command
I have recently discovered how to Alter Add and Drop columns from MS Access. This is going to help me a lot with updating multiple databases when I... -
method name exists, property value exists, calling method fails
I have a class object I am calling in another class: class Stuff { var $myObj; function Stuff($myObj) { $this->myObj = $myObj; } -
Testing if a mysql table exists
Is there a simple way to test if a mysql table exists? JUST One line !
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
