MySQL Database Forum

I am building a query that gives the following information Total Claims, Total Charges, Total Payment, Denial Count, % of Billed Charges and % of Claims Denied This is all grouped by provider id, provider name and denied count then ordered by Total Claims. I have been successful with my query until it comes to getting the % of Billed...

I wanted to use MySQL for storage of login information. Then I will have multiple services (RADIUS, Proxy, etc) checking against the information. Is there a way to make a master table that will have all the information that is needed, then have a bunch of child tables that have the redundant information from the master table, however, only...

I need some help writing a sql query. I have below 2 queries and I want to combine them together. Now I already tried 'union' but it doesn't work. I first want to print all results of query1 than at bottom of that I want to print all results for query2. --Query#1 SELECT DISTINCT a., b.Description FROM CONTAINSTABLE(myTable, *,...

I have a long, complicated set of conditions that I would like to use in a MySQL stored procedure to either (a) update a table with the complicated set of conditions in the WHERE clause, or (b) return a single value based on the same set of complicated conditions. I know how to write a stored procedure to do one or the other, but cannot see a way...

Alo all, We are targeting specific kind of customers who use different kind of services such as fashion shops, cosmetics etc. This service providers just buy a package (domain, web site, db etc) and they are good to go. Now they customers are repeated time and again and so a single customer is registered 5-6 times in a single computer running...

I am working on a project similar to Cleverbot (a chatbot). It will store user input and quickly match it with a response that another user already gave for that input. What would be the proper way to store the conversation in a database? Just as a table with a bunch of individual records of sentences? (with key>value type pairs?)... or is that...

Hey everybody, Problems everywhere ain't they? Well this one is about mysql and when I open phpmyadmin, I get "Access Denied. Error! Cannot connect: invalid settings. Connection for controluser as defined in your configuration failed. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check...

I need help designing a separate lookup database that allows me to find information about members quickly. On our main system each account can have 3 sub-members linked to it including the main which makes 4. They can only purchase an event once per member + sub member. Each member has its own 15 Digit ID. I need help figuring out how to join...

***> here is the code***. > when i search single word like GOOGLE then the result is appear > if i search two or more word search then the result is not appear. <?php include("connection.php"); @ob_start(); session_start(); $GLOBALS=isset($_GET) ? htmlspecialchars(urldecode(urlencode($_GET))):"";

Hi, I have used inner join but need to remove leading zero's in one of the field because my query is "select * from table1 inner join table2 where table1.start = table2.start" here table1.start field consistleading zero's. how can i apply query in where condition to remove leading zero's.

i wish to now know how to normalize a table which have duplicate names and number repeated severally and i tried normalizing but could not

Hello, I am trying to query the data set below for the data_value for the data_id of the recent data_date. So for data_id 18554 the recent data_date will be 2/8/2016 18:40 and its data_value will be 29504.76 And for data_id 18555 the recent data_date will be 2/8/2016 18:40 and its data_value will be -90909090909 ...

I have a table where i enter the students details. Whenever we insert a row in this table, a mail should be sent to the student for the student to verify the details entered. The email id is already stored in the table. How to implement this using mysql? create table s_details( SELECT_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,...

Hello everyone, I ran into a big design flaw in this software I'm writing in PHP and MySQL. I'll try to explain this the best I can: I have a table let's call it "claims" it has all of the clients claim information but also has attorney information and insurance information in it. Now my client is asking me to set this up to where I can...

I am creating a login page , tables: database has tables &quot;student&quot; and &quot;faculty&quot; schema: "student" table has columns "sid,spass,sfname.....etc." "faculty" table has columns "fid,fpass,ffname......etc." Problem---

Hello Experts, I had a issue with a MYSQL Table. Here's my scenario. CentOS Linux 6.4 MySQL version 5.1.69 When trying to run a script to update some tables the Mysql shows a warning at the EventData table • I first check the table

Hi group, I use "LIMIT 10" in mysql query but what I really need is to get also all the equal with the 10th record values. I know that ms access do it by default with "select top" but I can't make it to work in mysql. Searching around I didn't manage to find any familiar issue... Could you please help? Thank's the query is SELECT ...

Does 5.7.11-ndb-7.5.1-cluster-gpl support json datatype in ndb table?

My javaScript. <script language="javascript" type="text/javascript"> var i=0; function addRow(table1) { i++; frm.reza.value=i; var tbl = document.getElementById('table1');

i have some dynamic rows, when i submit a single row submit into my database. how can i insert my dynamic all rows into database by submit? entry_history.php (page)

I am struggling to wrap my head around a data model, and I can't seem to find the right answer on the Google's... I am working on setting up an event registration database (and eventually website) and I need to be able to register as a member, have members register members, and members register guest. I will include my current tables. ...

Hi, I have created an event which inserts data into table after every 2 minutes. I want Email Notification informing successful execution / Failure of event so that we can take corrective actions. Attaching Table Definition and Event Definition for reference. CREATE TABLE "test" ( "test_id" mediumint(9) NOT NULL AUTO_INCREMENT, ...

How to Count number of rows in a table that matches to the related condition and echo that count out. Code goes as follows:: <?php $sql = "SELECT * FROM input ORDER BY date DESC"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) {

Today I brought the database I need to restore. I'll be doing it on your local computer. The database is MySQL off a Linux box, is it possible to mount these files similar to how you would a .mdb file on a MSSQL Server? I am looking to mount them on my Windows based version of MySQL 5.5. I have the MYI, MYD and FRM files.

Hi, I have some large data collected from another system that are for year 2014 and 2015. These are entered into our MySQL database. There are about 20 columns of data. eg: Column A, B,C,D, E ..... I just realized that data 2014 should be inserted from column E onwards. And 2015 data should be inserted from column A onwards. When I look...