Mysql Definition and 29 Threads

Hello All, I am working on a database project and I am good at SQL commands. I want to know which one supports ACID compliant between MySQL and PostgreSQL. I have asked this question on Quora and according to this post, MySQL is not completely ACID compliant. It supports ACID only when used in...

I would like to practice SQL and install MySQL, one of the most popular open source DMBS. MySQL workbench can also to be installed and used as a visual GUI to interact with MySQL which in turns interacts with the database. My question: is MySQL a server application? If so, what does it mean? I...

I wanted to install MySQL on my laptop running Ubuntu 20.04, and was following this website for instructions. I executed the following commands: ~$ sudo apt update ~$ sudo apt install mysql-server ~$ sudo mysql_secure_installation After installation, I found that I could log into root user...

I have a database of bus routes in MySQL. Each table has three columns: location1, location2 and fare for going from location1 to location2. Consider one table of this database, route_a which goes via region1 → region2→ region3 → region4: and another table, route_b which goes via region5 →...

I just installed MySQL Server 8.0. The server is configured to run automatically at startup. However, when I wake up my laptop from hibernation or sleep, sometimes the server stops. I read on the net that I should execute mysqld from command line to start the server. I have set the folder of...

Hi, Just curious as to what, if any procedural language MySQL extends to, in the way SQL Server's SQL extends to T-SQL, Oracle SQL extends to PL/SQL? Is it PHP? Sorry, could not get a clear answer in a search.

Hi everyone, I have a MySQL DB with a couple of large tables (a couple hundred million rows). Each row has a timestamp associated with it. Since this is just historical data, and not needed we want to copy older data into another database, and then delete the copied records. I've written a...

Hi, I am having problems importing the Northwind database https://msdn.microsoft.com/en-us/library/bb399411(v=vs.110).aspx into mysql on my machine. I'm running wamp64 and mysgl ver 5.7.14. When I download the files, I obtain instnwnd.sql file. However, when I use phpMyAdmin and attempt to...

I found this before out on the interwebs, but alas can't find it today. How can you print the location of the .ini file that MySQL is using from the MySQL command line?? Thanks, -Dave

Hi All, I am using MySQL in order to design an ERD (Entity Relation Diagram) , and I can make use of indexes, triggers, etc. but for some reason, the columns tab , which allows me to add data or just edit the tables is disabled. I have searched online without success. Any ideas on how to enable...

Hi all, I am given a data table, with dependencies. Can I use MS MySQL workbench to draw the associated dependency diagram? Thanks.

Dear PF Forum, I want to learn web programming, but there are specifics information that I need to know. What is the most famous database in web programming? My SQL? Is it true that PF Forum database is MySQL? If this is true, then the conclusion is MySQL can handle millions of post, hundreds...

So... I hae this issue trying to connect mySQL to ruby on net bean... Has anyone connected it before? The code: #!/user/bin/ruby require 'mysql' begin puts "hello World" con = Mysql.new 'localhost', 'sqluser', '' puts con.get_server_info rs = con.query...

I have a website but it's very difficult to make changes online because you can't change what you did.So I just want to make required changes offline and later upload it.So is there any good offline server software? I also want Mysql I tried Mr.Google but couldn't find anything helpful

If you rename an attribute or a relation with the keyword AS in MYSQL can you use the alias created outside the query where you renamed the attribute, also can you use the old name?

I'm confused about whether MySQL is an actual language you program in or whether it is just an environment or IDE. Or is PHP what you write in Mysql or can you write any language in MySQL. Can someone explain this to me? please let me know if I haven't explained my question clearly enough.

I am wanting to gain experience with SQL without buying a license. I am planning to buy a program that shows you how to create databases as well as write code for them. However, this program requires that I have an SQL setup to use. I saw that Microsoft has a MySQL download but I'm not sure...

Hi, I am self learning MySQL, I am a bit confuse with the terminology, can someone explain a little bit what is schema and model? And how they are usually used? Thanks.

Anyone know of a GUI for MySQL that would work with the Solaris 10 OS? (Free is always good.)

hey everyone, I'm about to take an introductory course in databases in the fall, but I figured I could start learning about them now. I downloaded & installed MySQL Server 5.1, but I'm not exactly sure what to do at this point. I'll migrate to the bin folder and type in the following...

Hi, I already have a static website, and now I am trying to design a dynamic website. I used Apache, PHP, and MySQL and setup on my computer (hostname = localhost) and tested my member directory database. It worked fine that I can add, edit and delete, and update the data from table. I...

Hello, I have never used SQL before and I have a .mdf & a .ldf file and I need to change some parameters. Is there a way to view them like an Access Database? I have Microsoft SQL Server 2005, but to my knowledge there is no utility included to access these files. Thanks

I am designing a map game, using PHP and MYSQL. I don't know how to make the players who sign-in to the website to see other players who are also connected to the site and be able to chat with one another. I want to design the game in such a way that 2 players can play with each other and...

Goal: I seek to log the SQL statements into a MySQL table, with the time they were executed as an aid to debugging problems with PHP apps I am writing. Problem: MySQL seems to try to interpret the statement, meant to simply be data in a field. When I try to "INSERT" the values, I get MySQL...

I use php to select data from the mysql database with chinese character but when I echo it ,it show ? . I am sure the encoding is correct but it still don't show the chinese character . I am using IE 6 . Please help .

Hi everyone, I'm just beginning to learn php, but I'm working on a small script where I'm trying to search a few fields in a table and if the values match, other fields in the same row are displayed. The db has just one table with 6 fields: ID (primary key), words, definitions, roots...

I want to create a online multiplayer games with php but I don't know how to let the members know their opponents' move realtime ? Please help me !Thanks

I have a MySQL server on OS X and I want to make it so that it accepts client loggins from my laptop on teh network. how do I make it so that it will allow my laptop to connect? Thanks

Do you guys know if it is possible to use pre-appended wildcards when doing a fulltext search? Is there a workaround that I could possibly use? I've read through the documentation and it seems as if you can only do appended wildcards. Here is my query: $query = "SELECT title, MATCH (title)...