The first is the most concise, I would go with that. The first two are the same, but the first is just that little bit shorter, so you’ll save on bytes. The third is plain wrong, because that condition will always evaluate true because the object will never be null or falsy for that matter.
What I’m trying to do is INSERT subscribers in my database, but IF EXISTS it should UPDATE the row, ELSE INSERT INTO a new row. Ofcourse I connect to the database first and GET the $name, $email and $birthday from the url string. This works, but just adds the new row; Here’s what I tried; … Read more
Your status-codes are also a collection, so use Contains: or in query syntax:
If you just need to know if a db exists so you won’t get an error when you try to create it, simply use (From here):
You could also try EXISTS: and per the documentation, you can SELECT anything. Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with SELECT 5 or SELECT column1 or anything at all. MySQL ignores the SELECT list in such a subquery, so it makes no difference.
Just in case anyone still cares: I had the same issue after copying a database directory directly using command If you do this with a database that uses InnoDB tables, you will get this crazy ‘table does not exist’ error mentioned above. The issue is that you need the ib* files in the root of the MySQL datadir (e.g. ibdata1, ib_logfile0 and ib_logfile1). … Read more
It seems some people are landing here, and simply want to know if an element exists (a little bit different to the original question). That’s as simple as using any of the browser’s selecting method, and checking it for a truthy value (generally). For example, if my element had an id of “find-me”, I could … Read more