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
answer220
viewsInsert data from a TXT into a DB
Even making all these conditions, my database is responding in a strange way, because literally what I am selecting, is in every line of my file .txt, returns everything, including empty spaces,…
-
1
votes1
answer113
viewsUsing two statment at the same time without giving "Fatal error: bind_param"
On my records page I want to check the names of users and emails separately but at the same time. I could leave the message like this: Username or email already exists to facilitate but I have never…
-
1
votes1
answer2650
viewsUpdate with Inner query by selecting the same table
I have the following query: UPDATE cp_feedback_trabalho as a SET a.visivel = 1 WHERE a.dhEnvio IS NOT NULL AND EXISTS ( SELECT b.id FROM cp_feedback_trabalho as b WHERE b.id_pessoa_que_enviou =…
-
1
votes1
answer277
viewsCodeigniter - Installation script
I created an installer for my system it installs normal, but before finishing the installation the error occurs Error Number: 1046 No database selected CREATE TABLE IF NOT EXISTS `auditoria` ( `id`…
-
1
votes3
answers1488
viewsForeign Key in another database?
Doubt in Mysql... What are the possible problems that may arise when making a foreign key in different databases? Taking into consideration this type of foreign key and a View that fetches…
-
1
votes2
answers93
viewsmysql organizing database entries
I wondered if it is possible to reorder the entries of a table in mysql, overwriting the deleted entries, and without breaking the other tables. If possible, which command would you use and show me…
-
1
votes1
answer871
viewsRecover parameter sent to a modal and perform Mysql query
I need to recover parameter sent to a modal bootstrap, perform a query in the database and show result in a text field for the user, what I have is this: Sending the parameter to the modal <i…
-
1
votes2
answers995
viewsConvert text to number in C# to write to DB
I’m using this conversion to get the string from txtvalor.text and turn it into such a value: 1.500,80 curso.Valor = double.Parse(txtValor.Text); Example I type 1,500.80. And I would like you to…
-
1
votes1
answer114
viewsData insertion with PHP OO (Similar to Entitymanager.persist (Object) java manager)
I would like a tip on how to loop to insert an object into the mysql/ postgres database ... Example class User { // PRIMARY KEY public $id; public $login; // PRIMARY FOIREIGN KEY public $people;…
-
1
votes1
answer127
viewsPerformance in dynamic menus
I’m building a cakephp and mysql application, and would like to display some menus and items dynamically through the database. Better example: Display latest updates, latest entries in the database,…
-
1
votes2
answers2452
viewsHow to make a database connection using the Singleton design standard
Well I do many web applications, where I all use database, and every time I do a new project, I create a file responsible for making queries with the database (CRUD). Only that I want to change…
-
1
votes1
answer1330
viewsmysql error when importing tables
When I import from 44 tables mysql returns me the following error: #1062 - Duplicate entry '0000000001' for key 'PRIMARY' Does anyone know what it can be? and how to solve?…
mysqlasked 10 years, 3 months ago Silvio Andorinha 8,394 -
1
votes2
answers440
viewsSelect only 1 record with the same category and Hidden in the other
I have to list some Humbs of the same category only I want to appear 1 for the user and others stay as Hidden in the code. I’m seeing with GROUP BY categoria only if I do it and give while() it…
-
1
votes1
answer148
viewsselect like that returns a Sting without line break
I am using the following query: select distinct con_destinatario from tab_conhecimento where con_destinatario like '%CALLE%' order by con_destinatario; and get several results of this type: A.S.…
-
1
votes2
answers298
viewsError with $_GET function
Personal my question is the following, I have the page criareditarevento.php that updates information from a registration system, but I need to make the update message open inside the page main.php…
-
1
votes2
answers7523
viewsGet the most recent month’s records
I have a simple table that stores titles and publication date, this in DATE format, and I need to get all records for the most recent month/year. select titulo, publicacao FROM teste1 ORDER BY…
mysqlasked 10 years, 2 months ago marcelo2605 790 -
1
votes0
answers724
viewsHow to create tag system similar to Blogger?
Sirs, I am trying to add to my CMS (in PHP/Mysql) a Tag system similar to Blogger. On the news registration page, I would like the administrator to add in the field "tags", information separated by…
-
1
votes1
answer1569
viewsHow to send Ckeditor formatting to BD?
My question is this, I set up the CKEditor within a textarea, where everything I type sends to the banco de dados that at the same time feeds another page, working in style sistema de noticias.…
-
1
votes2
answers756
viewsTreat ranges between two Time Mysql fields
I have a table Atendimento in my comic book. Inside it I have two fields that are: HrIni which refers to the initial and other time HrFim which refers to the final time. I need each record of these…
-
1
votes1
answer150
viewsReplication Mysql Database
I am drafting an online project and I need to ask a question regarding the creation of the database. I will have a database COMPANIES containing the reference with name and a code. From this…
-
1
votes0
answers57
viewsHow to insert database query data into an html page
I need to insert a database query data into an html page. The moment the user presses the PDF button, the data entered by the user will be captured in a contract in html format. Someone has a…
-
1
votes3
answers823
viewsDo not receive the POST data
I am trying to generate the login according to the database data and proceed to the page restricted to registered users, but there is incorrect password error. Front-end: <div…
-
1
votes4
answers14935
viewsHow to solve image upload problems in Wordpress?
After migrating to Kinghost, I’m having trouble uploading images to the Wordpress library. I normally upload the image but it seems that it does not enter the library, it is as if it had been…
-
1
votes1
answer2437
viewsHow to disable date and time spent in jQuery UI calendar?
I would like to know how to create a function that disables the dates passed in jQuery UI. For example, it is now 15/09/2014 07:31:25, how to disable any date and time prior to this current time?…
-
1
votes1
answer846
viewsPhonegap / Mysql Connection Remote without PHP
I would like to make a connection to a remote Mysql database through an application compiled for Phonegap without the need to use PHP. The bank would not be inside the device but in the network…
-
1
votes1
answer207
viewsHow do I make a registration in Moodle, and where the data is recorded?
I am developing a Moodle subscription plugin which generates a ticket from a certain bank, but I have some questions regarding the confirmation of the user’s registration (enrol): What table is…
-
1
votes1
answer228
viewsView [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
About VIEW in database... What is the difference between the three algorithms when creating a VIEW with [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]? What each one does?…
-
1
votes2
answers146
viewsError in mysql query in php
I make an appointment at DB mysql and it works normal, then I’m going to do the second consultation and you give me the following mistake: Warning: mysql_fetch_object(): supplied argument is not a…
-
1
votes3
answers4226
viewsHow to select multiple results in one row
The problem: One of our sites has a messaging system between users, for this we have two tables: one that stores the messages between users and the other with users, follow the structures below,and…
-
1
votes1
answer3634
viewsWhere to place the connection string with the database?
I have the form: Already created the database and table for registration, I am using wampserver and Mysql Workbench. My question is where to place the connection string: MySqlConnection conn = new…
-
1
votes2
answers10731
viewsGet date with day of week, number of week, month and year
Is there any way to get the date if you only have the day of the week, the number of week, month and year with Mysql? Example: I want to know what day it is with these parameters: Year: 2014 Month:…
-
1
votes1
answer213
viewsData modeling problems with Persistence.xml
I created a college application to create automatic tables by Hibernate with JPA however it gave error in some tables, that were these; Catalogued Orderly Commodity but this generating the following…
-
1
votes1
answer199
viewsTake values that were not used within the bd
I have a table with several product codes: EX: 1, 2, 3 ,4 , 5, 15, 20, 21, 22, 45, 60... I wonder if there is a query to get the codes that have not been used in the records? In the above example…
-
1
votes1
answer334
viewsHelp with SQL to sum daily between dates
I have two tables: company and walking In the table walk, I have the input date, date, value I would like to select all companies, and list it and the total amount the company spent on daily rates,…
-
1
votes3
answers1951
viewsHow to search for ID in Mysql
Staff I am developing a system of input and output of vehicles of the company, in the index I made 2 inputs one of entrada and another saída, when I click on input appears the registration screen of…
-
1
votes1
answer860
viewsSaving hexadecimal data in the database
I need to register in the database a document or image in hexadecimal format and then recover these data by converting them back to correct format.
-
1
votes2
answers327
viewssyntax criteria using Yii framework
I’m having a hard time making a where using criteria, I am posting the code I am making and below the error.. Codigo Criteria $criteria->compare('id',$this->id);…
-
1
votes1
answer101
viewsDatabase migration from one server to another
I have an E-commerce that I developed through Wordpress, all his BD was on my old server, with the URL http://www.felipestoker.com/teste Now, already finished, I have to export everything to…
-
1
votes1
answer219
viewsMultitenancy application and structure
Saas applications are getting higher, reducing costs, maintenance, etc. We know we have the concept: Multitenancy (http://msdn.microsoft.com/en-us/library/aa479086.aspx) It’s them: By Column: Place…
-
1
votes1
answer1171
viewsUpdate in another row in the same table by Trigger
Is there any way to update in the same table, being in another row, through a after insert or before insert?
-
1
votes1
answer161
viewsHow to know if the client is already open on another computer?
I’m building a system that can and will open on possibly two to seven computers. There is concern in the following case: PC1 opened the João client file and began editing. PC4 opened the João…
-
1
votes3
answers760
viewsHow to close mysql connections in C#
When executing the code below: DataSet bdDataSet; MySqlConnection conexao; public void inserir() { bdDataSet = new DataSet(); conexao = new MySqlConnection("Server=localhost; Database=teste; Uid=;…
-
1
votes2
answers682
viewsMerge results and cross with another table
I have two tables in Mysql: table_schedules: id - tratamentos 1 - 1 2 - 1,2,3 3 - 2,3 table_treatments: id - nome 1 - Facial 2 - Corporal 3 - Outros I want to make a query where I can return the…
-
1
votes1
answer89
viewsProcessing of inserts in Mysql
It is possible to know if Mysql inserts are being made after closing the connection? The PHP code has 800 lines, I know it goes all the way, because the last instruction is successfully performed.…
-
1
votes0
answers71
viewsHow to view queries that returned error?
Hello, I wonder if in mysql, in his own dictionary (Mysql) I can debug the query that returns with an error of a particular application?
-
1
votes2
answers112
viewsStrange code (Green) coming back from the database
I have the following PHP query $mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE); $mysqli-> set_charset("utf8"); $stmt = $mysqli->prepare("select header, title, footer, head from configs");…
-
1
votes2
answers181
viewsRelation between 3 tables and find the result of last week mysql
I have three tables, the tbl_recursos, tbl_categorias and the tbl_categoria_recurso. To tbl_recursos is the listing of resources posted by the user. A tbl_categorias are the categories a resource…
-
1
votes3
answers30995
viewsInsert date in Mysql via PHP
I want to insert an HTML FORM that I made the field DATE, however it is in format dd/mm/yyyy and mysql only accepts yyyy-mm-dd. How do I convert the date to insert correctly into the Mysql database…
-
1
votes1
answer6313
viewsRegastar Mysql column name and values
I want to get the name of the columns of a table and their respective records.. Ex: I have the table criminal records and on it are the columns name, login, password and there are 2 records recorded…
-
1
votes1
answer430
viewsDoubt of Concept when registering parcels in the database
Personal case I have a sale to be registered, with contract number, customer data and among others and I have sales fields with plots... Here comes my question, should I create a table of plots…
mysqlasked 10 years ago Rafael Assmann 381