Fix mysql error 1069

Lukket Lagt ut 5 år siden Betales ved levering
Lukket Betales ved levering

I have a windows server with “wamp” and a mysql database that has a table with many columns, and I want to add index to all the columns:

Using sql, for example:

ALTER TABLE ticks ADD INDEX v65_index (v65);

ALTER TABLE ticks ADD INDEX v66_index (v66);

ALTER TABLE ticks ADD INDEX v67_index (v67);

But I get the following error:

#1069 - Too many keys specified; max 64 keys allowed

You must solve this problem

Thanks

MySQL PHP

Prosjekt-ID: #17793776

Om prosjektet

19 bud Eksternt prosjekt Aktiv 5 år siden

19 frilansere byr i gjennomsnitt $56 for denne jobben

mvaqasuddin

Hi There, How are you doing? how can I access your wamp ? could you please come over chat I will try to fix now. Thanks

$25 USD på 1 dag
(408 Omtaler)
7.4
w6d

Hello, I have checked out your project description regarding MySQL issue. I can resolve this issue within a few minutes if you award me this project. I do have 6+ years of experience in MySQL, MongoDB, Core PHP, Cake Mer

$20 USD på 1 dag
(192 Omtaler)
7.6
anmoltech

Hi there, My name is Abhishek. I have read your project description and analyze your requirements that you need to fix MySQL error. I can fix it within hours, so let us start it. I do have over 8+ year of exper Mer

$55 USD på 1 dag
(170 Omtaler)
6.9
talhamq

I have experience in deploying and maintaining of: Cloud Computing Platforms: AWS Amazon Web Services,Microsoft AZURE, Google Cloud (GCP). Server Operating Systems: Windows Server 2003-to-2012R2, Windows Server Mer

$25 USD på 1 dag
(188 Omtaler)
6.2
grupociberia

I can start right now, I'm interested in this project, I have experience in Mysql - Linux server. Thanks Puedo comunicarme en español

$50 USD på 1 dag
(133 Omtaler)
6.4
bishnudev3

Hi, I have read your requirements, I will definitely help you in configurations and setting up the Project as per your requirements. If you can give opportunity then I will do this job for you. Have a look at my exp Mer

$25 USD på 1 dag
(81 Omtaler)
5.5
iamsinghkrishna

Hi, I did 500+ websites and web applications in 9+ years in CakePHP, Zend Framework, LARAVEL, YII, Wordpress, Core PHP, so i have knowledge of PHP, MySQL, Rest API, AJAX, JAVA SCRIPT, JQUERY... i will do anything as Mer

$15 USD på 0 dager
(43 Omtaler)
5.5
WebRss

I am a qualified Developer, Designer and seo expert based in India. I have over six years of experience working with highly profitable businesses in London and the USA. I pay attention to your vision as my client and Mer

$25 USD på 1 dag
(11 Omtaler)
3.9
laserlance

This is an easy fix, but you should really consider if having a table with that many columns is necessary. If you just want a fix, it will take me a few minutes to do this if I have access to the server.

$40 USD på 1 dag
(2 Omtaler)
3.6
carlamorillo2

Hi, it seems you overpassed the maximum table number of indices limit. You might want to do either of 2 things: 1) consider using another DB engine 2) Change your DB relational design. I recommend changing the DB desig Mer

$15 USD på 3 dager
(9 Omtaler)
3.8
vinodbansal

Hello I am an expert in MySQL to maintain a database and fix Issues. I am ready to start work now to Fix Database. I will also Fix Issues, Design and Develop Website, Custom Plugin, Integrate API's, Optimize for SEO Mer

$40 USD på 1 dag
(7 Omtaler)
3.4
sreenivas2903

hi please let me know more about this , i will run the indexes . ping me for more info and your exact requirement

$35 USD på 1 dag
(4 Omtaler)
3.0
asadmr1

I seem some limitation, my opinion to check alternative solution it seem the database is too much normalized, try to normalized as alternative solution , I am ready to discuss further.

$25 USD på 1 dag
(0 Omtaler)
0.0
adityamittal1993

Hi, I understand you want to add an index to all the columns. It is one of the worst things you can do to database. It will affect your insertion time and read time highly. If you want a cost effective consultation a Mer

$555 USD på 3 dager
(0 Omtaler)
0.0