Stack Overflow
Stack Overflow

Questions tagged [mysql6]

7 questions
11
votes
2 answers

What are the limitations of implementing MySQL NDB Cluster?

I want to implement NDB Cluster for MySQL Cluster 6. I want to do it for very huge data structure with minimum 2 million records. I want to know is if there are any limitations of implementing NDB cluster. For example, RAM size, number of databases,…
Sunil Kumar Sahoo
  • 53,011
  • 55
  • 178
  • 243
2
votes
1 answer

MySQL 6 connection with Enterprise Library Data 5

Building a simple asp.net web app just to test things out (will obviously refactor before anything gets built for a production site), and I'm trying to connect to a mysql database using the latest version of the Enterprise Library, and am running…
Ben S
  • 185
  • 1
  • 10
1
vote
1 answer

The procedure works in MySQL 5, but fails in MySQL6, why?

Procedure: delimiter | create procedure pro_regs(in username varchar(50), in pwd varchar(50), in email varchar(50), in address varchar(50)) begin insert…
Mask
  • 33,129
  • 48
  • 101
  • 125
1
vote
1 answer

print report in sentence format in mysql

Being a newbie I need your help again. This time I'm trying to print a report in MYSQL 6.0 that shows each branch & its location in the following format: The 'branch name' is located at 'street address' in the city of 'city name'. I also need…
S Elizabeth Starkey
  • 55
  • 1
  • 1
  • 6
0
votes
4 answers

Should I use MySQL 6.0 for my large project?

MySQL 6.0 is for production. Can I use it for database storage of a large project?
Ashok Gupta
  • 2,247
  • 5
  • 28
  • 34
0
votes
1 answer

#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

I have a Magento2 website and wanted to deploy on a server. I got the above mentioned error when I tried to import DB copy of a local to the live mySQL server. I found the reason that on local system I have mySQL 5.6 and phpMyAdmin 4.4 and on the…
mbkh10
  • 43
  • 1
  • 11
-3
votes
1 answer

get rows from another mysql table depening on distinct value from another mysql table

I have two mysql tables. UserInformation and referencelog Now, most of the columns are not of interest. This is what I am trying to do: Get the unique "created_by_user_name" from referencelog for a given level id. I am able to do it by following…
user1631306
  • 4,350
  • 8
  • 39
  • 74