MySQL is an open-source, relational database management system.
0
votes
0answers
4 views
converting sql server database to mysql, needing change table structure and column names?
I need to achieve:
1, similar demands in this question: How to export data from SQL Server 2005 to MySQL
2, change table structure and column names, for example:
Source(sql server):
Table A
id ...
0
votes
1answer
6 views
Error adding foreign key to existing column
I have a table where i had one primary key and another column which is primary key of the other table in same database.
I just wan add the foregin key but showing error -
#1452 - Cannot add ...
0
votes
0answers
17 views
INSERT ON DUPLICATE KEY UPDATE when composite key
I want to insert new rows in MySQL table only if the combination of 3 of the existing columns (ID, Type, Year) is not unique. In case these 3 columns match I want to update the field 'Val' only.
...
-1
votes
0answers
16 views
Issue while installing MySQL? [closed]
I downloaded the recommended mysql-installer-community-5.6.12.0.msi for windows 7 64 bit os from http://dev.mysql.com/downloads/mysql/. But when I double click it to install it, a popup comes stating ...
0
votes
1answer
18 views
Does anyone use command line exclusively for managing mysql DB?
I find it quite not user friendly, but I wonder if I'm doing something wrong... maybe there are some flags I'm not aware of that can help me display data in a better more screen friendly way?
0
votes
0answers
14 views
How to fetch a row which is related to multiple rows in another table?
I have some tables:
ws_shop_product
CREATE TABLE `ws_shop_product` (
`product_id` int(10) unsigned NOT NULL AUTO_INCREMENT
`product_title` varchar(255) COLLATE utf8_general_ci DEFAULT ...
0
votes
1answer
9 views
How do I ORDER BY MAX(date) in a subquery in MySQL?
I'm in trouble with this query :
I have two tables : samples and songs
I would like to select
pathName from samples
id_user from samples
id from songs
name from songs
Each ...
0
votes
1answer
27 views
How to define a variable inside $_GET in php
<?php
$var = "sub";
echo $_GET['{$var}'];
?>
i want this working when i called mydomain.com?sub=hii .
is there any other way to make this work?
I want to use random $var value from my ...
2
votes
1answer
67 views
MySQL is too slow
I don't know why mysql is too slow for querying about 39000 records which include inner join with other two tables. I have country, region and city tables as follows:
tbl_country
CREATE TABLE ...
-6
votes
0answers
16 views
which is better according to memory performance regular tables or temp tables in postgresql
which is better for memory performance regular tables or temp tables in postgresql and mySQL? and I tried Table vs Temp Table Performance but I couldn't find the needed solution.
-1
votes
1answer
17 views
Runtime error in php mysql
I am trying to make a social networking website and I am programming for it. But I encountered a problem in it. When user try to update status for 1st time, it is not shown,then when he try to update ...
0
votes
1answer
19 views
How i can use cloud mysql database with java?
I Have a software built in Java/Swing mysql. Can I use any Cloud Service for storing and retrieving data with JDBC? or what else i can use?
0
votes
0answers
9 views
Loop through query results without loading them all in array in Codeigniter
I'm failing to find a specific statement if it is possible to use Codeigniter DB API to batch process all records in a table (thousands of them potentially) without loading all results in a results ...
1
vote
1answer
21 views
Populate a table with random set of rows from another table on insert using a trigger
I got this problem.
I have a mysql database with this tables:
USERS(Cod,Interests)
SURVEY(Cod,Target_Interests)
USERS_OF_A_SURVEY(CodSurvey,CodUser)
with Interests having the same set of values of ...
-2
votes
2answers
38 views
PHP login with mysql authorized error
Questions of this sort have been asked before, though i am still having issues, also is this the most current up to date syntax for PHP.
i'm not sure if im logging in correctly, it seems as though ...
