Most voted "mysql" questions
Mysql is a relational database management system (RDBMS) that functions as a server, and provides access to multiple users simultaneously. Your source code is available under the GNU General Public License.
Learn more…10,264 questions
Sort by count of
-
2
votes1
answer204
viewsFind Modules according to Permissions
I designed a function that lists all modules and sub-modules within the system. But I need it to be different, I need that in this same listing, only come the modules and submodules that the…
-
2
votes3
answers2173
viewsHow to select all tables in mysql
What query makes me query a certain database in mysql that brings me all its tables?
-
2
votes1
answer261
viewsMysql to Mariadb Migration
I have a Mysql server that has several banks; some gigantic ones. I have been studying and saw that several services have migrated from Mysql to Mariadb. As it is a Fork, I could simply migrate this…
-
2
votes2
answers180
viewsField sorting of Join with Line in Mysql (C#, MVC)
I have the following query: query = from p in db.pessoa join f in db.pessoa_origem on p.Pessoa_Origem_Id equals f.Id join s in db.pessoa_status on p.Pessoa_Status_Id equals s.Id join c in db.contato…
-
2
votes1
answer221
viewsError converting mysql_list_tables to mysqli_
I have a page to download a backup of Mysql information, however it is giving the following error since I started migrating from mysql_ for mysqli_: Fatal error: Cannot use Object of type mysqli as…
-
2
votes1
answer73
viewsError while doing Multiple Insert
I have a form that generates multiple fields for adding data, and then sends all the data using for, doing so multiple insert in MYSQL. However, I have a problem. Let’s say I generate 30 forms, out…
-
2
votes2
answers485
viewsHow to send record only once in INSERT
Hello, I have an INSERT, sends, all great, but when it clicks several times on the Ubmit button, sends several, records, how can I avoid this? Code: <?php $id_noticia = $edit["id"]; $autor =…
-
2
votes0
answers111
viewsDoubt in PHP Paging
I’m working on a system and I’m having doubts in the pagination, I know it can have some grotesque errors because not "manjo" much. <?php include("cabecalho.php"); include("conexao.php");…
-
2
votes3
answers218
viewsPossibility to create 200 columns in a database
I am planning a software, which is a test of 200 questions where each question can only have 3 choices and select only one of them, and each question belongs to a class type ( for example question 5…
-
2
votes1
answer1038
viewsHow to load JSON in Mysql, including JSON specific fields
I wonder if someone could help me with a question that’s been slaughtering me? First, I am trying to upload this JSON to Mysql { "business_id": "fNGIbpazjTRdXgwRY_NIXA", "full_address": "1201…
-
2
votes1
answer96
viewsPaging in SQL
I have a doubt here, not even for the sake of code, but for the sake of what logic. I have a table with 6000 records in Mysql. I have a PHP script that returns 50 records per page, using SQL’s…
-
2
votes3
answers235
viewsHow to check by javascript if you have entered a new li tag through setInterval?
It is possible to ask through javascript if there is something new in a list ul - li? Like I’m working with a refresh of serInterval, but it is not very dynamic, pq? When the box receives a new…
-
2
votes1
answer5409
viewsHow to save data coming from the facebook SDK login in the database?
I’m using the facebook api for login, and following the tutorial I have been able to implement, but I still don’t understand how the system works that takes user information. What I need is to save…
-
2
votes1
answer2742
viewsProblem with php special characters
I’m using php on the html page to validate a form. When the database retouches the text to the page php is not displaying the result with special characters. Where is the error? Page: <meta…
-
2
votes2
answers81
viewsHow to delete the first line of a megaheavy SQL file?
I have a "mega heavy" SQL file that doesn’t open in the sublime, nor in the notepad nor in gedit. I just need to delete the first line Use nome_database; to be able to import via the mysql Workbench…
-
2
votes3
answers44
viewsHow to order from what has more records to what has less
I have a table where it will be stored id_produto and ip . I will assemble a "module" where the system will pull some of the products that have had more visits, so what I need to do is pull the…
-
2
votes2
answers1512
viewsConvert a date and send to the bank
The code is all working, the problem is the date, I want to take the date of a jformatedtextfiel ##/##/####### in the case txt_data and send to the bank, I’m in the java basics, I’ve been hooked…
-
2
votes1
answer3273
viewsInsert data into mysql, in a timestamp field
How do I enter information in a field of this type? The name of the field is duration, I would like an example..
-
2
votes0
answers153
viewsDatabase can overload like that?
This explanation there is no need for code, it is more a question of database logic even. What is happening: I have an application using Codeigniter and Mysql, and it has 4 actors, but in one of…
-
2
votes1
answer1093
viewsHow to import database for Django models?
I have an application that is almost ready. It was developed in PHP, through the Laravel Framework. I already have the database and all some data already entered to perform tests. However, as I am…
-
2
votes1
answer1016
viewsPopulate tables with multiple foreign keys
I have a database with the following tables: Airport ( Iata PK, airport, city, state, country, lat, long) Causa_cancellation ( code PK, description) Manufacturer (Idfabricante PK, manufacturer name)…
-
2
votes3
answers432
viewsInsert into seat with function
I’m trying to make an entry in the database using a function but I’m not able to enter the respective values; HTML: <?php if (isset($_POST['submitTexto'])) { inserir('empresa', $_POST); } ?>…
-
2
votes1
answer682
viewsReturn mysql result with function
I’m trying to list a database table using a function but I can’t use it outside the function: THE HTML: <tbody> <?php listar('empresa'); ?> <?php foreach ($row as $listar): ?>…
-
2
votes1
answer37
viewswebsite with bank image and pagination items
How I create items for a web shop type site. Pull BD items and place 15-item limit pagination.
-
2
votes2
answers706
viewsInform a date, and catch the interval of the week of the month of that date (from Sunday to Saturday)
I am in need of an SQL command (Sqlite for android), which returns the interval of one week (from Sunday to Saturday) of an informed date. For example: inform the date '05-05-2016', hence the sql…
-
2
votes4
answers1133
viewsReturn a sum in separate rows in mysql
I have a table of statement of deposit and withdrawal of some customers, follows the table: id_cliente|operação|valor | ----------+--------+------+ 51298 | 01 | 50,00| ----------+--------+------+…
-
2
votes2
answers389
viewsAsynchronous server execution problem with Express, Mysql and Socket.IO
I am developing a Node.JS project with Express, Mysql and Socket.IO. When the user opens the main page provided by the server, the request must cause data to be read from the database and sent to…
-
2
votes0
answers198
viewsMysql Workbench 6.3 does not change the data type of the attribute in the table, it always goes back to the previous one
Does anyone use the Mysql Workbench Designer tool in version 6.3 ? I’m having a hard time changing a data type from a certain attribute, whenever I change and enter it back to the previous…
-
2
votes1
answer460
viewsError connecting remote database
Good evening, I’m having trouble with the following context: MySql Using the line of code below I tried to connect to a remote mysql server to try to access some tables and comes the following…
-
2
votes1
answer80
viewsSelect between 2 tables
Based on the tables below and passing to 'dataInicio' and 'dataFim', would it be possible with only one Select select from the Vehicle Table only vehicles that are not in the Reserve Table? I’m…
mysqlasked 8 years, 6 months ago Will Levandoski 49 -
2
votes1
answer163
viewsSend image in form with AJAX / PHP / Mysql
I’m redoing a form for a website that I need to send an image of, but I’m not able to upload and I need your help. I’ve already searched and I can’t find the answer... Function: function…
-
2
votes1
answer280
viewsExporting my database to CSV with PHP
I created a php code that performs a twitter search and saves the result (100 tweets) in a database. In this code, I also have the option to select all tweets from the database and export them to a…
-
2
votes1
answer812
viewsupload multiple images
I know you already have some posts on this subject, but as I would just like to add to the code and not redo. In the code below, I need to add a way that the upload supports several images and as I…
-
2
votes0
answers125
viewsC3P0 Connection Pool
I have the following properties in my Hibernate XML to Connection Pool taken off the internet: <property name="hibernate.c3p0.min_size" value="4"/> <property name="hibernate.c3p0.max_size"…
-
2
votes1
answer303
viewsDatabase Modeling, many to many relationship between two tables
I have three websites that will share the same database. There are 3 tables: News, Photo Gallery, Blog. It will only be a management system for the 3 websites. Example: the user will save a news…
-
2
votes2
answers192
viewsLogin PHP and Mysql generating mysqli_fetch_array() error
Good morning! I have the following code to log in to the system: <?php require_once('conexao.php'); // FETCH DATA FROM FORM USING METHOD POST // IF BUTTON NAME "LOGIN" IS SET if…
-
2
votes1
answer1692
viewsHow to check if a table exists in Mysql
I’ve found several ways on the Internet, but none the way I wanted. I would like a java method for which it checks whether a table exists in the database if it exists TRUE or return FALSE. Grateful…
-
2
votes1
answer3467
viewsSave php array to mysql database
I am needing to save an array in a field in the database table and would like to know how best to do this by using the serialize() and unserialize() or json_encode() and json_decode(). I know you…
-
2
votes0
answers101
viewsComparison of Cities between Stretches
Hello! I am developing a system that consists of registering sections by neighborhood or city. In this case, which I am taking as an example, it includes only two excerpts, as I show in the figure.…
-
2
votes1
answer400
viewsMysql Backup Restore does not insert all Tables
I have a database MySql, where I performed a backup of all data from a given database (all data within a file has actually been saved .sql) but when I was reset using this file was not inserted all…
-
2
votes1
answer3515
viewsHow to take data from a Jtable for storage in a database?
I’m developing a project called Menu List with a Mysql and Java database in Netbeans, with an added Mysql-Connector-Java library. I want the names of the selected products, the quantity of products…
-
2
votes1
answer1061
views -
2
votes1
answer760
viewsSQL Sum by periods
I’m having a question to assemble a query, following: In my sales chart I would like to return the sum per product period. Today I am doing this way: select YEAR(venda.data_venda) as Ano,…
-
2
votes2
answers2263
viewsHow to generate an extract per month in the database?
I have to generate a statement in the database that is similar to the bank statement and present the cumulative balance. I have the following columns Data, Debito, Crédito. Data entry is daily but…
-
2
votes3
answers451
viewsExchange Postgresql connection for Mysql connection
I found a project made in PHP OO to be used in Postgresql with this connection. <?php class BD { public function __construct() { pg_connect("host=localhost port=5432 user=usuario password=senha…
-
2
votes2
answers2912
viewsWrite to two different tables using the same View
I am registering suppliers, and I need to record it in a table and your address in another. I use a single view suppliers. to fill in all the data. How can I separate this data to save it to their…
-
2
votes0
answers147
viewsFilter Products by Category in Opencart
I have a code in Opencart, it randomly displays the products from the store. I would like to modify this code to display the products of a specific category through id or in the best way. The…
-
2
votes1
answer182
viewsMicrosoft SQL Server for Mysql
I need some help. I downloaded a project in c# stock control, but the database is by Microsoft SQL Server, and would like to use Mysql for connection and data logging. Follow example of connection…
-
2
votes2
answers405
viewsNOT EXISTS in update?
I have the following SQL: insert into teste (id,nome) select 2,'João' from dual where not exists(select * from teste where nome = 'João') Would you like to do the same with update? Is there any way?…
-
2
votes1
answer93
viewsMYSQL primary key is it possible to create an AUTO_INCREMENT fill mask?
I wonder if it is possible to create a primary key, aaa-0000 as a mask and still be auto_increment, aaa-0000, aaaa-0001, so on. If yes, how to do? Thank you