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
votes3
answers1170
viewsCount Mysql records
I have a table where I store sales performed. The need to order sellers by quantity of sales has arisen. In case of a tie who made the most recent sale comes first. I can bring with sql below, the…
mysqlasked 9 years ago Pedro Augusto 2,392 -
2
votes3
answers175
viewsCounting filtered dates per day in Mysql
I’m a beginner in Mysql and registered a table on Phpmyadmin, where the id is int, and all other fields are text, including a field data_cadastro. I was in doubt, because there were several types of…
-
2
votes0
answers303
viewsFreight calculation
I’m trying to work out a freight system for a company but I’m having a problem. So,: the freight itself is calculated by the Post Office system which access through an API; I have already done…
-
2
votes1
answer172
viewsSearch by dates
I have a screen and on this screen I have a Textfield that is filled by a date in the format dd/mm/yyyy and then I convert that date to yyyy-mm-dd which is the format of java.sql.date so far quiet,…
-
2
votes1
answer129
viewsMysql Event Scheduler needs super privileges
Good morning, I have a website hosting in a company, I have created a very simple system that through an event that runs a certain time in a certain time and makes changes in the elements of the…
-
2
votes3
answers596
viewsHow to arrange the date order?
In the database: Showing on page (in php): I would like it to appear as follows: 03-11-2015…
-
2
votes2
answers385
viewsError in Mysql connection and Android application
I’m having an error trying to make the connection between my App and the Mysql database. I am creating a direct connection to my bank, I know the best way would be to use a webservice, but I am…
-
2
votes2
answers99
viewsmysql autoincrement restarts alone
I am with the same problem described here on this link: http://forum.novosga.org/discussion/26/erro-ao-reiniciar-a-senhas the guidance given was to do this here:…
-
2
votes1
answer669
viewsHow do I make sure a person can’t book a room on the same day?
I have the reservation code made, but the SELECT is so that people can not book the room on the same day I can not do. In my database I have the reserve table, in which are the data.…
-
2
votes2
answers1523
viewsParse error: syntax error, Unexpected 'mysql_query' (T_STRING)
Well I’m trying to make a "Registration System with PHP and Mysql" I did this by following all the instructions I gave but at the time of the result it returns the following message. Parse error:…
-
2
votes2
answers725
viewsWorking with directories to make a require in PHP
I have a page where I submit some information, stored in the Database. This page is inside 5 folders: pasta1/pasta2/pasta3/pasta4/pasta5. To the SELECT function, I need a require to make the…
-
2
votes3
answers5783
viewsHow to avoid duplicate registration in a php form
I would like examples of how to prevent email from being duplicated if a user tries to register multiple. <form action="processar.php" method="POST"> <input type="text" name="nome">…
-
2
votes1
answer722
viewsMysql data query with x Days to expire
I don’t know what I’m doing wrong. in this code below was to show me the list of records with the dates that entered the 3 days house to win only that there are coming records that have already won…
mysqlasked 9 years, 5 months ago Fabio Henrique 2,156 -
2
votes2
answers2342
viewsPercentage function in PHP
How to do a percentage function. In which it calculates the td or is the equal table of Excel to give the percentage. I want to calculate the percentage of a value in PHP, for example 10% of 100,…
-
2
votes0
answers281
viewsTrigger in Mysql for movie rentals?
I need a little help because the teacher said not to use FUNCTIONS and PROCEDURES, ONLY the TRIGGER. It follows image of what he is asking. I’m really not able to do. For me there had to be before a…
-
2
votes1
answer560
viewsPass array as parameter does not work
I need to pass an array as parametor to a function, each array value has the name of an image and the function should load each of these images as img/foto1, img/foto2, etc. But it is not passing…
-
2
votes1
answer319
viewsDelphi, Mysql, Adoconnection - Convert database data from latin1 to utf8
I’m having trouble converting the strings coming from the database (Mysql - latin1) to UTF8. The case is that I need to take the data in the database encoding for UTF8 to generate an XML with this…
-
2
votes3
answers960
viewsIs Mysql embedded in Easyphp?
I use Easyphp and only installed it, Phpmyadmin works perfectly and I can perfectly handle the tables. Mysql installation is already built into localserver that I use or something? Need to install…
-
2
votes1
answer1394
viewsCreate Task Mysql Database
I need to create a JOB (known in sqlserver) in a mysql database, first I would like to know if there is such a possibility, and if there is one, what would be the syntax? I have a Table that holds a…
-
2
votes2
answers87
viewsPass typed value to another method
I’m having a doubt when passing a typed amount. I’m posting here because I stayed the whole afternoon yesterday and found nothing. In first class: public class CompararLogin { private String nome;…
-
2
votes1
answer1572
viewsHow to use mysql_result with Mysqli?
I’d like to know how to use the mysql_result in the mysqli I’m not getting it, I was looking at the site php.net and the only thing I saw was a mysqli_data_seek if anyone can help me... Code I’d…
-
2
votes2
answers1631
viewsCheck if data already exists in codeigniter bank
I’m starting with codeigniter using active record to make the conversation with the bank, and wanted to know how to know if an email already exists in db, would have to list all email and create a…
-
2
votes1
answer572
views -
2
votes1
answer131
viewsProblem with select dynamical to show dropdown menu for user
I am building the visualization layer for clients of a system in my database have two tables with relationships: and I have a method to return the results of these tables: public function…
-
2
votes2
answers316
viewsCompleting form with AJAX and Mysql
I need to complete a form, according to the user’s demand, with Database information (Mysql). Example: I have the fields "Institution", "Course" and "Period". For the user, first, will appear only…
-
2
votes1
answer2994
viewsDisplay mysqli error using die
Wore mysql_query, as it is no longer used I am using the MySQLi. That left me with a question. To display query error by DIE that’s how you do it? $sql = $mysqli->query("SELECT * Fron tabela") or…
-
2
votes2
answers507
viewsmysql errors being displayed in French
All errors I receive regarding the phpmyadmin database are in Frances. However, the panel is in en, only query errors -a select for example- are displayed in French. I use the WAMP. EX: Aucune base…
-
2
votes1
answer346
viewsSQL LIMIT always returns the same last 3 records
I have a problem in a select. I have the following table id id_de id_para mensagem --- --------- ----------- ----------- 1 10 20 Oi David. 2 20 10 Oi José 3 10 20 Tudo bem? 4 20 10 Sim, e com vc? 5…
-
2
votes2
answers13066
viewsMake Insert in two tables at the same time
I need to do an Insert on two tables at once. I have a user registration and I need a user id to be registered in two tables at the same time, thus making an association of this user to another…
-
2
votes2
answers1200
viewsOnly get a repeated value in mysql
Guys, I have a table and in it a field called cargo and what value it can repeat, as for example, the teaching position. In my HTML I’m riding a <select> When I recover the value of this…
-
2
votes1
answer341
viewsHow: Fill Object Collections from Multiple Sources
I would like a help in passing values to my property private IEnumerable<OrderDetail> orderDetail;. I would like to fill it in, but I have already looked for some examples and I have not found…
-
2
votes1
answer1039
viewsHow to make a select starting with a certain line
How do I get one Select starting for example from the second row of my table? I know that using the ASC limit 1,1 I can pick the second line, but how to start from it?…
-
2
votes1
answer1233
viewsError php permission while uploading
I’m trying to upload my files to the lampp server but I haven’t been able to, which may be occurring ? Warning: move_uploaded_file(../uploads/1579387143.jpg) [function.move-uploaded-file]: failed to…
-
2
votes2
answers808
viewsTake the names of a form on a php page and put it in a select list on another php page
I have 2 pages cadastrar_loja.php and cadastra_documento.php. In cadastrar_loja.php there is a text field called Nome da loja, I’d like to take that name from the database and insert it into a…
-
2
votes1
answer159
viewshow to make a query that the user himself can generate?
Is there any material to learn? For example: I have a pet shop: Let’s say in my HTML I have several select boxes (animal, breed, gender, age, etc), in it I can select the dog or select dog >…
-
2
votes2
answers365
viewsORDER BY COM GROUP BY to get last Row, sql
I am using this SQL code to retrieve data, first it groups then organizes by birth date of Rows. SELECT U.id, U.born_data, U.bold FROM users U GROUP BY U.bold ORDER BY U.born_data DESC However he…
-
2
votes1
answer155
viewsSetting limit for query with UNION in Mysql
I would like to know how I create a limit for a query that uses UNION in Mysql, in my case I want to define the LIMIT 5 for the following query: $friends_a = mysql_query("(SELECT * FROM users WHERE…
-
2
votes1
answer110
viewsHow to group values and process them for the comic?
I have a BD that contains 16 fields of information, this BD keeps bets placed on a system, to later be able to process the result and payment of the customer’s ticket. In the administration part,…
-
2
votes2
answers1669
viewsForeach with database records
In my database I have a table called cadastroatendo within this table I put the days of attendance. I am recovering the data through the foreach... which in turn the array returns this result:…
-
2
votes1
answer205
viewsFree access to database table data for third party system
Is there any way to free access to reading a specific database table for a third party system? For example, I have a table called "customers" and a competing system has an efficient ticket issuing…
-
2
votes2
answers124
viewsProblem with access limit by refresh JAVASCRIPT account
Is there any way to return updated data from the server directly on HTML without using the setInterval, setTimeout those things? Because these server functions are wearing off.. Every time he gives…
-
2
votes1
answer2360
viewsUpdate several fields and values in the same table
I’m making a very simple system for inventory control, and in the part of editing the products, I’m doing it this way: I do a query in a database, and I list text fields with the name of the…
-
2
votes1
answer679
viewsMysql Date for Highcharts
Good I have been here a few days back from this subject until I got something, my only problem now and convert my chart which I was reading through a CSV to now read directly from MYSQL My original…
-
2
votes2
answers100
viewsDefault record if no other - mysql
Is it possible to program the database to have a default record if there is no other record in the table? making the table impossible to be empty. then if there are other records it ignores the…
-
2
votes1
answer2478
viewsWhat is the difference between Primary key and index in mysql?
I was wondering if there’s any difference between Primary key and index. Pq in mysql has several types of indexes (PRIMARY KEY, UNIQUE, INDEX, and FULLTEXT).
mysqlasked 8 years, 9 months ago Tiago Agenor 43 -
2
votes1
answer185
viewsCan Sql Server Management Studio handle any database?
I am asking this question because I find this DBMS simply fantastic, so I would like to use it with another database (not because I want to, but because most of the databases I have are in Mysql).…
-
2
votes1
answer225
viewsDropdown with Jquery/Ajax only sends data in the first record
I am applying a dynamically dropdown to each item of a returned list in PHP. When selecting any of the dropdown items, this value is sent to an Update.php file, via Jquery and Ajax. The Dropdown:…
-
2
votes1
answer27
viewsMysql insert with "Link" between inserts
I’m in big trouble here. I need to upload multiple files and insert them into different tables. The products table contains the details of the products and the photos table the files to access the…
-
2
votes2
answers5838
viewsCopy data from one column of a table to another of the same table
Hey, guys, I have a question. I need to copy the data from an integer column to another decimal column of the same table, that in Mysql. Is it possible to do ? there may be some inconsistencies in…
-
2
votes1
answer55
viewsMysql - No changes Detected
Every time I change a process in Mysql Workbench and try to write (Apply) and I get the following message (No changes Detected) there to get around the problem I delete and recreate the process.…
mysqlasked 8 years, 8 months ago Mauricio Ferraz 2,074