Just kidding. I’m a big fan of SQL and I’m always trying to figure out a way to make it easier for myself. I have a small project with a long list of SQL queries that I need to run. It’s a project that is not going to take a lot of time or effort. The problem is that I already have a server set up with mysql, so I can’t seem to find the right set of queries.
Thanks, I got to give you some suggestions. I have a lot of SQL queries I need to run in my new site. I’m going to write a PHP script that will perform the conversion and insert a row into the database.
Check out the code below. It is a bit more involved than the simple SQL query above, but I feel like the performance is worth it. I hope it helps. If you have any questions, please talk to me.
That’s a really good question. If you have a server set up with mysql, you can run the query above via phpmyadmin.
I do have a server that I could test this on if needed, but I’m not sure if it would be a good idea. I’m not sure if there are performance implications to running it on another server. We’ll have to wait and see. In the mean time, I’ve put a link below, where you can find the PHP code and see the output.
I am not sure how effective this will be for someone using MySQL but I thought I would post it here in case someone else is interested. But if you’re using another database, or need/want to use PHP, you could probably use this code along with a script to get you started.
Ive also included a link to a SQL script to convert the output to the format that mysql uses. It should be fairly easy to convert it to your own database format.
The main reason I ask this is to get you started. The PHP script used by the PHP guys to convert the output to the format I wanted to convert to was called Convert_Pipe_SQL.
We’re using this for a variety of reasons, but one of the biggest is that we want to make sure that our database is the most up to date possible. To do that we need to have the server’s database. We’ve tried a variety of approaches, but most of them aren’t reliable. So my plan is to have all of our database objects point to the server’s database, and that way we can use the server’s database when we need it.
mql is a powerful tool, sure. But its also a bit of a black box. The two databases that we use the most in our data-warehouse are mql_db and our own servers database. And even though they are both on the same server and connected using the same database engine, they are very independent. One of the biggest reasons the conversion rate is high is because mql does not use the same types of objects that we use in our database to create objects.