MySQL Database Forum

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...

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 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. ...

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()) {

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, ...

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...

Does MySQL 5.6 include support for Roles Based Access Control (RBAC)?

Hello, I hope someone can help me! I have 'payment' data in two databases. One db contains old/archived data. Each db contains the exact same table "PmtsTbl" but obviously the data is different. I want to select all payment data from both db within a date range. I have the following sql which works in "Mysql Workbench" SELECT * FROM ...

Hi Im sure the answer is obvious but I cant see it I have a table of events (they are actually radio meteor events) This table has amongst other things event_id which is unique Date time contributor

Here is what I have so far when use the DATE_ADD function in MySQL Workbench 6.3, but I have been struggling to output the hrs:mins:secs (you don't see the code for that output because I didn't write it here). I know that I can use INTERVAL HOUR_SECOND to display hrs:mins:secs but I don't understand how it works. SELECT DATE_ADD('2017-01-26',...

How can I get the DATE_ADD to output the hrs:min:secs after it outputs 31 days from the specified date in my SELECT code below? SELECT DATE_ADD('2017-01-26', INTERVAL 1 MONTH) AS '31 Days';

Here is what I have so far when use the DATE_ADD function in MySQL Workbench 6.3, but I have been struggling to output the hrs:mins:secs (you don't see the code for that output because I didn't write it here). I know that I can use INTERVAL HOUR_SECOND to display hrs:mins:secs but I don't understand how it works. SELECT...

Hi sir, I want to calculate time in a proper format (hours, minute and second). My first field type is datetime directly fetch from database and second one is fixed it's 08:30:00.

Hello Everyone, I have basically 13 different tables. I have Customer table, a Sale table which is connected to Customer table because a customer can buy a Sell and that same Sale table is also connected to an Employee table because an Employee can Sell a Sale. Then I have an Order table connected to a Vendor table because a single order can...

Hello, I am have created 12 tables for my EER diagram, but I need some help with the problems that I am having. First I am not sure if I really need the last table (OrderLineItems table) and also if I do need the last table, what could I put in the table?

Hello Everyone, I have been struggling for hours with trying to figure out how I can return the average GPA across all sections that a professor teaches. Here is the code that I have so far. I know would only need Section and Registration tables in order to output this type of procedure that I want, but it is not producing the right results. Can...

Hi , i need to write a script for upadate stored procedure in mysql, this is my code , but someting is not good , can anyone help me? Thanks! CREATE DEFINER=`root`@`localhost` PROCEDURE `table_upd` (IN customer_id int, IN cname_param VARCHAR(45),IN lastname_param VARCHAR(45), IN date_of_birth_param DATE, IN country_param VARCHAR(45), IN...

Hey people, I wanted to generate a random number (for a unique and unpredictable memberID) and insert it into every memberID column which has not a memberID already (equals NULL). I dont want to change the already generated memberIDs in the meantime. SELECT FLOOR(10000 + RAND() * 89999) AS random_number FROM customer WHERE...

Not every of mysql databases has such problems. Some days ago something happened, and my changes in database are disappeared. Now I don't know how to be. I am on MySQL 5.6

I am working on localhost LAN network Accidentally deleted selected rows from mysql table i wanted to execute select * from mytable where remark='C' but accidentally executed delete from mytable where remark='C' because my previous command was delete command all my updated records got deleted Please help if there is any method to recover...

I had a quick course of database few years ago and I forgot a lot from there. So you can say I'm starting from zero. I will try to explain to you on what I want to do and a picture with what I did so far. We have a small business at home to change tires on a car (winter tires, summer tires). When I customer comes and changes tires they usually...

What I'm looking for is a lazy man's way to define a table structure, using the table headings row in a CSV file. I'd be happy to start with all fields being VARCHAR(50) or some such default, and then making appropriate changes via PHPmyAdmin later. The reason for being this lazy is the number of fields that I need to define - the CSV file is...