I'm trying to send an email to several recipients when a new row is inserted into a table. The list of recipients varies. I would like to be able to set this list using a select statement. I also have installed Navicat which allows me to send email notifications but only to a predetermined set of people. Thanks. ...
Often when I define a View in Navicat I receive the following message: xxx does not have a primary key. Updates to this table will be done using the following pseudo statement: UPDATE xxx SET ModifiedFieldsAndValues WHERE AllFieldsAndOldValues LIMIT 1 Obviously I only use my Views for viewing data, not updating. But this did make m...
Hello, I have a MySQL database that has several databases used by more than 1 web app. I need to now create a new Database that can only be accessed via a new user account. I've been using Navicat v5.3.3 manage users to try to set this up but it doesn't seem to work and I don't know if that's bec of MySQL or Navicat. But given that I ...
Hi there, I've 2 computers connected to Internet. Each one has Xampp installed, with a local mysql database. Is it possible to sychronize these 2 dbs ? I use Navicat. The sync works well with a local database to a server database, using tunneling. But what about the sync between 2 PCs dbs ? Thank you very much for your help, Cheer...
My firm was delivered a 20+ GB .sql file in reponse to a request for data from the gov't. I don't have many options for getting the data in a different format, so I need options for how to import it in a reasonable amount of time. I'm running it on a high end server (Win 2008 64bit, MySQL 5.1) using Navicat's batch execution tool. It's b...
I am fairly new to building sites with PHP and MySQL but am trying to achieve the following: During an online enrollment process, a promoter is able to enroll up to 20 'fighters' for medical testing services. Each fighter's information is stored in SESSION as $_SESSION['FnumAttr'] where num is the number and Attr is the attribute being ...
I have my data imported. Now I want to put syntax in view. I have 5 columns and each with a single number(0-9). I would like to seperate the number by odd and even. My case is odd = 0 and even =1 for each number. Please write step by step as possible because I want to learn it. ...
I try to use formula "IF" in view but dont know what the structure. Basically I try to divide two group of number. 0,1,2,3,4 after "IF" = 0 and 5,6,7,8,9 after "IF" = 1. Here is an example of my database: Row 1 / Column A = 8 column B = 1 column C = 2 Column D = 5 Column E = 7 Column F = 9 ...