MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

-2
votes
1answer
56 views

How to freeze a view in standard SQL? [closed]

I have the following: create view ONE as select ID workers_A; create view TWO as select ID workers_B; create view FINAL as (select * from ONE) UNION (select * from TWO); That works correctly, but ...
-2
votes
1answer
1k views

Trigger not working, why? [closed]

What i'm doing wrong? CREATE TRIGGER `Calc` AFTER INSERT on `test`.`bookings` FOR EACH ROW BEGIN UPDATE `test`.`article` AS `ST` SET `ST`.`stock` = SUM(`test`.`bookings`.`amount`) WHERE ...
-2
votes
1answer
125 views

MySQL MATCH vs JOIN

I have a lot of data to filter and therefore I wonder is it better to create somekind of indexes and save them to one table and use MATCH or LIKE to find matches or should I use many different tables ...
-2
votes
1answer
515 views

MySQL Incremental Backup (cron job): “sh: mysqlbackup: command not found” [closed]

I want to run cron job Mysql Incremental backup, Can any one pls help me. I tried: $command = "mysqldump-h $dbhost -u $dbuser -p$dbpass ". $dbname." > $backup_file 2>&1"; ...
-2
votes
1answer
388 views

Second time query execution using different constants makes faster? [closed]

Can someone explain or direct me how execution on indexes happen with different constants at intervals in Mysql. I notice only for the first execution on the table it takes time, after that with ...
-2
votes
1answer
91 views

How to efficiently model this simple data structure?

catId(INT) | userId(INT) | catName(VARCHAR) 0 1 Cat1 1 1 Cat2 2 2 U2Cat1 3 2 ...
-2
votes
1answer
2k views

Which is the shortest way to find out if a float IS NULL or equals 0 in mysql [closed]

I want to type the least possible characters, to find out all columns in a table that are 0 or NULL In this example I explain it further: lets assume the table test CREATE TABLE IF NOT EXISTS ...
-2
votes
0answers
16 views

Is there any future scope with DBA profile?

I have appointed as DBA. And I don't have any kind of experience. Right now I am fresher and I don't have any idea about How is DBA profile ? What should I do to become a good DBA ? Is there any ...
-2
votes
0answers
23 views

MySQL Workbench cloud alternatives [on hold]

I have some analyst who runs some particular queries which are provided by me. Now when a new analyst joins our team I have to install MySQL Workbench on their laptop to set up the connection. I went ...
-2
votes
1answer
41 views

how to trace the data whether the destination stop using mysql?

I am newbie in programming.. I have table test and 3 columns(source, from and destination) below.. Table test source from destination 01 VALID/NUM-6283 ...
-2
votes
1answer
44 views

Is a normalized MYSQL DB faster than one organized with comma strings?

I've always used databases with comma-separated id strings, something like +------+--------------+ | id | users | +------+--------------+ |1 |2,4,5,6,12 | +------+--------------+ ...
-2
votes
1answer
36 views

what else to enable to make LOAD DATA INFILE work?

Anyone got an idea what to enable to make the LOAD DATA INFILE working? I have the global variable 'local_infile' set to ON, the database is answering queries just normaly, but LOAD DATA INFILE ...
-2
votes
1answer
33 views

Allow me to transpose rows into columns [duplicate]

I have a table data as shown below. +---------+----------+-------+--+ | Name | Semester | Score | | +---------+----------+-------+--+ | John | Sem 1 | 80 | | | Michael | Sem 1 | ...
-2
votes
1answer
101 views

The best my.cnf for my AWS server

I have an amazon server , my mysql is very slow , i dont know what is the best configration for my server , i need to big caching system for improving my website speeds, it's my config : my.conf : ...
-2
votes
0answers
21 views

increasing Mysql DB Size and Server Size [closed]

I have installed xampp on my windows machine, i'm using MySQL, How to increase the size of mysql server and databases in it? Kindly help me..! Thanks in advance...!!!?
-2
votes
1answer
24 views

What is the correct format to do this?

SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME.value = 'Diwali' AND TABLE_SCHEMA='database_name'
-2
votes
1answer
956 views

how to design a database for erp in mysql

i am developing a database for a erp system. the products are electronic goods like camera, CCTV, GPS etc. the system has purchase order, purchase invoice in Purchase module. And quotation, delivery ...
-2
votes
0answers
81 views

Can this architecture supports 350 concurrent access? [closed]

This question is more about server capacity issue. I have a linux server with Apache 2.24 installed (12G Ram, 32 cores CPU, Red Hat 64Bit). Install 11 instances of Wordpress, all 3.8.1, with WP ...
-2
votes
1answer
136 views

MySQL ran out of space, now won't start

So the partition MySQL was mounted on ran out of space. As a quick fix, I decided to move mysql's data directory to /home/minecraft/mysql/. I then changed the datadir in the config to the correcy ...
-2
votes
0answers
265 views

How to make make my query run fast? [closed]

How to make this query run faster? Table contains over 2 million rows of data and takes around 30 to 120 seconds to process the query. SELECT INET_NTOA(blocks.startIpNum), ...
-2
votes
1answer
152 views

Bulk Insert / Data Transformation [closed]

What techniques do people use to upload data from a flat file into a normalised database? We are planning on using MySQL or MariaDB. I have a number of large excel spreadsheets that I would like to ...
-2
votes
0answers
61 views

MySQL-CLuster PHP5 [closed]

I have installed correctly MySQL Cluster on my Vm's the mgm nod with two SQL/Data node and everything looks ok, but I cant run my application because MySQL Cluster dont see PHP5 anyone know how to ...
-2
votes
2answers
3k views

How can I search for a name in two columns in MySQL? [closed]

I want to search a name 'Hamed Haddadi'. 'Hamed' is first name and 'Haddadi' is the last name of the user. When I search individually in the first name and last name columns it shows a record. My ...
-2
votes
1answer
134 views

percona innobackup failed

I'm trying to get percona innobackup but I'm struggling with this since 4hrs. Tried all possible ways from many forums. interms of changing my.cnf, parsing arguments but still not able to get this ...
-3
votes
2answers
496 views

How can I generate Cassandra data model from a MySQL schema?

Is there a tool for generating a Cassandra model from a MySQL database?
-3
votes
2answers
619 views

SQL Server equivalent to MySQL UNIQUE index?

In MySQL (5.1) I am able to create a Index on a field that is type UNIQUE. This ensures that the field contains only unique items. Is there something equivalent to that feature in SQL Server 2008? ...
-3
votes
1answer
117 views

How long will it take to import 28 millions rows in a MyISAM table? [closed]

Someone has idea how long time it will take to import? I hear something like 40k each minute? Thanks.
-3
votes
1answer
153 views

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

On my local WAMP stack things are working perfectly. When I upload the database on GOdaddy.com, this error shows up. Warning: mysqli_connect(): (HY000/1045): Access denied for user ...
-3
votes
1answer
40 views

How to check table [closed]

How to check which tables a user have access to on a server?
-3
votes
1answer
377 views

error querying data with apostrophes [closed]

I'm getting empty sets from running the following query permutations: select * from gsapi_articles where article_title = "James Dean On Merilyn: 'This Woman Is A True Marvel'" select * from ...
-3
votes
1answer
65 views

How can I move one table from one database to other database [closed]

I want to move one table in one database to other database using mysql dump on linux terminal How can I go about it ?
-3
votes
3answers
95 views

Listing databases that are not in use

I want to show databases that are not used. For that I tried this query, but the result set is empty: mysql> SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA where SCHEMA_NAME NOT IN ...
-3
votes
1answer
982 views

How to merge two rows in a table? [closed]

I have a table called Person with columns Col1, Col2, Col3, etc. In Col1 I have two values: ABC and XYZ. What I want is to replicate all the values from the other columns (Co2, Col3, etc.) for the ...
-3
votes
1answer
59 views

How to organise huge mysql database for emails and search through it

I wanted to ask you for your opinion, what would be the ultimate and the best way to store million of emails and search on them, using MySQL. So first the product: You have tons of emails, which ...
-3
votes
1answer
112 views

MySql - Get all child categories until not exists

Based on this answer, can you please tell me what's wrong in the next code ? I'm trying to get all child categories. The example that I try it is: DELIMITER $$ DROP FUNCTION IF EXISTS ...
-3
votes
1answer
36 views

MySQL Insert Performance

i've been tasked to check whether MySQL can be used for Large DataWareHousing Requirement is as following the Table contains 83 column each row pay load size is 1272 bytes the requirement is the DB ...
-3
votes
1answer
137 views

MYSQL Combine two results into one

I have two mysql queries first query having results bookmark_id, is_fav, title and second query have results like this bookmark_id, is_deleted Sometimes both have same results or may have ...
-3
votes
0answers
35 views

Doubt :: my sql performance tuning [duplicate]

Possible Duplicate: MySQL performance tuning I would like to optimize my MySQL DB and I identified some important points as follows: enabling query cache, using memory storage (I know ...
-4
votes
2answers
175 views

Performance with IN clause

Does indexed data affect query performance? means If I passed value as 1,2,3,4... in ordered form in any IN clause, can it improve query performance? and what happen in case I pass value randomly ...
-4
votes
1answer
72 views

How to design type table with indefinite multiple items?

I want to design an invoice system. In invoice table there should be an invoice_type, which comes from a table called invoice_type_table. I am confused with the structure of this invoice_type_table. ...
-4
votes
1answer
99 views

When you type an SQL query in interpreter, what does happen? [closed]

Actully this question is asked in an interview from me . When you type an SQL query in interpreter, what does happen? How is the query processed?
-4
votes
1answer
181 views

How to run mssql server dependent application to mysql workbench [closed]

I am very new in mysql workbench. I have created an application in c# which uses sql server 2008 r2 database. Now i have migrated my database on mysql workbench. i want to run my application now. My ...
-4
votes
1answer
558 views

where can I get mysql-5.1.7.tar.gz or mysql-5.1.9.tar.gz? [closed]

I need mysql-5.1.7.tar.gz or mysql-5.1.9.tar.gz, but I can not find them anywhere, who can give me a link to find them, thank you very much!!!
-4
votes
1answer
74 views

one or multiple tables mysql [closed]

I have a table with 3 columns and i want to split it according to 3 last character in string of one column , it will be more faster or more performant or it's same one and large table ..?? i talk ...
-4
votes
1answer
31 views

ExecuteNonQuery () not fungsional and database failed [closed]

Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Dim SumberDb As String = "Data Source=c:\users\ogieuntung\documents\visual studio ...
-4
votes
1answer
66 views

“general_logs” is not being written [closed]

I wonder why my data inside my "mysql" table "general_log" is not writing more record, stock given the last day was yesterday 04/27/2014. My my.cnf file is as follows: [mysqld] ...
-4
votes
1answer
2k views

What are the disadvantages of PostgreSQL compared to other DBMS? [closed]

I am a student studying PostgreSQL. I want to know the advantages and disadvantages of PostgreSQL in comparison to other DBMS.
-4
votes
0answers
36 views

SELECT * FROM `Table` query is returning rows not ordered by primary key [duplicate]

First question here and I hope it is the right place. I'm using MySQL and I've always expected a SELECT * FROM 'Table' query to return rows in order of primary key, (BTW those should be back-ticks ...
-4
votes
2answers
44 views

How to view all logged user in mysql yog?

I want to see all loggin username in current local system in my sql Database using tool for SQL Yog.
-4
votes
0answers
76 views

Can I move up rows in the memory itself? [closed]

Lets say i have the following table : id col2 col3 1 1 1 2 2 2 3 3 3 4 4 4 And I'm trying to move rows to different ...