Questions tagged as 'mysql'

1
answer

I can not connect to MySql with Visual Studio 2013 to work on Asp.net MVC 4 web and in E.F

I want to connect to a database with entity framework to a database with MySql yog Ultimate, but it does not work for me. Start by adding the dlls: And I even add the following to the webconfig:         But it does not show the MyS...
asked by 17.08.2016 / 15:26
1
answer

Autoid in box value, using Mysql

Stackoverflow, I write this question because I have a system to register projects and their corresponding forms. I have: a registration form a php code (contained in the connection.php file as a function) that is responsible for savi...
asked by 07.09.2016 / 16:15
1
answer

How can I know if a date is a date? (VB.NET)

My intention is to know if the data that the user has entered, is date and that it is in the MySQL ( YYYY-MM-DD ) format. First I made a query with data type date to a table of Excel , but it turns out that when doing a test to see what...
asked by 16.08.2016 / 00:51
1
answer

How to export code lines to a .sql file

I have created a database, in mariadb, I need to save in my .sql file my database and the code lines I use to create it, for example if I did: CREATE TABLE ejemplo ( id VARCHAR(20), x INT, PRIMARY KEY ( id,x ) FOREIGN KEY x REFERENCES otratab...
asked by 03.08.2016 / 23:16
1
answer

save excel in MySQL and delete an existing one

I am saving an excel file in MySQL using a jsp in java. How do I make sure that when I save another excel file in the same database, I delete the existing file and replace it with the new one? I enclose the class code where I read the excel a...
asked by 21.12.2016 / 14:03
1
answer

Add students to a single project

Stackoverflow, greetings, I think this question because I have a system that registers projects and the students that integrate it, it saves them in a database, in a nested table PROJECT_ALUMNO that contains student_id and project_id, as well as...
asked by 07.09.2016 / 17:03
1
answer

How to display a MySQL table in HTML?

I have a problem linking a DB and displaying it in an HTML page in a table. I made the connection to the database in the following way: <?php $connect = mysql_connect("localhost", "username", "password") or die(mysql_error()); mysql_se...
asked by 07.07.2016 / 16:27
1
answer

Check php and ajax

I have a form with an input type text and a button submit where I write a product code and search in a MySQL database. I show the results in a table within the same page, but how do I make the page not be reloaded by pressing th...
asked by 06.07.2016 / 21:58
2
answers

Connect Database in Java Menu

I need help to connect the database to a menu created in Java, the menu is about a store in which an order is placed and the products are in a database which can be added to the order as required. that the client wants, what I need is that the b...
asked by 22.07.2016 / 00:06
1
answer

Restore phpmyadmin users with XAMPP in windows

Good morning everyone! I have the following problem, accidentally delete all the users from the phpmyadmin and now I can not enter anymore because there is no user. How can I restore all the lost users? I do not want to lose my database :( URGEN...
asked by 04.04.2017 / 17:36