Tagged Questions
MySQL is an open-source, relational database management system.
0
votes
0answers
9 views
Combining a VIEW and TABLE
These are my codes for creating view is working fine for me, I just want to add one more field name:job_type which is from a table called Job Type.
So basically, I just want to combine ...
0
votes
0answers
5 views
Error in Jsp with Mysql connection
how to connect sql server with jsp page?
I wrote whole code but it shows this error while debugging:
Not able to submit breakpoint JspLineBreakpoint ...
0
votes
0answers
8 views
Voting-system wont pass on vote to database
I'm having difficulties on debugging why this voting-script I'm trying to adapt wont update the vote count and register the user's IP-address in the database. As of now neither of the two things seem ...
0
votes
0answers
6 views
MySQL - invalid number of fields for SHOW SLAVE HOSTS
I'v recently had to upgrade my MySQL Master database from 5.0 to 5.5. Everything went fine, except that now one of my slave databases is refusing to connect citing the following error:
'the master ...
1
vote
1answer
8 views
Can one change MySQL's default assignment from character sets to collations?
I set up a MySQL database, version 5.5.31. The default collation for the character set utf8mb4 is utf8mb4_general_ci (as shown by SHOW CHARACTER SET). I would like to change this to ...
0
votes
2answers
19 views
Compare two databases and find common value in a row
I have two databases (infact two database dump ... db1.sql and db2.sql)
both database have only 1 table in each.
in each table there are few columns (not equal number nor type) but 1 or 2 columns ...
1
vote
3answers
16 views
Getting data from two tables if they match.
I am trying to get information from two tables in the database:
misc.users and misc.course
The misc.users table contains every person that has ever been to the institute whereas the misc.course table ...
0
votes
0answers
5 views
gevent + SQLAlchemy + MySQL: what's the best driver?
I'm working on a project which relies on gevent for concurrency and needs to work with a MySQL DB. I would like to use SQLAlchemy although I have to say it is not a strict requirement. Using a MySQL ...
-3
votes
0answers
14 views
A Database error occured when trying to install codeigniter
Hi i am new to codeigniter,i am getting an error when trying to open my codeigniter using mysite.com/fiverr1 i have added my database details in database.php and also i have added the base url in ...
0
votes
0answers
4 views
Creating MySQL Spatial Procedure in MySQL 5.0
I found a procedure that pretty much meets exactly what I am looking for here on this page:
http://www.scribd.com/doc/2569355/Geo-Distance-Search-with-MySQL
I have modified it just a little to ...
1
vote
0answers
13 views
Create view from select with parameters
I want to create view from this 'select'
CREATE VIEW `ste_15` AS
set @n:=0;
select
instr_name,
min(instr_bid) as minBid,
max(instr_bid) as maxBid,
avg(instr_bid) as ...
-4
votes
1answer
36 views
How to write SELECT query?
Table orders:
id, car_id, date, status
Table cars:
id, client_id, model
Car has many orders.
Order belongs to car.
I need to get all cars by client_id with status and date from last order (1 order) ...
0
votes
2answers
11 views
Issue in Code Igniter JOIN
i have this query in CI Active record Form
$this->db->select('companies.*,comp_permissions.user_id');
$this->db->from('companies');
$this->db->join('comp_permissions', 'companies.id ...
-4
votes
6answers
34 views
PHP And MySQL Troubles
So Im Making A SignUp Form And Its Going Very Good.
I Dont Want To The Code, So Im Gonna Give An Example.
<form action="register.php" name="signup_form">
<input type="text" name="username" ...
0
votes
1answer
13 views
Creating a database view with hibernate
I am using MySql database and hibernate in my application, I have a case where I need to create database views from the application, how can I do that? I mean I tried to do this, but it isn't working: ...
0
votes
1answer
8 views
Linux folder identification or metadata in php
I've developed a kind of internal business webdrive.
The data contains 'root folders' all users can be set to have read or read/write permissions on these folders.
This data is stores in a MySQL db.
...
0
votes
3answers
24 views
mysql syntax error near expected new line in terminal mac
I am running the following command as given on web to connect the mysql data base but it gives syntax error new line expected here is the command i am entering.
mysql ...
0
votes
0answers
4 views
Force UTF8 in MySQL 5.5.* [client] section
I try to run mysql on Ubuntu. I filled the config with strings like default-character-set=utf8, but mysql didn't run throwing the unknown variable errors. I found, that that is deprecated and should ...
0
votes
0answers
4 views
change datadir for MariaDB 5.5
I want to change my datadir for MariaDB. I mean I want to have all my file except data folder in
C:\Program Files\MariaDB
5.5 and my data file in
C:\user\appdata.
I don't want any data ...
0
votes
0answers
6 views
Generated Query with multiple SubSelect from Zend Framework 2
I have been battling an issue with Zend Framework 2.
This function creates as many subselections as are needed to filter my results.
public function getResponsesByFilterArray($filter_array)
{
...
0
votes
0answers
8 views
Setting up vagrant with the following configuration
Upon learning Vagrant, I am amazed by its functionalities and benefits as a developer, operations manager, and client. I am studying how to create a Vagrant with the following requirements:
Box: ...
0
votes
3answers
25 views
Get inner SELECT result as ResultSet from INSERT INTO SELECT statement in mySQL Java
I have 2 DBs, Database A and Database B.
What I want to achieve:
build records from Database A and insert them to Database B
Process those records in my java app
What I'm currently doing:
I use ...
0
votes
1answer
23 views
Is it possible to run scripts on django using only ftp?
I am newbie to python and django, but this time I need a fast solution. I've got a problems, using hosting where my django application is deployed so I need to migrate to another server, but I have no ...
0
votes
1answer
13 views
Apache Tomcat reboot. Could not load com.mysql.jdbc.SQLError
I use Apache Tomcat 7.0 with connection-pooling in Spring Source and Hibernate POJO's.
Always that I reboot Tomcat I have the following error:
03-dic-2013 9:33:46 ...
0
votes
0answers
36 views
summation in view table mySQL
I make view table from joining many table and the result is like below
-- view_report ---
===+=======+=======+=====+=================+=======+======+========+============+====+
| | | ...
0
votes
0answers
54 views
Group mysql results by user
I want to create page that lists all the messages send by current user,and all the messages sent to current user by other members , group the results by user and show they last message(something like ...
0
votes
1answer
20 views
getting one estimate from multiple teams
table: estimates
id | team_id | project_id | value | type
What I want to achieve is only the latest value of one estimate type.
Types are 1, 2 or 3
Lets say we have project_id 1 with estimate ...
0
votes
2answers
30 views
Invalid parameter number when executing query
I am trying to query a values and if there is a DUPLICATE KEY UPDATE table person. But I am getting an error Invalid parameter number'. This causes the query to not work at all. personal_id is the ...
0
votes
0answers
25 views
Problems with relative path while including database constants
I'm running into problems when I require a php file that contains my constants if I use a relative path. When I change it to an absolute path, it works well but I don't want to deploy it into ...
0
votes
0answers
9 views
How do I save file data to my newly mounted SSD in mysql innodb continually?
I've recently mounted a new SSD since my disk's empty space had less than 10% (mysql unbuntu linux)
and this is what I did in my.cnf file to save data to my new path:
innodb_buffer_pool_size=2G
...
-4
votes
1answer
36 views
how to build an ask/answer website with html/css/ajax/php
//this is register.js
window.onload=initPage;
var request;
function initPage(){
var submit=document.getElementById("submit");//<input type="submit" id="submit>"
...
-1
votes
1answer
23 views
A DB Error Occurred [on hold]
A Database Error Occurred
Hi frnds i getting exact output first time.But if refresh the page second time means getting below error.so again i need to restart the xampp server. Please help me why this ...
0
votes
5answers
78 views
MySQL won't update in Where condition PHP
Hello could you guys please help me out with my code. I am trying to update my database with the code below. The query is fine but when I am trying to put that $ecode variable on the WHERE condition ...
0
votes
0answers
18 views
CI active record style sql queries
I am new in Code Igniter and like its active record feature now is there any useful steps or tips or any guidness how do i convert my pervoiusly written simple SQL Queries in CI style like this is my ...
-4
votes
1answer
26 views
How to insert data into a table from two or more tables in a stored procedure?
In my query I want to insert data into a 'TABLE' table:
ALTER PROCEDURE TEST_INSERTION
--@TABLE_NAME VARCHAR(MAX)
AS
BEGIN
INSERT INTO TABLE (COLUMN_NAMES)
(SELECT ...
0
votes
2answers
40 views
How to get a value without characters like “- , + ”?
This is the normal output:
mysql> select module_id from Modules where Module_name = 'STP_XENA';
+-----------+
| module_id |
+-----------+
| 3 |
+-----------+
1 row in set (0.00 sec)
Can ...
0
votes
4answers
47 views
Querrying more than two entities
JPQl Am new in jpa and i want to query all fields from two entities and then use the entity classes getters to access the data .
Query q = em.createQuery("SELECT u(*),f(*) FROM User u join Employee f ...
1
vote
1answer
22 views
catch MySQL trigger signals in C#
I want to create a MySQL trigger to generate different signals and based on those signals I want to display some specific messages through my C# code.
If I set signals like:
signal sqlstate '45000' ...
0
votes
0answers
26 views
Sphinx Group By for both RT index and plain index
I need to put Group by for Both Rt index and plain index...
For example:
I have 4 records with different document ids in plain index with persons of same age..
And also I have 2 records of the ...
-1
votes
2answers
38 views
Check if values in mysql database exist in multi dimensional array
I have multiple ID's in an mysql database. I would like to know if there are ID's in the database which are not present in an multi dimensional array. For each ID which is not present in the multi ...
0
votes
2answers
29 views
Is it possible to get LAST_INSERT_ID() from different database?
Suppose, that we have 2 databases: a and b, and tables a.test1 and b.test2.
If I need to insert a row into table a.test1, and return LAST_INSERT_ID() to insert into b.test2, will LAST_INSERT_ID() ...
0
votes
0answers
6 views
innodb_IO_r_wait value too high
I am using MYSQL server on rhel 6
On one machine its too fast and on other it is very slow.
All the table are on INNODB and Indexing is same on both machine.
The faster machine has the following ...
0
votes
1answer
22 views
How can i update changes occured in the main database to my local database? [on hold]
I have created a student portal project which includes registration,examination etc.The main database will contain all the records. Now I am having that database in my local server. I need to update ...
0
votes
0answers
29 views
JPA: how to save date timestamp in MySQL
I have an issue in saving offset in MySQL. I am using JPA 2.0 + EclipseLink.
Here is the code which I tried:
@Entity
@Table(name="log")
public class Log {
...
0
votes
0answers
21 views
how to reduce restore time of database?
I am using my sql database and have a database with the size of 3GB. I have an issue with the restore of database.
Means I want to restore 3GB database backup into my sql database but it takes more ...
0
votes
2answers
38 views
Error: SQLSTATE[HY000] [1040] Too many connections
I'm working on a website, and I rarely get the error in the title. I know one possible solution for the error is by changing max_connections, but other than that I get this error as well:
Fatal ...
0
votes
1answer
42 views
How to Add a Foreign key in my SQL
I am using spring mvc and hibernate. I created a lot of one to many mappings in this project, but now when I try to add a foreign key, I get the error bellow.
MY SQL
ALTER TABLE ...
2
votes
5answers
41 views
MySQL Select Statement not working
I am trying to create a select statement to be used in a view. The goal is to create a view showing office description, party description, candidate name and incumbant indicator. I have the following ...
0
votes
1answer
27 views
How do you extract information from database using Spring MVC? [on hold]
The database that I am using is MySQL. I don't know if this is a basic question or not, but I am currently starting on developing a basic web service, and i'm a little clueless about extracting ...
-2
votes
0answers
12 views
Want to create a website using hibernate ,spring and struts in which user can post queries
hi guys i am new to Spring,Hibernate and Struts .actually i want to create a web site using these frame work and want to build a site in which student and post there question or queries related to any ...
