Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 8227

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

0
votes
1answer
I have this related tables: And I need to get those devices with no driver assigned, in other words the device returned on this query shouldn't be on driver_has_device table since it'll not have dr …
asked Jul 2 '14 by ReynierPM
1
vote
1answer
Based on this I'm working on this bash script for export all databases from MySQL but exlude some ones and also system ones. This is how it looks like: read -e -p "Enter MySQL root user: " -i "root … " root_user read -e -p "Enter MySQL root user password: " root_password FILENAME="mysqlbck"-$(date +%d-%m-%Y-%T).sql read -e -p "Enter backup filename: " -i "$FILENAME" file_name read -e -p "Enter …
asked Mar 13 '15 by ReynierPM
1
vote
0answers
I have this semi-complex table structure: And I need to return this data: { "id": "10111001", "rep_id": "30000001", "targets_id": "60011001", "brands_id": "10010001", "brand_name": "Quil …
asked May 22 '15 by ReynierPM
1
vote
2answers
I have a table called fos_user_user where I have a default record "always". Since I'm testing all the time and sometimes I need to clean that table I'm asking if there is any way to run the following …
asked Feb 27 '14 by ReynierPM
4
votes
1answer
the DB used - which is in scenario is MySQL (don't know the version) - is this possible? I don't think the username and password were removed for security reasons: It would be better to change it to …
asked Apr 26 '18 by ReynierPM
2
votes
1answer
I'm trying to get non-deleted (deleted = 0) messages for one user_id if the same user_id appears in two tables at same time, but something is wrong because I am not getting the correct or expected dat …
asked May 17 '12 by ReynierPM
2
votes
1answer
I have this table structure: id1 id2 1 2 1 3 2 1 2 4 id1 and id2 are not unique as you can see in the values. I need to retrieve those values that exists in the two columns me …
asked May 9 '12 by ReynierPM
1
vote
2answers
I've two tables default_tb_persona and default_tb_envio, this are the DDL for those tables: CREATE TABLE `default_tb_envio` ( `codigo` varchar(7) NOT NULL, `fecha` date NOT NULL, `id_modalidad` …
asked Feb 27 '13 by ReynierPM
1
vote
2answers
I'm trying to get the rows from a table where lastLoginTimestamp is in last 7 days and I'm doing as follow: SELECT * FROM representative WHERE DATE_SUB(lastLoginTimestamp, INTERVAL 7 DAY) lastLogin …
asked Apr 7 '15 by ReynierPM
1
vote
1answer
: Each row should contains UNIQUE values for each column event_type should be randomize for populate the table with several event types This data is for testing purpose. Can this be done from MySQL query? How? …
asked May 22 '15 by ReynierPM
2
votes
1answer
I have the following tables structure (DDL): CREATE TABLE restricted_components ( component_id INT(11) PRIMARY KEY NOT NULL, resources_id INT(11) NOT NULL, component_dom_id VARCHAR(50) NO …
asked Nov 17 '16 by ReynierPM
1
vote
1answer
I have created a EER model using MySQL Workbench (latest release). Apparently all is fine but when I try to do a FORWARD ENGINEER I get the common Error 1005: Can't create table. As suggested in this …
asked Feb 27 '14 by ReynierPM
0
votes
1answer
am using MySQL 5.5) Note: Feel free to rewrite the SQL if needed in order to obtain the required results. …
asked Nov 23 '16 by ReynierPM
3
votes
1answer
friends. If I leave only one way relationship then I need a UNION and this migth slow my DB Is that correct? How yours handle this when CRUD on this? I'm using MySQL by the way and MyISAM tables. Cheers and thanks in advance …
asked Apr 17 '12 by ReynierPM
2
votes
1answer
I have this table structure: http://www.dropmocks.com/mBjNvF and need to get the id_user_rq if not exists in id_user_ap as the title said. I need to get the rows where id_user_rq = 1 and id_user_ap = …
asked Jun 5 '12 by ReynierPM

15 30 50 per page