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
-
1
votes1
answer278
viewsPage of product comparison
I created a page where I first make a choice on a select/list (musical genre), then depending on the choice appears the second select/list (music) with options related to the genre. What I need is…
-
1
votes3
answers121
viewsSelect union rest between tables
I have two tables, customers and sales. I would like to know which customers have no sale, and store in the sales table the customer ID. I tried it but to no avail: SELECT * FROM cliente RIGHT JOIN…
-
1
votes1
answer195
viewsImprove SQL query performance that accounts for other tables
I have an E-learning system and I need to create a report to return to me how many students have passed, failed, students who do not access more than 30 days, students who are taking the course and…
-
1
votes0
answers215
viewsMysql Longblob only accepts file up to 128mb
Create a table to store files, but all the life I send a file above 128mb all the columns are null except the id. I also realized that it saves only pictures, other type of file it doesn’t want to…
-
1
votes3
answers144
viewsHow to check if the user is currently online?
The thing is, I made a system where the administrator can see the online users at the moment and move them. So far so good, I created a variable in the table user in mysql that becomes TRUE when the…
-
1
votes1
answer46
viewsInsertion with non-standard characters
When I enter into Mysql database with PHP and PDO are entering strange and disordered characters, which may be wrong? Here is a picture of a bank table: My page has the parameter: <meta…
-
1
votes1
answer134
viewsMYSQL - Return occurrences closer to REGEXP
I need to return the number of occurrences closest to REGEXP, see the example below: SELECT * FROM tabela WHERE nome_produto REGEXP 'vestido|longo|manga|curta' The idea is that this query returns me…
-
1
votes2
answers239
viewsRetrieve database records by date field?
How do I recover users recorded in a database table by the dt_birth field through two values representing the minimum and maximum age of the users that will be returned, the minimum and maximum age…
-
1
votes2
answers111
viewsTreating bank search dates
I’m performing the following capture of a date: $dtInicial = $this->_getParam('dataInicial'); // Padrão dd/mm/aaaa To search the bank precisely leave it in the standard yyyy/mm/dd: $dt1 =…
-
1
votes2
answers269
viewsCould not resolve this Reference. Could not locate the Assembly "Mysql.Data"
How do I add the "Mysql.Data" Reference? I am using Sharpdevelop and not Visual Studio!!
-
1
votes1
answer563
viewsHow to check if a name is in the database?
I want to check if a name exists in the database; if there is no registration. Using the code below I can register several users with the same name. php. $user = $_POST['user']; $pass =…
-
1
votes1
answer110
viewsJava project with Oracle and Mysql at the same time?
In view of an Oracle BD and a Mysql BD, and the impossibility of integration of both bases: It would be possible, for example, a class of my application to 'look' at the mysql table and update an…
-
1
votes0
answers375
viewsHow to create graphics in pChart with Object-oriented Connection?
I’m having problems creating my graph in pChart, I’m currently using an object-oriented connection and I’m able to connect to the database but, I’m not able to generate the data for the chart. I get…
-
1
votes1
answer3380
viewsAssign null value to a field
I was doing some tests in the local database, and for them I ended up modifying a field that was null, assigning a value to it. Now that I’ve done the tests, I want to re-assign the value null to…
-
1
votes1
answer149
viewsOptimize SQL Query in three tables
I have a product table that has a foreign key that is the category and a table that stores the name of the product photos. I usually make two queries: one to retrieve the category name and some…
-
1
votes2
answers92
viewsIndex creation in the table
I have a table that has 140 fields. From this table 45 items are important in a query. Every time a user selects an item as true, my script mounts the SQL as requested. In this case, should I create…
-
1
votes1
answer177
viewsSQL: Can I have clauses in Groupby that don’t appear in Select?
I know I can’t have clauses in select that don’t appear in Group By. But is it possible otherwise? For example: Select B From Table Group By A,B
-
1
votes1
answer591
viewsChat youtube url system for embed
Good afternoon, I’m trying to create a system, where I receive a youtube url in a form, convert it to embed and save it in a database. This is a classified site, I do not know if this is the best…
-
1
votes1
answer1373
viewsEncrypt password and log in PHP and PDO
File login.php <?php session_start(); require_once '../includes/config.php'; if(isset($_REQUEST["post_back"])){ $tb = $conn->prepare("select nm_usuario, imgPerfil, nome from usuario where…
-
1
votes0
answers717
viewsOracle Data Modeler - Connect to Mysql Database
Hello! I’m having problems about two days ago about how to connect the ODM ( Oracle Data Modeler) to a mysql database. The process in all the locations I found consists of: -Start Oracle Data…
-
1
votes0
answers312
viewsFill java combobox with mysql query
I’m having a question about how to implement loading items into a combobox from a table data in mysql. The problem is to select from the combobox the name of a supplier and then assign to that…
-
1
votes1
answer100
viewsSQL only in custom Wordpress post for tag conversion
Let’s say a site using Wordpress has half the posts of the default type, and the other half using a Custom Post Type "review" http://codex.wordpress.org/pt-br:Tipos_de_Posts_Personalizados. But this…
-
1
votes0
answers1859
viewsMYSQL, problem with characters importing csv
I am passing the Maxmind csv database to mysql and some accented characters are giving problem. In Latin appears a ? and in UTF nothing appears. CSV : Östra Frölunda UTF8 : LATIN1: ?stra Fr?lunda I…
-
1
votes2
answers1286
viewsQuery sql does not work with date in Delphi
I am making the following query in Delphi, using Mysql: QueryExtraiDados.Close; QueryExtraiDados.SQL.Clear; QueryExtraiDados.SQL.Add('Select * from clientes where…
-
1
votes1
answer63
viewsHow does an e-commerce with bars e.g.: www.loja.com/meunome work, and how is the comic divided?
I would like to know if possible how a great e-commerce works for example, I would like to create my user and put my products for sale, in the link example: www.loja.com.br/meunome…
-
1
votes1
answer549
viewsRefer to number of Mysql returns
I am trying to do a check in a database to check if there is a certain value, which should return me 0 or 1. In the query made manually inside the phpMyAdmin get success with my query. SELECT…
-
1
votes1
answer282
viewsGive preference to greater equality, mysql
I have a table with a column called X in it I enter values separated by comma, for example: 1,2,3,4,5. Use this query to capture certain Row. SELECT * FROM 'x' WHERE CONCAT(',',x,',') LIKE '%,1,2,%'…
-
1
votes1
answer485
viewsHow to Take an Auto Increment Id and Attach it to a Variable in the same Index
How to Grab a newly created auto increment id and repeat it in another column by attaching it to a variable? Ex: Na hora do Insert pego idxxxx repito somando a $varxxxx…
-
1
votes1
answer88
viewsComparison between mysql fields
I have a Mysql table where I store the years I took from a register, but I am creating a search where the user selects from one date to another. In Mysql I did so: SELECT * FROM tabela WHERE…
mysqlasked 9 years, 6 months ago user24136 -
1
votes4
answers428
viewsMake SELECT return data in default language when no translation can be found
I’m building a multi-language base. I have a select with the chosen language, but there is no guarantee that 100% of the content is translated, so I need to do a sort of or to the default language…
mysqlasked 9 years, 10 months ago Papa Charlie 8,721 -
1
votes1
answer264
viewsCart php quantity
I have a cart made in php and the products are in the database, as I do to put a restriction on in a particular product for example: Product number four in my database, I want it to be only 100.…
-
1
votes0
answers159
viewsImport XML into Mysql
I have two xml files. When I care one of them comes like this pública and the other one comes like this pública I opened the files in Notepad++ and in the Format tab the two files are with UTF-8…
-
1
votes1
answer691
viewsBetter cardinality for a table with many relationships
Well, I have a table of cash flow, this table can be related to a process, request, bill to receive, bill to pay... among several other tables that relate and that can result in a launch in the box,…
-
1
votes1
answer4876
viewsHow to merge result from two tables 1 - n
I have the following problem. 1 table client that has relation with 1 table photos (respective photos from client) 1 client ratio for "n" photos; In short: client has id, name. photo possesses…
-
1
votes1
answer23
viewsWindows 7 server with Mysql 4.1
Someone would know how to tell me the limitations regarding the performance and maximum number of users to be using a Windows 7 server with MYSQL 4.1? Does it support a system used by about 50…
-
1
votes2
answers621
viewsReturn default value in mysql query
I own a query that in certain situations does not return value. In this case I would like to get the value 0, I tried using the ifnull, but without success. SELECT ifnull((valor * t1.PBRT),'0') AS…
-
1
votes2
answers147
viewsWorking with hierarchical data
I’m creating a system where administrators will set user permissions. As I want to do in an organized and very detailed way, I thought of creating permissions by groups, hierarchically, in this way:…
-
1
votes0
answers565
viewsDisplay plots on Prestashop product page
Good morning, I was wondering if someone could help me indicating how do I display the price and amount of parcels on a product detail page (product.tpl) in the Shop. Example: 10 x R$ 10,00. If…
-
1
votes0
answers1318
viewsIntel XDK connection to Mysql database
I have a question about connecting my application to an external database on Intel XDK. Could someone tell me what other techniques to connect my application with an external database, besides the…
-
1
votes1
answer342
viewsList Dates Online Schedules in One Table
Tom with a problem here that I don’t know how to fix. I made An Agenda that returns to me the users and the calls that he would have in the week, this presented in a table equal to a weekly…
-
1
votes1
answer392
viewsCURRENT_TIMESTAMP() inserting zeroed
I am inserting more than 9000 records via query, but CURRENT_TIMESTAMP() -3 is inserting several fields with 0000-00-00 00:00:00. Is there any way to avoid it? INSERT INTO yourls.yourls_url…
-
1
votes0
answers159
views"java.sql.Sqlexception: Incorrect string value: xE7 xF5 for column" error
Good afternoon, I’m having the error below whenever I try to run an indexing method. ERROR: javax.servlet.ServletException: net.alforria.util.InfraException:…
-
1
votes1
answer676
viewsProblem with HTML and MYSQL accentuation
I’m having a lot of issues with accentuation, first of all, I’m using WAMP Server. The charset of my site is as UTF-8, that’s why the ISO-xxx... simply uncouples the whole accent of the HTML page,…
-
1
votes1
answer142
viewsHow to use Scope_identify to return id . NET
I am developing an application and need that when sql does the Insert return the value of the id that was inserted, I am using the following command SqlCommand cmd = new SqlCommand("insert into…
-
1
votes1
answer361
viewsModifying Values of Multiple Lines
I need a query that modifies several values at the same time That’s kind of the idea "INSERT INTO registros(Envio) VALUES('1') where Aviso = '" + DdataAtual.Year + "-" + DdataAtual.Month + "-" +…
-
1
votes1
answer85
views -
1
votes0
answers546
viewsAdd amount of gold to player
I have a server of [ Mu Online ] Ex 802 , and it has a { SHOP CASH } system so players can buy their items. Well my Server has a control panel in which I can add the amount of currency that the…
-
1
votes1
answer821
viewsImport Mysql CSV files
I am using Xampp as a server and Mysqlworkbench as a database, how can I import a csv file for various experiments (file size, upload time, etc)?
-
1
votes1
answer1688
viewsSecure backup using Mysql and C#
My application is C# and BD is Mysql, when I do the backup he creates a arquivo.sql. That one arquivo.sql can be easily edited in a notepad, or any other editor, thus leaving my comic very truthful,…
-
1
votes2
answers79
viewsError in the procedure
I’m new to creating PROCEDURE. I am trying to create this PROCEDURE plus this tando error. DELIMITER // DROP PROCEDURE IF EXISTS `P_lgs`; CREATE PROCEDURE `P_lgs` ( idcod INT, dt VARCHAR(20), ip…