MySQL is an open-source, relational database management system.
0
votes
0answers
3 views
How to have a grouped field horizontally in ireport Jaspersoft
I have a query like this:
“SELECT
C.City AS City,
COUNT(DISTINCT(IF(C.Township= 'Apple',B.ObjectName,NULL))) ASM1,
COUNT(DISTINCT(IF(C.Type= 'Government',B.ObjectName,NULL))) ASM2,
...
0
votes
1answer
12 views
how to get last insert id after insert query in codeigniter active record
I have an insert query for used to insert the form fileds into a mysql table. I want to get the last incremented id for the insert operation as the return of my query but I have some problems with it!
...
0
votes
0answers
13 views
profile page do not work after submitting the login process
i have a login page that allow user to enter email and password after checking if data correct the browser must display the profile page but the problem is that after i enter email and password the ...
-2
votes
1answer
38 views
What join do I use?
Hello I have 1 database with the following 3 tables:
Classroom ///
Student ///
ClassroomToStudent
A student can have multiple classrooms
A classroom can have multiple students
Classroom:
...
0
votes
1answer
12 views
SQL being executed twice in FOR loop
I think I need a second pair of eyes on this one. For the life of me I can't figure out why my SQL INSERT query is running twice every iteration:
if (($handle = fopen($spreadsheet_url, "r")) !== ...
-1
votes
0answers
11 views
Delete duplicate text in TextField mysql and can't make it unique
I can't delete the duplicate rows, because can't set the textfield to unique, how to solve this?
0
votes
1answer
8 views
What I need to write in schema.xml for searching in two or more fields in Solr?
I'm new in Solr.
I've indexed 3 fields from MySql to solr.
Id, first_name, last_name.
I want to search in first_name and last_name.
In schema.xml I wrote:
<fields>
<field name="id" ...
0
votes
0answers
13 views
what data mining algorithm can be applied to determine reorder point of inventory items?
I am working on an EOQ model for inventory management in php. I have to decide the reorder point for inventory items or when to reorder a particular item and in how much bulk? for this i need some ...
0
votes
0answers
28 views
Match performance times with audience availability using MySQL & PHP
I've looked at a lot of the stackoverflow answers around this subject, but they all seem to be coming at it from a different direction. Here's what I want to do, and at this stage I'm more ...
0
votes
0answers
6 views
How to insert data into MySQL database by using the GWT, HTML and JDBC or Hibernate?
I am using the GWT(Google Web Tool-Kit) version 2.5.1. I am already done for develop sample application to display that username and password. But i am not identifying how to insert that values into ...
0
votes
2answers
14 views
Java query with setString unable to insert bit type
Here is the issue
I'm using Netbeans and MySQL latest version
I'm using the BIT(1) Field type in MySQL to manage the Boolean types in my app
When storing Data in the data base if I use this code ...
0
votes
2answers
24 views
Execute two query from mysql in same page by passing value in url
I have created a page in php
I want to show when user type in weektable.php it should show all the value i.e it should execute this query
$sql = "SELECT * FROM `battery`";
above query display all ...
0
votes
1answer
30 views
How to add value to SET field in mysql?
I have a table named user with a field of type SET named privs.
The allowed values of this field are: 'ADD','EDIT',DELETE','ALL'.
What SQL query should I execute to add let's say value 'EDIT' to the ...
0
votes
4answers
56 views
MYSQL join query not working
I have 2 mysql tables named
blog
comment
What i am trying to do to retrieve following columns
user_name comment_desc from the comment table using blog_id.
Both the tables have blog_id in ...
0
votes
7answers
56 views
Checkbox with PHP and MYSQL
I have two checkboxes
<form action="" method="post" enctype="multipart/form-data">
<input type="checkbox" name="file_type" value="1"> Filer<br />
<input type="checkbox" ...
